When a QuickBooks Online reconciliation balanced last month and will not balance now, the cause is usually that something already reconciled has changed. A transaction inside a completed reconciliation was edited, deleted, voided, or had its reconciled status removed. QuickBooks builds the beginning balance of every new reconciliation from the transactions already marked reconciled, so a change to any one of them moves the starting point, and nothing you enter in the current month will make the difference go away.
The fix is to find the specific transaction, decide whether the change was a correction or an error, and act on that. This post covers QuickBooks Online and works through it in the order that saves time.
First, confirm which problem you have
Two different symptoms get described as "the reconciliation won't balance".
- The beginning balance does not match the statement's opening balance. QuickBooks shows an alert on the Reconcile screen: "Your account isn't ready to reconcile yet. Your beginning balance is off by…". A previously reconciled transaction has changed. Most of this post deals with this case.
- The beginning balance is right, but the Difference will not reach zero. This is a current-period problem: a missing transaction, a bank feed duplicate, an amount keyed wrongly, or the wrong statement date or ending balance. It is covered near the end.
Before you change anything, write down the exact amount the beginning balance is off by. Every change you find should add up to that figure. That is how you know you have found all of them.
Start with the reconciliation discrepancy report
Go to All apps > Accounting > Reconcile, select the account, and click We can help you fix it on the alert. This opens the discrepancy report for that account. You need admin access to see it.
For each reconciled transaction that has changed since it was reconciled, the report shows what changed, when, and which user changed it. Read the What happened column first. Then use Review in tray to open the transaction, and the dropdown next to it to select View history, which shows the transaction's full history of changes.
The user name matters. A change by a bank-feed rule, an app integration or a staff member who no longer works on the file points you to different explanations, and to different people to ask.
Check what the report does not show
Intuit's own help article lists two gaps. Check both before you conclude the report is complete.
- Deleted and voided transactions. Open Settings > Audit log, filter it to the account and to the period since the last completed reconciliation, and look for deletions and voids.
- Transactions marked reconciled outside a reconciliation. Open the account register from Chart of accounts > View register, filter by reconcile status, and look for transactions marked R that are dated after the last completed reconciliation. Clicking the status column in a register can set a transaction to R without any reconciliation being run, and it moves the beginning balance just as an edit does.
When the changes you have found add up to the amount you wrote down, you have found them all.
Correction or error: the judgment the report cannot make
The report tells you what changed. It cannot tell you whether the change should have been made. Here is a useful test. The amount and date of a reconciled bank transaction were confirmed against a bank statement. A genuine correction should almost never need to change either.
Each change will fall into one of three groups.
- An error. A reconciled payment was deleted because someone took it for a duplicate. An amount was changed while recategorising. A bank feed match replaced an entry that had already been reconciled. Restore the original: re-enter a deleted transaction with its original date, amount and account, revert an edited amount, and mark it reconciled again only where the bank statement shows it cleared.
- A legitimate change to the other side of the entry. If the expense account or customer on a reconciled payment was wrong, correcting the category does not change the bank side and is normally fine. If the original entry was wrong in substance, post a dated adjustment in the current period with a memo. Do not rewrite the reconciled transaction.
- A change nobody can explain. Ask the user named in the report. If the change touched a period that has already been reported on, such as a VAT or sales tax return, a tax filing or a set of management accounts, the issue is bigger than the reconciliation. Those reports were prepared on the old numbers. Record what changed and tell whoever owns that filing.
There are two fixes to avoid. Do not post a single journal entry to force the beginning balance to agree. Do not mark an unrelated transaction as reconciled to make the figures match. Both hide the difference without explaining it, and the next person to review the file will find it again.
When to undo a reconciliation, and when not to
QuickBooks lets you undo a completed reconciliation from Reconcile > History by account: find the reconciliation and choose Undo from the dropdown in the Action column. According to Intuit, this is available to the Primary Admin and to Accountant or In-House Accountant users with access to the company.
Two points from Intuit's guidance decide whether you should use it:
- Undoing a reconciliation also reverses every reconciliation completed after it, and the beginning balance reverts with them.
- It permanently deletes the reconciliation reports and attachments for those periods. Download them first.
Undo is the right tool when several months are genuinely wrong and you intend to reconcile them again against the bank statements. It is the wrong tool for making one changed transaction disappear, because it destroys the record of what was originally reconciled. That record is your evidence.
Prevent it: close the books with a password
Most reconciliation breaks happen because nothing stops anyone editing last quarter. QuickBooks Online lets you lock the books:
- Go to Settings > Account and settings > Advanced.
- In the Accounting section, click Edit and turn on Close the books.
- Enter a Closing date. Transactions on or before this date are locked.
- Choose Allow changes after viewing a warning and entering password, not the warning-only option. People click through warnings, but a password stops them.
Set the closing date to the last month-end that has been reconciled and reviewed, and move it forward as the final step of each month's close. Give the password to the person responsible for the close, not to every user on the file.
Each month, also run the Exceptions to Closing Date report. Search for it under Reports > Standard reports. It lists changes made to the closed period after the books were closed. If that report is empty and reconciliations still break, look at register status changes, which are covered above.
If the beginning balance is right but the Difference is not zero
This is a current-period problem. Check these points in order:
- Statement details. Confirm the ending date and ending balance you entered match the statement exactly.
- Bank feed duplicates. Look for the same amount on the same or a nearby date, where one entry was matched and the other added as new.
- Dates outside the statement period. A transaction dated after the statement end date may not appear in the reconciliation list, depending on the view selected. Check its date.
- A difference divisible by 9. As a general bookkeeping rule of thumb, this usually points to transposed digits, such as 540 keyed as 450.
- A difference equal to twice a transaction. This usually means a deposit was entered as a payment, or the reverse.
When it is a file problem, not a reconciliation problem
If the discrepancy report shows dozens of changes across many months, or the audit log shows reconciled periods being edited routinely, fixing one reconciliation will not hold. The file needs a structured cleanup: reconciliations oldest first, then Undeposited Funds and Opening Balance Equity, then the balances the bank work exposes. Our QuickBooks cleanup checklist sets out that order.
Wissen Solutions handles this as part of our QuickBooks Online and offshore accounting services, for businesses and as white-label support for accounting firms. Work usually starts with a review of one file. The workpapers record each discrepancy, what was changed and what could not be resolved.
Sources (QuickBooks Online menus and behaviour checked 24 October 2026; Intuit changes the interface periodically, so labels may differ slightly in your file)