Skip to main content
rhondakjos
February 11, 2020
Solved

Deleted reconciled transaction. How to correct?

  • February 11, 2020
  • 42 replies
  • 0 views
Original commenter did not share additional details
Best answer by Michael K

Hey there, @rhondakjos. Happy to help out here.

 

If you've deleted transactions that had the Reconciled status, you will need to re-create them. To find the information from the transactions you deleted, you can check out the Audit Log. It's super easy and only takes a few clicks. Take a look:

 

  1. Go to Gear ⚙, then Audit Log.
  2. Click the Filter drop-down, pick the dates when the transactions were deleted, then choose the Show only these events radio button.
  3. Tick the Transactions checkbox, then select Deleted/Voided Transactions from the Show drop-down.
  4. Hit Apply.
  5. The Audit log will now be filtered to only show deleted transactions based on the filters you applied. Find the transactions that were deleted in the list and click View.
  6. You can use the information displayed here to re-create the transaction. Be sure to change the transactions status in the register back to R for Reconciled.

 

If you aren't sure how to change the transaction's status back to Reconciled from within the register, it's super easy. Check it out:

 

  1. From the account register, locate the transaction you just recreated.
  2. Change the reconciliation status to "R" by clicking on the blank box in the column marked with a check mark. Once your transaction has an R next to it, it's reconciled. 

 

That's it! Please reach out if there's anything else I can do to help, I'm determined to be your number one resource for QuickBooks Online.

42 replies

Michael K
Michael KAnswer
February 11, 2020

Hey there, @rhondakjos. Happy to help out here.

 

If you've deleted transactions that had the Reconciled status, you will need to re-create them. To find the information from the transactions you deleted, you can check out the Audit Log. It's super easy and only takes a few clicks. Take a look:

 

  1. Go to Gear ⚙, then Audit Log.
  2. Click the Filter drop-down, pick the dates when the transactions were deleted, then choose the Show only these events radio button.
  3. Tick the Transactions checkbox, then select Deleted/Voided Transactions from the Show drop-down.
  4. Hit Apply.
  5. The Audit log will now be filtered to only show deleted transactions based on the filters you applied. Find the transactions that were deleted in the list and click View.
  6. You can use the information displayed here to re-create the transaction. Be sure to change the transactions status in the register back to R for Reconciled.

 

If you aren't sure how to change the transaction's status back to Reconciled from within the register, it's super easy. Check it out:

 

  1. From the account register, locate the transaction you just recreated.
  2. Change the reconciliation status to "R" by clicking on the blank box in the column marked with a check mark. Once your transaction has an R next to it, it's reconciled. 

 

