How to undo past bank reconciliation in qb online

Hi there, Nev.

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

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. 

To undo reconciliation, here's how:

1. In the left menu, click Accounting. 
2. Go to the Reconcile tab.
3. Select History by account.
4. Choose the account you want to reconcile and set a date range from the dropdowns.
5. Find the reconciliation on the list.
6. Select View report to open the Reconciliation Report.
7. Review any discrepancies and changes your client wants to make.
8. When you’re ready, select the dropdown ▼ in the Action column, and then select Undo.
9. 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.

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.

1. Click the Gear icon at the top.
2. Select Chart of Accounts.
3. Locate and choose the account you’re working on, and click on View Register.
4. Select the transactions you want to unreconcile.
5. Keep on clicking the R status until it shows blank or cleared (C).
6. Click on Save.
7. 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!

Hi , thanks for the info, however i do not see the action column in quick books online (using accountants view and steps show below).

I have actually seen this method and used it in the past and I beleive Intuit might have updated the software and now the action column is not visible.

Not sure if you have any idea for the new method used for undoing the reconciliation.

Thanks

Nev

1. When you’re ready, select the dropdown ▼ in the Action column, and then select Undo.
2. Select Yes and then Undo to confirm.

Hello there, Nev. Let me share some information about undoing your reconciliation in QuickBooks Online (QBO).

The option to undo reconciliation is only available in the QuickBooks Online Accountant version. That being said, only your accountant can undo the entire reconciliation. What you can do is manually undo or remove transactions from reconciliations in QuickBooks Online.

Here's how:
 

1. Go to the Accounting menu, then select Chart of Accounts.
2. Locate the account and select Account history.
3. Select the transactions under the reconciliation in question.
4. Review the check column. If the transaction is reconciled, you’ll see an “R.” tick the box and keep ticking it until the box is blank. This removes the transaction from the reconciliation.
5. Then select Save.

You may also check out the following articles about reconciliations:
 

• Reconcile an account in QuickBooks Online
• How do I view, print, or export a reconciliation report?

You're always welcome to post again here and ask any other questions about managing your reconciliation. I'm always ready to lend you a hand. 

Hi, 

I am the only user for my quickbooks online account. So, my role is Primary Admin and I do not see "undo" when I click on under  ▽ "Action". Is is possible to undo reconcile from Primary Admin user? 

Thanks 

Let me step in to shed some light on how you can undo reconciliation in QuickBooks Online (QBO), @aye.

Currently, the feature to undo the entire reconciliation is exclusive to accountants with a QBO Accountant subscription. Considering that, you don't have the Undo option under the Action column on the Reconciliation page. If you have an accountant, you may invite them to your company so they can accomplish this task on your behalf.

However, the primary admin has general access to every part of the QBO account. That said, you can manually remove individual transactions from the reconciliation. Here's how:

1. Go to the Gear icon and select Chart of Accounts.
2. Locate the account that has the reconciled transaction and click View Register.
3. Find the transaction and select it to expand the view. If the entry is reconciled, you'll see an R in the checkmark (✔) column. To undo it, click the box until it's blank. 
4. Select Save.

Moreover, I'll share these pointers to help rectify issues during reconciliation:

• Fix issues for accounts you've reconciled in the past in QuickBooks Online.
• Fix issues at the end of a reconciliation in QuickBooks Online.

Should you have further queries concerning reconciliation, please don't hesitate to visit us again. Our team is active 24/7 to assist. Keep safe and have a good one.

The function to only allow accountants to undo reconciliations is disappointing to say it mildly. 

I paid for this software. And you guys are limiting my ability like a 5 year old kid. Super frustrating. Grow up quick books.

If I undo reconciliations, will I lose all the individual transaction categorizations, memos, attachments etc?

Hello there, hmacattack.

Undoing a reconciliation in QuickBooks Online will not erase individual transaction categorizations, memos, and attachments. However, it'll unreconcile previously reconciled transactions and reverse any changes made during the reconciliation process.

Additionally, undoing the entire reconciliation is only available in QuickBooks Online Accountant. If you have a different version, I suggest contacting your accountant. They can undo the entire period at once.

Here's how:

1. Go to the Gear icon.
2. Select Manage Users.
3. Click the Accounting Firms tab and select the Invite button.
4. Enter the accountant's information.
5. Tap Save.
6. Let your accountant undo the entire reconciliation.

