Skip to main content
nev-rosemail-ca
August 19, 2023
Question

How to undo past bank reconciliation in qb online

  • August 19, 2023
  • 39 replies
  • 0 views
Original commenter did not share additional details

    39 replies

    MirriamM
    August 19, 2023

    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!

    nev-alpina-net
    August 20, 2023

    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.
    DebSheenD
    August 20, 2023

    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:
     

     

    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. 

    hmacattack
    January 18, 2024

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

      Maybelle_S
      January 18, 2024

      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.

      RandyNesbit
      October 4, 2024

      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?

      JanbonN
      October 4, 2024

      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.

      Terms & ConditionsAccessibility statement