cancel
Showing results for 
Search instead for 
Did you mean: 
new_to_this
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

some blog say there should be an "undo" within the action dropdown but I do not see one.
Solved
Best answer January 12, 2021

Best Answers
AlexV
QuickBooks Team

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

Yes, you can undo it, michael-cardman.

 

The Undo button in the Action column is only available in QuickBooks Online Accountants. If your accountant is using this version, you can let them undo the reconciliation on your behalf. Here's the article for the detailed steps: Undo a client’s reconciliation in QuickBooks Online Accountant

 

You can also invite an accountant to review your accounting in QuickBooks Online.

 

We can manually undo it if you want to do it by yourself. You can follow these steps:

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Find the account and select View register
  3. Locate the transactions you want to unreconcile and select it to expand.
  4. Repeatedly click the box with the letter R until it's blank. Then, Save.

Please check Undo or remove transactions from reconciliations in QuickBooks Online. This will give you more info on what to do if you encountered issues with your reconciliation. 

 

Don't hesitate to post again if you have other questions. We'll respond as soon as we can.

View solution in original post

20 Comments 20
AlexV
QuickBooks Team

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

Yes, you can undo it, michael-cardman.

 

The Undo button in the Action column is only available in QuickBooks Online Accountants. If your accountant is using this version, you can let them undo the reconciliation on your behalf. Here's the article for the detailed steps: Undo a client’s reconciliation in QuickBooks Online Accountant

 

You can also invite an accountant to review your accounting in QuickBooks Online.

 

We can manually undo it if you want to do it by yourself. You can follow these steps:

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Find the account and select View register
  3. Locate the transactions you want to unreconcile and select it to expand.
  4. Repeatedly click the box with the letter R until it's blank. Then, Save.

Please check Undo or remove transactions from reconciliations in QuickBooks Online. This will give you more info on what to do if you encountered issues with your reconciliation. 

 

Don't hesitate to post again if you have other questions. We'll respond as soon as we can.

Koala77
Level 2

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

I'm in accountant mode and it doesn't work -get exactly same as what person is saying - just shows Print in dropdown

Rasa-LilaM
QuickBooks Team

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

I’m glad to see you in this thread, new_to_this.


Let me provide some information about the Undo reconciliation option. Then guide you in the right direction on how to resolve your concern.


For QuickBooks Online Accountant (QBOA) users, there are special tools you can utilize to enhance your bookkeeping. The feature mentioned above is one of them.


If you’re using a different QuickBooks Online version, you’ll not see the Undo menu in the Action column. This option is only available for accountants with QBOA subscriptions.


For more details, check the following article: Use accountant tools and features in QuickBooks Online Accountant. From there, you’ll see how each accountant tool works.


To unreconcile the account, you’ll have to remove the transactions one at a time. I recommend following the steps shared by the AlexV above.  Once done, you can now reconcile your bank or credit card account.


If you encounter any hurdles during the reconciliation process, the links below contain solutions on how to resolve them. The troubleshooting is scenario-based, and I suggest you choose the one that suits your situation.

 

 

Reach out to me again for any other reconciliation or QuickBooks concerns. I’ll get back to help and make sure you’re taken care of. Have a good one.

ddeveaux1
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

As usual the responses from the Quickbooks Team conveniently don't answer the question. I feel this must be on purpose given how often it happens!

You cannot do this from Accoutant mode. You have to be using their Accounting Edition of Quickbooks which is different. So if you don't actually have an accountant and are using QB Online as a small business owner partially to save the time and $$ to hire an accountant, which is a lot of what the tool is for, then no, you must go through each transaction and unreconcile yourself.

When they started out they let some of us, me included, have a free license for QB Accounting specifically for this purpose. My edition doesn't seem to work anymore and they want me to pay as an accounting firm, which I am not. So guess I'll just unreconcile the individual transactions for Feb 2021. Oh wait, since this is Sept 2021 I guess I can't just do that can I? I guess I have to unreconcile each of the individual transactions for Feb, Mar, Apr, May, June, July, Aug? Ok, sounds like a good use of time all because of a $12 change in Feb. After all, we wouldn't want me to unreconcile my statement since I'm not an accountant. Right?