If you prefer to do it by yourself, follow these instructions to undo reconciled transactions one at a time:

1. Go to the Transactions menu. Then select Chart of Accounts.
2. Find the account and select View Register. 
3. Filter the register.
4. Review the check column. If the transaction is reconciled, you’ll see an R.
5. Click the box repeatedly until it's blank to remove the transaction from the reconciliation.
6. Hit Save. Then close your register.

You can check this article if you encounter reconciliation issues: Fix issues when you're reconciling accounts.

Please come back if you need any further assistance with undoing the reconciliation. The Community is always here to help.

It's so they can charge us for the "live bookkeeping" function. It makes me furious.

What an awful, money grabbing policy. Why on earth am I not allowed to undo a reconciliation?

I appreciate you joining the thread, Dunstan.

I understand the importance of undoing a reconciliation in QuickBooks. Let me share more details about it.

The option to undo whole reconciliation process in a QuickBooks Online account is unavailable. However, you can only unreconcile one transaction at a time to lessen the damage.

If you need to start over, you need to consult with your accountant. They can undo the entire period at once using QuickBooks Online Accountant. They have this option to ensure your books are in good shape and to avoid messing up your accounts.

To invite your accountant:

1. Click the Gear icon in the upper-right corner and select Manage Users.
2. Go to the Accountants tab and click the Invite button.
3. Enter the accountant's information.
4. Click Save.
5. Then, let your accountant undo the entire reconciliation.

Here's how to undo reconciled transactions one at a time:

1. Go to the Gear icon.
2. Select Chart of Accounts.
3. Select the account that has the reconciled transaction. Then, View register.
4. Locate the transaction to edit.
5. In the reconcile status column (indicated by a checkmark), repeatedly click the box until it changes from "R" to blank.
6. Then select Save.

Please check out this article for visual reference: Undo or remove transactions from reconciliations in QuickBooks Online.

I've added here some articles for future reference for the whole process of reconciling an account and managing a reconciliation report:

• Learn the reconcile workflow in QuickBooks
• View, print, or export a reconciliation report

Please come back if you need any further assistance with this process. I'm always here to help.

What an insulting reply. Quickbooks and its support gets worse every day. Anyone with an ounce of accounting experience understands that undoing reconciliations by month avoids the discrepancies that come with undoing individual transactions. Sincerely, a CPA.

Awful bullshi* policy

I don't know how QB/Intuit went from desktop which was such a great piece of software to this pile of sh*t they're peddling online at a ridiculous cost.  This company should be ashamed of themselves at all levels.  There's either a high level of incompetence or mismanagement or both going on here.

Hi,

This sounds like "my best guess" advise.

Firstly there is no such thing as an action column, then playing with the register is the worst idea someone ever could come up with. 

One thing that is not clear and it took me a long time to find.

Not everyone has the UNDO button available.

I am the company accountant and had to set myself up as if I were an outside accountant to get access to that button. That means no one else in the company can undo a reconciliation. That's good and bad. We don't want everyone changing a closed reconciliation, but it would be nice if permissions could be given from the Admin level.

The problem with this is that if someone changes a transaction that was in a previous reconciliation, that previously reconciled account is no longer in balance. You may be able to unreconcile a single transaction easily, but you cannot re-reconcile that transaction without undoing and re-doing the reconciliation. 

It is necessary for the one that reconciles the accounts to have the ability to also un-reconcile the accounts.

QuickBooks needs to change this. I have been able to work around this by setting myself up as the company accountant, but that is a pain as well because I have to log out and back in if the account needs to be unreconciled.

I'm sharing insights about undoing reconciliation without using QuickBooks Online accountant, Breeeze.

As mentioned by my colleague above, you can undo the entire period at once using QuickBooks Online Accountant.  At the moment, the ability to permit the admin level is unavailable in QBO. I can see how the functionality would be beneficial to your business.

 I'd recommend sending a feature request directly to our Product Development team. This helps us improve your experience and the features of the program. 

Here's how:

1. Go to the Gear menu and then select Feedback.
2. Type in your feature request in the description box.
3. Once done, click on Next.

I'll add these helpful articles for future reference: 

• Learn the reconcile workflow in QuickBooks
• Reconcile an account

Keep your posts coming if you need more help with undoing reconciliation in QBO. I'm always here to help. Have a good one.