Bank reconciliation template
A bank reconciliation proves your books match the bank. This free template starts from the statement balance, adds deposits the bank hasn't shown yet, takes off checks that haven't cleared, and compares the result with the balance in your books. If the difference isn't zero, something is missing or entered twice.
Updated November 2026
What does the template look like?
Type your numbers in the white cells. Totals and results add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Line | Amount |
|---|---|
| Bank side | |
| Ending balance on the bank statement | $18,420.55 |
| Add deposits in transit | $2,310.00 |
| Less checks and payments not yet cleared (enter as negative) | -$1,965.40 |
| Bank errors to correct (+ or -) | $0.00 |
| Adjusted bank balance | $18,765.15 |
| Book side | |
| Ending balance in your books | $18,789.75 |
| Add interest the bank paid, not yet recorded | $4.40 |
| Less bank fees not yet recorded (enter as negative) | -$29.00 |
| Less returned checks or NSF items (enter as negative) | $0.00 |
| Book errors to correct (+ or -) | $0.00 |
| Adjusted book balance | $18,765.15 |
| Difference (should be 0) | -$0.00 |
How do I reconcile a bank account?
- Get the statement and your books for the same end date.
- Tick off every deposit and payment that appears in both.
- List deposits in your books that the bank hasn't shown yet, and checks or payments that haven't cleared.
- List bank items you haven't recorded: fees, interest, returned checks.
- Adjust both sides. The two adjusted balances should match exactly.
Why bother every month?
Because it's the only way to know your books are complete. It catches missed deposits, double-entered bills, bank errors and fraud while they're fresh. Your tax return and every report rest on reconciled cash, so this is the first job in any month-end close.
What if it won't balance?
Look for a difference that's divisible by 9 (two digits swapped), an amount that's exactly double (entered the wrong way round), or a single missing item. If months are unreconciled, start with the oldest month and work forward.
General information, not tax advice for your situation.
Want your books off your plate?
One accountant keeps them current, every month.
See our bookkeeping serviceHow often should I reconcile?
Every month, for every bank and credit card account.
What is a deposit in transit?
Money you recorded as deposited that hasn't appeared on the bank statement yet, usually a deposit made on the last day of the month.
Does QuickBooks reconcile for me?
It gives you a reconcile screen, but someone still has to tick the items and look into the differences.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.