Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NP-L
Level 1

Why does my statement ending balance & cleared balance match, but I still have a big difference showing up?

My QB's on line register and bank statement's ending balances match perfectly, but QB's says there is a big difference.  It is line this on all of my bank and credit card accounts except one.   EX:  bank register in QB's and statement 12/31/2019 both are 20,965.39.  When I go to do the 1/31/2020 reconciliation QB's says the opening balance is off 3,000.00 it starts at 17,965.39.  How can I fix this without affecting the actual balance in QB's as it is correct.

2 Comments 2
Pete_Mc
Community Champion

Why does my statement ending balance & cleared balance match, but I still have a big difference showing up?

Did this just start happening?  It sounds like you may have deleted/added/changed one or more entries after they had been reconciled.  So QBs is showing the $3K difference. 

 

If you think/know this is what happened and you know which transaction(s) was changed, then there may be a quick fix.  An example would be if you deleted an item in September that had been reconciled, you realized what you did, added the transaction back in and checked it off as Reconciled.  QBs knows the original was deleted and now there is this new transaction that QBs did not Reconcile, but it is showing that it is.  

 

Option 1: If you do know which transactions, go UN-reconcile them.  Then take the last statement that you have already reconciled and do Reconcile again.  **Not the one with the Opening Balance $3K issue the one before that.**  Use the same Closing Date and the same Closing Balance.  Hopefully the now un-reconciled items match the $3K you were off before.  When you let QBs reconcile these items all should be back in sync.  Then take the lastthe missing items from that period will show up and you can mark them off. 

 

Option 2: Unreconcile the last couple of months to where you know everything was in sync.  Best/easiest way to do this is with an Accountant copy if you happen to have one or can call whomever does your taxes for a quick favor.  They can log in and unreconcile the month in one action. 

 

The other way is to manually go in and UN-check all the transactions and then re-reconcile.  It gets real tricky figuring out what cleared in what month.  So hopefully you do know which items were changed and the top option will work for you.

NP-L
Level 1

Why does my statement ending balance & cleared balance match, but I still have a big difference showing up?

Thank you for your response.  I am trying to fix someone else's incorrect entries and have undone (if that is a word) all of 2020 reconciliations.  It did not look like it went back farther than that, but now I am getting this message.  This message was not there when the October 2020 reconciliation was completed. 

Will go back further.

Thank you again.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us