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. 

I am an accountant User and I am using QuickBooks online accountant version and I do not have the option to undo an entire reconciliation when I follow the directions here. I have done it before as an accountant so I am very confused as to why Its not working for me now. Did intuit update the software? Why cant I undo reconciliations?

We appreciate the details you've shared, Randy. I'd be glad to help you successfully batch undo your reconciliation in QuickBooks Online (QBO).

Upon checking here on my end, I found no updates regarding the missing Undo button for accountant users. 

Since you’ve confirmed that you’re using your accountant account to attempt the batch undo of transactions, you should indeed have access to this feature. That said, the problem you're experiencing is a possible cause of a cache issue. Browsers use cache to speed up the loading of web pages, but over time, it accumulates and leads to unusual behavior of the program. 

To fix this, log in to your QBO account using an incognito or private browser window. This will enable you to work with a clean slate. Please use these keyboard shortcuts:

• Google Chrome: Ctrl + Shift + N
• Mozilla Firefox: Ctrl + Shift + P
• Microsoft Edge: Ctrl + Shift + N
• Safari: Command + Shift + N

Then, try to access the undo button. If it's visible, clear your regular browser's cache to remove specific issues and help the program run efficiently. Also, you can use other devices and supported browsers to ensure everything works as expected.

Additionally, please refer to this article if QuickBooks Online doesn't match your bank statement at the end of a reconciliation: Fix Issues for Accounts You've Reconciled in the Past in QuickBooks Online.

Let us know if you have other concerns with undoing your reconciliation in QuickBooks. We're here to help you in any way we can.

I agree completely! Moving from desktop to online has been incredibly frustrating for this reason alone!

I did the same thing and it worked.  As the admin, I sent myself an invitation as if I were inviting an outside accountant.  I was then able to see the undo button.  

Hi Mirriam M,

What would be the best action if instead of unreconciling, transactions were deleted instead because deposits were improperly categorized.  Previous person categorized the transaction instead of applying them to open A/R accounts; hence, why they were deleted.

So, what would be the best course of action to fix the beginning balance before trying to reconcile the account?

You can match the deposit to the open Account Receivables (A/R), Jersey. I'm here to discuss this matter further.

In QuickBooks Online, deleting the deposit directly from the bank register will return it to the For Review tab in the bank feed center. In this case, you can match it to the open A/R.

Here's how:

1. Head to Transactions in the left pane.
2. Select Bank transactions, then the For Review tab.
3. Look for "matches found" in the Assign to or Category or match column and click on the deposit to expand the view.
4. Review the Suggested matches, ensuring it's the appropriate open A/R. Otherwise, pick Find other matches to look for other transactions.
5. Select Match.

For more information, refer to this material: Match online bank transactions in QuickBooks Online.

After that, manually reconcile the entry in the bank register with these steps:

1. Look for the account in the Chart or Account and click View register.
2. Locate the deposit from the lists and select it to expand the view.
3. In the checkmark column, click the box until you see an R.
4. Select Save.

Additionally, you'll want to browse this material for more instructions on correcting an opening balance and reconciling the succeeding period: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Moreover, consider scanning this material to generate a reconciliation report and review the summary of your past reconciliation: How do I view, print, or export a reconciliation report?

You can keep posting in this forum anytime you have questions about fixing the beginning balance in QuickBooks Online. We're here to offer relevant help to address your queries.