Deleted reconciled transaction affecting opening balance. How can I restore?

Hello there, @brendahudsonoo. I'm here to help fix your reconciliation issue to get you back on track.

Deleted transactions that had the Reconciled status could mess up your balances. You'll need to re-create them and reconcile them again to correct them. 

First off, let's find the information from the transactions you've deleted by checking out the Audit Log. Here's how: 

1. Click the Gear icon, then Audit Log.
2. Click the Filter drop-down, then pick the dates when the transactions were deleted. 
3. Choose the Show only these events radio button, then tick the Transactions checkbox and select Deleted/Voided Transactions from the Show drop-down. Hit Apply.

Once done, the Audit log will now be filtered to only show deleted transactions based on the filters you applied. Look for the transactions that were deleted in the list and click View.

Then, use the information displayed to re-create the transaction. Ensure to change the status of the transactions in the register back to R for Reconciled.

Check out Step 3: Review your account register to learn more about this process outlined in this help article: Fix opening balance issues in QuickBooks Online. 

For future reference, here's an article with the link that can guide you in fixing reconciliation: Learn the reconcile workflow in QuickBooks.

Reach out to me again if there's anything else I can do to help. I'd be here to provide you with more options.

Hi there, @brendahudsonoo.

Hope you’re doing great. I wanted to see how everything is going about your reconciliations concern you had yesterday. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!

Is there steps for this in Quickbook Desktop?? I had duplicate checks in October, deleted one, now the opening balance is off by that amount! 

Hello there, Jules1015.

I know a way how to fix the opening balance after deleting reconciled transactions in QuickBooks Desktop (QBDT).

First,  you can visit the Audit Log to see the deleted transactions and recreate them manually. 

Here's how:
 

1. Choose Reports and then Accountants and Taxes.
2. On the side menu, choose Audit Trail.
3. Tap 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. 

Once done, you can check to follow the steps from this article to complete a mini reconciliation to get your books looking as they should:  Reconcile previously deleted and re-entered checking or credit card transactions.

Let me know if you have further concerns with the reconciliation, so I can help you further. Just mention me anytime to notify me of your reply. Have a nice day!

Hi,

I fixed an issue like this by recreating the deleted transaction and manually setting the status to reconcile as instructed by a QBO video.  This corrected my reconciliation error but in the History of account page for my Bank Register, it still showed the discrepancy (in my case -$1,600) under the CHANGES column (see image below).   

My questions are:

1 - Since the Bank Register is reconciled after the correction, how do I remove the $1,600 discrepancy so it doesn't show up on the History of account page?  I expected to see $0.00 under CHANGES after I fixed this issue.

2 - If the History of account was designed to show the discrepancy even after the reconciliation correction for audit purposes, is there another page where I can get a list of all my successfully reconciled periods?  This was a useful page to ensure all my past bank statements were reconciled.

Thank you.

Hello, @EH68.

Thanks for following along with the thread and sharing your concerns. 

There are many possibilities as to why the discrepancy is showing, even after you manually reconciled the transaction. One could be that you need an adjusting entry, or need some basic browser troubleshooting. To determine your next steps, I recommend contacting our Technical Support Team. This way, one of our agents can review your account in a secure environment and investigate this matter further. I've included a link below to connect with our team directly. 

• QuickBooks Online Support

In the case that you need to enter an adjusting entry, you'll want to be sure to connect with your accounting professional. If you don't have an accountant, don't sweat it. You can find one here in our Resource Center. 

In the meantime, feel free to explore some of our guides I've included below that cover more details about reconcile discrepancies. 

• How to reconcile in QuickBooks Online
• Fix issues when you're reconciling accounts in QuickBooks Online
• Fix beginning balance issues during your first reconciliation
• Fix beginning balance issues if you've reconciled the account in the past

Please let me know if you have any other questions or concerns. Take care! 

Thank you Tori for responding.

After contacting Customer Support, I was instructed to log into the Accountant account to undo the reconciliations up to the problematic transaction.  This wasn't too much of an issue because it only goes back to two reconciliations.  However, this may be a problem in the future should someone need to correct reconciliations from months ago.

I hope there will be a better option in the future.

Thank you,