Showing results for 
Search instead for 
Did you mean: 
Level 1

Reconciliation Beginning Balance Error

Reconcile of bank account for February 2020 was perfect.  Went to reconcile March 2020 and noticed beginning balance was high by $700.   When I run the reconciliation detail report for the previous period it shows a reconciled transaction included in the  cleared transactions in the amount of $700 and dated 4/2/2020 which certainly did not exist at the time the account was reconciled.   The transaction was created by a Sales Receipt.  This transaction was created by creating a copy of the customer's sales receipt posted in February.  The old sales receipt was displayed and "Create a Copy " used to make the new sales receipt and the date of 4/2/2020 was used and the amount modified from the original $1000 to the new $700.  Somehow,  QB added this new transaction to one that it thinks was reconciled in the previous period.  Would like explanation of  this happened and looking for easy fix.

1 Comment 1
Tori B
QuickBooks Team

Reconciliation Beginning Balance Error

Hey there, @cjcntreasurer


I hope you're enjoying your Friday so far. 


I'm happy to explain what's going on with your reconcile. Anytime that you modify a transaction that's been reconciled will exclude it from the prior reconcile. Modifying meaning, changing the date, adding a period to a memo, changing the dollar amount, or making a copy. 


To resolve this, you can unreconcile the previous reconcile and include the sales receipt in it. Or you could perform a mini reconcile, which is a reconcile that's dated only to the time frame of the transaction (sales receipt). Below I've included a couple of articles that cover how to do both. 


I recommend connecting with your accountant/bookkeeper before making any changes in the file to ensure this is the best course of action for you and your business. 


Please don't hesitate to let me know if you have further questions or concerns. I'll be here every step of the way. You can always reach out to the Community anytime you find you need a helping hand. Take care! 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up