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 wizard, 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"
- Order Id - An optional 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 is describing:
On March 1 2019 - Bought 1 BTC at a cost of $5800.00 in order Id f1e65d14-f35c-40b6-af9e-107193ddc92b
On April 8 2019 - Sold 1 BTC for 20 ETH
Note that orders between one crypocurrency and another are denoted by a '-' or '/' between the symbols.
On August 10 2019 - Sold 8.5549 ETH for $248.50 each (total of $2125.89) in order Id b5ede5e0-214b-4f80-a49b-282fd78eec45
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) in order Id 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)
If an exchange can not be integrated into Ledgible with an API connection, you have the option to generate a CSV transaction report from your exchange, and import the file into Ledgible. Unlike an API connection, uploading your transactions to Ledgible through File Import will not allow Ledgible to refresh your transactions if there is any crypto activity after the date of file import. Any subsequent activity would need to be added either as a new file import, or created as a manual transaction.
To upload your CSV file into Ledgible:
- Log into your Ledgible account.
- Navigate to the Exchanges tab at the top of the page.
- Click + Add Exchange Data on the right hand side of the screen.
- In the list that appears, select File Import.
- On the following page, select your exchange. For the purposes of this example we will be using Coinbase.
If the exchange is not listed, please select Exchange not listed / Template Import. If you select this option, at this point you will need to follow the File Import Template Guide to ensure Ledgible captures your transactions correctly. NOTE DO THAT ARTICLE LOL
- On the same page after selecting your exchange, enter your account type, and click on the blue section to upload your CSV file obtained from your exchange. Once uploaded, the blue area will turn green and confirm the number of transactions processed.
- On the following page, enter the name you would like Ledgible to display for this exchange, and click Create. The exchange will be added to Ledgible. Run an account refresh, and your transactions will be displayed.
You can now proceed with uploading any other exchange or wallet data to Ledgible. If you have uploaded all of your sources, you can now review your transactions and fix any transaction exceptions.