Ledgible currently supports most popular wallets and exchanges automatically. This means users can set up an API connection to link their exchange, or simply enter a wallet address for a certain type of cryptocurrency for Ledgible to obtain all transactions linked to that address.
Other sources of cryptocurrency data may not be able to be linked automatically. In this case, users can generate a file from their exchange or wallet, and in many cases, upload this directly to Ledgible with no formatting required. For more information on which files can be uploaded with no formatting required, please see this article in our Knowledge Base.
The final method of upload to Ledgible is for data sources that are not yet listed amongst our available wallets or exchanges. If not listed, transactions can still be uploaded by formatting them according to our File Import templates. This process may vary in difficulty based on the file obtained from your cryptocurrency data source, and this section aims to cover the main difficulties users may face when formatting their transactions for upload.
Please note that Ledgible Support services are happy to format 1 file per client. Additional formatting requests will incur an additional charge. An estimate based on the complexity of the task will be provided.
There are three types of template for transactions that can performed within wallets: "regular" transactions, DeFi activity, and NFTs. If your wallet address contains all of these activity types, this means you will need to upload three separate files to encompass all of your activity.
1) To obtain the file formatting template for DeFi activity:
- Head to the Crypto Sources tab in your Ledgible account.
- Click Add Source on the top-right side of the screen.
- Click Add Unlisted Source, then Add Unlisted Chain.
- Enter a name for your Crypto Source, then select Import transactions from files.
- Select the type of activity you are reporting, and click Next. In this case we are selecting DeFi Activity.
- On the following page, you will be able to obtain the template into which you can insert your transactions.
2) Once you have obtained the template for DeFi activity, you can begin formatting your transactions.
Ledgible supports the import of staking transactions, liquidity pool transactions, and DeFi swaps through the DeFi transaction template. The template contains the following columns:
Timestamp: the timestamp of the transaction.
Timezone: the timezone the transactions occurred in. This will default to UTC if left blank.
Type: the transaction type. Must be one of the following: depositStake, removeStake, stakingReward, swap, addLiquidity, or removeLiquidity.
DeFi Provider: platform the transaction occurred on, for example Uniswap or Sushiswap. If unsure, can be entered as "generic".
Chain: the chain the asset was swapped on, such as ETH.
Asset #1: the cryptocurrency symbol of the first coin or token being interacted with.
Quantity #1: the cryptocurrency symbol of the first coin or token being interacted with. For the symbol being deducted, a negative value must be entered.
Asset #2: the cryptocurrency symbol of the second coin or token being interacted with.
Quantity #2: The cryptocurrency symbol of the second coin or token being interacted with. For the symbol being deducted, a negative value must be entered.
Asset #3 (optional for liquidity pools): the cryptocurrency symbol of the third coin or token being interacted with.
Quantity #3 (optional for liquidity pools): The cryptocurrency symbol of the third coin or token being interacted with. For the symbol being deducted, a negative value must be entered.
Asset #4 (optional for liquidity pools): the cryptocurrency symbol of the fourth coin or token being interacted with.
Quantity #4 (optional for liquidity pools): The cryptocurrency symbol of the fourth coin or token being interacted with. For the symbol being deducted, a negative value must be entered.
Pool Removal Percentage (optional for liquidity pools):: If withdrawing from a liquidity pool incurs a removed percentage, you can enter this in this column.
Fee: the quantity of the fee paid.
Fee Currency: the currency of the fee paid.
DeFi transactions can be complex in nature, and Ledgible Support is happy to assist if you are encountering any difficulties. Below are some examples of correctly formatted transactions of several different types, also available in the template: