Undo a reconciliation in QuickBooks Online

Two different jobs share one name

People say “undo the reconciliation” for two problems that have almost nothing in common.

The first is that one transaction got cleared by mistake, and everything else about the period is fine. The second is that an entire reconciliation was wrong, usually because it was completed against the wrong statement balance or forced to zero, and the period needs rebuilding. Either way, it helps to be clear on what a bank reconciliation proves, because undoing one removes that proof for every period after it.

The fix for the first is small, reversible, and takes under a minute. The fix for the second is irreversible, cascades into every later period, and permanently deletes reports. Using the second when the first would do is the single most expensive mistake available on this screen.

Feature	Unreconcile one transaction	Undo a reconciliation
Use it when	One transaction was cleared by mistake	The whole reconciliation was wrong
What changes	That transaction’s status, and the next period’s beginning balance	That reconciliation and every one completed after it
Reversible	Yes	No
Reports	The reconciliation and its report stay in history	Every undone reconciliation’s report is deleted
Time	Under a minute	The period has to be reconciled again from the statement

How to unreconcile one transaction in QuickBooks Online

Go to All apps, then Accounting, then Chart of accounts. Find the account and select View register. Reconciled transactions carry an R in the checkmark column. Select the transaction to expand it, then select the box in that column repeatedly: it cycles from R to C to blank. Select Save.

Intuit is explicit that this removes a transaction from a reconciliation rather than undoing the reconciliation itself, and the difference is not cosmetic. The completed reconciliation stays in the history with its report intact. What changes is that transaction’s status, and, as a consequence, the beginning balance of the next reconciliation on that account. That second effect is why this is not free: pull a transaction out of a closed period and the following period will open on a different figure than it did before. Correcting a wrong date or amount this way, rather than undoing the month, is set out step by step in editing a reconciled transaction.

How to undo an entire reconciliation in QuickBooks Online

This requires signing in as the Primary Admin. If the Undo option is not visible, that is usually the reason, and it is worth checking before concluding the reconciliation cannot be undone.

Go to All apps, then Accounting, then Reconcile, and select History by account. Change the report period if the reconciliation you want is not listed. In the Action column, open the dropdown and select Undo. Read the warning, tick the confirmation checkbox, select Undo reconciliation, then Done.

Three things about that operation are worth knowing before you start it rather than after.

It is irreversible. There is no undo for the undo. The reconciliation is gone and has to be performed again from the statement.

It permanently deletes the associated reports and attachments. Not archives them. Anything you need, including the reconciliation report itself and any statement PDFs attached to it, has to be downloaded first.

It does not stop at the period you selected. Intuit’s documentation states that the chosen reconciliation and any reconciliations since then are undone. Undoing March in a file reconciled through June undoes April, May, and June as well.

To undo only the last reconciliation, select Undo on the most recent row in History by account. Nothing was completed after it, so no other period is undone with it. Its own report is still deleted, so download it first.

The cascade is the part that surprises people

A file reconciled cleanly from January through June, with a serious error in March, does not have a March-shaped problem. It has a March-through-June-shaped problem, because the undo cannot leave April standing on a beginning balance that no longer exists.

That changes the calculation considerably. Four reconciliation reports are destroyed instead of one. Four periods have to be redone, which means four statements have to be at hand before starting. And any manual adjustments made during those four reconciliations are gone with them.

Intuit’s guidance for accountants unwinding several periods is to work backward from the most recent, which is the same conclusion arrived at from the other direction: know how far the repair reaches before making it.

One nuance in the accountant documentation is easy to miss. Undoing a reconciliation does not undo manually reconciled transactions, meaning transactions whose status was set to R directly in the register rather than through a reconciliation. Those keep their status, and after an undo they are the transactions most likely to make the register look wrong in a way nobody can account for. Intuit’s own advice is to check the audit history afterwards to see what actually changed.

Through QuickBooks Online Accountant

A firm working in a client’s file through QuickBooks Online Accountant needs accountant access to that company, and then follows the same path inside the client’s file: All apps, then Accounting, then Reconcile, then History by account, then Action and Undo.

