Bank Reconciliation Template for Excel (Free Download)
A ready-made bank reconciliation statement with formulas, a worked example and a sheet for the bank transactions — plus a quick way to get those transactions out of a PDF statement.
What is a bank reconciliation template?
A bank reconciliation template is a spreadsheet that compares the balance on your bank statement with the balance in your books for the same date. It adds deposits in transit, subtracts outstanding cheques, records bank fees and interest on the book side, and shows a difference that should be zero. Download our free Excel version below.
How to reconcile a bank account with the template
- 1
Enter both closing balances
Type the statement's closing balance and your cash book or general ledger balance for the same date.
- 2
Get the bank transactions into Excel
Convert the PDF statement with the tool below and paste the rows into the 'Bank transactions' sheet.
- 3
Tick off matching items
Mark each bank transaction that is already in your books. Whatever is left unmatched explains the difference.
- 4
Fill in the adjustments
Deposits in transit and outstanding cheques go on the bank side; bank fees, interest and returned cheques go on the book side.
- 5
Check the difference is zero
When the adjusted bank balance equals the adjusted book balance, record the book-side adjustments in your accounts.
Turn your PDF statement into Excel for the template
Drop PDF here or click to upload
Max 20 MB · Text-based or scanned PDF
Download the template
Free, no sign-up. The XLSX has three sheets: Reconciliation (with formulas), Bank transactions and How to use.
How the reconciliation statement is laid out
The template follows the standard two-sided format used in accounting courses and month-end close checklists:
- Balance per bank statement + deposits in transit − outstanding cheques ± bank errors = adjusted bank balance.
- Balance per books + credits not yet recorded (interest, direct deposits) − debits not yet recorded (fees, returned cheques, direct debits) ± book errors = adjusted book balance.
- Difference = adjusted bank balance − adjusted book balance, which should be 0.
Worked example
| Bank side | Amount | Book side | Amount |
|---|---|---|---|
| Balance per bank | 12,450.00 | Balance per books | 12,520.00 |
| + Deposit in transit | 1,800.00 | + Interest earned | 15.00 |
| − Cheque #1043 | 650.00 | − Monthly bank fee | 35.00 |
| − Cheque #1045 | 1,200.00 | − Returned cheque (NSF) | 100.00 |
| Adjusted bank balance | 12,400.00 | Adjusted book balance | 12,400.00 |
Difference = 0, so the account is reconciled. The same figures are pre-filled in the template.
Common reasons the difference isn't zero
- Transposed digits — a difference divisible by 9 often means two digits were swapped (e.g. 540 entered as 450).
- An item entered twice, or on the wrong side of the reconciliation.
- Balances taken from different dates.
- A bank fee, interest credit or direct debit that hasn't been recorded in the books yet.
- A typing error when copying transactions from a PDF — converting the statement to Excel, with each row checked against the running balance, removes this one entirely.
Frequently asked questions
Is the bank reconciliation template free?
Yes. Both the XLSX and CSV versions are free to download and use, with no sign-up.
Does it work in Google Sheets?
Yes. Upload the XLSX to Google Drive and open it with Google Sheets; the formulas keep working. It also opens in LibreOffice and Numbers.
How often should I reconcile my bank account?
At least monthly, when the statement arrives. Busy businesses often reconcile weekly so that problems are caught early.
Can I fill the template automatically from my PDF statement?
Convert the PDF with the tool on this page, download Excel and paste the rows into the 'Bank transactions' sheet. Matching items against your books is still your decision.
What is a deposit in transit?
Money you have recorded and deposited that the bank had not yet processed on the statement date. It is added to the bank balance.
What is an outstanding cheque?
A cheque or payment you have recorded that had not cleared the bank by the statement date. It is subtracted from the bank balance.
Does the converter reconcile automatically?
No. It extracts the statement transactions and checks them against the statement's own running balance. Comparing them with your books is what the template is for.
Related tools and guides
50 pages free every month
Create a free account — no credit card. Need more? See the plans.