Some exchanges have closed/shut down making it difficult (or most likely impossible) to get a copy of your transaction history if you didn't export this before the website closed.

You can upload CSV files for all closed exchanges including MtGox, QuadrigaCX, and Cryptopia to Coinpanda if you have these files. If you don't have this, there are still a few things you can do:

Tag Send (no tag) transactions as Lost

Go to the Transactions page on Coinpanda and filter for Send and No label. See if you have any outgoing Send transactions resulting in a large gain. If any of these transactions is a withdrawal to the closed exchange, you can tag it as Lost so that Coinpanda will not realize the gains on the transaction. The amount sent will instead be included in your Expense summary in the tax report and you might be allowed to report this as a loss in your tax return.

Import transactions manually

If you remember which coins you traded on the exchange, you might be able to add some transactions manually to the best of your knowledge. First, you should start by identifying Send and Receive transactions to and from the exchange and tag these as Deposit/Withdrawal so that they will be classified as internal transfers.

The next step is to make a list of all internal transfers sent to and from the exchange to identify which coins you need to add transactions for. Let's look at an example:

You have identified two transactions where BTC was sent to the exchange (deposited) and three transactions where ETH, LTC, and DOGE were transferred out of the exchange (withdrawn). You know now that you have sold BTC and received ETH, LTC, and DOGE in return (ignoring that you might have traded other coins interim). There are several ways to create these transactions, but here is what we recommend:

  1. Pick a date between the date you received BTC and withdrew ETH. This will just be a guess since you don't know the exact date(s) you traded ETH-BTC.

  2. Find the price of ETH-BTC on that date and calculate approximately how much BTC you would have sold to acquire the ETH. You can find these prices on Coingecko, Coinmarketcap, or other similar sites.

  3. Repeat the previous steps also for LTC-BTC to calculate the amount BTC sold to acquire LTC.

  4. The remaining BTC amount is now an approximation for what you paid to acquire DOGE. Because crypto prices can fluctuate wildly, these approximations might be very wrong. However, your net gain/loss will not be impacted that much when all your coins have been disposed of.

  5. Now you just need to enter these three transactions into Coinpanda.

Practical example:

You have the following transactions:

0.2 BTC Deposit (sent to Cryptopia) - January 10, 2018
0.5 BTC Deposit (sent to Cryptopia) - January 28, 2018
9 ETH Withdraw (transferred out of Cryptopia) - March 14, 2018
12 LTC Withdraw (transferred out of Cryptopi) - June 12, 2018
55,000 DOGE Withdraw (transferred out of Cryptopis) - August 4, 2018

Step 1: we will pick February 1st, 2018 as our date (just a random date)

Step 2: the price of ETH-BTC on February 1 was 0.114.

Approximate amount BTC sold: 9*0.114 = 1.026 BTC

Step 3: the price of LTC-BTC on February 1 was 0.01558.

Approximate amount BTC sold: 12*0.01558 = 0.18696 BTC

Step 4: remaining BTC = 1.5 - 1.026 - 0.18696 = 0.28704 BTC

Step 5: Now we need to enter the following transactions in Coinpanda:

  • 1.026 BTC → 9 ETH

  • 0.18696 BTC → 12 LTC

  • 0.28704 BTC → 55000 DOGE

These transactions can be added manually or imported using the generic Excel file. Remember to use February 1st, 2018 as the date.

We want to emphasize that this should not be considered as legal advice and that you should always consult a tax professional if you don't know how to report taxes for closed exchanges. You can also take a proactive approach and ask your tax authority directly - they might be able to clarify if the suggested method above is allowed or not. If you decide not to do, we recommend that you always make a note of this in your tax return explaining that you have entered the information to the best of your knowledge.

Did this answer your question?