Bank reconciliation is the process of comparing your bookkeeping records to your actual bank statement to ensure they match. It sounds simple, but it is the most powerful error-detection tool in bookkeeping — and the most commonly skipped step by business owners doing their own books.
Why Bank Reconciliation Is Non-Negotiable
Without monthly reconciliation, errors accumulate silently. A vendor charges you twice. A payment bounces but you keep recording the expense. A deposit is recorded for the wrong amount. Employee theft goes undetected for months. By the time you or your accountant discovers the problem, it may span an entire year — making cleanup enormously time-consuming and expensive.
Reconciliation catches: data entry errors (wrong amounts, duplicate entries), bank fees you forgot to record, interest income not yet recorded, fraudulent transactions, returned checks (NSF — non-sufficient funds), timing differences between when you record transactions and when the bank processes them, and outstanding checks that have never cleared.
The Reconciliation Process Step by Step
Step 1: Gather your bank statement (for the period being reconciled) and your QuickBooks or accounting software register for the same period. Step 2: Mark every transaction in your books that appears on the bank statement as cleared. In QuickBooks, this is the reconciliation module — you check off each transaction that matches. Step 3: Identify items in your books not yet on the bank statement — these are outstanding checks (checks you wrote that the recipient has not cashed yet) and outstanding deposits (deposits you recorded but the bank has not yet processed). Step 4: Identify items on the bank statement not yet in your books — these are typically bank fees, interest charges, electronic payments you forgot to record, and sometimes NSF fees. Step 5: Calculate: Bank Statement Ending Balance, plus Deposits in Transit (not yet on statement), minus Outstanding Checks (not yet cleared), should equal your Book Balance after recording any missing items from Step 4. If these match, your reconciliation is complete. If they do not match, you have a discrepancy to investigate.
Common Reconciliation Problems and How to Fix Them
Duplicate transactions are the most common cause of discrepancies — a transaction was entered manually and also imported from the bank feed. Delete the duplicate after confirming which record is correct. Transposed numbers — for example, recording $89 instead of $98 — create small discrepancies that are easy to overlook. Search for the difference amount in your unreconciled transactions. Missing transactions occur when you forget to record a cash purchase, bank fee, or automatic payment. Check your bank statement for transactions not in your books. Voided checks that cleared the bank indicate possible fraud — investigate immediately.
How Often to Reconcile
Monthly reconciliation is the minimum standard. Weekly reconciliation is better for cash-intensive businesses like restaurants or retail. If you have payroll, reconcile your payroll bank account after every payroll run to catch payroll errors immediately. The longer you wait to reconcile, the harder it becomes — memory fades, receipts get lost, and discrepancies compound.
Bank Feeds vs. Manual Reconciliation
Modern accounting software like QuickBooks Online connects directly to your bank and imports transactions automatically. This makes reconciliation faster — you are matching imported transactions rather than re-entering them manually. However, bank feeds create their own reconciliation pitfall: duplicate transactions (automatic import plus manual entry). Always review your bank feed imports and do not double-enter any transaction you have already recorded.
Reconciling Multiple Accounts
Reconcile every business account monthly: business checking, business savings, all business credit cards, PayPal or other payment processors if you use them, and petty cash. Each account needs its own monthly reconciliation. A clean reconciliation on all accounts means your books are trustworthy and your financial statements are accurate.