Free Bank Reconciliation Template (Excel)
What's in the bank reconciliation template
The workbook has three sheets: a Reconciliation summary, an Outstanding Checks list, and a Deposits in Transit list. Log every check that hasn't cleared and every deposit the bank hasn't posted yet in their own sheets, and each sheet totals itself automatically.
The Reconciliation sheet then walks through both sides of the reconciliation: the bank side (statement balance plus deposits in transit minus outstanding checks) and the book side (your GL balance plus unrecorded interest minus unrecorded fees).
That structure mirrors the standard reconciliation format any bookkeeper or accountant expects, so the file itself doubles as documentation if a lender or your accountant asks how you reconciled a given month.
Bank statement format explained
Bank reconciliation format in Excel comes down to two adjusted balances that should match: the adjusted bank balance (statement balance + deposits in transit − outstanding checks) and the adjusted book balance (your cash book balance + interest/credits not yet recorded − fees not yet recorded).
The template builds both formulas for you from the numbers you enter, labeled exactly this way, so you're not reconstructing the format from a blog post or a screenshot every month.
Copy the totals from the Outstanding Checks and Deposits in Transit sheets into the matching Reconciliation fields — the adjusted balances update the moment you do.
Reconciling balance sheet accounts and AP invoices
This same adjusted-balance structure — statement balance plus in-transit items minus outstanding items, compared to book balance — is exactly how you'd reconcile any balance sheet account against its supporting detail, not just a bank account. If you're reconciling a credit card or loan balance, use the Reconciliation sheet the same way: statement side vs. book side.
For invoice or accounts-payable reconciliation — matching what you owe vendors against what's actually been paid — the same 'two sides should match' logic applies, but that workflow needs a vendor-by-vendor ledger rather than a single bank statement comparison. Use this template's Reconciliation sheet as the balance-check pattern, and log vendor invoices individually in a ledger like our free General Ledger template.
Keeping the reconciliation logic consistent across bank, other balance sheet accounts, and AP means anyone reviewing your books sees the same RECONCILED / OUT OF BALANCE pattern everywhere, instead of a different ad hoc method per account.
The out-of-balance flag
The Status cell shows RECONCILED only when the adjusted bank balance and adjusted book balance match to the cent. If they don't, it shows OUT OF BALANCE - check your items, telling you immediately instead of after you've already filed the month away.
Because the flag is formula-driven, there's no manual subtraction to get wrong — you enter the six input numbers (statement balance, deposits in transit, outstanding checks, book balance, interest, fees) and the two adjusted totals and the difference calculate themselves.
If you get an OUT OF BALANCE result, the difference amount tells you exactly how far off you are, which is usually enough to spot a missing check or an unrecorded fee on a second pass.
How to use it
- List every outstanding check and every deposit in transit in their own sheets; totals calculate for you.
- In the Reconciliation sheet, enter the bank statement ending balance and copy in the two totals.
- Enter your book/GL ending balance plus any unrecorded interest or fees.
- Check the Status cell: RECONCILED means the two adjusted balances match to the cent.
Download the free Free Bank Reconciliation Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Small Business Bookkeeping & Tax Dashboard
If you also need your bank activity categorized for Schedule C and a quarterly tax set-aside, the paid Bookkeeping template ($19) picks up right where a reconciled bank balance leaves off.
See the full versionFrequently asked questions
Can I use this bank reconciliation template in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All the reconciliation formulas keep working.
Is this template really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
Can I use it for a credit card or loan account instead of a bank account?
Yes — the same statement-balance-vs-book-balance logic applies to any balance sheet account. Just relabel the fields to match the account you're reconciling.
Does it reconcile individual vendor invoices?
No. This template reconciles one account total against its statement. For invoice-by-invoice or vendor-by-vendor accounts payable reconciliation, pair it with a ledger that logs each invoice, like our free General Ledger template.
Does it carry the reconciled balance forward to next month automatically?
No, it's a single reconciliation for one statement period. Duplicate the sheet each month and start with the new statement balance.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.