Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
O
OEC
April 25, 2022
Question

Deleted reconciled transaction

  • April 25, 2022
  • 1 reply
  • 3 views

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. 

1 reply

C
ChristieAnn 11
Level 9
April 25, 2022

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!

O
OECAuthor
April 26, 2022

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. 

Morgan_B
Morgan_BQuickBooks Team
QuickBooks Team
April 26, 2022

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement