Start with the import history
Make a list of the files and connections used for each account. Record the source name, import method, date range, import date, and time zone. Overlapping coverage is easier to spot in this inventory than in a total balance.
CoinLedger’s duplicate-import guidance identifies repeated wallet addresses and mixing CSV and API imports for the same exchange as possible sources of duplicates. Its duplicate detection depends on the import method; a completed import is not proof that every repeated event was removed.
Build a candidate list, then verify it
- Compare the source account. Similar activity in different accounts may describe a transfer rather than a repeated trade.
- Compare identifiers. Use trade IDs, order references, and transaction hashes where available. A single order or on-chain transaction can include several entries, so also inspect the row’s role.
- Compare the event details. Check the asset pair, quantities, timestamp, direction, fee, and description against the source.
- Compare coverage. Establish whether both imports include the same underlying event or whether one file supplies missing information.
Keep “possible duplicate” separate from “confirmed duplicate.” Identical amounts or a shared order ID alone do not establish that one entry is redundant.
Demo: overlapping CSV and API imports
Fictional imports · CSV: Jan–Mar · API: Feb–Dec.
- One duplicate
- Both imports show TRADE-101: 0.200 ETH, matching event details. Keep one trade with both source references.
- Unique trades
- January’s TRADE-100 appears only in CSV; November’s TRADE-201 only in API. Keep both.
- Distinct details
- TRADE-102 is a separate 0.200 ETH execution. The fee row for TRADE-101 also stays.
Six source rows become five working-ledger records. Keep both original imports; deleting the full CSV would lose the January trade and fee detail.
Keep corrections reversible and traceable
Preserve the downloaded source files. Before changing imported data, keep an export of the current ledger and note which rows or imports you will review. If you use software, check its current instructions for managing imports.
Removing an entire overlapping import can also remove rows absent from the import you keep. Compare the periods and event types first. Record the action, the reason, the supporting source, and any detail retained from the secondary file.
After the change, review the affected transaction count, balances, and warnings. A lower row count is expected only when the evidence supports repeated entries; a changed total by itself does not establish accuracy.
When to ask for a cleanup review
Consider a review when repeated imports span several exchanges, when the files use different formats, or when the same issue returns after a sync. Elena’s transaction cleanup service brings source coverage, duplicate checks, and documented corrections into an agreed ledger.
In your inquiry, name the software, affected account, years, and import methods. Keep the source files available for the next step.
See how the records fit together
View the illustrative record package to compare source rows, a working ledger, correction notes, and an open-items list.
Related recordkeeping guides