That's it! Please reach out if there's anything else I can do to help, I'm determined to be your number one resource for QuickBooks Online.

    Cmharvey
    August 4, 2020

    I’ve re created mine but they are still in the list?

    Cmharvey
    August 4, 2020

    I’ve recreated mine but they are still showing on my list to reconcile.

    JamesDuanT
    August 4, 2020

    Thanks for joining in on the thread, Cmharvey.

     

    Recreating the transaction will bring them back to your register. Hence, they're also showing in your Reconcile page. We'll need to change their reconcile status manually to correct your data. Here's how:

    1. After recreating the transaction, click Accounting on the left menu.
    2. Go to the Chart of Accounts tab and look for the account that affects the recreated transactions
    3. Click View register and look for the recreated transactions.
    4. Under the Reconcile (✓) column, click on the blank field to mark the transactions as reconciled (R).
    5. Click Save and select Yes to confirm the action.

    Once you go back to the Reconcile page, these transactions should no longer display. You can use this link for reference: Undo and remove transactions from reconciliations in QuickBooks Online.

     

    Then, you can already continue reconciling the account.

     

    Let us know how this goes so we can further assist you. Additional screenshots would be much appreciated. Have a great day!

    Dash27
    March 9, 2021

    I have 3 transactions from the December reconciliation that for some reason now are no longer reconciled.  When I did the January reconciliation they showed as uncleared and when I manually make them reconciled, my beginning balance is off.

    Help!  I'd like to undo the jan and dec reconc's but cannot do that in qbo without involving the accountant.

    Firstclassbrenda
    February 24, 2022

    how to correct a DEPOSIT that was accidently deleted after reconciled?

     

    Firstclassbrenda
    February 24, 2022

    FOR DELETED DEPOSITS does not work the same as other transactions.  Please assist.

    Firstclassbrenda
    February 24, 2022

    2/24/22 this is not solved the person on line with me did not know as much and I have learned on my own.  She had me on hold for long time and NO solution.  frustrated.  Can someone who knows how to correct for a DELETED DEPOSIT please leave instructions.  Reminder, this is not the same as other a deleted transaction.

    thank you in advance.

    Rasa-LilaM
    February 24, 2022

     

    Thank you for posting on this thread, Firstclassbrenda.
    I want to ensure your concern about the deleted deposits is taken care of. However, I have to ask for some details about the issue. This way, I can provide the best solution.


    May I know if this is a merchant deposit? Have you tried recreating the transaction? If yes, did you encounter any issues?


    I appreciate any information you can provide. I’m looking forward to working with you again. Have a good one.

     

    Firstclassbrenda
    February 24, 2022

    Thank you for your response.  The deleted deposit was applied to a customer for payment on their account.

    Yes, I have two deleted deposits, recreating the deposit in the customer did not solve the problem.

     

    When clicking on reconciling and I go to Reconciliation Discrepancy Report both deposits are listed, I can view under the history tab, but it will not allow me to make any changes from here like it does if you need to re-create other transactions.  The key here is the type is DEPOSIT.  I sure appreciate your help.  thank you.

     

     

    UniIlo
    August 16, 2022

    The remedy says to go to "View Register" in the Chart of Accounts. This expense account where the "deleted and reconciled" transaction allows only to Run Report or Edit the Account - NOT View Register. My user status is both an Admin and the Accountant. 

      Mich_S
      August 16, 2022

      I know exactly how you can add the deleted transaction back to QuickBooks Online, @UniIlo.

       

      When a reconciled transaction is deleted, you'll have to first review the Audit Trail page, then locate and take note of the transaction detail. Once done, you can proceed in recreating it:

       

      1. Open the Gear icon and hit Audit Log.
      2. Choose the Filter drop-down and select the right user, date, and event(s).
      3. Once done, hit Apply.
      4. Then, find the deleted transaction.
      5. When you locate the deleted item, hit View under the History column.
      6. You'll see all the information needed for the transaction under the Event section.
      7. Use that details to re-enter the transaction with its original date.

       

      After that, manually reconcile the transaction by going to your account register.

       

      1. Select the Gear icon and pick Chart of Accounts.
      2. Search for the account where the transaction is allocated. Then, hit View register.
      3. Choose the transaction to expand the view.
      4. Go to the check column, and continuously hit the box until you see R (reconciled).
      5. Then, hit Save.

       

      Here are helpful modules you can read about handling bank reconciliation in QuickBooks Online:

       

       

      The Community is always available 24/7. Fill me in if you need extra help with banking or QuickBooks in general. Your efforts are much appreciated, stay safe!


       


       


       

      bookkeeper_99
      August 3, 2023

      okay so I deleted a reconciled entry in qbo as it was incorrect. I added in the correct entry from open uncollected deposits. this was done multiple times as the accountant wanted the uncollected deposits cleared up. They are now cleared up; however I cannot reconcile because now my beginning balance is off and it's because of all the deleted reconcile transactions. please help!

      kandyjk
      January 23, 2023

      I have recreated and marked reconciled any transactions I deleted or changed from the previous reconciliation.....but it still won't let me reconcile.  Any other ideas?  I've checked that all entries are correct for the 2022 year I'm working in.  It says my beginning balance is off my a certain amount but all past entries have been reconciled from the previous year.??

      Terms & ConditionsAccessibility statement