Skip to content

Few Clicks To Undo Bank Reconciliation In QuickBooks Online!

Undo Bank Reconciliation in QuickBooks Online

Before you Undo Bank Reconciliation in QuickBooks Online, you should know what Reconciliation is. Basically, it compares your bank statement to the information in QuickBooks for a given time period. It is quite difficult to reconcile transactions manually, so QuickBooks allows users to reconcile accounts with a few clicks, which saves a lot of time and effort. And many times, users enter inaccurate details, or the balance sheet does not match the bank account statement, which creates a need to undo bank reconciliation in QBO.

This blog presents you with a complete guide to Undo Bank Reconciliation in QuickBooks Online. However, first, understand the reasons for undoing a reconciliation in QuickBooks Online.

Reasons you need to Undo Bank Reconciliation In QuickBooks Online

Reconciliation helps you get assured that your recorded bank balance and business match. It also allows you not to miss any updates that happened at the bank and even highlights any duplicated records that you might have entered. The reconciliation also helps you to keep track of your cash flow.

However, there are certain reasons that sometimes need you to undo Bank Reconciliation In QuickBooks Online. These reasons are as follows:

  • Uncleared transactions

QuickBooks Online automatically checks the transactions that you have entered using the bank feed features on the reconciliation screen. So, you can directly reconcile transactions that are not cleared in the bank yet and are causing the problem.

  • Data entry errors

If there are two transactions on the book for the same amount, you can check the wrong one during the reconciliations. It will make the transaction appear a second time in the upcoming months. 

There are also the chances that you might have entered a vendor’s name or category and even the wrong date. All of these can be detected after the reconciliation. However, you can make changes to some of this information without redoing the entire reconciliation (except the date).

  • Categorization errors

Sometimes, when you may enter a transaction in QB as a transfer, QB may post it to an uncategorized asset account. This may also create an incorrect data entry. And after this, you might not be able to recategorize transfers that were meant to be booked as expenses. In such cases, you need to undo bank reconciliation In QuickBooks Online, delete the transfer, and then re-enter the information in the appropriate account.

Read This Before You Undo Previous Bank Reconciliation In QuickBooks Online

Before you begin to undo bank reconciliation in QuickBooks online, you must know these points:

  • Create a backup of your company data before un-reconciling the account in QuickBooks Online.
  • Don’t change the reconciliation status of the transactions manually.
  • Try not to delete the adjustment entry if in case it is created.
  • Look for the discrepancies in the account before you proceed to Unreconcile a Transaction in QuickBooks Online. Moreover, if you try to fix the discrepancies manually, it can help you avoid un-reconciling the account in QuickBooks. 

Steps to Undo A Bank Reconciliation In QuickBooks Online 2023

You can only undo a bank reconciliation in QuickBooks Online Accountant only. As this feature is available only there, and if you’re using the regular version, you’ll have to manually un-reconcile each transaction. That said, only an accountant user can revert any reconciliations made on the account. Now, since you have admin access, you can undo the reconciled transactions but one at a time by following the below-given instructions:

  • First, tap on the Gear icon, and then choose the Chart of Accounts option.
Chart of Accounts Option
Chart of Accounts Option
  • Now, you have to select an account from the list, then click on View register.
View register
View register
  • Further, search for the transaction that needs to be unreconciled, one at a time.
  • In the reconcile status column, you need to select the top line of the transaction and change the status repeatedly.
    1. C – Cleared
    2. R – Reconciled
    3. Blank – Not cleared or reconciled 
Change The Reconcilation Status
Change The Reconcilation Status
  • Then, click on Save.
  • Lastly, click on Yes and confirm that you want to un-reconcile the transaction.

Steps To Undo Bank Reconciliation In QuickBooks Online Accountant 

Users of QuickBooks Online Accountant have access to a unique reconciliation tool. If a client needs to make changes to several transactions in a previous reconciliation, it’s probably best to undo the reconciliation and start over. You should download any attachment that is tied to the reconciliation. When you reverse the reconciliation, all the existing attachments are deleted automatically. Apply the instructions provided below to make changes to the reconciled account of your client:

  • In QuickBooks Online Accountant, you have to select the client from the drop-down list on the Toolbelt and open the client’s company file.
  • Select the Gear icon on the Toolbar.
  • Under Tools, select Reconcile.
  • Then on the Reconcile an account page, you have to select the History by account option.
Reconcile An Account
Reconcile An Account
  • Now on the History by account page, choose the Account and Report period to locate the reconciliation you need to undo.
  • Next, from the Action column drop-down list, tap on Undo.
  • When prompted to confirm, select Yes.
  • In the final confirmation window, select Undo.
History By Account
History By Account
  • Lastly, click OK.

Avail Experts Help!

We hope the above-mentioned steps would have helped you undo bank reconciliation in QuickBooks Online. However, if you get stuck while canceling a transaction and need expert assistance, then we would suggest you to get in touch with our support team. To reach us, place a call on QuickBooks Data Service Solutions Helpline Number +1-(855)-955-1942.

1. How do I undo bank reconciliation in Quickbooks Online for an entire month?

You can unreconcile the entire month, but only if you are an Accountant user. You can do it by going to the Accounting tab, followed by the Chart of Accounts, then by hitting the  Reconcile option. Then you just need to click on the arrow present next to the View Report option and click Undo. You will get about three confirmation messages to be sure about your action; then, it will undo the reconciliation for the entire month.

2. Can all the Quickbooks users undo a bank reconciliation in QuickBooks Online?

Yes, all QuickBooks users can undo bank reconciliation in QuickBooks Online. However, an Accountant user can do the entire reconciliation, and the rest have to undo it for individual transactions.

Leave a Reply

Your email address will not be published. Required fields are marked *

nv-author-image

Lily Evans

Lily Evans is a Certified Accountant with Expertise in QuickBooks, Sage and Quicken Accounting Software. Lily has been working with Data Service Solutions for the last 3 years as a QuickBooks Expert and is Helping Accounting software users with their day to day accounting tasks and issues.

© Dataservicesolutions - All Rights Reserved

Disclaimer

"Data Service Solutions" is a Accounting and Bookkeeping service provider. We are distinguished by the virtue of our expertise in various products developed by a wide range of third-party companies. The use of any third-party trademarks, logos, or brand names on our website or other platforms is for informational purpose only. It does not imply any endorsement by Data Service Solutions or vice-versa or that the trademark owner has authorized or collaborated with Data Service Solutions to promote their products and services.

Data Service Solutions does not have any affiliation from any third-party companies, unless any such relationship is explicitly specified. We have no link or affiliation with any of the brand or third-party company as we independently offer support service for all the product errors you face while using different accounting software.

For detailed information on permitted use and specific warranties associated with the software or its peripherals, please contact the concerned third-party directly. Any content accessed, downloaded, or otherwise obtained from or through the use of the website should be at your own discretion.

Intuit and QuickBooks are trademarks and service marks of Intuit Inc., registered in the United States and other countries. It’s Completely Your Choice to Purchase Your Product Directly from Intuit® And Contact Intuit® Directly for Support. Intuit®, The Intuit® Logo, QuickBooks®, TurboTax®, Quicken® Are Registered Trademarks of Intuit Inc. Data Service Solutions Is an Independent from Intuit Inc. Intuit®, QuickBooks®, TurboTax®, Quicken® Among Others, Are the Registered Logos, Trademarks and Brand Names of Intuit Inc. And Are Used Here Solely for The Purpose of Reference.