cancel
Showing results for 
Search instead for 
Did you mean: 
catherine-conner
Level 1

How do you undo a bank reconciliation?

 
Solved
Best answer March 06, 2022

Best Answers
LieraMarie_A
QuickBooks Team

How do you undo a bank reconciliation?

I have all the steps to undo your reconciliation, @catherine-conner.

 

You can only un-reconcile one transaction at a time. If you need to start over, I'd suggest reaching out to your accountant. They can undo the entire period at once using QuickBooks Online Accountant.

 

Here's how to invite your accountant:

  1. Click the Gear icon in the upper-right corner, and select Manage Users.
  2. Go to the Accounting firms tab, and click the Invite button.
  3. Enter the accountant's information.
  4. Click Save.
  5. 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 Accounting menu. Then select Chart of Accounts.
  2. Find the account and select View register
  3. To help you focus on this task, filter the register to only include the last 60 days of transactions.
  4. Review the check column. If the transaction is reconciled, you’ll see an “R.”
  5. Select the box and keep clicking it until it's blank. It removes the transaction from the reconciliation.
    LisaNullar_0-1711126370698.jpeg

     

  6. Select Save. Then close your register.

 

I've added here an article that will help you in case you encounter reconciliation issues: Fix issues when you're reconciling accounts.
 

If you want hands-on help, you can get a QuickBooks-certified bookkeeper to show you how to do reconciliations and other tasks: Check out QuickBooks Live.

 

Please come back if you need any further assistance with this process. 

View solution in original post

33 Comments 33
LieraMarie_A
QuickBooks Team

How do you undo a bank reconciliation?

I have all the steps to undo your reconciliation, @catherine-conner.

 

You can only un-reconcile one transaction at a time. If you need to start over, I'd suggest reaching out to your accountant. They can undo the entire period at once using QuickBooks Online Accountant.

 

Here's how to invite your accountant:

  1. Click the Gear icon in the upper-right corner, and select Manage Users.
  2. Go to the Accounting firms tab, and click the Invite button.
  3. Enter the accountant's information.
  4. Click Save.
  5. 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 Accounting menu. Then select Chart of Accounts.
  2. Find the account and select View register
  3. To help you focus on this task, filter the register to only include the last 60 days of transactions.
  4. Review the check column. If the transaction is reconciled, you’ll see an “R.”
  5. Select the box and keep clicking it until it's blank. It removes the transaction from the reconciliation.
    LisaNullar_0-1711126370698.jpeg

     

  6. Select Save. Then close your register.

 

I've added here an article that will help you in case you encounter reconciliation issues: Fix issues when you're reconciling accounts.
 

If you want hands-on help, you can get a QuickBooks-certified bookkeeper to show you how to do reconciliations and other tasks: Check out QuickBooks Live.

 

Please come back if you need any further assistance with this process. 

AandARealEstate
Level 2

How do you undo a bank reconciliation?

This is not helpful if you are an accountant directly employed with the organization.

ExpertKellum
Level 1

How do you undo a bank reconciliation?

@LieraMarie_A 

 

I used this to help a customer, I wanted to know if she went to reconcile the 2 months she unreconciled will that make a mess of things?  Or as long as she's sure to have the actual bank statements with the correct opening balance she can reconcile again with no problems?

katherinejoyceO
QuickBooks Team

How do you undo a bank reconciliation?

Thanks for following this thread, @ExpertKellum. That's correct. You can reconcile previously unreconciled transactions for as long as you have a correct opening balance. 

 

And it's always advisable to have an actual bank statement for accuracy. You also want to do a "special reconciliation" for this process. This method uses an "off-cycle" reconciliation date to correct it.

 

Here's how: 

 

  1. Go to the Banking menu and select Reconcile.
  2. Select the bank account with the transactions you need to reconcile, then enter date for an "off-cycle reconciliation." It can be any date between your last reconciliation and the next scheduled one. Note: When you enter an "off-cycle" date, QuickBooks will remind you that you're doing a mini reconciliation. This puts previously unreconciled transactions back without affecting the "cycle" that they follow.
  3. In the Ending Balance field, enter the balance of your last successful reconciliation. Then, select Continue.
  4. In the Reconcile window, check off the transactions you are fixing and re-reconciling.
  5. Make sure the Difference field shows $0.00, then select Reconcile Now.

 

Visit this article to learn more ways to reconcile previously deleted and re-entered checking or credit card transactions in QuickBooks.

 

Come and visit us if you have any further questions. I'll be glad to assist you again soon.

fionahutchinson
Level 2

How do you undo a bank reconciliation?

I invited my accountant and she was not able to undo the reconciliations

Mark_R
Moderator

How do you undo a bank reconciliation?

Hello there, @fionahutchinson.

 

