Reconciling Exchange and Wallet Records: Finding the Missing Trades

On Wednesday 4 November 2026, with Binance reporting net withdrawals of $4.72bn since reopening after the 29 October theft, Reconciling Exchange and Wallet Records is a timely discipline for anyone who moved funds in a hurry. Reconciliation means proving that two independent records, exchange history and wallet history, describe the same reality, and any gap between them is a missing trade, an unrecorded transfer, or a fee nobody logged. The work is detective work: match deposits to withdrawals, follow assets across chains, and explain every balance change with a dated event. The glossary defines the record types involved, and the best scanners page reinforces a useful habit: verify across independent sources instead of trusting one view.

Start With Balances, Not Transactions

Begin reconciliation from balances, because a balance gap tells you the size of the problem before you drown in transaction lists. For each asset, compare the exchange balance, the wallet balance, and your ledger balance at the same timestamp, and record the difference for each. If the ledger is lower than the exchange, entries are missing; if it is higher, phantom entries or duplicated imports are likely. Work asset by asset rather than all at once, starting with the largest balances, since a single large asset often explains most of the total gap. This balance-first approach prevents the common trap of fixing small transactions for hours while a single large transfer remains unexplained.

Match Transfers Across Both Sides

Most reconciliation gaps are transfers recorded on one side only. A withdrawal from an exchange should appear as a deposit in a wallet, with matching asset, amount minus network fee, and a transaction identifier linking them, and the reverse applies for deposits. Build a transfer table with sending side, receiving side, asset, amount, fee, and identifier, then tick off each pair as matched. Pay special attention to bridge transfers, which change chains and sometimes asset representations, and to internal transfers between sub-accounts on the same exchange, which may not generate a blockchain record at all. Unmatched items at the end of this step are your investigation list, and each one needs either a missing entry or a correction.

• Compare exchange, wallet, and ledger balances per asset at one timestamp.
• Match every withdrawal to a corresponding deposit using transaction identifiers.
• Flag bridge transfers separately, since chain and asset representation may change.
• Check internal sub-account transfers that leave no blockchain trail.
• Investigate unmatched items one by one until every gap has an explanation.

Common Causes of Missing Trades

Missing trades usually come from a short list of causes, and recognising them speeds the search. Delisted or renamed assets break automated imports, small dust conversions and staking rewards arrive without obvious trade records, and failed transactions that later succeeded create duplicates or omissions. API exports sometimes cover only a limited date range, silently dropping older history, while manual imports can duplicate a month when a file is loaded twice. The cross-exchange guide notes how venue differences complicate even simple comparisons, and reconciliation across venues multiplies that complexity. When a gap resists explanation, widen the date range, check the asset's full history on a block explorer, and look for events outside trading, such as fees, rebates, or airdrops.

Reconcile in a Repeatable Monthly Cycle

Reconciliation should be a monthly cycle, not an annual emergency. At month end, export exchange histories, download wallet histories, update the ledger, and run the balance comparison before the month's details fade. Keep a reconciliation note for each month recording the starting gap, the items found, and the ending gap, so next month starts from a known position rather than from scratch. If a gap cannot be resolved, record it explicitly as unresolved with its size and suspected cause, instead of forcing a balancing entry that hides the problem. A small, honestly labelled unresolved item is far safer than a fabricated adjustment, because it can be revisited when new information appears.

When to Seek Professional Help

Seek professional help when gaps involve large amounts, when assets passed through mixers or privacy tools you cannot fully document, or when a tax filing deadline approaches with unresolved differences. An accountant or forensic bookkeeper can advise on reasonable estimation methods permitted in your jurisdiction, but they need your honest gap list, not a polished fiction. This article describes general record-keeping principles only and is not tax advice, and rules vary by jurisdiction. Bring complete exports, transaction identifiers, and your monthly reconciliation notes, since professionals resolve gaps fastest when the investigation trail is already laid out.

AI Help: Muse AI

Muse AI is Meta's personal AI assistant. It can explain reconciliation steps in simple words and help you draft a monthly checklist for matching exchange and wallet records. Join Muse with invite code LTGSWD — in the Muse app, go to Settings > Redeem token and enter the code. Disclosure: LTGSWD is the author's Muse invite code. Muse AI is not a trading tool and does not give financial advice.