In this article, we'll go over how to upload your data to our platform using our .csv/.xlsx template. You can use this method anytime you want to upload data from a blockchain or exchange that we do not yet support.
We only supported this method on the desktop version of our application and not on our mobile versions.
Downloading the template
You can download the template by clicking here.
Or you can follow these steps:
To get started, you'll first want to go to the "import data" screen and enter the name of the wallet/exchange you'd like to add.
If the wallet or exchange is not available, as shown above, the option to create a manual wallet will appear. The name you put here will be the default name of the wallet, but we'll ask you if you want to rename it in a later step.
Once you have selected the option to create a manual wallet, you'll see two options.
Select "Manual template" and press "Continue".
Next, we'll present you with a screen to download the template.
Once you download the template, we'll have to come back to this page to upload the template after we finished creating the file.
Filling out the template
Now that you have the file, you are ready to put your data into it. In our examples, we'll use Google Sheets to edit this file since it's free and multi-platform. But you can use Apple's Numbers, Microsoft's Excel, or any other app that will let you edit .xlsx files.
Opening The file in Google Sheets
To get started, go to your Google Sheets and open your Accointing_template.xlsx file using the folder icon shown below.
You can select your file by going to the "upload" section and selecting the file.
Upon opening your file, you'll see some examples of the different transaction types that you can include in the file.
Entering your data
When entering your transactions, the following information can be helpful.
This section can include:
- "deposit" - used for an asset that is transferred into your account.
- "withdraw" - used for an asset that is transferred out of your account.
- "order" - used for trades between two distinct assets that are in your account.
This section is required for every transaction type. The formatting needs to match exactly to the examples to prevent any import errors.
inBuyAmount & inBuyAsset
These sections are for the assets you are buying/receiving. They are required for the "deposit" and "order" transaction types. Using them for the "withdraw" transaction type will cause an import error.
outSellAmount & outSellAsset
These sections are for the assets you are selling/sending. They are required for the "withdraw" and "order" transactions types. Using them for the "deposit" transaction type will cause an import error.
feeAmount (optional) & feeAsset (optional)
These sections are for the transaction fees, and you can use them for any transaction type. We add any fees to the amount transferred. The following are a few examples of how this works.
- Matching outSellAsset & feeAsset Example: [ outSellAmount = 1 ] [ feeAmount = 0.1 ] [ outSellAsset & feeAsset = BTC ] this means that the total amount of assets that left your account was 1 BTC and 0.1 BTC. Since the assets are the same, you can also phrase this as 1.1 BTC in total left your account.
- Unmatching outSellAsset & feeAsset Example: [ outSellAmount = 1 ] [ feeAmount = 0.1 ] [ outSellAsset = BTC ] [ feeAsset = ETH ] this means the total amount of assets that left your account was 1 BTC and 0.1 ETH.
This section is for classifying what the transaction was for. You can use it for the "deposit" and "withdraw" transaction types. Using it for the "order" transaction type may cause an import error. This section is entirely optional since you can use our platform to classify them if we leave them blank.
For Deposit classifications you can choose from: add_funds, airdrop, bounty, gambling_income gift_received, hard_fork, ignored, income, lending_income, liquidity_pool, margin_gain, master_node, mined, staked.
For Withdraws classifications you can choose from: remove_funds, payment, fee, gambling_used, gift_sent, ignored, interest_paid. lending, lost, margin_fee, margin_loss, payment
In the template, you can use any classification that is already in our system except for "internal", "OTC", and "ICO". This is because these are special classifications that must match one transaction with another transaction within our platform to be used. To get a list of the classifications along with their definitions, you can go to the "classify transfers" section in the review process.
To see a full list or transactions, click here
This section is for the unique hash that was given to the transaction. It is used to view the transaction on the blockchain explorer. While this section is completely optional, including it may be helpful in the future.
Downloading the completed file from Google Sheets
Once you have completed adding the transactions into your file, you can download your file by selecting "file", "download", then "Microsoft Excel (.xlsx)".
Uploading your completed template
Once you have your completed file, you are ready to upload it to our platform. You can do so on the same page we were on earlier. Select the time zone used in the template you created and upload the file in the provided field.
You can also choose a different name for the wallet and select a timeframe to import from using the provided fields. Once you are done, press "Continue".
Next, we present you with a screen to show you if there were any problems with the import.
You shouldn't have any problems listed on this page, and you can press "Continue" to move on to the next page.
Here is where it lists the assets that did not get detected automatically.
For each asset listed, search for the correct currency in the box provided. if CoinMarketCap does not list the asset, we can't list the asset here either. So if you have an asset that's not listed, you'll need to make sure there are no other assets closely matching the ticker symbol used. This is because our system will try to match it if you don't and may match it incorrectly if there is a similar ticker symbol. If we do not list the asset and there are no close matches, then you can leave the field blank. Leaving an asset blank will make the asset show up in the "unknown currencies" section of the review process so you can classify it at a later date.
Once you have finished classifying your assets, press "Save" to complete the upload.