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 MM/DD/YYYY HH(24h):mm:ss format
- The date will be converted to UTC time upon upload
- Ex: 12/14/2019 13:45
- 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"
- Tax Category - An optional classification that can be added to orders for tax purposes. The options available depend on the type of order.
- Buys and Sells cannot have a category included.
- Deposits may have one of the following: fork, work, deFi, mining, stakingReward, or gift.
- Withdrawals may have gift or donation.
- Order Id - A unique identifier to differentiate between orders. If not provided, a unique id will be created on upload.
- Ex: 32855494825
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 in order Id f1e65d14-f35c-40b6-af9e-107193ddc92b
2019-03-01,buy,BTC,"1.00","5800.00",,f1e65d14-f35c-40b6-af9e-107193ddc92b
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
2019-04-08,sell,BTC,"1.00","6000.00",,
Second line - On April 8 2019 - Bought 20 ETH for $300.00 each (total of $6000.00)
2019-04-08,buy,ETH,"20.00","300.00",,
On August 10 2019 - Sold 8.5549 ETH for $248.50 each (total of $2125.89) in order Id b5ede5e0-214b-4f80-a49b-282fd78eec45
08/10/2019 12:00,sell,ETH,8.5549,248.5,,b5ede5e0-214b-4f80-a49b-282fd78eec45
On September 22 2019 - Sold 11.4451 ETH for $328.31 each (total of $3757.54)
2019-09-22,sell,ETH,"11.4451","328.31",,
On October 28 2019 - Deposited 3 ETH to an exchange with a value of $300 each (total of $900.00) as defi in order Id dcb78a7b-3390-42b9-9e2a-a894503801ca
2019-10-28,deposit,ETH,"3.00","300.00",defi,dcb78a7b-3390-42b9-9e2a-a894503801ca
On November 13 2019 - Withdrew 3 ETH from an exchange with a value of $320 each (total of $960.00) as a gift
03/01/2019 12:00,withdrawal,ETH,3,320,gift,