Bank Reconciliation Worksheet Template
Match your cash book to your bank statement. Identify unreconciled items and ensure accuracy.
File format: .xlsx (Microsoft Excel, Google Sheets, LibreOffice compatible)
Bank Reconciliation
- Side-by-side comparison
- Outstanding item tracking
- Unreconciled difference calculation
- Multiple bank account support
What is a Bank Reconciliation Worksheet?
A Bank Reconciliation Worksheet is a structured tool for comparing your recorded transactions against your actual bank statement. You tick off what matches, identify what does not, and calculate your true bank balance. It is the single most effective way to catch errors, spot fraud, and keep your books accurate.
Common use cases:
- Matching your cash book entries to your bank statement each month
- Identifying missing transactions or duplicate entries
- Spotting unauthorised transactions or fraud early
- Calculating your true bank balance including uncleared items
- Providing clean, reconciled records to your accountant at year-end
When to use this template
- You record transactions in a spreadsheet and need to verify accuracy
- Your bank balance never seems to match your records
- You want to catch errors before they become expensive problems
- You are preparing for year-end or a VAT return and need clean figures
What Your Template Contains
Everything you need, pre-built and ready to use. Just enter your data in the blue cells.
Side-by-Side Comparison
List your recorded transactions next to your bank statement entries for easy matching.
Outstanding Item Tracking
Record cheques issued but not yet cashed, deposits in transit, and pending transactions.
Unreconciled Difference Calculation
The template automatically calculates the difference between your records and the bank — zero means perfect reconciliation.
Multiple Bank Account Support
Separate reconciliation sheets for each business bank account or credit card.
Monthly Reconciliation Summary
Track reconciliation status month by month to ensure nothing gets missed.
Error Spotting Assistance
Common discrepancy causes are listed as a checklist — transposed numbers, missing entries, duplicates.
How This Template Helps Your Business
Catch Errors Before They Cost You
A small typo today can become a tax nightmare tomorrow. Monthly reconciliation catches mistakes while they are still easy to fix.
Spot Fraud Instantly
If your reconciliation does not balance, something is wrong. It might be fraud, a bank error, or a missed transaction — all worth investigating immediately.
Sleep Better at Year-End
Reconciled records mean your accountant works faster, your tax return is accurate, and HMRC has nothing to question.
Get Started in Minutes
No accounting knowledge required. Follow these simple steps and you'll be tracking your finances in no time.
Download TemplateDownload the template and open in Excel or Google Sheets
Enter your bank account details and opening balance on the cover sheet
List all transactions from your cash book or expense tracker in the "Recorded" column
List all transactions from your bank statement in the "Bank" column
Tick off matching items and note any differences
Investigate unreconciled items using the error checklist until the difference is zero
Related Templates
You might also find these useful
Cash Book
Track income and expenses month by month with automatic running balance, bank reconciliation, and profit summary.
Expense Tracker
Detailed expense logging with receipt tracking, mileage integration, and HMRC-compliant categorisation.
A/R Ledger
Track money owed by customers. Monitor invoices issued, payments received, and overdue amounts.
A/P Ledger
Track money you owe suppliers. Monitor bills received, payments made, and upcoming due dates.
Frequently Asked Questions
Quick answers about this template
Ready to Get Started?
Download this free template and take control of your business finances today.
Free download, no email required. Works in Excel and Google Sheets.