Crypto recordkeeping guide

Duplicate crypto transactions: how to review overlapping imports

Two similar rows can be two records of one event, or two separate events. Start with the import history and source identifiers, then document which evidence supports any change to your working ledger.

From Elena Mocchi, CPA · Published · Updated · Reviewed by Elena Mocchi, CPA ·

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

  1. Compare the source account. Similar activity in different accounts may describe a transfer rather than a repeated trade.
  2. 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.
  3. Compare the event details. Check the asset pair, quantities, timestamp, direction, fee, and description against the source.
  4. 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

Work directly with Elena Mocchi

Seeing duplicate entries?
Let’s review the imports.

Tell Elena which software and import sources are involved, and where their date ranges overlap. A short overview is enough to discuss the review scope.

Message Elena on Telegram

Prefer a quick start? Get a free records check

Request a records quote

Describe the warning or record issue. A short overview is enough.

Add details about your records (optional)

A brief overview is enough. After I review it, you get a private portal link for your records.

Your details and message are sent to Elena by email to respond to your inquiry. See the privacy policy.