How To Import Transactions Manually

Cryptoworth’s manual CSV import is an option when integration is not yet available for a particular connection. Using the format of Cryptoworth’s manual CSV import, you can consolidate the transactions into the spreadsheet for the purpose of uploading it to the platform afterward.

Step 1

Create your Manual Import connection. Head to the Connections page.

Step 2

Click on the blue Connect button.

Step 3

Search for "manual import" and click on the Cryptoworth manual import option.

Step 4

Make sure to name your manual import connection and fill in the description. Optionally, if you want the manual connection to calculate the inventory balance you can click the checkbox.

Step 5

Click on the Connect button to initiate the connection.

Step 6

The next objective is to download the manual import CSV format. Head to the Transactions page. 

Step 7

Click on the Import button. 

Step 8

Click on the "Select a source" field and look to select your recently added manual import connection.

Step 9

Click on the link to download the Cryptoworth manual import CSV to obtain the required format.

Step 10

The manual CSV format will show all the fields that you can use to upload your transaction data. Transaction IDs are not required, however, they are highly recommended if available. 

The date formats are not required to be the same however the date format CANNOT be day/month/year. It MUST be in a format that represents, month/day/year. 

If there is a manually recorded trade event, one line item is the first asset. The second line item is the second asset. The third line item is the associated fee. 

The Crypto ID is how Cryptoworth identifies the cryptocurrency transaction that is being manually entered into the system. To find the Crypto ID, head back to the Cryptoworth platform. 

If you are manually inputting NFT transactions, the Crypto ID is always -1. There are three tags you can use for the Tag column of your NFT transaction (NFT, NFT BUY, NFT SELL)

Please note when recording fees, if the fee currency is the same as the currency being sent (BTC SEND event for example), the SEND event always has the fee recorded in the same line item and this input would be filled under the Fees column. If the SEND event is a different currency than the fee, take for example USDC being sent and the fee being in ETH, then in this case the fee will always be recorded in a separate line. Trade fees from an exchange are always recorded on a separate line.

To find the Crypto ID click on the square search icon.

Step 10

Every cryptocurrency on Cryptoworth has an associated number that the system uses for recognition. This number is the Crypto ID, use the number for each cryptocurrency you are manually adding to the manual CSV import. 

Here is an example of a completed manual CSV import in the correct format:

Step 11

Once you've completed entering your transactions into the CSV. Click on the Import button.

Step 12

Search for and click your manual import connection.

Step 13

Select your manual import CSV file then click on the blue Import button to sync the transactions.

Next, select Skip CSV Validation and then import. Only if the import fails should you unselect Skip CSV Validation. 

Your transaction will now synchronize over the next few minutes.

_________________________________________________________________________________________

Below is a map of descriptions for each column within the Cryptoworth manual CSV template.

Date Time (UTC) 

This column is where the transaction timestamp is recorded. Formats accepted are 2020-10-09 and 12 Jan 2021, 22:56:48.

Crypto Id

This column is where you find the ID associated with the crypto asset on Cryptoworth. You can find this ID by following step 10 in this guide.  

Type

This column is the Type of transaction which can be one of four options, BUY, SELL, SEND, and RECEIVE. A BUY or SELL is only recorded if a fiat-to-crypto or crypto-to-fiat transaction was conducted. Every other transaction event that is crypto to crypto is a SEND or RECEIVE. 

Tag

There are many transaction Tags on Cryptoworth that are automatically applied to transactions when possible for streamlined reconciliation. You can find all the available Tags under the "Tags" menu under the Classifications page (screenshot below). 

Amount_One

The Amount_One column is simply the amount of the crypto or fiat for the transaction. If this is a crypto to crypto transaction, the Amount_One and Amount_Two will be identical. If fiat is involved, depending on whether it is a BUY or SELL there will be a fiat amount on one side or the other of the transaction. 

Amount_One_Type

The Amount_One_Type column is what the ticker symbol is of the asset. 

Amount_Two

The Amount_Two column is the amount of crypto or fiat for the transaction. 

Amount_Two_Type

The Amount_Two_Type column is the ticker symbol of the asset. 

Fees

The Fees column is the amount of the fees.

Fee_Currency

The Fee_Currency column is the ticker symbol of what the fees are being paid in.

Cost Value

The Cost Value column is the amount of the cost basis if there is one.

Cost Value Currency Code

The Cost Value Currency Code is the ticker symbol of what the cost basis is being tracked in.

Sale Value

The Sale Value column is the amount of the sale value of a transaction if there is one.

Sale Value Currency Code

The Salve Value Currency Code is the ticker symbol of what the sale value is being tracked in. 

Transaction_ID

The Transaction_ID column is optional if you want to input the transaction id. 

From_Wallet

The From_Wallet column is the origin wallet address of the transaction line item, this is an optional field.

To_Wallet

The To_Wallet column is the destination wallet address of the transaction line item, this is an optional field.

Classification Id

The Classification Id column is for the IDs associated with your existing classifications. On your Classifications page, there is a classification ID column for you to use if you want to indicate what the classification is for your transaction line items on the manual CSV import. 

Label

The Label column is if you'd like to label your transaction, this can be anything you like it to be. 

Description

The Description column is if you want to provide a small description for the transaction line item.

Contract_Address

The Contract_Address is there if you want to associate a contract address to a transaction line item, this field is optional.

Token_Id

For the Token_Id column, you can input the ID of your NFT asset here. 

Token_Name

For the Token_Name column, you can input the name of the NFT asset here.