If you want to import transactions from an exchange, wallet or service, the most easy and accurate way of doing so is to connect with API keys or import a downloaded CSV/XLSX file to Coinpanda. Even though we support almost every single exchange on the market today (and we are continously adding support for more), there might be a few reasons you want to import transactions using our generic Excel file template instead:
- the exchange/wallet/service is not supported
- the exchange does not support API or export of transactions as CSV file
- exported file contains wrong or missing data
- you have gifted, donated, spent or lost crypto
Below is an example of how transactions may be entered in the generic file template:
Import transactions in 3 steps
- Download the sample file
- Delete all example transactions and add your own according to the requirements and notes as specified below
- Save the file and upload to Coinpanda
Instructions for how to upload the file is shown below:
You can download the generic file template in XLSX format below. The file contains 23 example transactions to demonstrate the input and data format for different transaction types.
- Date: date and time format must be DD.MM.YYYY hh:mm:ss. All dates should be UTC timezone.
- Type: you can use all transaction types and labels supported by Coinpanda (trade, deposit, withdrawal, receive, airdrop, fork, gift, mining, staking, loan interest, other income, realized p&l, send, spend, lost, stolen, donation, deductible cost). Further explanation and examples are shown below.
- From: this is amount sold/withdrawn/sent (outgoing)
- Curr. (From): this is currency sold/withdrawn/sent (outgoing)
- To: this is amount bought/deposited/received (incoming)
- Curr. (To): this is currency bought/deposited/received (incoming)
- Fee: fee amount (optional)
- Curr. (Fee): fee currency (optional)
- decimal separator can either be comma (,) or dot (.)
- fee is always on top of what you paid or sent. Example: you bought 0.5 BTC and paid 4,500 EUR + 25 EUR in fees. In this case, ‘From’ should be 4,500 EUR, ‘To’ should be 0.5 BTC, and ‘Fee’ 25 EUR. Alternatively, you can specify ‘From’ as 4,525 EUR (total amount paid) and leave ‘Fee’ empty which gives the same cost basis.
Example transactions from sample file explained
Row 2: the first transaction in the sample file is a trade transaction. In this case we have bought 1.5 BTC and paid 5,000 USD. We did not pay any fee so this field is left empty.
Row 5: this is also a trade transaction. On 4th of January we sold 10 ETH and got paid 850 USD. We did also pay a fee of 0.001 BTC to the exchange which is specified in the Fee column.
Row 7: we made a withdrawal of 20,000 ADA from an exchange. The exchange charged a fee of 5 ADA for the withdrawal which is specified in ‘Fee’ column. Note that we must specify 5000 ADA in the ‘From’ column and NOT the ‘To’ column (a withdrawal is outgoing, not incoming).
Row 9: Ontology did an airdrop of ONT tokens to early supporters. We were lucky and received 1,000 ONT on 8th of January 2019. Note that the amount is specified in the ‘To’ column because an airdrop is incoming (an increase in our holdings).
Row 18: we buy coffee at the local coffee shop which happens to accept crypto payments. We paid 0.67 ETH for the coffee from our mobile wallet, which we specify in the ‘From’ column because it’s an outgoing transaction (a reduction in our holdings).
- Trade: value in both ‘From’ and ‘To’ column must be specified (fee is optional)
- Deposit: specify value in ‘To’ column only (fee is optional)
- Withdrawal: specify value in ‘From’ column only (fee is optional)
- Receive, airdrop, fork, mining, staking, loan interest, other income: specify value in ‘To’ column only (fee is not allowed and will be ignored)
- Send, spend, lost, stolen, donation, deductible cost: specify value in ‘From’ column only (fee is not allowed and will be ignored)
- Realized P&L: specify value in ‘From’ column for trading loss (reduction in holdings), and ‘To’ column for trading gain (increase in holdings)
- If you have received crypto as gift, you’ll need to specify a value in both ‘From’ and ‘To’ column. The original cost basis for the crypto received should be in ‘From’ column.
- If you have gifted crypto to someone else, simply specify the amount given in ‘To’ column (leave ‘From’ empty!)