Skip to content
All guides

Data and reconciliation · All teams · Sep 28, 2026 · 2 min read

Exchange CSV exports: the eight problems that break crypto records

Duplicates, missing fills, fee assets, time zones and more: how to spot each problem in an exchange export and fix it before it reaches a report.

By ChainLedger editorial team · Crypto audit, tax and fund reporting · Last reviewed

Key takeaways

  • Exchange exports are rarely complete or consistent. Assume they need checking.
  • A balance check against the live balance is the fastest way to find what's wrong.
  • Fix data with a recorded reason, never by editing the original export.

Most crypto record-keeping starts with exchange exports, and most crypto record-keeping problems start there too. Each exchange formats data differently, changes its formats over time and sometimes leaves activity out entirely.

The eight common problems

  1. 1Duplicates. Overlapping date ranges, or the same trade in two reports, double-count activity.
  2. 2Missing activity. Some exports omit staking, earn products, conversions, airdrops or futures.
  3. 3Split fills. One order appears as many small fills, or many orders as one line.
  4. 4Fee asset confusion. Fees charged in a third token, such as an exchange token, are easy to miss.
  5. 5Time zones. Exports in local time mixed with others in UTC put trades in the wrong order or year.
  6. 6Internal transfers. Moves between spot, futures and earn accounts look like deposits and withdrawals.
  7. 7Renamed or delisted assets. Tickers change, and delisted tokens can vanish from later exports.
  8. 8Closed accounts. Once an account is closed, getting its history can be hard or impossible.

How to find the problems

CheckWhat it catches
Rebuild the balance from the export and compare with the live balanceMissing activity, duplicates and fee errors
Compare deposits with withdrawals from the client's other accountsInternal and external transfers that weren't linked
Look for negative balances at any point in timeMissing purchases or wrong ordering from time zones
Compare totals with the exchange's own statementsMissing products and date range gaps

Fixing problems the right way

When something needs fixing, add the correction on top with a reason and the evidence behind it, and keep the original data untouched. Editing the export directly destroys the trail that a reviewer or auditor needs to follow.

ChainLedger syncs exchanges with view-only API keys where possible, rebuilds every balance and compares it with the live one, and records every correction as a layered adjustment with who, when and why.

Related product page: Wallet and exchange integrations