RECORDS · EXPORTS · RECONCILIATIONIndependent publication / Not Binance
REKQO
MAKE EVERY ENTRY CLEAR.
Start with the source records.
Build a ledger you can trace.
English

Reconcile one asset at a time

Use quantities from the same period and account boundary. This worksheet does not calculate investment returns or tax.

Include this asset’s trade and conversion movements, not just deposits and withdrawals. Enter non-negative quantities: an outflow of −120 goes here as 120. Up to 8 decimal places; no commas or scientific notation.

Enter 0 here if outflows already include fees. Only include fees paid in this asset.

Your comparison

Expected closing quantity—
Actual − expected—

Enter quantities and calculate.

How should I use this worksheet?

Set a consistent boundary before entering numbers: one asset, one set of accounts and the same opening and closing times. A fiat valuation on an account screen is not the asset quantity requested here.

  1. Use an opening quantity from the beginning of the period. Include only movements inside that period.
  2. A transfer between two accounts inside your boundary does not create additional assets for the combined set. Movements across that boundary belong in the appropriate flow.
  3. Use a consistent fee convention. If the outflow is already inclusive of fees, enter zero in the separate-fee field.
  4. Compare the actual closing quantity with the expected one. A positive difference means actual is higher; a negative difference means it is lower.

For example, 1,000 USDT opening plus 250 in, less 120 out excluding fees, less a 2 USDT fee, gives 1,128 USDT. An actual balance of 1,130 leaves a difference of 2. That is a starting point for investigation, not proof of a missing fee.

A zero difference does not establish completeness. Opposing missing entries can cancel out. Keep the source files and check the underlying entries before treating the period as reconciled.

Download the blank month-end checklist (CSV)

Continue the checks