QuickBooks Won't Reconcile? Find the Discrepancy Fast

First, read the difference itself, it's a clue

• Difference equals one transaction's amount exactly: search the register for that amount, you've either missed checking it or it's entered twice
• Difference is divisible by 9: classic transposition error ($540 entered as $450). Scan for near-miss amounts
• Difference equals a round fee-like number ($25, $35): look for bank fees or interest on the statement that never got entered
• Difference is small and weird ($0.01–$1.00): amount typos on manually entered transactions

The four causes, in order of frequency

1. Missing transactions: on the statement, not in QuickBooks, usually fees, interest, or transactions that arrived while the feed hiccuped. Enter them, check them off
2. Duplicates: in QuickBooks twice (manual entry + feed 'Add'), on the statement once. The register sorted by amount exposes pairs fast
3. Wrong amounts: entered by hand, entered wrong. The divisible-by-9 trick and line-by-line compare find them
4. Wrong-account postings: a transaction that belongs to the credit card sitting in checking. It won't be on this statement at all, but it inflates the register

The divide-and-check method (for the stubborn ones)

When line-by-line feels endless: reconcile half the period. Check off only the first half-month and compare against the statement's running balance at mid-month. Difference gone? The error is in the second half. Still there? First half. Halve again. Three or four splits isolates the problem to a few days of transactions, minutes instead of hours. This is how professionals actually do it; nobody re-reads thirty days line by line four times.

When the BEGINNING balance is wrong, the deeper problem

If QuickBooks opens the reconciliation with a beginning balance that doesn't match your statement, this month isn't your problem: someone changed, deleted, or un-reconciled transactions in an already-reconciled period. QuickBooks Online's Reconciliation Discrepancy Report (linked right on the reconcile screen when this happens) lists exactly what changed. Your options: restore the altered transactions per the report, or, if the trail is long and mangled, a professional re-reconciliation of the affected periods. Do not use the 'adjusting entry' button QuickBooks offers to force it to zero; that buries the error permanently and guarantees the next person (auditor, tax preparer, buyer) finds a forced adjustment instead of an explanation. Forced reconciliation adjustments are the bookkeeping equivalent of painting over a crack.

Preventing the monthly hunt

• Reconcile monthly, always, discrepancies in a 30-day window are findable; in a 300-day window they compound
• Match, don't Add, in the bank feed, the root cause of most duplicates
• Lock closed periods so reconciled history can't drift, the beginning-balance problem is almost always an unlocked file
• Enter from the feed rather than by hand where possible; typos need keyboards