Let me clarify things about undoing reconciliation with the help of your accountant.

 

Just to confirm, is your accountant using the QuickBooks Online (QBO) Accountant version? If so, they should have a special reconciliation tool that allows them to undo the entire reconciliation. You can share these steps with your accountant to undo the reconciliation:

 

  1. Let your accountant sign in to their QBO Accountant account.
  2. Open the client's QuickBooks Online company.
  3. Go to the Accounting menu, then select Reconcile.
  4. Select History by account.
  5. Choose the account you want to reconcile and the date range from the drop-down.
  6. Find the reconciliation on the list.
  7. Open the Reconciliation Report by clicking the View report.
  8. Review any discrepancies and changes your client wants to make.
  9. Once you’re ready, select the Undo from the drop-down under the Action column.
  10. Click Yes, then Undo to confirm.

 

I'm adding this article for more guidance: Undo a client’s reconciliation in QuickBooks Online Accountant.

 

However, if they don't have a QBO Accountant account, your accountant can undo the reconciliation manually. You can follow the steps shared by my colleague LieraMarie_A above.

 

Just in case you encounter issues reconciling accounts in the future, this article will help you fix it: Fix issues at the end of a reconciliation in QuickBooks Online.

 

Please let me know how things go, @fionahutchinson. I'll be around to provide further assistance. 

fionahutchinson
Level 2

How do you undo a bank reconciliation?

Hi Mark_R,

 

I am the accountant and the only user of ,my account. I seem to have been issued the third world version of QBO for Barbados and I don't have an accountant view. This is a huge fail for QBO that I can't undo a reconciliation and even if I manually undo all the reconciled items, the record of a reconciliation with the incorrect date is still evident

Rose-A
Moderator

How do you undo a bank reconciliation?

Good day, fionahutchinson.

 

To ensure you're able to use the UNDO reconciliation option in QuickBooks Online Accountant, we might need to look over the account if we're using the Accountant version.

 

The first thing to notice if we're using an accountant version is the Accountant word on our dashboard instead of QuickBooks. Then, the Accountant Tools option, Your Practice section. See the sample screenshots below:
 

 

 

If you're using the Accountant version and don't have the Accountant view or the UNDO option, I'd suggest getting in touch with our QuickBooks Online Support to have your account checked.

 

Here's how to contact us:

 

1. Click the Help (?) icon.

2. Choose Contact Us.

3. Enter a brief description of your situation in the What can we help you with? area, then click Let's talk.

4. You'll be presented with a few options for connecting with Intuit. Select Get a call.

 

For our reference, we can bookmark this link: Learn the reconcile workflow in QuickBooks. This will provide us with links on how to handle reconciliation starting from checking its opening balance, to fixing, and editing completed reconciled transactions.

 

If there's anything else I can help you with, aside from reconciliation, please let me know by leaving a comment below. I'd be more than willing to lend you a hand, fionahutchinson.

Christi9844
Level 2

How do you undo a bank reconciliation?

Why can I undo a reconciled month without my accountant?  I pay for the subscriptions!  

Christi9844
Level 2

How do you undo a bank reconciliation?

Why can’t I undo a reconciled month without my accountant?  I pay for the subscriptions!  

fionahutchinson
Level 2

How do you undo a bank reconciliation?

I am a single user of this particular company as I am the accountant. My version does not allow me to invite an accountant. I am trying to undo multiple bank reconciliations so it is not practical to do so manually.

 

Still waiting for a solution!

LieraMarie_A
QuickBooks Team

How do you undo a bank reconciliation?

Hi there, @Fiona.

 

Thanks for following up on this thread. Allow me to chime in and share a workaround on how to save time unreconciling transactions.

 

Which QuickBooks Online (QBO) version do you have? You can invite up to two accountants in QBO Simple Start, Essentials, and Plus, and up to three in Advanced. Only accountant users have the privilege to undo multiple reconciliations using their QuickBooks Online Accountant (QBOA). If you're the only one who manages the books, don't worry. You can sign up for QBOA for free. All you have to do is to send an invite to your email address.

 

Follow these steps to invite yourself or your accountant:

 

  1. Sign in to QBO as a primary admin.
  2. Go to the Gear icon and then Manage users.
  3. Under the Accounting firms tab, select Invite.
  4. Enter your accountant's info or yours.
  5. Hit Save.

 

After that, open the invite email and select the Accept Invitation link. Follow the steps to create an account or connect. Once done, here are the instructions to undo the previous reconciliations:

 

  1. Sign in to QBOA.
  2. Find and open your QBO company.
  3. Go to the Accounting menu and then the Reconcile tab.
  4. Click the History by account link.
  5. Select the account and date range from the dropdowns.
  6. Find the reconciliation on the list.
  7. Select View report to open the Reconciliation Report.
  8. When you’re ready, select the dropdown under the Action column, and then Undo.
  9. Hit Yes and then Undo to confirm.

 

