QuickBooks Reconciliation Discrepancy: How to Fix It

A QuickBooks reconciliation discrepancy means the beginning balance in QuickBooks no longer matches the beginning balance on your statement, almost always because a transaction you reconciled before was later edited, deleted, voided, or unreconciled. To fix it, open the Reconciliation Discrepancy Report, find each changed transaction, and restore it to the amount and status it had when it was reconciled. When the report's total difference is $0.00, the beginning balance matches again.

Catching a discrepancy early keeps your monthly close honest, because a wrong beginning balance carries forward into every reconciliation after it, and changing the beginning balance in QuickBooks Online means correcting what it is calculated from rather than typing over it. If the discrepancy is there because transactions are missing entirely and never made it into QuickBooks, convert those statement PDFs to a .qbo file with the tool above and import the exact months, so the register matches the statement before you reconcile again. Here is what a reconciliation discrepancy is, what causes it, and how to clear it in QuickBooks Online and Desktop.

What is a reconciliation discrepancy in QuickBooks?

A reconciliation discrepancy is a difference between the beginning balance QuickBooks expects and the beginning balance on your statement when you start a new reconciliation. It signals that something already reconciled has changed since you last balanced the account. Until you find and fix that change, the new reconciliation starts from the wrong number and will not reach $0.00.

What causes a reconciliation discrepancy in QuickBooks?

It happens when a previously reconciled transaction is edited, deleted, voided, or had its reconcile status removed. Changing the amount, date, or account of a cleared item, or unchecking the R column in the register, all shift the ending balance of the last reconciliation and therefore the beginning balance of the next one, which triggers the warning.

How do I fix a reconciliation discrepancy in QuickBooks Online?

When QuickBooks warns your beginning balance is off, select the We can help you fix it link to open the Reconciliation Discrepancy Report. It lists each changed transaction and the difference. Open each one, restore the original reconciled amount or status, and Save. When the report's total difference reads $0.00 and the beginning balance matches your statement, resume reconciling.

How do I find the Reconciliation Discrepancy Report in QuickBooks?

In QuickBooks Online, the report opens from the We can help you fix it link in the beginning balance warning, or from Settings, then Reconcile. In QuickBooks Desktop, go to Reports, then Banking, then Reconciliation Discrepancy, and choose the account. The report shows the transaction type, the change made, the date entered or modified, and the effect on the balance.

What is the Reconciliation Discrepancy account in QuickBooks?

The Reconciliation Discrepancies account is a special expense account QuickBooks Desktop posts to when you force a reconciliation with an unexplained difference. The off amount lands there as an adjustment so the period closes, but the real error is still unfixed. A balance in that account is a sign that past reconciliations were forced rather than truly balanced.

Why did my beginning balance change in QuickBooks?

Your beginning balance changed because a transaction that was part of an earlier reconciliation was altered after the fact. Common culprits are editing the amount, deleting the entry, voiding a reconciled check, or clearing the R reconcile status in the register. Any of these rewrites the prior ending balance, which becomes the new period's beginning balance.

How do I fix a reconciliation discrepancy in QuickBooks Desktop?

Run Reports, then Banking, then Reconciliation Discrepancy for the account to see what changed since the last reconciliation. Open each flagged transaction and restore it to its reconciled amount and status. Also run the Previous Reconciliation report and compare it to your statement. Once every change is reversed, the beginning balance matches and you can reconcile the new period.

How do I correct a previous reconciliation in QuickBooks?

Do not delete the whole reconciliation if only one item is wrong. Use the discrepancy report to find the specific transaction that changed and put it back to what it was when reconciled. If a reconciled transaction was deleted, re-enter it and mark it reconciled in the register. Targeted fixes keep your reconciliation history intact.

Should I force a reconciliation in QuickBooks to clear a discrepancy?

Avoid it. Forcing a reconciliation posts the unexplained difference to an adjustment account so the period closes, but the underlying error stays and the discrepancy reappears next month. Forcing it only makes sense for a tiny, truly untraceable rounding amount. For anything else, find the changed transaction and fix it so the difference clears on its own.

What reports help find a reconciliation discrepancy in QuickBooks?

The Reconciliation Discrepancy Report is the main one, since it lists transactions changed since the last reconciliation. In Desktop, also run the Previous Reconciliation report, the Missing Checks report, and a Transaction Detail by Account filtered to the period. The Audit Log in QuickBooks Online shows who edited or deleted a reconciled transaction and when. To compare against what was originally reconciled, open the bank reconciliation report in QuickBooks for that period.

How do I fix a beginning balance that doesn't match in QuickBooks?

First identify the amount of the gap, then look for a single transaction that matches it, which is often the changed item. Restore that transaction to its reconciled state. If transactions are missing entirely, enter or import them and mark them reconciled. Once the register reflects every cleared item correctly, the beginning balance lines up with your statement.

Why is my reconciliation off by a small amount in QuickBooks?

A small difference is often a bank fee, interest charge, or rounding that was never recorded, or a transaction whose amount was edited by a few cents. Check for service charges and interest on the statement that aren't in QuickBooks, and scan the discrepancy report for an amount close to the gap. Record the missing item rather than forcing the balance.

Can deleting a transaction cause a reconciliation discrepancy?

Yes. Deleting a transaction that was already reconciled removes it from the cleared total, which changes the ending balance of that reconciliation and the beginning balance of the next one. If you must remove a reconciled entry, re-enter a correct version and mark it reconciled, so the period's cleared total stays the same.

How do I prevent reconciliation discrepancies in QuickBooks?

Avoid editing, deleting, or voiding transactions in periods you have already reconciled. If a closed period needs a change, post a correcting entry in the current period instead. Set a closing date with a password in QuickBooks so reconciled months are locked, and reconcile every account monthly so any change is caught while it is still easy to trace.

Fixing a discrepancy is part of keeping a clean reconciliation, so pair this with the pillar on reconciling bank statements in QuickBooks and the fix for when your bank balance doesn't match QuickBooks. If you need to back out a whole reconciliation, see how to undo a reconciliation in QuickBooks, and to stop missing items from causing gaps, add missing bank transactions. To rebuild a register that's missing whole months, import old bank statements into QuickBooks. If your records also live in spreadsheets, you can convert statements to Excel, turn a CSV file into a .qbo, or pull data from receipts to match the charges you're chasing.