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
- 1Duplicates. Overlapping date ranges, or the same trade in two reports, double-count activity.
- 2Missing activity. Some exports omit staking, earn products, conversions, airdrops or futures.
- 3Split fills. One order appears as many small fills, or many orders as one line.
- 4Fee asset confusion. Fees charged in a third token, such as an exchange token, are easy to miss.
- 5Time zones. Exports in local time mixed with others in UTC put trades in the wrong order or year.
- 6Internal transfers. Moves between spot, futures and earn accounts look like deposits and withdrawals.
- 7Renamed or delisted assets. Tickers change, and delisted tokens can vanish from later exports.
- 8Closed accounts. Once an account is closed, getting its history can be hard or impossible.
How to find the problems
| Check | What it catches |
|---|---|
| Rebuild the balance from the export and compare with the live balance | Missing activity, duplicates and fee errors |
| Compare deposits with withdrawals from the client's other accounts | Internal and external transfers that weren't linked |
| Look for negative balances at any point in time | Missing purchases or wrong ordering from time zones |
| Compare totals with the exchange's own statements | Missing 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