BR
BankStatementReader

How to Undo a Bank Reconciliation in QuickBooks Online

By BankStatementReader Team ·

Sometimes a reconciliation is finished and then you realize something was wrong: a transaction was matched to the wrong line, the opening balance was off, or a period was reconciled with a duplicate still in the books. Undoing a bank reconciliation in QuickBooks Online lets you revert the reconciled status so you can fix the underlying data and reconcile again cleanly.

What "undoing" a reconciliation actually does

A bank reconciliation confirms that the transactions in your books match what the bank actually processed during a period, and marks those transactions as reconciled — each one carries a reconciled status (often shown as an "R"). Undoing it reverses that confirmation. In practical terms, the transactions that were marked reconciled for a given statement period have that status removed, so they show as unreconciled and are selectable again the next time you reconcile. (Note that a reconciled status does not by itself lock a transaction from being edited or deleted — undoing simply clears the reconciled mark.)

Undoing does not delete transactions and does not, by itself, change any dollar amounts. It simply takes a period (or a set of transactions) back to an unreconciled state. The amounts, dates, and accounts stay as they were until you edit them.

Common reasons to undo and redo

  • A transaction was matched or categorized incorrectly. The period reconciled to zero, but only because two offsetting errors cancelled out.
  • The beginning (opening) balance was wrong. If the starting balance for a period is off, every reconciliation built on top of it inherits the discrepancy.
  • Duplicates or missing entries. A transaction was entered twice, or one that belongs in the period was never recorded, so the reconciled set does not reflect reality.
  • A prior period was reopened. Someone edited or deleted a previously reconciled transaction, which can throw off the running reconciled balance and call for a redo.

In each case the goal is the same: get the books back to a state where you can re-match transactions against an accurate statement.

The general approach (verify the exact path in your account)

The exact menu wording and which options are available depend on your QuickBooks Online plan and whether you are working in the standard company view or the accountant view. Treat the steps below as the general concept rather than a guaranteed click path, and confirm the current wording inside your own account.

One distinction matters before you start: undoing an entire reconciliation in one step is generally available to users with accountant access (through the accountant tools and the reconciliation history), not to a regular company user. If you are signed in as a regular company user, you typically cannot undo a whole reconciliation at once. Instead you have two options: you can un-reconcile transactions individually by changing each transaction's reconcile status (for example, editing the status field on a transaction in the account register), or you can ask your accountant to undo the reconciliation for you. Availability and wording vary by plan and role, so verify what your own account offers in-product.

  1. Open the reconciliation area for the account. This is the same area where you start a reconciliation. Look for the reconciliation screen or reconciliation history for the bank or credit card account in question.

  2. Find the reconciliation history. QuickBooks Online keeps a record of past reconciliations, typically a history list showing each period that was reconciled. Locate the specific period you need to revert.

  3. Look for the undo (or reverse) option. Depending on the plan and view, the option to undo a reconciliation may appear in the history list, in an actions or dropdown menu beside the period, or only within the accountant view. The wording and availability vary, so look for the reconciliation history and an undo option there.

  4. Confirm and review the result. After reverting, the affected transactions should no longer be marked as reconciled for that period. Review the account register to confirm the change looks the way you expect before you do anything else.

Because the placement of this option differs between plans and has changed over time, do not assume a single fixed sequence will be present. If you cannot find it, or if the period you need to undo affects already-closed books, verify the current steps in-product or check with your accountant before proceeding. An accountant can also tell you whether undoing a closed period is the right move or whether an adjusting entry is safer.

After you undo: fix, then re-reconcile

Once the period is unreconciled, correct the underlying issue — fix the miscategorized transaction, remove the duplicate, add the missing entry, or correct the opening balance. Then run the reconciliation again for that period against the correct statement so the books and the bank agree for the right reasons.

It is worth being deliberate here. Undoing and redoing can ripple into later periods if a reconciled balance shifts, so re-check the periods that follow as well.

How to avoid the re-work next time

Most reconciliations that need undoing trace back to messy input: a transaction matched to the wrong line, a duplicate, or amounts that did not line up with the statement in the first place. The cleaner your starting data, the less likely you are to reconcile to a false zero and have to unwind it later.

A practical habit is to work from the statement itself in a spreadsheet before you reconcile, so you can scan for duplicates, confirm dates, and spot anything missing while the rows are easy to sort and filter. If your statement only exists as a PDF, you can turn it into clean spreadsheet rows with the free bank statement converter, then compare those rows against what is in QuickBooks before you mark anything as reconciled.

Reconciling from accurate rows is the simplest way to keep a reconciliation finished once it is finished — and to spend less time undoing your past work. For a refresher on the underlying process, see what a bank reconciliation is and how to do one step by step.

Related reading