Bank Reconciliation in QuickBooks: The Right Order to Run It (and the 3 Mistakes That Cost Most)

What bank reconciliation actually does

Reconciliation compares two records of the same money: your bank statement and your QuickBooks register. When they match to the penny, your books are accurate. When they don’t, you have a problem — duplicate entry, missing transaction, bank error, or a mis-categorised charge. Reconciliation is the single highest-value monthly bookkeeping activity because it catches errors before they compound.

The right order to reconcile

Reconcile in this order: (1) Operating bank account, (2) Credit cards, (3) Loan/line of credit, (4) Merchant accounts (Stripe, Square, PayPal), (5) Payroll-related accounts last. Why this order? Because credit card transactions often draw from the operating account, payroll uses the operating account, and merchant deposits hit the operating account. If you reconcile operating last, every fix you make has to flow downstream.

Step-by-step in QuickBooks Online

1. Go to Accounting → Reconcile.
2. Select the account to reconcile.
3. Enter the statement date and ending balance from your bank statement.
4. Check each transaction that appears on both QuickBooks and the statement.
5. The difference should equal zero at the end. If it doesn’t, find the discrepancy before finishing.
6. Click “Finish now” only when the difference is $0.

The 3 mistakes that cost most

Mistake 1 — Finishing reconciliation with a non-zero difference. QuickBooks lets you force a reconciliation by booking a “reconciliation discrepancy” entry. Never do this. The difference is hiding a real error.

Mistake 2 — Reconciling months out of order. Always reconcile chronologically. If you skip July and do August, July’s errors flow into August and compound.

Mistake 3 — Treating the reconciliation report as decorative. Save the PDF of every reconciliation. Auditors ask for them. Disputes over which transactions cleared depend on them.