venko.tech

What Happens if You Lost the CSV from a Closed Exchange?

You lose the ability to automatically reconstruct your trade history and cost basis for that exchange's activity. Without the CSV, you must manually piece together your records from whatever sources remain, and the difficulty of that task depends on how much other data you saved outside the exchange.

Why the CSV mattered

When an exchange shuts down, its API stops working and its web interface disappears. The CSV export you downloaded before closure was your only structured record of every trade, deposit, withdrawal, and fee. It contained timestamps, amounts, trading pairs, and transaction IDs - information that portfolio tracking software reads directly to calculate gains and losses.

Without that file, you have no single authoritative source for what happened inside that exchange. Your portfolio tracker will show a gap in your history, and any tax report you generate will miss those trades unless you fill in the missing data manually.

What you still might have

Even without the CSV, you may hold several pieces of the puzzle:

How to Reconstruct the Missing History

Step 1: Gather every available source

Collect all email confirmations, blockchain explorers, bank statements, and any saved screenshots. Create a folder or spreadsheet where you can organize them chronologically. This step is tedious but necessary - every piece helps narrow down what happened.

Step 2: Rebuild the timeline

Start with your first deposit to the exchange and your final withdrawal. Use blockchain explorers to find the dates and amounts of crypto transfers. Use bank statements for fiat deposits and withdrawals. Place each confirmed movement on a timeline.

Between deposits and withdrawals, you know you traded, but you don't know exactly when or at what price. You can estimate by looking at the market prices on the dates your deposits arrived and your withdrawals left. This is rough - you'll lose precision on timing and may miss small trades entirely.

Step 3: Decide on a reconstruction method

You have two choices, and the one you pick depends on how much detail you need:

Step 4: Enter the data into your portfolio tracker

Most crypto portfolio tracking software allows manual transaction entry. You will need to input each trade, deposit, withdrawal, and fee by hand, including the date, asset, amount, and price. For trades without a known price, use the estimated price from Step 3 and note in a comment that this is a reconstruction.

What this means for your cost basis

The biggest problem is that without the CSV, you lose the exact cost basis for each trade. If you later sell a crypto that you originally bought on the closed exchange, the gain or loss calculation depends on knowing what you paid. A rough estimate may cause you to overpay or underpay tax.

If the exchange closed years ago and you never filed taxes on those trades, you may need to amend past returns or consult a tax professional. The longer you wait, the harder the reconstruction becomes.

What you should do now for any open exchange

The lesson is straightforward: download CSV exports regularly from every exchange you use, even if you think the exchange is stable. Store them in at least two places - local storage and cloud backup, or an encrypted USB drive. When you close an account, download the CSV before you lose access. A single export covers your entire history on that exchange, and once it is gone, it is gone for good.

Not financial advice. venko.tech publishes market data and general information about digital assets. Crypto assets are volatile and you can lose everything you put in. Nothing here is a recommendation to buy, sell or hold, and we make no price predictions.

Prices are sourced from third parties and may be delayed or wrong. Verify anything you intend to act on against a primary source.

Back to portfolio