Can I undo a past bank reconciliation in QuickBooks Online myself, or do I need an accountant?In QuickBooks Online you can undo a past bank reconciliation yourself, and in most cases you don't need an outside accountant. Thanks to a recent update, if you're the primary admin (or have the in-house accountant role) you can now undo an entire reconciliation in one step, right from your own account. If you only need to fix a transaction or two, you can instead unreconcile individual transactions from the register.One thing to note: whether the one-step full undo is available can depend on your QuickBooks Online plan as well as your user role, so the exact options you see may vary. If you don't see the Undo option described below, use the manual method in Option 2 or invite an accountant.Before you undo: Undoing a reconciliation permanently deletes its reconciliation report and any attachments, so download anything you want to keep first. It also reverts every reconciliation completed after the one you pick, and your beginning balance resets to the ending balance of the prior reconciliation. If you work with an accountant, check with them before you start.Option 1: Undo an entire reconciliation in QuickBooks OnlineAvailable to the primary admin, the in-house accountant role, or an accountant connected through QuickBooks Online Accountant. This reverses a whole reconciliation at once, no need to touch transactions one by one.Go to All apps, then Accounting, then Reconcile.Select History by account.Select the account and date range, then find the reconciliation you want to undo.From the Action column, select the dropdown ▼, then select Undo.Review the consequences in the confirmation window, then select the checkbox to acknowledge them. (You can't continue until you check it; to back out, select Cancel.)Select Undo reconciliation.Full details: Undo an entire reconciliation in QuickBooks Online. If your accountant manages your books through QuickBooks Online Accountant, they can follow Undo a client's reconciliation in QuickBooks Online Accountant.Option 2: Unreconcile individual transactions in QuickBooks OnlineIf you only need to fix a few transactions rather than a whole period, you can change their status directly in the register. This doesn't undo the full reconciliation.Go to All apps, then Accounting, then Chart of accounts.Find the account containing the transaction and select View register.Locate the transaction. Reconciled transactions show an R in the checkmark column (✔).Select the transaction to expand the view.Select the box in the checkmark column repeatedly until it's blank. This cycles the status from R (Reconciled) to C (Cleared) to blank (Uncleared).Select Save.Heads Up: Removing a cleared transaction changes the beginning balance of your next reconciliation. If a balance looks off afterward, this article walks you through the fix: Fix issues with your beginning balance for accounts you've reconciled before.Prefer to have an accountant handle it?You can invite an accountant to your books, and they can run the one-step undo in Option 1 for you.Ready to re-reconcile?Once the old reconciliation is undone, confirm your beginning balance matches your last good reconciliation, then start fresh from your bank statement: Reconcile an account in QuickBooks Online.Did this get you sorted? Reply below and let us know which option worked for you.

Solved

How do I undo past bank reconciliations?

Forum|Forum|2 years ago
December 28, 2023
11 replies
863 views

No text available

QuickBooks Online

Best answer by katelynner

Can I undo a past bank reconciliation in QuickBooks Online myself, or do I need an accountant?

In QuickBooks Online you can undo a past bank reconciliation yourself, and in most cases you don't need an outside accountant. Thanks to a recent update, if you're the primary admin (or have the in-house accountant role) you can now undo an entire reconciliation in one step, right from your own account. If you only need to fix a transaction or two, you can instead unreconcile individual transactions from the register.

One thing to note: whether the one-step full undo is available can depend on your QuickBooks Online plan as well as your user role, so the exact options you see may vary. If you don't see the Undo option described below, use the manual method in Option 2 or invite an accountant.

Before you undo: Undoing a reconciliation permanently deletes its reconciliation report and any attachments, so download anything you want to keep first. It also reverts every reconciliation completed after the one you pick, and your beginning balance resets to the ending balance of the prior reconciliation. If you work with an accountant, check with them before you start.

Option 1: Undo an entire reconciliation in QuickBooks Online

Available to the primary admin, the in-house accountant role, or an accountant connected through QuickBooks Online Accountant. This reverses a whole reconciliation at once, no need to touch transactions one by one.

