A QuickBooks bank balance that won't reconcile

Start with the report, not the register

Before scrolling through months of transactions by eye, run the Reconciliation Discrepancy report (Reports, then search “Reconciliation Discrepancy”). It exists for exactly this problem: it lists every transaction that was part of a completed reconciliation and has since been edited, deleted, or had its date or amount changed, along with the difference each one introduced. Nine times out of ten, the number that won’t zero out on this month’s reconciliation is sitting in that report with a name and a date attached, which turns a search through hundreds of transactions into a lookup of one or two.

The three real causes

A transaction entered twice. Usually a bank feed duplicate, and there is a separate fix for that one, but it can also be a manually entered check and its matching bank feed download both hitting the register. Either way, the register total is higher than the true activity by the duplicated amount, and reconciliation will be off by that exact figure.

A transaction entered with the wrong amount or date. A bill paid for one amount but keyed into QuickBooks as a slightly different one. A single transposed digit is enough. A deposit dated the 30th of one month that actually cleared the 1st of the next, landing it in the wrong statement period. These are the hardest to spot by scanning, because the transaction itself is not wrong in kind. It is wrong by a typo, and it will not stand out visually next to a hundred correctly entered lines.

A prior period that was never actually correct. Sometimes a reconciliation was marked complete despite a real discrepancy, because someone used QuickBooks Online’s option to force the difference into a miscellaneous expense or income account just to make the screen show zero and move on. That forced entry papers over the real problem instead of fixing it, and it tends to resurface the moment a later reconciliation depends on that period’s ending balance being genuinely accurate.

Why the fix has to go backward, not forward

Reconciliation in QuickBooks Online is cumulative: each month’s starting balance is the prior month’s ending balance. If the actual break happened three months ago, it is not fixable by adjusting anything in the current month; the current month will keep failing to reconcile until the transaction that caused the original break is found and corrected in the period it actually belongs to.

That means the correct sequence, once the Discrepancy report has named a transaction, is: undo the reconciliation for the month that transaction belongs to, correct the transaction itself, whether that means the amount, the date, or removing a true duplicate, and then re-reconcile that month before touching anything more recent. Undoing a reconciliation in QuickBooks Online does not touch any transaction; it only removes the “reconciled” checkmark for that period, so the step is safe and reversible on its own.

When there’s no clean discrepancy to point to

Occasionally the Discrepancy report comes back empty and the difference is still there. That usually means the very first reconciliation ever done in the file had an incorrect opening balance, often because the beginning bank balance was mistyped when the account was first connected. In that case there is nothing to find inside the reconciliation history itself; the opening balance for the account needs to be verified against the actual first bank statement on file and corrected at the source.

An empty Discrepancy report can also mean the difference was never part of a completed reconciliation to begin with. A transaction sitting uncategorized in “For Review,” never added to the register at all, will never show up as a discrepancy because it was never reconciled in the first place. It just needs to be added or excluded like any other bank feed line before the current month’s reconciliation will have a chance of matching.

A sanity check before spending an hour searching

One number is worth checking before diving into the Discrepancy report at all: does the difference on today’s failed reconciliation match a round number, or the exact amount of a transaction visible on the current statement? A difference that is an exact dollar match to a single line almost always means one transaction, miskeyed or missing or duplicated, rather than several small errors stacked together. A difference that looks like an odd, uneven number spread across many cents more often points to several small transactions instead of one obvious culprit, and is worth comparing statement-by-statement, not transaction-by-transaction.

The opening balance equity trap

A related and easily confused problem: when an account gets connected to QuickBooks Online for the first time, any gap between the register’s existing balance and the real starting bank balance gets swept into an account called Opening Balance Equity. That account is meant to be temporary, cleared out to the correct equity accounts once the books are reviewed, but it is routinely left sitting on the balance sheet indefinitely. It will not, by itself, break a reconciliation going forward, but a nonzero Opening Balance Equity from years ago is a strong signal that the very first reconciliation in the file was never actually verified against a real bank statement, which is exactly the kind of history worth checking before trusting anything reconciled on top of it.

What this costs to fix

Tracing a reconciliation break back through several closed periods, undoing and correctly redoing each one in order, is a cleanup engagement. The scope is set by how many months back the actual break sits, not by how far off this month’s number looks.

$199 per month of backlog

Once the file is clean, a monthly close keeps every account reconciled by the 5th business day going forward, so this doesn’t quietly build up again. Full pricing for both is on the pricing page.