Bank Reconciliation
Match your cash book against the bank statement and produce a proper reconciliation — outstanding items, unrecorded charges and adjusted balances on both sides.
Nothing you paste leaves this page. Parsing and matching happen in your browser.
How it works
A bank reconciliation explains the gap between what your books say and what the bank says. The gap is never mysterious once it is itemised: it is made of cheques you have written that have not cleared, deposits that have not landed yet, and bank charges or interest you did not know about.
The two sides adjust in opposite directions, which is the part people get wrong. Items in your books but not on the statement adjust the bank balance. Items on the statement but not in your books adjust the book balance. Done correctly, both adjusted figures land on the same number — and if they do not, the residual is a genuine error worth chasing.
Adjusted bank = statement balance + items in books only · Adjusted book = book balance + items on statement only
- Deposits in transit — money you have recorded that the bank has not yet credited
- Outstanding cheques — payments you have recorded that have not yet cleared
- Unrecorded items — charges, interest and direct debits the bank applied without your knowing
Worked example
A cash book closing at 486,200 against a statement closing at 495,700
Inputs
Results
The 9,500 gap resolves fully into two outstanding cheques, a deposit in transit and a bank charge. Both sides land on 484,750, and a zero residual is what a completed reconciliation looks like.
Frequently asked questions
What format should I paste?
Copy straight out of a spreadsheet, or paste CSV. A header row is optional — columns are identified by their headings when present and by their content when not. Dates, references and amounts are detected automatically, and amounts may carry currency symbols, thousands separators or accounting parentheses.
What does a non-zero residual mean?
Something is genuinely wrong rather than merely outstanding: a transposed figure, a duplicated entry, a missing transaction, or a payment recorded at the wrong amount. Check the amount-mismatch table first — that is where transposition errors surface.
How should I handle bank charges the statement shows?
They belong in the "on statement only" list, and they need posting to your books. Until they are, your book balance overstates the cash you actually have.
My bank shows payments as negative and my books show them as positive.
Set the sign convention to flip the statement. Otherwise every payment will appear as an exception on both sides at once.
Is my ledger data uploaded anywhere?
No. Every line you paste is parsed and matched inside your browser. Nothing is transmitted to us, nothing is stored, and closing the tab discards it. That is the whole reason this tool exists in this form.
More in Reconciliation
Two-List Matcher
Paste any two lists of transactions and find what does not line up — matched pairs, exceptions on each side, and duplicates within either.
ReconciliationInvoice vs Payment Reconciliation
Match payments received against invoices raised, and find the short payments, overpayments and unallocated cash sitting in your receivables.
ReconciliationPayment Gateway Payout Reconciliation
Reconcile what the gateway actually paid you against what your orders say it should have — with fees, refunds and missing settlements itemised.
ReconciliationGST / VAT Return Reconciliation
Match your purchase register against what your suppliers actually filed, and find the input tax credit you are about to lose.
ReconciliationDuplicate Payment Detector
Scan a payment run or a full year of ledger for payments made twice — the same supplier, the same amount, days apart.
ReconciliationAR / AP Aging Report Builder
Turn a flat list of open invoices into a proper aged report — bucketed, totalled, and sorted by how long the money has been outstanding.