Andrew C
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

Why does it have to be done in QBOA? This seems like something a company should be able to do on their own.

AlexV
QuickBooks Team

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

Hello Andrew C!

 

Thanks for joining this post. I'm here to assist you in undoing a reconciliation.

 

You can still undo a reconciliation in QuickBooks Online Simple Start, Essentials, Plus, and Advanced. However, to prevent issues, you can unreconcile one transaction at a time.

 

Follow the steps in this article: Undo and remove transactions from reconciliations in QuickBooks Online.

 

We want to ensure accuracy of your data. Any changes on the reconciled transactions can unbalance your accounts. That's why it's best to seek some assistance from an accountant so they can also review your data.

 

I understand that you also want to have the option to undo entire reconciliations. You'll want to send feedback about this to our developers by clicking the Gear icon, then select Feedback.

 

Also, I added this link if you need help in running, customizing, and saving financial reports in QuickBooks Online: Run reports in QuickBooks Online.

 

Leave a comment below if you have other concerns with your accounts. Take care!

Beachlaw
Level 2

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

Thank you for clearly explaining why I am going to have to spend the next couple of hours manually changing each R. This is utterly baffling that QB has decided that I am not knowledgeable enough to undo a reconciliation and instead must hire an accountant to do so.

KathyTownsend
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

It is very baffling since I am able to make this decision on my own in Quickbooks desktop.

lucindalintz
Level 2

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

I have fixed many past reconciled months without undo'ing the recon by clearing the R on the transaction(s) in question then making the correction(s) then putting the R back in the right (now uncleared) transaction. I follow the bank register for correct ending balance at the end of the month (or each month) to check my work. Always check your work when doing something out of the ordinary. By putting the R back in the field it fixes the pointer for Balance Forward - unlike QBDT (Desktop) Love it!  Disclaimer: Not an Intuit employee. This can be a tedious fix and you really do have to know what you are doing or something might be left undone, thus the Accountant recommendation so be careful. Finally, click on the Reconciliation button when you are done to make sure that the balance forward is correctly intact. 

ChristieAnn
QuickBooks Team

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

Thank you for coming back to the QuickBooks Community, lucindalintz. I appreciate you for sharing solutions/details about reconciliation that surely be helpful for other users who encountered an issue with managing bank transactions.

 

For now, I'm adding this article to view different banking errors and how to fix them: What to do if you get a bank error or can't download transactions in QuickBooks Online.

 

Please know I'm always around to help with any QuickBooks issues you may be having. Have a great day!

ddev
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

To be clear on all of this, the functionality for QBO changes over time. The original post was over a year from when I'm writing this. In the past manually clearing or adding the 'R' in the column did not fix the reconciliation problem. QBO detected that you made a change to a reconciliation report and essentially undid it...even if the net result of your edits was $0. It would say you made changes and make a mess....

 

Today, 2022, this behavior is different and yes, you can manually add or update the 'R' and it does what you would expect which is the edits show up on a report as items that were changed so an auditor or accountant can see you did something, but if the net result doesn't change the totals then it lets you proceed with further reconciliations.

It would be helpful if the QB employees that respond include that in their new responses. It makes it look like answers or posts from before were flat out wrong.

 

I still do not think that an individual can undo a reconciliation, I think that still has to go through QBOA. I purchased that temporarily just because I had to do many of these going back years and it was worthless to scream about it when my accounting was a mess. Still mad about that but moved on for now.

dserata
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

We did not buy our QBs thru our accountant.

If our accountant has a QBOA subscription, can I give him our sign in credentials and can he undo for us?

Charies_M
Moderator

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

Welcome to the Community, dserata.

 

If your accountant owns a QBOA subscription, then he/she will add your company under his/her subscription. From there, they'll have access and can make changes in your account with your permission.

 

You might want to check out this article in case you want to know how undoing reconciliation works: Undo a client’s reconciliation in QuickBooks Online Accountant.

 

Once done, please click this article to view detailed steps on how you can reconcile your accounts: Reconcile an account in QuickBooks Online.

 

Let me know if you have additional questions about the process of undoing a reconciliation in QuickBooks Online. I'd be happy to help.

