Skip to content
BankReconciler

QuickBooks Online reverse reconciliation step by step

Sometimes a reconciliation in QuickBooks Online has to be taken back: it was finished with a difference, the wrong statement was used or a transaction was ticked by mistake. Here is how to reverse it safely, and how to avoid creating a bigger problem in the months that follow.

Before you reverse anything

A reconciliation is a record that the books agreed with the bank on a given date. Undoing it changes the beginning balance of every later reconciliation of that account. So first find out what actually went wrong. Open the reconciliation report from the history of the account and compare it with the statement. Often the fix is a single transaction, not the whole month.

Also check whether the period is closed. If your books have a closing date, changes before it may need the closing password and may affect reports already given to a lender or tax preparer.

Unreconcile a single transaction

Use this when one item was ticked by mistake or needs to be corrected.

  1. Open the register of the bank account from the chart of accounts.
  2. Find the transaction. Reconciled items show R in the reconcile status column.
  3. Click the status until it is blank, or open the transaction and change its status.
  4. Save. QuickBooks warns that the item is reconciled, confirm only if you are sure.
  5. Reconcile again for the period, so the item is either ticked correctly or left open.

Changing a reconciled amount or deleting a reconciled transaction has the same effect as unreconciling it, and it changes the beginning balance next month. That is the most common reason a future reconciliation suddenly starts with a difference.

Undo a whole reconciliation

QuickBooks Online lets an accountant user undo an entire reconciliation from the reconciliation history of the account, using the accountant version of the product. If you are a business owner, invite your accountant as an accountant user, or unreconcile the transactions of that period one by one in the register. When undoing several months, start with the most recent and move backwards, one reconciliation at a time.

After undoing, reconcile the month again with the correct statement and the corrected transactions, and check that the next month starts from the right beginning balance.

Mistakes that make it worse

  • Undoing an old month without redoing the months after it.
  • Forcing the next reconciliation to finish with an adjustment instead of finding the cause.
  • Editing amounts of reconciled transactions to make a difference disappear.
  • Deleting a reconciliation adjustment entry without understanding the original difference.

Find the cause before you redo the month

The fastest way to know which lines are wrong is to compare the statement with the transactions in QuickBooks outside the reconcile screen. Export Transaction Detail by Account for the account and period and reconcile it against the statement in BankReconciler. You see which bank lines are missing, which book entries are doubled and which amounts differ, then you fix exactly those in QuickBooks. See how to reconcile in QuickBooks Online for the redo and bank reconciliation QuickBooks for the export.

See what went wrong before you undo