September 24, 2026

QuickBooks reconciliation beginning balance doesn’t match: find what changed, fix it, and why it has to be clean before you migrate

Your beginning balance is simply the ending balance of your last completed reconciliation. If it no longer matches the statement, something already reconciled has changed since then: a transaction was edited, deleted, voided or unticked, or the opening balance was wrong from the start. The fix is to find that change, not to force the numbers. QuickBooks Desktop and QuickBooks Online both give you a report that lists it. This guide covers both, in any regional edition, and explains why a drifting reconciliation is the first thing to clear before converting a file to another system.

Why the beginning balance moves

Intuit lists the same causes for both products. In QuickBooks Online: an incorrect opening balance when the account was created; a reconciled transaction that was edited, deleted, voided, moved or unreconciled; a categorised bank-feed transaction that was undone and sent back to pending; or a transaction dated before the last reconciliation that was marked reconciled by hand outside a reconciliation. In QuickBooks Desktop: the account was never given a balance or was given the wrong one; previously cleared transactions were voided, deleted or modified; the file was converted from another version of QuickBooks; or the file has data damage.

Before you start, write down the exact amount the balance is off by. Every change you find should add up to it. When the sum matches, you are done; when it doesn’t, there is another change still to find.

QuickBooks Online: the Reconcile Discrepancy report

Make sure every bank-feed transaction for the period is matched, categorised or excluded. You need admin access.
Open Reconcile and choose the account. When QuickBooks says the account isn’t ready because the beginning balance is off, select We can help you fix it. That opens the Reconcile Discrepancy report.
Work through it one line at a time. The What happened column shows what changed, when and by whom; View History shows the full history of the transaction.
Only reverse changes made in error. Intuit’s suggested fix assumes a mistake, and some edits were deliberate.
If the report is clear but the balance is still off, check two things it doesn’t show: deleted and voided transactions in the audit log (Settings, Audit log, filtered to the period since your last reconciliation), and transactions marked R in the account register with dates after your last completed reconciliation.

When the total discrepancy reads zero, you can reconcile again. Two details matter. First, when a fix asks you to reconcile a single transaction, re-running the reconciliation with the same ending date and balance records the change on a reconciliation report, while ticking R in the register does not. Second, the audit log keeps two years of events, so a change made earlier than that will not appear there. Undoing an entire reconciliation is only available to an accountant working in QuickBooks Online Accountant.

QuickBooks Desktop: three reports and one button to avoid

Reconciliation Discrepancy report (Reports, Banking): lists transactions changed since the last reconciliation, with the date each change was entered or last modified.

Previous Reconciliation report (Reports, Banking): the cleared transactions as they stood when you reconciled. Premier, Accountant and Enterprise keep the last 120 reconciliations; Pro keeps only the most recent one, so on Pro the history exists only if someone saved the PDFs.

Audit Trail report (Reports, Accountant & Taxes): filter it to the account, with transaction dates up to the statement date and an Entered/Modified range starting at the date the last reconciliation was created. Anything in that list was changed after it had been reconciled.

Once you have found the changes, you either re-enter or correct them, or back up the file and use Undo Last Reconciliation to redo the most recent period properly. The button to avoid is Enter Adjustment at the end of a reconciliation. It makes the difference disappear by posting a journal entry to an expense account called Reconciliation Discrepancies. The bank then matches, but the books now contain an expense nobody can explain, and the next discrepancy stacks on top of it.

If the balance is zero or wrong on an account you have never reconciled, the cause is the opening balance. Intuit’s fix is a journal entry dated to the statement date of your starting balance, posted against Opening Balance Equity, then reconciled. That equity balance should be cleared before a conversion; our guide to Opening Balance Equity cleanup covers how. Customer payments that were never linked to a bank deposit cause a similar drift; see Undeposited Funds cleanup.

When it isn’t a changed transaction

If the discrepancy report, the audit trail and the register all come back clean and the balance still moves, suspect the file. Intuit names data damage as a cause on Desktop. Run the Verify and Rebuild sequence before editing anything else, because transactions altered by a damaged file look like user edits in every report above.

Why this has to be clean before a migration

A conversion copies your reconciled position into the new system. If the last reconciliation no longer agrees with the bank, the new file starts from a number that is wrong, and nobody will notice until the first reconciliation in Xero, QuickBooks Online or Sage, when the difference turns up with no history attached. Intuit also warns that reconciliation works differently in QuickBooks Online and QuickBooks for Mac, so some transactions can come across unreconciled when you switch versions, which changes the opening balance on the other side.

That is why our reconciliation standard ties every bank and card account to a statement at the cutover date before anything is moved, and why a drifting beginning balance is fixed first, not carried over. Doing it the other way round means reconciling the same months twice, once in each system.

Frequently asked questions

Why is my QuickBooks beginning balance different from my bank statement?

Because something that was already reconciled has changed since your last reconciliation (it was edited, deleted, voided or unticked), or because the opening balance was entered incorrectly. The beginning balance is the ending balance of your last completed reconciliation, so any change to those transactions moves it.

How do I find what changed in QuickBooks Online?

Open Reconcile, choose the account and select We can help you fix it to open the Reconcile Discrepancy report. It lists each change, who made it and a suggested fix. Check the audit log for deleted or voided transactions, and the register for transactions marked R after your last reconciliation.

Should I use Enter Adjustment in QuickBooks Desktop?

Only on your accountant’s advice. It posts the difference to a Reconciliation Discrepancies expense account, so the bank matches but the books carry an unexplained expense. Finding and fixing the changed transactions, or undoing and redoing the last reconciliation after a backup, keeps the books accurate.

Can I undo a reconciliation in QuickBooks Online?

You can unreconcile individual transactions. Undoing an entire reconciliation is a QuickBooks Online Accountant feature, so it needs an accountant user.

Does a reconciliation problem affect converting my file?

Yes. The conversion carries your reconciled position into the new system, so a wrong beginning balance becomes a wrong opening balance there. Fix it first and tie each account to a statement at the cutover date.