File Import allows you to record on-chain transactions that occurred on non-supported blockchain by importing either a template file or on-chain transaction export file.
If your wallet does not provide a list of addresses or your public keys, 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 wallet allows you to download/export your transaction history into a CSV file. This article contains the following sections:
- File Import Step-By-Step Instructions
- Using the File Import Template for Wallets
- Example File Import Wizard Entries
- Related Resources
File Import Step-By-Step Instructions
Please see the following step-by-step instructions once you have downloaded your transaction history from the wallet:
- Log in to your Ledgible account and select the Wallets tab.
- Select the Add Wallet Data button from the top right.
- Select the radio button (circle) to the left of File Import and then select Next.
- Give your wallet a meaningful name in the Wallet Name field and then select Next.
- Use the template file to ensure your transaction export file is processed correctly into Ledgible. See the information below for examples and details on importing your file using the template.
Using the File Import Template for Wallets
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: transfer-in / transfer-out
- Currency Symbol - The Symbol of the cryptocurrency you bought or sold in the transaction
- Ex: BTC or ETH
- Quantity - The number of units of the cryptocurrency you transferred
- Ex: "3.5738"
- Tax Category - An optional classification that can be added to transactions for tax purposes.
- Options available depend on the type of transfer.
- Transfer-In: fork, work, deFi, mining, stakingReward, or gift
- Transfer-Out: gift or donation
- Adding a category is not required to upload.
- Transaction Id - An optional unique identifier to differentiate between transactions. If not provided, a unique id will be created on upload.
- Ex: d20212b2-2d1b-4a64-b063-bcaa4b6e69f1
Example File Import Wizard Entries
Two correctly formatted sample entries have been provided below along with a description of the transaction each is describing:
On March 1 2020 - Transferred 1 BTC a a gift in Transaction Id a79066cf-bf0f-4d84-8ec5-11b0bba89d27
On August 10 2020 - a transfer of 1.5549 BTC was sent to this wallet in Transaction Id 7c75c737-7e7a-493f-8e4b-4c2535fd98e8