cancel
Showing results for 
Search instead for 
Did you mean: 
OEC
Level 2

Deleted reconciled transaction

Hi,

 

Back in Sept. 2018, I entered a bill for $1530.00 and paid it from my bank account.  The check was never cashed.  The invoice and payment were deleted just last month.  I cannot reconcile the bank account because it says that my beginning balance is off by $1530.00.  I cannot reinstate this transaction because it will throw off my bank balance.  How can I fix this?  Do I have to do a journal entry?  Which one?  Thank you. 

5 Comments 5
ChristieAnn
QuickBooks Team

Deleted reconciled transaction

Hi there, OEC.

 

I appreciate you for coming back to the QuickBooks Community. Let me share some details on why the beginning balance is off. Then, ensure you'll be able to fix this so you can reconcile the account accurately.

 

 When Beginning Balance is incorrect or off, this may be due to one of the following reasons.

 

  • Someone entered an incorrect opening balance when they created the account in QuickBooks.
  • Someone added transactions that are older than the opening balance, but didn't edit the original opening balance entry to reflect the change.
  • Someone edited, deleted, moved, or unreconciled an already reconciled transaction. This changes the ending balance of your last reconciliation, which impacts the beginning balance of the next one.
  • Someone manually reconciled a transaction, so it didn't show up on the next reconciliation.

 

 

Since you've mentioned that some entries were deleted, you'll have to recreate the check and make a deposit. Then, post it to the same expense account, and creating a journal entry isn't necessary.

 

Once done, you can now start reconciling your account. Then, if you encounter another discrepancies issue, you can open this article to see the steps on how to fix them: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Lastly, you may refer to this article to view details on how you can view a reconciliation report, print, or export this one: How do I view, print, or export a reconciliation report.

 

Fill me in if you need more help with reconciliation by leaving a comment below. I'll be around in the Community to help. Take care and have a great day!

OEC
Level 2

Deleted reconciled transaction

Thank you for your answer.  I did recreate the check and then made a deposit for the same amount.  However, it's still showing me my beginning balance if off by that amount.  Is there a specific date I need to put on the check and deposit?  Should it be both entries on the same day?  If I put the check on it's original date in 2018, then my balance is off for 3 years....  The check was deleted in March 2022... help. 

MorganB
Content Leader

Deleted reconciled transaction

Thanks for following up with those additional details, OEC.

 

I have a few more articles to add to those mentioned above that I believe you'll find helpful. You can check them out here:

 

 

These help articles offer great info, however I think it would be in your best interest to consult with an accountant about the specific steps to take next. They'll be able to give you the best guidance based on your unique business setup. If you don't currently have an accountant, you can find one in your area with a quick search on the ProAdvisor site

 

Please don't hesitate to reach back out here if you have any other questions. I'll be here to help in any way that I can.

kerribish70
Level 1

Deleted reconciled transaction

OEC...I just did the same thing. Somehow deleted a check from 2014. How did you correct your issue? 

I have tried to recreate the check as they said and it is NOT working.

UGH

kerribish70
Level 1

Deleted reconciled transaction

Hi OEC...

I did the same thing! Do you mind sharing how you corrected the beginning balance? I tried recreating the check that was deleted as well but its not working for me either. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us