Finally, if there are any discrepancies, check out this article to help you resolve them: Fix Issues When You're Reconciling Accounts.

 

Please let me know how these steps turn out or if you need any more help with this process. The Community is always here. It's us to ensure your success! Have a wonderful day!

fionahutchinson
Level 2

How do you undo a bank reconciliation?

As I have explained to multiple people, I have the third world version of QBO in Barbados. I can't link bank accounts and I am not able to undo bank recs as the accountant.

 

Still looking for a resolution!

DebSheenD
QuickBooks Team

How do you undo a bank reconciliation?

Hello there, fionahutchinson.

 

Thanks for getting back to us and for following the steps provided by my colleague. I'm here to provide the support you need in being unable to undo bank reconciliation in QuickBooks Online (QBO).

Currently, the Undo option is only available in the QuickBooks Online Account (QBOA). If you're using this version, we can follow these steps.

  1. Go to the Accounting menu.
  2. Hit the Reconcile tab.
  3. Tap History by account.
  4. Choose View report to open the Reconciliation Report.
  5. Review any discrepancies and changes your client wants to make.
  6.  Click the dropdown ▼ in the Action column, and then select Undo.
  7. Tap Yes and then Undo to confirm.


If you have the regular version you can undo the reconciliation by changing the transactions one at a time.

Here's how:

  1. Go to Accounting and tap the Chart of Accounts tab.
  2. Choose the account from the list and hit View Register from the Action column. 
  3. Find the transaction that needs to be unreconciled one at a time.
  4. Tap on on the Check icon column, between Deposit and Balance. Clicking this field will allow you to change the status of the transaction. 
  5. Hit Save
  6. Tick Yes to confirm that you want to unreconcile the transaction.

You can check this article for more details: Undo or remove transactions from reconciliations in QBO.

Feel free to check out to bookmark these articles just in case you might need them while reconciling your accounts: 

 

 

Please know that you can always count on us if you need anything else in bank reconciliation. We'll make sure everything is sorted out. 

Svitlana_M2022
Level 1

How do you undo a bank reconciliation?

I canceled all postings a few months ago and want to reconcile everything.  but the program does not allow me to enter a balance on a bank statement of that period.  Nothing has changed since the bank reconciliation was cancelled.  what should I do?

JamesAndrewM
QuickBooks Team

How do you undo a bank reconciliation?

Hey there, @Svitlana_M2022. I see it's your first time posting here in the forum. A warm welcome, and know that we're always here to listen and find the best solution for you.

 

Could you tell me what error you encounter when you say the program does not allow you to enter a balance on a bank statement for that period?

 

However, you may want to create a journal entry to enter a balance on a bank statement for that period. Here's how:

 

  1. Go to + New.
  2. Select Journal entry.
  3. On the first line, select an account from the Account field. Depending on whether you need to debit or credit the account. Enter the amount in the correct column.
  4. On the following line, select the other account you're moving money to or from. Depending on if you entered a debit or credit on the first line, enter the same amount in the opposite column.
  5. Check the amounts - you should have the same amount in the Credit column on one line and the Debit column on the other. It means the accounts are in balance.
  6. Enter information in the memo section to know why you made the journal entry.
  7. Select Save and new or Save and close.

Refer to this article for detailed information: Create journal entries in QuickBooks Online.

 

Also, I recommend consulting with your accountant to ensure your records are in tip-top shape, especially with matters like closing the book.

 

You can visit this link to learn how to run different types of reports in QuickBooks Online: Run Reports In QuickBooks Online.

 

Feel free to reach us back if you need further help. We're available 24/7 to lend a hand in resolving each of your concerns. Have a good one!

jjinu04
Level 1

How do you undo a bank reconciliation?

Hi,

 

I cannot find the "Undo" button after clicking "view report". 

I incorrectly did the reconciliation and I need to Undo What I did for the month end reconciliation. 

 

Can you please help? Thanks. 

DHeraV
Moderator

How do you undo a bank reconciliation?

Hello there, @jjinu04.

I recognize the urgency of resolving this to have your reconciled account corrected. Before anything else, are you using the QuickBooks Online (QBO) regular version? If so, this explains why you weren't able to find the Undo button when reconciling since the option is only available in QuickBooks Online Accountant (QBOA). 

To undo reconciliation using the regular version of QBO, you have to do it manually. Here's how:
 

  1. In your QBO account, go to the Accounting tab, then select Chart of accounts (Take me there).
  2. Find the account that has the reconciled transaction. Then select View register.
  3. Locate the transaction. If the transaction is reconciled, you'll see an "R" in the checkmark column.
  4. Select the transaction to expand the view.
  5. In the checkmark column, select the box with the “R” until the box is blank. This removes the transaction from the reconciliation.
  6. Click on Save.
  7. Close the account register.

 

