Bank reconciliation is the monthly habit that keeps your books honest: you compare your own records against the bank's statement, line by line, until the two agree. When they do, you know every deposit landed, every payment cleared, and nothing slipped through. When they do not, you have found a problem while it is still small — a duplicate charge, a missed deposit, a check that never cleared — instead of discovering it at tax time, when it is expensive to fix.
Every business, from a freelancer with one account to a company with a full finance team, reconciles the same way. The process has not changed in decades, and it takes about twenty minutes a month once you have a routine. This guide walks through the five steps, explains the differences you will meet most often, and shows how a clean statement file makes the whole job faster.
What Bank Reconciliation Actually Does
Your books and your bank statement describe the same money from two sides, and they rarely match at first glance. You record a payment the day you make it; the bank records it the day it clears. A deposit you made on the 31st may not appear until the 1st. Checks you wrote may sit uncashed for weeks. The reconciliation is the process of explaining every one of those timing gaps, plus any real errors, until the two balances agree.
The goal is not to force the numbers to match — it is to prove they match for a reason. A proper reconciliation ends with a clear list: these deposits are in transit, these checks are outstanding, this is the bank fee, and the adjusted balance equals the book balance to the cent. That list is also your audit trail. If a lender, an accountant, or the IRS asks how a number was reached, the reconciliation shows the work. For the QuickBooks side of this same job, see our guide on how to reconcile a bank statement in your accounting software.
Bank Reconciliation in Five Steps
Step 1 — Gather the documents. You need the bank statement for the month and your own records: your accounting software, your check register, or a spreadsheet of the same period. If the statement is a PDF, convert it to Excel first — matching hundreds of lines by eye across two documents is slow, and a spreadsheet lets you sort and filter instead. A converter that preserves the running balance gives you a column to check against as you go.
Step 2 — Compare the opening balances. The statement's beginning balance should equal the ending balance of last month's reconciliation. If it does not, stop: something changed in a period you already closed, and you need to find it before this month's work means anything. A changed prior transaction is the most common cause, and it is the first thing to check.
Step 3 — Match the deposits. Go through every deposit and credit on the statement and tick it off in your records. Deposits in transit — money you recorded but the bank has not yet posted — get listed separately; they explain a real gap and they are not an error. If a deposit appears on the statement but not in your books, add it: it may be interest, a refund, or a customer payment you forgot to record.
Step 4 — Match the withdrawals. Do the same for every withdrawal, check, and debit. Checks that have not cleared are outstanding, and they stay on the list until they do. A withdrawal on the statement that is missing from your books is usually a bank fee, an automatic payment, or a subscription — record it, then decide whether the charge itself was correct.
Step 5 — Compare the adjusted balances. Add deposits in transit to the statement balance and subtract outstanding checks; adjust your book balance for any bank fees, interest, or errors you found. The two adjusted balances should now be equal. If they are, sign and date the reconciliation and file it. If they are not, the difference is your next job — and the next section covers the usual suspects.
Common Differences and How to Clear Them
Most differences fall into four buckets. Outstanding checks are the most common: a check you wrote that has not cleared yet. They are not errors — they are timing — but a check outstanding for more than six months deserves a call to the payee, because stale checks can be voided by the bank. Deposits in transit are the mirror image: money you recorded that the bank has not posted yet, usually because it arrived on the last day of the month.
Bank fees and interest are the second bucket. Monthly maintenance fees, wire fees, and overdraft charges appear on the statement but not in your books until you record them, and the interest the bank paid you works the same way in reverse. The third bucket is errors: a transposed digit, a deposit credited to the wrong account, a duplicate charge. These are rarer, but they are the reason you reconcile — and the reason to report a bank error within 60 days of the statement date. The fourth bucket is duplicates, which hit hardest in accounting software: the same transaction imported twice through a bank feed and a file. Our Stripe payout reconciliation guide shows the same discipline applied to payment payouts, and if the mismatch is inside QuickBooks, our guide on undoing a reconciliation in QuickBooks Online explains how to fix it safely.
How Often Should You Reconcile?
Monthly, without exception — and weekly if your volume is high. A business with hundreds of transactions a month should reconcile every week, because a difference found after seven days is a five-minute fix, and the same difference found after six months is a forensic exercise. Daily reconciliation is overkill for most small businesses, but a quick weekly glance at the unmatched items keeps the month-end job short.
The routine matters more than the tool. Whether you reconcile in QuickBooks, Xero, or a spreadsheet, the steps are the same, and the discipline is the same: never skip a month, never force a balance with a plug figure, and never delete a transaction to make a difference disappear. An adjustment entry with a note is honest; a deleted line is a hole in your records. If you reconcile in QuickBooks, a balance-checked statement file — one converted from the bank PDF with the running balance intact — removes the slowest step, which is retyping the statement by hand.