How to Fix a Beginning Balance Discrepancy in QuickBooks Reconciliation

Short answer: A beginning balance discrepancy in QuickBooks means a transaction that was already reconciled got changed, deleted, or unreconciled after the fact, which shifts the balance the next reconciliation starts from. The fix is to find that altered transaction and restore it. Use the Reconciliation Discrepancy report, which lists every previously reconciled transaction that was edited or removed and by how much, then add back a deleted entry, re-check a transaction that was unreconciled, or correct an amount that was changed. Once the total discrepancy on the report reaches zero, your beginning balance matches again.

The beginning balance for any reconciliation is simply the ending balance of the last one. So if the number QuickBooks shows does not match your statement's opening balance, something in an already-closed period moved. Nothing you can do in the current month causes it; the cause is always behind you.

What causes a beginning balance discrepancy?

There is really one root cause with a few faces: a transaction that was part of a completed reconciliation was touched afterward. That can happen in several ways. Someone deleted a reconciled transaction, so the reconciled total dropped. Someone edited the amount, date, or account of a reconciled transaction, so the total no longer ties. Someone unreconciled a transaction by clearing its reconciled status, so it no longer counts toward the prior ending balance. Or an opening balance was entered incorrectly when the account was first set up, or transactions older than that opening balance were added without adjusting it. Each of these changes the ending balance of the last reconciliation, and that number is exactly what the next reconciliation uses as its beginning balance.

How do I use the Reconciliation Discrepancy report?

The Reconciliation Discrepancy report is the tool built for exactly this. When QuickBooks flags a beginning balance problem at the start of a reconciliation, it shows a message with a link to help you fix it, which opens the report. The report lists every previously reconciled transaction that was later changed or deleted, the type of change, and the dollar effect. Review each row one at a time and reverse what was done: add back a deleted entry, re-reconcile one that was unchecked, or restore an amount that was altered. As you correct each item, the total discrepancy shrinks, and when the report totals zero, the beginning balance is repaired. In QuickBooks Online you reach it from the Reconcile screen when the alert appears; in Desktop it is under Reports, then Banking, then Reconciliation Discrepancy for the account and statement date.

How do I fix a beginning balance that is off because a transaction was deleted?

If the discrepancy report points to a deleted transaction, the cleanest fix is to recreate it exactly as it was originally recorded, with the same date, amount, and account, then mark it reconciled so it counts toward the prior period again. Recreating it restores the reconciled total to what it was before the deletion, which brings the beginning balance back in line. Avoid the temptation to plug the gap with a random adjusting entry in the current month, because that hides the problem rather than fixing it and leaves a mystery entry your accountant will question later.

How do I fix a wrong opening balance?

If the account never reconciled correctly from the start, the opening balance entered at setup is usually wrong. Find the opening balance transaction, which is dated when the account was created and often posted against opening balance equity, and correct it to the actual balance from the bank statement on that date. If transactions predating the opening balance were entered later, they can also throw it off, so make sure the opening balance reflects the true starting point before those transactions. Getting the opening balance right once fixes every reconciliation that follows, because they all build on it.

Can I just force the reconciliation to balance?

You can, but you usually should not. QuickBooks lets you post a reconciliation adjustment to force a difference to zero, and it dumps that plug into an expense account. That closes the current reconciliation but leaves the real error in place and adds a fake entry on top of it, so your books drift further from reality. The only time an adjustment is reasonable is a tiny, genuinely untraceable difference of a few cents. For anything larger, find the changed transaction with the discrepancy report and fix the cause, because a forced balance today becomes a bigger unexplained gap tomorrow.

How do I stop beginning balance discrepancies from happening?

The habit that prevents them is leaving reconciled transactions alone. Once a period is reconciled, do not edit, delete, or unreconcile anything in it without understanding the downstream effect. Reconcile every account every month so any change is caught within weeks rather than a year later when the trail is cold. And keep a clean record of what each statement actually contained, so you can compare your books against the source when something drifts. Converting each monthly statement to a spreadsheet gives you that permanent, searchable record, and you can convert the PDF straight to a QuickBooks-ready file to reduce the manual entry that causes errors in the first place. If the discrepancy is really a broader mismatch between your books and the bank, our guide on why your QuickBooks balance differs from your bank walks through the other causes, and to keep the account healthy, reconcile in QuickBooks Online on a monthly cadence. When the statement is in rows, importing it cleanly is a step you can do with a bank statement to QuickBooks converter.

What if the discrepancy report is empty but the balance is still wrong?

If the report shows nothing but the beginning balance is still off, the change likely happened before QuickBooks started tracking discrepancies, or the opening balance itself is the problem. In that case, work backward from the last reconciliation that was correct: pull that period's statement, compare the reconciled transactions in QuickBooks against it, and find where the totals diverge. The point where your books stop matching the statement is where the altered or missing transaction lives. Having the statement as a sortable spreadsheet makes this comparison much faster than scrolling a PDF next to the register.

Beginning balance discrepancies feel mysterious, but they follow one rule: the past changed. Find the transaction that moved, put it back the way it was, and the balance you start from lines up again.