If your exchange is not listed in the Exchange API Data drop down menu, or you do not wish to use the API to connect to permit read-only access to the exchange directly, you can opt to manually import the transactions using the File Import option if the exchange allows you to download/export your transaction history into a file. This article contains the following sections:
File Import Step-By-Step Instructions
Please see the following step-by-step instructions once you have downloaded your transaction history from the exchange:
- Log in to your Ledgible account and select the Exchanges tab.
- Select the Add Exchange Data button from the top right.
- Select the radio button (circle) to the left of File Import and then select Next.
- If your exchange IS listed, select the exchange from the list and follow the instructions to import your transaction file.
If your exchange IS NOT listed, you will need to use the template file to ensure your transaction export file is processed correctly into Ledgible. Choose Exchange Not Listed/Template Import from the bottom of the list. See the information below for examples and details on importing your file using the template.
Using the File Import Template for Unlisted Exchanges
To upload transactions using the File Import feature, please note the following examples and instructions.
Note that these instructions are also included in the template file you can download through the application; please remove any of the lines that begin with 'DELETE-ME;' prior to attempting to upload your data.
IMPORTANT: You *must* remove all lines beginning with 'DELETE-ME' before attempting to upload this file
Each row that you upload must include the following fields in the following order:
- Date - The date on which the transaction occurred
- Must be in yyyy-mm-dd format (i.e. 2019-01-01)
- Type - The type of the transaction
- Must be one of: buy / sell / withdrawal / deposit
- Currency Symbol - The Symbol of the cryptocurrency you bought or sold in the transaction
- Ex: BTC or ETH
- Amount - The number of units of the cryptocurrency you bought or sold in the transaction
- Ex: "3.5738"
- Price (USD) - The per-unit USD price for the cryptocurrency you bought or sold when the transaction occurred. Only numbers and decimals - do not include dollar sign ($) or thousands place separator / comma
- Ex: "6000.00"
Seven correctly formatted sample entries have been provided below along with a description of the trade(s) each are describing:
On March 1 2019 - Bought 1 BTC at a cost of $5800.00
On April 8 2019 - Exchanged 1 BTC for 20 ETH
Note that crypto-to-crypto transactions are represented by two lines - one line for the "sell" and one for the "buy"
First line - On April 8 2019 - Sold 1 BTC for $6000.00
Second line - On April 8 2019 - Bought 20 ETH for $300.00 each (total of $6000.00)
On August 10 2019 - Sold 8.5549 ETH for $248.50 each (total of $2125.89)
On September 22 2019 - Sold 11.4451 ETH for $328.31 each (total of $3757.54)
On October 28 2019 - Deposited 3 ETH to an exchange with a value of $300 each (total of $900.00)
On November 13 2019 - Withdrew 3 ETH from an exchange with a value of $320 each (total of $960.00)