Trading Account Cash Reconciliation Resources
Explain the gap between an expected closing cash balance and your recorded balance.
A closing cash balance combines starting cash, external flows and the net trading component. This worksheet lays those pieces out in one currency and reports recorded minus expected. It is a practical way to isolate an unexplained amount instead of calling every balance increase a trading gain.
Trading Account Cash Reconciliation Worksheet
Reconcile opening balance, cash flows and trading results without treating transfers as profit.
Start with a hypothetical 1,000 USD, add 200 of deposits, subtract 50 of withdrawals, add 30 of gross realized P&L and subtract 5 of costs. Expected closing cash is 1,175 USD. A recorded 1,180 USD leaves a +5 USD difference to investigate. Using already-net P&L of 25 gives the same expectation.
Open the worksheet10 Services for Crypto Account Record Reconciliation
Reconciliation requires records with compatible scope. A trade export, a cash ledger and a portfolio valuation are different evidence. These resources can help obtain or organize records, but none is treated here as an independently verified balance audit.
Compare documented roles using cash-flow coverage, trades versus ledger records, transfers, already-included costs, recorded balance comparisons. The Telegram channel we promote is disclosed in the first entry.
Read the comparisonPrepare useful inputs
Use the same account scope, currency and period for every amount. Deposits and withdrawals are external flows. Select whether realized P&L is gross or already includes costs. If it is net, the costs field is not subtracted a second time.
Read results in their proper scope
A nonzero difference identifies a reconciliation gap; it does not determine its cause. Review omitted ledger movements, the period boundary and gross-versus-net amounts. This is cash reconciliation and does not automatically value open inventory or convert currencies.
The worked example and method can be read without JavaScript. Running the calculator requires JavaScript; its form values remain in the browser, with no account connection or quote lookup for calculation.
Official sources and scope
The sources document formats, mechanisms or record workflows. The arithmetic and editorial comparison on this page use the supplied worksheet definitions.
- Kraken account history export
Separate trades, ledger and balance exports.
Reference checked 2026-10-01. Consult the source for current product rules. - Kraken ledger versus trades
Trade fee estimates differ from actual ledger deductions and currencies.
Reference checked 2026-10-01. Consult the source for current product rules. - CoinLedger universal manual CSV
Provider-specific UTC transaction template, field mapping and already-included fee considerations.
Reference checked 2026-10-01. Consult the source for current product rules.