Free Bank Reconciliation Template (Excel)
Your books and your bank statement almost never match exactly — outstanding checks, pending deposits, and bank fees all create timing differences. This free template walks through the reconciliation step by step and automatically shows you if the two balances actually agree once those differences are accounted for.
No email required · Works in Excel or Google Sheets · Includes a built-in AI prompt
Who this is for
- Business owners reconciling their own books monthly
- Bookkeepers standardizing a reconciliation process across clients
- Anyone who has ever been surprised by a bank balance that didn’t match their records
- Students learning how bank reconciliation actually works
What's included
- Book balance and bank statement balance starting points
- Outstanding checks and deposits-in-transit sections
- Automatic adjusted balance calculation on both sides
- Built-in check confirming whether the two sides match
Why use a template instead of starting from scratch?
Reconciling by scanning two lists side by side and hoping nothing was missed is how small discrepancies slip through for months. This template forces you through the standard reconciliation steps in order, so a missed check or an unrecorded bank fee gets caught immediately instead of quietly compounding.
How to Use This Template
Download and open in Excel or Google Sheets
Works identically in either — no macros or add-ins needed.
Enter your book balance and your bank statement balance
These are your two starting points, straight from your records and the bank statement.
List outstanding checks and deposits in transit
These are the timing differences — money that’s in your books but hasn’t cleared the bank yet, or vice versa.
Add any bank fees or interest not yet recorded in your books
These typically only show up on the bank statement first — record them in your books too once you spot them here.
Confirm the adjusted balances match
If they don’t, the difference points you toward exactly what’s still unaccounted for.
Built-in AI prompt
Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on likely causes of any remaining gap between your book and bank balances, based on the specific outstanding items you’ve listed, no accounting background required.
Common Mistakes to Avoid
Reconciling too infrequently
Monthly is the standard minimum — the longer you go between reconciliations, the harder it is to track down where a discrepancy came from.
Forgetting bank fees and interest
These often only appear on the bank statement, not your books, until you catch them during reconciliation — make sure to record them in your books afterward.
Not following up on old outstanding checks
A check that’s been outstanding for months might have been lost — worth following up with the payee or considering a stop payment.
Assuming a small unexplained difference doesn’t matter
Even a small gap usually points to a real missing or duplicated transaction — track it down rather than plugging it as an adjustment.
Frequently Asked Questions
Related Templates
Related Resources
Want the Full Template Library?
70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.
Join the Tools Club