Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
April 2, 2021

Reconciliation

  • April 2, 2021
  • 1 reply
  • 1 view

How do I remove a past reconciliation that was done incorrectly? 

    1 reply

    Jen_D
    Level 8
    April 2, 2021

    Thanks for posting here about your reconciliation, @Waldo69,

     

    There are 2 ways to get a reconciliation undone in QuickBooks Online. First, you can request for an accountant use to undo it or use the second option to manually unreconcile an entry.

     

    For the first option, see this link for the steps: Undo a client’s reconciliation in QuickBooks Online Accountant

     

    If you opt for the latter option, follow the steps below:

     

    1. Click the Gear icon, then tap Chart of Accounts.
    2. Find the account you want to review.
    3. From the Action column, click View register.
    4. Locate the entry from the list that shows a code R (Reconciled).
    5. Click the field to remove the reconciled status. Leave the status Blank to uncleare it and be tagged as unreconciled.
    6. Once done press Save. To give you an idea on how it looks like in QBO, see this screenshot:

       

     

    You can also find these steps from this article: How to unreconcile a transaction or undo a reconciliation.

     

    If you have any additional questions about a reconciliation in QBO, let me know in the comment below. Have a wonderful day!

    Waldo69Author
    April 2, 2021

    Thanks for the quick reply @Jen_D . Following the instructions, I found close to 1k entries with the "R" designation. I really messed something up, is there any way to make a bulk change or must it be one transaction at a time? 

    Moderator
    April 2, 2021

    Not to worry! I’m here to handle it for you, @Waldo69.


    As mentioned by my colleague above, there are two ways to unreconciled transactions in QuickBooks Online. Either edit them individually or have your accountant undo the entire reconciliation by using the QuickBooks Online Accountant version.


    If you choose option two, changing them by bulk isn’t possible at the moment. While there isn’t a way to do it, you may consider contacting an accountant. QuickBooks Online Accountant has a special tool that can undo reconciliation. Sometimes it's best to start over from scratch to make sure everything is accurate. In case you don't have one, you can follow the steps below to find an accountant.


    Here's how:

     

    1. Visit the ProAdvisor site.
    2. Enter your city or ZIP code in the Location field. It will display a list of accountants or bookkeepers near you.
    3. You can also filter the service provided, industry served, and product supported to narrow down the results.


    Check out this reference for complete instructions to undo the reconciliation. This also provides steps to redo the reconciliation process so records match your actual bank.


    Don’t hesitate to post a comment below if you need further assistance with your reconciliation. We’re always here, ready to help you out. Take care!