Go to All apps, then Accounting, then Reconcile.
Select History by account.
Select the account and date range, then find the reconciliation you want to undo.
From the Action column, select the dropdown ▼, then select Undo.
Review the consequences in the confirmation window, then select the checkbox to acknowledge them. (You can't continue until you check it; to back out, select Cancel.)
Select Undo reconciliation.

Full details: Undo an entire reconciliation in QuickBooks Online. If your accountant manages your books through QuickBooks Online Accountant, they can follow Undo a client's reconciliation in QuickBooks Online Accountant.

Option 2: Unreconcile individual transactions in QuickBooks Online

If you only need to fix a few transactions rather than a whole period, you can change their status directly in the register. This doesn't undo the full reconciliation.

Go to All apps, then Accounting, then Chart of accounts.
Find the account containing the transaction and select View register.
Locate the transaction. Reconciled transactions show an R in the checkmark column (✔).
Select the transaction to expand the view.
Select the box in the checkmark column repeatedly until it's blank. This cycles the status from R (Reconciled) to C (Cleared) to blank (Uncleared).
Select Save.

Heads Up: Removing a cleared transaction changes the beginning balance of your next reconciliation. If a balance looks off afterward, this article walks you through the fix: Fix issues with your beginning balance for accounts you've reconciled before.

Prefer to have an accountant handle it?

You can invite an accountant to your books, and they can run the one-step undo in Option 1 for you.

Ready to re-reconcile?

Once the old reconciliation is undone, confirm your beginning balance matches your last good reconciliation, then start fresh from your bank statement: Reconcile an account in QuickBooks Online.

Did this get you sorted? Reply below and let us know which option worked for you.

M

MelroseV

Level 1

I'd be happy to help you unreconcile your past bank reconciliations so they don't throw off your records, akrill.

If you’re currently using QuickBooks Online Accountant, you can utilize the Undo reconciliation feature to unreconcile previous transactions without manually editing individual transactions from within the register.

Here's how:

In the left menu, click Accounting.
Go to the Reconcile tab.
Select History by account.
Choose the account you want to reconcile and set a date range from the dropdowns.
Find the reconciliation on the list.
Select View report to open the Reconciliation Report.
Review any discrepancies and changes your client wants to make.
When you’re ready, select the dropdown ▼ in the Action column, and then select Undo.
Select Yes and then Undo to confirm.

For more information on how to undo reconciliation, see this article: Undo a client’s reconciliation in QuickBooks Online Accountant.

Alternatively, you can invite an accountant to help you unreconcile the transactions.

If you use a different version, you can undo a reconciled statement by manually unreconciling each transaction. Let me walk you through the procedure step by step.

Click the Gear icon at the top.
Select Chart of Accounts.
Locate and choose the account you’re working on, and click on View Register.
Select the transactions you want to unreconcile.
Keep on clicking the R status until it shows blank or cleared (C).
Click on Save.
Choose Yes to confirm.

Before completing any of the steps, I suggest consulting with your accountant. This is to make sure that all of your records are in order.

If you run into any errors or problems while reconciling, refer to this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Should you have any other questions or concerns, feel free to leave a comment below. We're always around to help. Have a great day!

J

jburnes

It is ridiculous that your company doesn't allow QB Online users to roll back an accidental reconciliation. It's just a way for you to squeeze more money out of us by forcing us to pay our accountant to do it for us. It is unethical business practices like this that will have me finding a new accounting software for my company. Your greed has motivated me to find a new company to work with.

T

tsamop

I read this solition as:

Unless you pay Intuit, or one of our partners to do your accounting for you, you may only remove reconciliation one transaction at a time. Effectively removing the ability to remove a reconciliation, so the only solution here is to pay Intuit a lot more money for a feature that should exist in the software by default.

H

HonEx

This is yet another example of the Intuit corporation holding small businesses hostage and trying to squeeze more of our hard-earned dollars out of our hands. To not allow a business owner complete control over their business accounting without a premium service fee is simply outrageous. I'll be filing yet another complaint with the Better Business Bureau. (I filed one about the Shopify product from Intuit for the same money-grubbing kind of scam.)

katelynner

Answer

Community Manager