Reconcile your statement and cash ledger in two transparent steps. Add timing differences and missing book entries, then review the difference instantly.
Works offline · No registration · Inputs stay on this device · Fictional demo loadedDeposits in transit are added. Checks or payments outstanding at cutoff are subtracted. Enter positive amounts.
| Item type | Reference | Amount ($) | Open at cutoff? | Remove |
|---|
Enter verified items on the statement not yet recorded in the original ledger. Positive cash credits increase the balance.
| Cash effect | Reference | Amount ($) | Include? | Remove |
|---|
Choose the statement cutoff date and enter the bank's closing balance alongside the unadjusted cash balance in your accounting ledger as of the same date. The example values are fictional. Replace them with figures from records you are authorized to use.
Use bank-side timing items for deposits already recorded in the ledger but not yet credited by the bank, and for checks already recorded in the ledger but not yet cleared. Deposits in transit increase the adjusted bank balance; outstanding checks decrease it.
Use book-side adjustments only for verified transactions shown by the bank that were not yet included in your original cash ledger, such as bank fees, interest credits or automatic payments. Enter cash increases as book credits and cash decreases as book debits. These labels describe their effect on the cash balance, not the debit or credit side of a journal entry.
The calculator compares adjusted balances and reports any remaining difference. Download the CSV to keep a record of the figures used. The tool does not import bank statements, connect to financial institutions, generate journal entries or store your input between sessions.
A zero difference means the two adjusted cash balances agree mathematically. It does not prove all transactions were authorized, correctly classified or supported by evidence. Do not create an unsupported balancing adjustment merely to make the result zero. Review the original statements, cleared transactions and outstanding-item schedules with a qualified accountant when necessary.
Prefer a structured worksheet? Download the free bank reconciliation Excel template (.xlsx) with sample transaction schedules and formulas. For the full fictional $12,205 example, explanations of the journal entries and monthly review checklist, read our bank reconciliation example for small businesses.
Educational use only. This free calculator provides arithmetic assistance, not accounting, legal or tax advice. Download or print your work before closing this tab.