For detailed information, kindly visit: Undo or remove transactions from reconciliations in QuickBooks Online.


On the other hand, if you're using the QBOA version and can't find the Undo button, it could be a browser issue. QuickBooks can occasionally stop working properly since locally stored internet cache files can cause the product to behave unexpectedly due to overloaded site data. I recommend opening a different browser or a private window to isolate possible issues. This can help us remove any cache-related matters that may have contributed to the problem.

Here's how to activate incognito mode in some of the most common online browsers:
 

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

 

If you can finally find the Undo button, it's safe to say that the browser has caused it. This can be sorted out by clearing your cache and cookies.

Moreover, I'll also share this link where you can search for articles that can serve as your reference to guide you in reconciling and managing your bank feeds in QuickBooks: Banking Help Articles in QuickBooks Online.

 

I'm looking forward to having this resolved. Feel free to leave a reply if you have additional QuickBooks-related queries. The Community team always has your back. Have a good one.

MConnerR1
Level 1

How do you undo a bank reconciliation?

It's upsetting that we are all paying so much for this program but something as simple as undoing an account reconciliation (people error!) isn't possible without a 3rd party (an accountant)... the desktop version we used for years prior to this recent migration is/was SO superior to this online mess.  It's one thing after another, one time consuming road block after another, with this "upgrade."  Very frustrating.

pplbob
Level 1

How do you undo a bank reconciliation?

If you dont have an accountant (firm) that can undo your recon, all you have to do is invite yourself as a firm using a different email than the one you are using to log into QBO.  When you get the accountant invite, it will allow you to set up an accountants account, then you can access your company thru the dashboard and undo the recon as described above.

 

Don't confuse the accountant view with accessing the company in a QBO Accountant's account - they are not the same thing.

Bridget Salas
Level 1

How do you undo a bank reconciliation?

This is the first reconciliation since migrating to QB Online and my beginnig balance for my reconciliation is not correct. Since there are no previous reconciliations in QBOnline we cannot undo the reconciliation through Accountant.

Am I able to undo the reconciliation in the register by unclicking the R (reconciled transaction) for the entire month and then redo the reconciliation?

Kevin_C
QuickBooks Team

How do you undo a bank reconciliation?

Joining this thread to share some information about fixing your reconciliation after migrating to QuickBooks Online (QBO), Bridget.

 

Yes, you're correct that you can manually undo the reconciliation by going to the account register since it's your first time reconciling them. 

 

You can simply select the box with the “R” and keep clicking it until the box is blank. Refer to this article for more details about this process: Undo or remove transactions from reconciliations in QuickBooks Online.

image.png

 

Additionally, you can check out these references as your guide to view various guidelines that will guide you in reconciling your online transactions:

 

 

Let me know if you have additional concerns with reconciling your account. I'm always here to assist you. Have a great day!

millermoose1126
Level 1

How do you undo a bank reconciliation?

I mistakenly hit finish without realizing that my date was off for reconciling. It said 7/31 instead of 6/30. I tried to undo it, but it wouldn't let me. I went and changed the R to blank on all of the individual transactions but now my beginning balance is off. That has to be an easier way...ugh!

JaeAnnC
QuickBooks Team

How do you undo a bank reconciliation?

I can provide an easier way how to undo an entire reconciliation, @millermoose1126.

 

With access to your company, your accountant can analyze your books, make necessary adjustments, and collaborate on any concerns. They also have the ability to undo entire reconciliations, write off invoices, and reclassify transactions.

 

That said, it's best to invite your accountant so you can skip the hassle of unreconciling each transaction manually. Here's how:

 

  1. As a primary admin, go to the Gear icon and select Manage Users.
  2. Click the Accountants tab.
  3. Select Invite.
  4. Fill out their contact information and click Save.
    image (3).png

 

Once done, they are able to undo the reconciliation all at once and get a fresh start. 

 

If you don't have an accountant, you may also undo the reconciliation of each transaction manually, just like what you're doing. However, unreconciling an already reconciled entry changes the ending balance of your previous reconciliation, which affects the beginning balance of the following one. Don't worry. I'm sharing an article containing the actions to resolve this issue: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

At the end of a reconciliation, a minor sum may be left behind. This is referred to as a discrepancy. QBO allows you to create an adjusting entry to force your accounts to balance and finish your reconciliation. 

 

Should you have additional questions concerning reconciliation, please don't hesitate to get back to us. The Community is here anytime to assist you. Take care and have a good one!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us