The prerequisites Intuit lists are worth reading as a checklist rather than boilerplate. Download the attachments and reports first, because undoing permanently deletes them, and that deletion takes the client’s records with it, not just yours.

Deciding whether to undo at all

The question is not whether the reconciliation history looks tidy. It is whether the accounting record is accurate, and those come apart more often than they should.

One transaction cleared by mistake: unreconcile that transaction. One transaction with the wrong amount: correct the transaction and accept that the beginning balance of the next period moves. One transaction duplicated: remove the duplicate, which has its own complications if it was reconciled. A wrong opening balance: that is an opening balance problem and undoing reconciliations will not touch it.

An undo earns its cost when the reconciliation itself is structurally wrong. Completed against the wrong statement. Completed with a forced adjustment. Completed with a set of transactions that bear no relation to what the statement actually shows. In those cases there is nothing to repair inside the period, because the period was never right.

There is also a middle path that gets overlooked. If a vendor payment was categorized to the wrong expense account but the amount and date are correct, the cash reconciliation is not wrong at all. Fix the category and leave the reconciliation history alone. Reconciliation tests cash, not classification, and correcting a classification error by unwinding six months of cash reconciliations is a large amount of destruction in service of nothing.

Five questions before you click

What exact error am I fixing. Which reconciliation is the first one that contains it. How many later reconciliations will be undone with it. Do I have the reports, attachments, and statements I need for every period in that range. Can I correct the transaction instead of rebuilding the reconciliation.

If any of those is unanswered, the undo is premature. The information is easier to gather before the history changes than after.

Do not use undo as a troubleshooting step

A reconciliation that will not reach zero is not, on its own, a reason to undo anything. Differences come from missing transactions, duplicates, wrong dates, and prior-period edits, and every one of those is diagnosable without destroying history. Start with the reconcile workflow, and when the beginning balance is the thing that moved, a bank balance that won’t reconcile covers finding what changed.

A beginning balance moves when a previously reconciled transaction was edited, deleted, voided, or unreconciled after the fact. The Reconcile Discrepancy report and the audit history will usually name it. That is a smaller and better-informed repair than undoing the period it belonged to.

How to undo a reconciliation in QuickBooks Desktop

Desktop does not cascade. Go to Banking, then Reconcile, choose the account, and select Undo Last Reconciliation. Check the period it names, then select Continue and OK. The beginning balance goes back to the one before that reconciliation, and every transaction it cleared becomes uncleared.

The limit is in the name: Desktop undoes only the most recent reconciliation. Undoing March in a file reconciled through June means running it four times: June, May, April, then March. The reach is the same as the Online cascade, one period per click, and every one of those months has to be reconciled again from its statement.

Back up the company file before the first undo. Desktop has no undo for the undo either, and restoring that backup is the only way back.

Common questions about undoing a reconciliation

Why can’t I undo a reconciliation in QuickBooks Online?

Usually because of who is signed in. The Undo option on the reconciliation history screen is shown to the Primary Admin and to an accountant working in the file through QuickBooks Online Accountant. Signed in as any other user, the Action column has no Undo, and the only route is unreconciling transactions one at a time in the register.

Can I unreconcile an entire month in QuickBooks Online?

Yes. Undoing that month’s reconciliation unreconciles every transaction it cleared. It also undoes every reconciliation completed after it, so one month in the middle of a reconciled year cannot come apart on its own. If only a line or two is wrong, unreconcile those lines in the register and leave the period intact.

When several periods have to come apart

Unwinding multiple reconciliations, correcting the transactions underneath them, and rebuilding each period against its real statement is cleanup work. It is scoped by how many months sit between the first bad period and the present, which is usually further back than the month that first refused to reconcile:

$99per month of backlog20% off 6+ months

If more than one period has to come apart, send the file for a free review before undoing anything.

After the file ties, a monthly close reconciles each account against a statement every month, which is what keeps a single bad period from becoming a year of them. Both are priced on the pricing page.