SheetCompareBank Reconciliation Template
Match your ledger against the bank statement, with a live difference column and totals that flag anything out of balance.
What's in it
- Statement Amount — The amount as it appears on the bank statement.
- Book Amount — The amount as recorded in your books.
- Difference — Auto-calculated (Statement minus Book). Anything non-zero needs explaining.
- Cleared — Whether the transaction has cleared the bank (Y/N).
A bank reconciliation proves that your own record of cash matches the bank's. This template lines up each transaction's statement amount against your book amount and computes the difference automatically, so a fee you haven't booked or a deposit in transit shows up as a non-zero number instead of a silent gap. The totals row sums both sides and the difference, giving you a single 'out of balance' figure to chase to zero.
It's deliberately plain: no macros, no add-ins, just columns, sample rows, and formulas you can read. Replace the sample data with your month, and the difference column and totals recalculate as you type.
How to use it
- 1
List every transaction
Enter each statement line with its date, description, reference, and the amount as the bank shows it. Use negative numbers for money out.
- 2
Add your book amount
Next to each line, enter the amount from your own ledger. The Difference column calculates Statement minus Book automatically.
- 3
Chase the differences to zero
Any non-zero difference is an unrecorded fee, a timing gap, or an error. Note it, fix the source, and confirm the totals row reads zero out of balance.
Frequently asked questions
Does the difference column calculate automatically?▾
Yes. The Difference column and the totals row are live Excel formulas. Edit the statement or book amounts and they recalculate immediately.
Can I use this in Google Sheets?▾
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas carry over.
How do I reconcile this against last month?▾
Fill in this month, then drop last month's copy and this month's copy into SheetCompare to see exactly which rows changed.
Related templates
Credit Card Reconciliation Template
Match each statement charge against what you recorded, with a variance column that flags mismatches and category tracking.
General Ledger Reconciliation Template
Reconcile each GL account against its subledger, with an automatic difference column, a reconciled flag, and a reviewer column for sign-off.
Petty Cash Reconciliation Template
Track every petty-cash transaction with a running-balance formula so the sheet total always matches the cash in the box.