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. Usually 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 duplicate bank feed transactions, 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.

Cause	How it shows up	Where it gets fixed
A transaction entered twice	The difference equals the duplicated amount	Remove the duplicate in the period it belongs to
Wrong amount or date	A transposed digit, or a deposit landing in the wrong statement period	Correct the transaction in its own period
A prior period that was never right	A forced adjustment to a miscellaneous account in an old reconciliation	Undo that period, fix the cause, reconcile forward again

For the reconcile screen itself, from entering the ending balance to clearing transactions, see how to reconcile in QuickBooks Online.

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.

Once the Discrepancy report has named a transaction, the size of the repair depends on what went wrong. If one reconciled transaction was edited or deleted, put that transaction right in its own period and set its status back to reconciled, without reopening the month; editing a reconciled transaction has the steps. Only when the period itself was wrong, because it was finished against the wrong statement balance or forced to zero, does it need to be undone, corrected and reconciled again before anything more recent. Undoing a reconciliation in QuickBooks Online does not change any transaction, but it is not a small step: it also undoes every reconciliation completed after that one on the same account, and the undo itself cannot be reversed. Read what an undo destroys before starting.

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. (To review the core timing formulas, see our breakdown on bank reconciliation explained.)

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.

$99per month of backlog20% off 6+ months

If the Discrepancy report points to a period more than a month back, send the file for a free review before undoing anything.

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.