A bank reconciliation proves your books match the bank after timing differences. It is the single highest-value habit in small business bookkeeping — and it takes about fifteen minutes per account once the routine is set.
Your bank balance and your book balance are supposed to differ. Checks you have written but the bank has not cleared, deposits you recorded on the 31st that posted on the 2nd, bank fees you have not entered yet — all of these make the two numbers legitimately different. A reconciliation lists every one of those differences until both sides land on the same adjusted balance.
When the two sides agree, you have proven three things: every bank transaction is in your books, every book entry is real, and nothing was recorded twice or skipped. When they do not agree, the difference itself tells you where to look — a difference divisible by 9 is often a transposed digit, and a difference equal to a transaction usually means it was recorded once instead of twice, or not at all.
Work both sides toward the same adjusted balance. Never force the books to match the bank by plugging a number.
The part most spreadsheet reconciliations get wrong is the outstanding list. Keep one tab per account where every outstanding check and deposit in transit lives until it clears. When an item clears, move it off the list; when a month ends, whatever remains is your starting point for the next reconciliation. An item that stays outstanding for more than 60–90 days is a flag: a lost check, a duplicate payment, or a deposit that never arrived.
The same routine works for credit cards, with one sign change: outstanding items are charges you recorded that have not posted yet, and the goal is to prove the statement balance, because that is what you actually owe.
A consulting business reconciles its checking account for the month. The bank statement ends at $12,480. The books show $13,905. Working both sides:
| Side | Item | Amount |
|---|---|---|
| Bank side | Statement balance | $12,480 |
| Bank side | Add: deposit in transit (recorded 31st, posted 2nd) | + $2,300 |
| Bank side | Less: outstanding checks | − $1,150 |
| Bank side | Adjusted bank balance | $13,630 |
| Book side | Book balance before adjustments | $13,905 |
| Book side | Less: bank service fee | − $45 |
| Book side | Add: interest earned | + $12 |
| Book side | Less: software auto-pay not yet entered | − $242 |
| Book side | Adjusted book balance | $13,630 |
Work the difference before you re-check everything. A few patterns solve most out-of-balance reconciliations:
The free QuickBooks Reconciliation Template on this site gives you the two-sided layout with the outstanding list built in, in Excel and Google Sheets. The $29 Month-End Close Template wraps reconciliation into a full close checklist — reconcile, review, close — so every account gets proven every month.
Monthly, for every bank and credit card account, within a few days of the statement closing. Quarterly is the bare minimum for a very low-volume account; anything less often turns error-hunting into archaeology.
Contact the payee after 60–90 days. If the check is lost, void it in your books, reissue it, and keep the original on the outstanding list until the void is recorded. Never just delete it — the deletion rewrites history your reconciliation already proved.
Yes — the method is identical and nothing about it needs accounting software. Every template on this site ships in both Excel and Google Sheets versions.