cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Bank Balance does not match Ending Balance

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.

Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

Possible file and/or data damage. With the chart of accou...

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.

View solution in original post

22 Comments
Established Community Backer ***

Possible file and/or data damage. With the chart of accou...

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.

View solution in original post

Not applicable

Unfortunately this does not work for me.  Accounts on hom...

Unfortunately this does not work for me.  Accounts on home page and inside register match, but chart of accounts does not.
Established Community Backer ***

When you run File->Utilities->Rebuild Data it is still of...

When you run File->Utilities->Rebuild Data it is still off? Please try it another time and let me know here.
Not applicable

It did work.  Thanks!

It did work.  Thanks!
Established Community Backer ***

Great. The Verify will only report the error but won't fi...

Great. The Verify will only report the error but won't fix it. Rebuild fixes it.
Not applicable

Thanks.  Worked for me on the same problem.

Thanks.  Worked for me on the same problem.
Not applicable

Thank you soooooo much!! I have been dealing with this fo...

Thank you soooooo much!! I have been dealing with this for 3 months. So happy to see it correct!! THANKS!!!
Not applicable

Rebuild data did it! Thanks a bunch!

Rebuild data did it! Thanks a bunch!

Established Community Backer ***

You're welcome.

You're welcome.
Not applicable

Thanks!!  I was going crazy!

Thanks!!  I was going crazy!
Not applicable

Thanks it worked for me too. but why did this happen?? Iv...

Thanks it worked for me too. but why did this happen?? Ive been using QB since 2009 on a PC and never experienced this. this is my first month on MAC 2014 - is this going to happen all the time now??
Established Community Backer ***

It's just a computer thing. Files and data get stored in...

It's just a computer thing. Files and data get stored in whatever space is available, sometimes these get fragmented (windows term) and need to be resorted and/or indexed.
Established Community Backer ***

The value in the chart of accounts is cached - its a copy...

The value in the chart of accounts is cached - its a copy that is maintained and then adjusted (rather than summing up the transactions from scratch every time something is changed). Rebuilding should detect if it is off and correct it.
Not applicable

So it should be indicated to MAC users to do this daily o...

So it should be indicated to MAC users to do this daily or weekly in order to rely on QB for accurate account balances. Otherwise we would need to keep manual chi registers to cross reference balances which is not practical.
Established Community Backer ***

It should stay synched up automatically. Occasionally, fo...

It should stay synched up automatically. Occasionally, for some users, it doesn't - there's a bug somewhere that we haven't yet been able to identify. Sorry it is occurring.
Not applicable

Thanks. I'm dbl checking for my own peace of mind. So far...

Thanks. I'm dbl checking for my own peace of mind. So far all is good.
Not applicable

Thank you worked for me.

Thank you worked for me.

Not applicable

Thanks again for the feedback and help with the rebuild d...

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.

Established Community Backer ***

My theory about this (which I can't prove but makes sense...

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.
Established Member

Re: When you run File->Utilities->Rebuild Data it is still of...

I have tried this fix several times and still my end balance is thousands of dollars higher than my bank reconciliation balance (which is correct).  Any other suggestions?  I have checked the chart of accounts and all entries are correct.  Thank you in advance

Established Member

Re: Possible file and/or data damage. With the chart of accou...

I have tried these suggestions several times and still my end balance is substantially (thousands) higher than my reconciled balance (which is correct).  I have double checked all entries and they are correct.  Any other suggestions?

 

Thank you in advance.

QuickBooks Team

Re: Possible file and/or data damage. With the chart of accou...

Glad to see you again, @Lhermitage,

 

Having to go through multiple troubleshooting steps can be time-consuming when you have more important things to do.

 

Since you already did the recommended steps but keeps getting the same hitch, I would recommend getting in touch with our QuickBooks Support for further assistance. They can open an investigation specifically for the problem, and provide further troubleshooting to complete your work.

 

Here's how to contact support:

  1. Go to your QuickBooks Home page, then click the Help menu at the top.
  2. Choose QuickBooks Desktop Help from the drop-down.
  3. Hit the Contact us icon.

 

Let me know how the call goes by adding a comment below. I want to make sure you can open the company file and I'm here if you need additional help. Have a good one!

Need to get in touch?

Contact us