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.

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.

Unreconciling one transaction

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.

Undoing an entire reconciliation

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.

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.

Desktop is a different program

This is the QuickBooks Online workflow. QuickBooks Desktop reconciles, and undoes reconciliations, through different screens with different constraints. The accounting principle survives the translation; the button locations do not.

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:

$99 per month of backlog

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.