Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets
Bank Reconciliation Statement Format (Excel & PDF)
Start from the cash book balance, add unpresented cheques and bank credits, deduct uncleared deposits and bank charges, and see if it matches the bank.
Opens in your browser. No Excel needed, no signup.
Free for personal and commercial use · No watermark · Updated November 2026
Guide
About this bank reconciliation statement template
A bank reconciliation statement (BRS) explains why the balance in your cash book differs from the balance on your bank statement on the same date. The usual reasons are cheques you issued that have not been presented yet, deposits the bank has not credited yet, and items the bank has recorded that are not yet in your books, such as bank charges, interest, standing orders and direct transfers from customers. This template starts from the cash book balance, adds and deducts each group, works out the balance that should appear on the bank statement, and shows "Reconciled ✓" when it matches.
How to prepare a bank reconciliation statement
- 1
Click "Edit online", or download the Excel file.
- 2
Enter the bank column balance from your cash book on the reconciliation date.
- 3
Tick off matching entries in the cash book and bank statement; list the unmatched ones in the right groups.
- 4
Enter the balance shown on the bank statement.
- 5
If the difference is zero, you are done; post bank charges, interest and direct entries to the cash book.
Tips for reconciling faster
Reconcile monthly
A month of entries is easy to match; a year of entries is not.
Overdraft is negative
If the cash book shows an overdraft, enter the balance as a negative number.
Look for transpositions
A difference divisible by 9 often means two digits were swapped, such as 540 and 450.
Follow up old cheques
Cheques unpresented for months may be lost or stale; contact the payee.
Frequently Asked Questions
Tools that help
Excel to PDF
Convert Excel spreadsheets to PDF with all sheets preserved
PDF to Excel
Extract tables from PDF into editable Excel spreadsheets
Percentage Calculator
Calculate percentages, increase, decrease, and ratios
Compress PDF
Reduce PDF file size without losing quality















