QuickBooks Online reconciliation ends with a difference that will not clear

QuickBooks Online users keep reaching the last screen of a reconciliation only to find a difference where zero belongs. The mismatch is common enough that the vendor’s accepted fix follows a fixed order: check the balances you typed, mirror how the bank grouped its payments, then sweep the list for duplicates and gaps. The repair is manual, but it needs no special tools.

A difference that refuses to reach zero

A reconciliation compares ticked entries in the software against lines on the bank statement. Done right, the cleared items land exactly on the closing balance you entered, for a difference of zero. When they land anywhere else, the two sides disagree about something, and the software will not name the line. You have to find it. The accepted answer narrows the search.

Three causes behind the mismatch

The accepted answer names three. Someone typed an ending balance that does not match the statement. Someone recorded entries the bank has not cleared yet. Or the books hold a missing transaction, or a duplicate the bank never made. Each cause has its own check, and the order matters: balances first, then payment grouping, then the sweep.

Start with the opening figure

Before touching any transaction, compare the beginning balance on the reconcile screen with the opening figure printed on the statement. They should match to the cent. If the beginning balance has drifted since the last session, an older reconciled entry was probably edited or removed after that session closed. Fix that first, or every later step inherits the error.

Verify the ending balance you typed

The ending balance does the heavy lifting, so confirm it before anything else. From the left menu, open All apps, choose Accounting, then select Reconcile. Pick the account, then select Edit info inside the reconciliation window. The panel shows the ending balance and the ending date you entered. Read both against the statement, correct any typo, and save. If the two sides still disagree after this, the problem lives in the transaction list.

Did the bank combine several payments into one?

Card batches cause a specific kind of mismatch. The bank posts one lump deposit; the books hold each sale as its own receipt. The fix is to make the software match the bank. Route the individual payments into Undeposited Funds, then record a single bank deposit for the combined total. The reconcile list then shows one line for the whole batch, exactly as the statement does, and the amounts tie.

Sort by amount to catch duplicates and gaps

Duplicates announce themselves once you put them side by side. On the reconcile screen, the money-in and money-out lists can be sorted. Sort by amount and watch for pairs: two lines with the same figure, the same date, and the same payee, where the statement shows one line. Untick the extra entry, then delete it or resolve it so it cannot return next month.

Gaps work in reverse. A statement line with no partner in the list means the entry was never recorded. Add it through the normal entry screens, and it will appear ready to tick.

For a wider sweep, open the register instead. Go to Accounting, then Chart of accounts, then View register for the account in question. Set the date range to the statement period and scan for the same twin pattern. The Reconcile page also keeps a history of past sessions; an account that used to tie and no longer does points to an edit made after the last clean session.

Finish only when the difference reads zero

As you correct each item, the difference updates on the spot. Keep going until it reads zero, then select Finish. The software will offer to plug a leftover difference with an adjusting entry. We would treat that as a last resort, because it hides the cause instead of clearing it. A reconciliation that ends at zero is the only one that stays closed.