Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Level 7
December 11, 2018
Solved

Bank Balance does not match Ending Balance

  • December 11, 2018
  • 4 replies
  • 5 views

If I am viewing my check register my "ending balance" shows the correct amount. However, if I view my "Chart of Accounts" my bank balance shows substantially more. When I click on my bank account in the chart of accounts it opens up the "Check Register". 

Why wouldn't the bank "Balance" on the Chart of Accounts match the "Ending Balance" in the "Register".

I am going crazy trying to figure out why the two numbers don't match and how can I get them to match.

Any help would be appreciated.

Best answer by SkinnyRaven

Possible file and/or data damage. With the chart of accounts open select edit>resort list, if that doesn't do it run file>utilities>verify data and rebuild data.

4 replies

Level 6
December 11, 2018

Possible file and/or data damage. With the chart of accounts open select edit>resort list, if that doesn't do it run file>utilities>verify data and rebuild data.

Level 7
December 11, 2018
It did work.  Thanks!
Level 7
December 11, 2018

Rebuild data did it! Thanks a bunch!

Level 6
December 11, 2018
You're welcome.
December 11, 2018

Thank you worked for me.

Level 7
December 11, 2018

Thanks again for the feedback and help with the rebuild data but I still don't understand why this is happened to my new MAC 2014 that I bought only 3 weeks ago as well as my new QB 2014 that I installed at the same time. I never had issues like this for over 6 years with my PC and QB. This is quite difficult to rely on especially when running a small business and every penny counts when paying vendors. I would not recommend MAC QB to others.

Level 5
December 11, 2018
My theory about this (which I can't prove but makes sense to me):

New data enters the system mostly around the current date. Over time a lot of data gets created but after it is entered it mostly isn't changed.  The older data is mostly just read but not modified.  Staying on the same system (QuickBooks Windows Desktop for instance) means that the data does not change. When you switch to another system (even QuickBooks Mac Desktop) every bit of the data is read in, modified, and written out to meet the needs of that platform/system.

If there were any errors anywhere along the way (including in the older system) these things are more likely to show up after all of the data has been "touched".  

Running rebuild corrected the issue you saw. I'm hoping it stays corrected without taking away any additional time from your work.