QuickBooks Online Reconciliation Won't Close to Zero

Reconciling a bank account in QuickBooks Online is supposed to end the same way every time. You tick off each transaction, the difference box drops to zero, and you close out the month. A steady stream of reader questions describes the other outcome: every line is checked, the month looks done, and the difference still shows a number.

It is the most common reconciliation complaint that reaches our desk, and it almost never means the books are truly broken. When you reconcile, QuickBooks compares the transactions you recorded against your bank statement. If everything sits where it should, the two ending balances match and the difference is zero. If they do not match, something is entered wrong, missing, or duplicated, and QuickBooks will not let the reconciliation close until the error is found.

Why won’t the difference drop to zero?

Three causes account for most cases. Someone typed a wrong ending balance when the reconciliation started. Someone entered transactions in QuickBooks that have not yet reached the bank, so the statement cannot show them. Or transactions are missing or appear twice, so the two sides never add up the same way.

The difference itself often hints at the cause. A figure equal to a single transaction usually points to a missing or duplicated entry. A round, tidy number instead suggests a typo, most often in the ending balance you typed at the start. Either way, the search narrows fast if you check in the right order.

Check the opening balance first

Compare the opening balance in QuickBooks with the beginning balance printed on your statement. The statement is the reference; QuickBooks has to agree with it, not the other way around. If the two figures differ, stop here and correct the QuickBooks balance before touching anything else. If they match, the problem lies further down.

Is the ending balance you entered correct?

QuickBooks asks for the statement’s ending balance and ending date when a reconciliation starts, and it judges everything that follows against that figure. One transposed digit is enough to poison the whole run.

To verify it, open the reconcile tool from the accounting menu and choose Edit info. Check the ending balance and the ending date in that window against your statement, correct whatever is off, and save. This is the quickest of the four checks, and it settles more stuck reconciliations than any other.

Combine deposits the way the bank does

Banks often bundle several customer payments into a single deposit line on the statement. If you recorded each payment as its own transaction, QuickBooks shows several entries where the bank shows one, and the totals drift apart.

The remedy mirrors the bank’s habit. Post the individual payments to Undeposited Funds, then record a bank deposit that combines them into a single record. Once QuickBooks shows one entry where the statement shows one, that slice of the difference should disappear.

Find transactions that changed after they cleared

The trickiest cause is a transaction that cleared in an earlier month and was later edited or deleted. Changing a cleared transaction retroactively unbalances a reconciliation that was already finished, and the damage often surfaces in the current month.

QuickBooks Online has a report built for exactly this problem. Run the Reconciliation Discrepancy Report from the Reports page. It lists cleared transactions that were edited or deleted after reconciliation, and it shows who made each change and when. Restore, re-enter, or correct the affected entries so the cleared amounts once again match the statement.

Once the difference reaches zero

Fix the offending entry and the difference collapses to zero, which frees you to finish the reconciliation. Save or print the reconciliation summary for your records before closing the window.

Two habits keep this problem from returning. Reconcile every month rather than in seasonal bursts, because a one-month gap is far easier to trace than three. And never adjust an opening balance just to force a reconciliation to fit; that hides the error without correcting it, and the same difference will resurface next month.