JohnGroot
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

How can I re reconcile by month so that I can check where the discrepancy is. It tells me that I was reconciled at the end of July but does not show the months. I show a $672 discrepancy yet the proram says a $292 deposit was deleted but I don't find in the bank records a $292 error. I bill advertisers and when the check comes in it is deposited and credited against A/R yet these don't show as deposited in the bank reconciliation.

 

The basic trouble may go back to the conversion from QB DTop.

 

I had used a lot of accounts so that when a 2022 convention expense was imported, the program picked it up a 2015 Convention. DTop which I used for 20 years, didn't care how many accounts were on my list, so each year I would add 80 or 90. e.g. 2022 Convention Expense and the sub accounts like busses, Food, Hotel, Activities, etc and the of course 2022 Convention Income with many associated sub accounts like Registration, Sales, Donations various other income items. I made the mistake of converting in the middle of the year. My Dtop was reconciled thru June of 2022. What should I do? I have manually eddit the Jan thru June and converted. 

Carneil_C
QuickBooks Team

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

I've got your back, John. Let's work together to find out where the discrepancy is and sort this issue out so you'll be able to get back to business in no time.

 

Please know that a reconciled transaction in QuickBooks Desktop is marked as R on the reconciliation status column in QuickBooks Online. You'll want to review the transactions from the discrepancy report to verify the transactions. Also, this ensures that the beginning balance matches your bank statement. Here's how:

 

  1. Select the We can help you fix it link to open your discrepancy report.
  2. Review the discrepancy report. Use it to decide if and how to make changes.

 

Once you're ready to make the changes, please verify it with whoever made the changes. Then, review each transaction on the report one at a time. I'll show you how:

 

  1. Select View to see the history of changes to the transaction.
  2. Review the Change Type column. This tells you what changed.
  3. From there, make edits based on the message in the Change Type column.

 

When everything is all set after reviewing the report, the Total Discrepancy Difference should be $0.00. Check again the beginning balance and ensure that it matches your bank statement. Then, you can now start reconciling your account.
 

In case you need further assistance, feel free to consult your accountant for the best process to sort this out. This way, we'll be able to ensure that your books are accurate and avoid messing up the data.

 

You can read through this article for more insights on what to review to fix issues for accounts reconciled in the past: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

For future reference, you can also check out these resources here to help you fix your reconciliations in QBO, as well as monitor your transactions and detect possible errors accordingly:

 

 

Please let me know if you have any more reconciliation concerns in QBO. I'll be right here to help. Thanks for dropping by, and wishing you the best. 

ddeveaux
Level 3

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

For your specific question John nothing has changed. See my response from April 2022. To do this by month as you want to do and as is normal you have to have the QuickBooks Accountant edition. That lets you complete undo 1, or more, monthly reconciliations with 1 push button. I just did this today going back to 2015 but only because I also have the QBOA.

 

The way described by Support is same as earlier in this thread and requires you go 1x1 and unreconcile your transactions BUT as you might guess you still don't know by looking if you are in balance or not so after you do that then you have to go back into a reconciliation to see if matches.

 

Quicken knows it makes sense to do this by month which is why the feature exists but I still find it very maddening that they intentionally do not let regular subscribers use this...and act in the answer like they are answering your question. @JohnGroot 

Rblack829
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

I literally just went to the gear icon > manage users > accountants > then invited myself as an accountant. Then I followed the steps as an accountant and un-did my reconciliations. 

PunkyBluster
Level 2

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

In Accountant mode, can you undo a single month in a prior year and then redo the reconciliation for that month?

Rblack829
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

As far as I know you have to un-reconcile all months prior to the one you are trying to correct. For example you have found an error in September 2023 you must un-reconcile Dec, Nov, Oct, September and fix the error then re-reconcile the months that were un-reconciled. 

Rblack829
Level 1

Is it possible to undo an account reconciliation and redo it? When on the "History by account" page, my action menu on has a "print" dropdown.

As far as I know you must un-reconcile all months prior to the month you need to correct. Then once the error is corrected you will have to re-reconcile the months that were un-reconciled. 

Need to get in touch?

Contact us