cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 3

Issues with recovering a reconciled transaction that has been deleted

We are using QB Desktop 2019 and we hired a QB "expert" to resolve a number of issues we were having in QB.  While she did resolve a number of issues, she created a few.  She was working fast and furiously and for some reason, deleted a number of transactions, all of which had been previously reconciled.  One of the transactions was from 9/19 and the rest were from 12/19. 

 

Following the steps in the Intuit Quickbooks Manual for re-reconciling corrected transactions, we started with the September transaction and using the audit log, we recreated it.  Now we are trying to re-reconcile it by performing the following steps:

1. Select Banking, Reconcile, and selected the correct bank under Begin Reconcile

2. Changed the date in the Statement Date box to 09/30/19

3. Updated the ending balance to reflect the 9/19 ending balance on the statement

4. In the reconcile window, the recreated transaction appears along with all other unreconciled transactions from 01/20. We put a check next to the recreated transaction.

 

Unfortunately, the difference is NOT zero.  In looking at this closer, we see the beginning balance displayed when we Begin Reconcile, is the beginning balance for January 2020, which explains why it was out of balance.

I guess what we're looking for is a way to re-reconcile 9/19 & 12/19 without having to go back and re-reconcile 9/19, 10/19, 11/19, & 12/19.  Any assistance or advice would be greatly appreciated.

 

 

Solved
Best answer February 17, 2020

Best Answers
Highlighted
QuickBooks Team

Issues with recovering a reconciled transaction that has been deleted

Hey there, @reiddg.

 

I see you're having some issues with previously reconciled transactions that have been deleted. Follow the steps below to resolve. 

 

1. Select Reports and then Accountants and Taxes.

2. On the side menu, choose Audit Trail.

3. Click on the "From" box and select the date the transaction was deleted on.

4. Pick "Refresh"

5. From the new list, select the deleted transaction and double-click it.

6. Enter the valid information. 

 

Follow the steps from this article to complete a mini reconcile to get your books looking as they should: Reconcile previously deleted and re-entered checking or credit card transactions.

 

Let me know if this helps by replying to this thread. Have a great week!

 

 

View solution in original post

9 Comments
Highlighted
QuickBooks Team

Issues with recovering a reconciled transaction that has been deleted

Hey there, @reiddg.

 

I see you're having some issues with previously reconciled transactions that have been deleted. Follow the steps below to resolve. 

 

1. Select Reports and then Accountants and Taxes.

2. On the side menu, choose Audit Trail.

3. Click on the "From" box and select the date the transaction was deleted on.

4. Pick "Refresh"

5. From the new list, select the deleted transaction and double-click it.

6. Enter the valid information. 

 

Follow the steps from this article to complete a mini reconcile to get your books looking as they should: Reconcile previously deleted and re-entered checking or credit card transactions.

 

Let me know if this helps by replying to this thread. Have a great week!

 

 

View solution in original post

Highlighted
Level 3

Issues with recovering a reconciled transaction that has been deleted

Thanks for the prompt response!  We'll try this right away and report back.

Highlighted
Level 3

Issues with recovering a reconciled transaction that has been deleted

Your steps and those in the article got us back on track.  Thanks so much!

Highlighted
Level 1

Issues with recovering a reconciled transaction that has been deleted

How do I do this in quickbooks online?  I don't have an option of "reconcile" in my banking tab!  Help!

Highlighted
QuickBooks Team

Issues with recovering a reconciled transaction that has been deleted

Thank you for joining the thread, @shantee21.

 

In QuickBooks Online, we can reconcile an account either from the register or the Reconcile tab. For the deleted transactions, you can visit the Audit Log to see the details and recreate them manually.

 

  1. Go to the Gear icon in the upper-right corner and select Audit Log.
  2. Look for the deleted transaction and click View.
  3. Click the arrow on when it was created and deleted.
  4. Take note of the transaction details.
  5. Recreate the transaction manually by clicking the New (+) icon.

After recreating the transaction, go to the register and change it's status to Reconciled (R) manually. For more information, check out this article: Undo and remove transactions from reconciliations in QuickBooks Online.

 

Let me know if you have any other questions. I'm always here to help. Have a good day!

Highlighted
Level 1

Issues with recovering a reconciled transaction that has been deleted

I tried this and received the message ,sorry another user has deleted this check. quickbooks will remove it.

The user was me.

Highlighted
QuickBooks Team

Issues with recovering a reconciled transaction that has been deleted

Thanks for following this thread, Honeycombs.


I appreciate following the solution shared by my colleagues and sharing its result. We can run the Verify and Rebuild Data Utilities to resolve the error.


Verifying the data will check any damaged transactions or lists in your company file. The rebuild utility resolves any problems detected in your account. Before performing the troubleshooting, make a backup of the data file to keep a copy of your transactions.


Here’s how:

 

  1. Click the File menu at the top to choose Utilities and Rebuild Data.rebuild.png
  2. Press OK to create a backup of the company file.rebuild1.png
  3. Hit Save to keep the copy.
  4. Tap the OK button once the Rebuild is completed.
  5. Then, go back to the File menu to choose Utilities and Verify Data.verify data.png
  6. If it finds a problem, click Rebuild Now.

If the issue persists, perform Solutions 2-3 in the Fix data damage on your QuickBooks Desktop company file guide. You can also resort the lists to keep them in order. Follow the detailed instructions in this article: Re-sort lists.


For additional resources, this link helps resolve entries that are out of balance and damaged item history: Fix damaged transactions.


Feel free to go back to this thread if you have additional questions or concerns about QuickBooks. I’ll jump right back in to answer them for you. Enjoy the rest of the day.

Highlighted
Level 1

Issues with recovering a reconciled transaction that has been deleted

I accidentally deleted a debit out of my register that has already been reconciled. I am using qb desktop. Do I have to undo all my previous reconciliation's to fix this?! Help

Highlighted
Moderator

Issues with recovering a reconciled transaction that has been deleted

Hello again, @Honeycombs.

 

There's no need to undo your previous reconciliation, to fix the issue, you can do a special reconciliation which also called a mini reconciliation. 

 

Before doing so, create a backup copy of your company file. Once done, follow the below steps to do mini reconciliation.

  1. Go to the Banking menu at the top. 
  2. Select Reconcile.
  3. Pick the bank account with the transactions you need to reconcile.
  4. Enter the date for an "off-cycle reconciliation in the Statement Date section. This date can be any date between your last reconciliation and the next scheduled one.
  5. In the Ending Balance field, input the balance of your last successful reconciliation then hit Continue.
  6. Check the transactions you wanted to correct and re-reconciling then make sure the difference field shows $0.00.
  7. Once done, hit Reconcile Now.

For more insights and detailed steps, check out this article: Reconcile previously deleted and re-entered checking or credit card transactions.

 

For additional reference, I've added below articles for more options on how to fix the reconciliation issue in Quickbooks Desktop:

Stay in touch with me if you need anything else. I’m more than happy to help. Have a great day!

Need to get in touch?

Contact us