A bank reconciliation statement is the evidence behind a zero difference. It starts with the statement balance and book balance, lists the timing and book adjustments separately, and shows how both arrive at the same adjusted cash balance.
The useful template is not the fanciest one. It is the one another person can pick up next month and understand without asking what a balancing number meant.
The reusable template
| Bank side | Amount | Book side | Amount |
|---|---|---|---|
| Closing bank statement balance | [A] | Closing cash balance in books | [B] |
| Add deposits in transit | [C] | Add interest and bank credits not recorded | [F] |
| Subtract outstanding payments | [D] | Subtract fees, charges and bank debits not recorded | [G] |
| Add or subtract bank errors | [E] | Add or subtract book corrections | [H] |
| Adjusted bank balance | A + C – D +/- E | Adjusted book balance | B + F – G +/- H |
The two adjusted balances must be equal. Keep a supporting list beneath every grouped amount. A line that says “outstanding payments 4,820” is not enough. List the payment date, payee, reference and amount that make up 4,820.
Filled example
Blue Oak Studio is reconciling its operating account at September 30.
| Bank side | Amount | Book side | Amount |
|---|---|---|---|
| Statement balance | 24,930 | Book balance | 23,985 |
| Add two deposits in transit | 2,400 | Add interest received | 15 |
| Subtract three outstanding payments | -1,860 | Subtract bank fee | -30 |
| Bank error | 0 | Correct payment entered as 500 instead of 400 | +100 |
| Adjusted balance | 25,470 | Adjusted balance | 24,070 |
This statement does not reconcile. The difference is 1,400, so the work is not done. The team checks the deposit list and finds that the 1,400 item had already reached the statement. It was incorrectly included as a deposit in transit. Remove it and the adjusted bank balance becomes 24,070, matching the books.
That is why the supporting list matters. The formula was right. One member of a grouped amount was wrong.
Supporting schedules to keep
Deposits in transit
Keep the receipt date, customer or source, reference, amount and the date it subsequently appeared at the bank. An old deposit that never clears may be a posting error rather than timing.
Outstanding payments
Keep the issue date, payee, payment reference and amount. Review old items before carrying them forever. A cancelled transfer needs a book reversal. An uncashed cheque may need reissue under your local rules.
Book adjustments
Attach the bank evidence for fees, interest, chargebacks and direct debits. Record the account used for each entry, not just its amount.
A close checklist
- The opening balance agrees with the previous signed reconciliation.
- The statement and book closing dates are identical.
- Every matched item is unique and has the same amount.
- Every grouped adjustment has a supporting line-by-line schedule.
- Old outstanding items were reviewed, not rolled forward automatically.
- Book-only adjustments were posted before the final report was saved.
- The two adjusted balances agree with no unexplained plug.
- The preparer and reviewer are named where duties are separated.
Spreadsheet or accounting software
A spreadsheet is acceptable for a low-volume account if formulas are protected and the file is versioned. Its weakness is evidence: matching, edits and reviewer sign-off are easy to overwrite.
A dedicated bank reconciliation tool keeps matches close to the transactions that created the book balance. That shortens the investigation path and makes the final statement reproducible. Use the companion cash flow statement for movement analysis, but do not confuse it with reconciliation. One explains how cash changed. The other proves the cash balance.
Copy-ready formula
Adjusted bank balance = statement balance + deposits in transit – outstanding payments +/- bank errors.
Adjusted book balance = book balance + unrecorded bank credits – unrecorded bank debits +/- book corrections.
When those numbers agree, save the statement and its supporting schedules together. The schedules are part of the reconciliation, not optional working notes.
Frequently asked questions
What should a bank reconciliation statement include?
The statement balance, book balance, deposits in transit, outstanding payments, bank-only credits and debits, corrections, both adjusted balances, and a detailed supporting list for every grouped adjustment.
What is the bank reconciliation formula?
Adjusted bank balance equals statement balance plus deposits in transit minus outstanding payments, adjusted for bank errors. Adjusted book balance equals book balance plus unrecorded credits minus unrecorded debits, adjusted for book errors.
Can I use a spreadsheet template?
Yes for a low-volume account, provided formulas are protected, versions are retained, and every grouped amount has a supporting schedule. Accounting software is stronger when you need transaction-level matching and an audit trail.
Who should review a reconciliation?
Where the team is large enough, someone other than the person who records cash should review it. A small owner-operated business may not be able to separate duties, but the owner should still review old items and unexplained adjustments.
How long should outstanding items remain?
Only as long as they are genuinely expected to clear. Review old deposits and payments every close. A stale item may need cancellation, reissue or reversal under your bank and local accounting rules.
Is a cash flow statement the same as a reconciliation?
No. A cash flow statement explains cash movement across operating, investing and financing activities. A bank reconciliation proves why the book balance and bank statement balance agree at one date.
