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

My quick shot checking balance does not match the register balance. Q.B. for Mac.

My account balance when I look at the chart of accounts and when it shows on the home quick shot page does not match what is in the register. What could be the issue here? It use to match two months ago.

Julia Norton

Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

Could be file damage. With your chart of accounts open se...

Could be file damage. With your chart of accounts open select edit>resort list. If that doesn't do it run file>utilities>verify data and rebuild data.

26 Comments
Established Community Backer ***

Could be file damage. With your chart of accounts open se...

Could be file damage. With your chart of accounts open select edit>resort list. If that doesn't do it run file>utilities>verify data and rebuild data.

Not applicable

Now that we have "upgraded" to QB 2015, this happens for...

Now that we have "upgraded" to QB 2015, this happens for us on an almost daily basis!

Instead of rebuilding the data, we "fix" the problem by renaming the old bank account in the chart of accounts, and creating a new one. Then we change the old name back and merge the two accounts. This only takes a minute or two compared with rebuilding the data (must be done in single-user mode).
Established Community Backer ***

In 2015 you can stay in the server and rebuild but you ha...

In 2015 you can stay in the server and rebuild but you have to log out the other users.
Not applicable

I'm having the same exact problem in every company file i...

I'm having the same exact problem in every company file i use.  I'm running three separate company files.  Rebuilding the data does help however the problem keeps occurring not after every check but fairly regularly.  This tells me that its a glitch in your program and not a data problem.  Does anyone know if Intuit has a fix for this yet?


Thanks

Established Community Backer ***

No question there is a problem with the program that lead...

No question there is a problem with the program that leads to this. Somewhere in the code the "cached value" associated with the account isn't being updated when a change to a transaction occurs. Rebuilding the file reads all the transactions and rewrites the "cached value" on the account.  But it does not fix the underlying issue.

We don't have a fix for it yet because we haven't been able to determine what is happening that is causing the cached value not to be updated.  If you see this on a particular account that has had very few transactions changed you may be able to guess at what this is.  This would be very helpful.  It may only happen for particular types of transactions and accounts and operations.  But it may be that this is something you do relatively frequently.

We'd love to figure out what is causing it. If you have any ideas let us know. Once we know we can fix it quickly I suspect.  The only other way to fix it I can think of is to get rid of the caching altogether and always recalculate the account balance.  That will be slow though.
Not applicable

It seems to have happened in an account that does have ve...

It seems to have happened in an account that does have very few transactions.  I will take a closer look at it and see if I can determine what type of transaction it is.  Thanks for getting back to me.  At least now I know it's not my data going bad.
Established Community Backer ***

Yes - its not the data, just the cache of it to avoid hav...

Yes - its not the data, just the cache of it to avoid having to add up all the transactions all the time to display the account balance.  Given that there aren't many transactions hitting that account it may be possible for you to check the account balance every time you do hit that account.  If you notice it is off the last operation you performed is the culprit.  I really appreciate your help in finding it!
Not applicable

Thanks IntuitBiscotti - I just sent you an email regardin...

Thanks IntuitBiscotti - I just sent you an email regarding our specific situation - we, too, are having this problem in QB for Mac 2014 and have had to rebuild a few times.  If you need any examples please let us know.  Thanks for your help!
Not applicable

I am also having the same problem.

I am also having the same problem.
Established Community Backer ***

Does File->Utilities->Rebuild fix it?

Does File->Utilities->Rebuild fix it?
Not applicable

I am having the same problem with one bank account - the...

I am having the same problem with one bank account - the other is working correctly.  Verify and Rebuild have not fixed the error. I didn't have this issue until I converted the file to 2015 Windows edition. Ughh.... Not only is the Snapshot checkbook balance wrong - but the Balance Sheet is as well. The check register itself is correct and matches the bank statement.  With year end upon us, I really need to fix this.  All suggestions welcome.
Established Community Backer ***

If you are asking about the 2015 windows product it is be...

If you are asking about the 2015 windows product it is best to start a new thread. This thread is specific to the Mac product.  The implementation of the two are different and you are likely to get better answers if your post is specific to the Windows product.
Not applicable

Is this solved yet?

Is this solved yet?
Not applicable

Yes! A major software update from Intuit in early May 201...

Yes! A major software update from Intuit in early May 2015 resolved that problem, along with several others I was having.
Established Community Backer ***

Depends on the version.  Fixes for other QuickBooks Mac v...

Depends on the version.  Fixes for other QuickBooks Mac version should be out soon.
Not applicable

I am using QuickBooks Pro 2014.  I know the date it stopp...

I am using QuickBooks Pro 2014.  I know the date it stopped working and with which check.  How do I fix the culprit?
Established Community Backer ***

The issue addressed in this thread was a problem with a c...

The issue addressed in this thread was a problem with a cached value.  File->Utilities->Rebuild will correct the balance.  The issue you describe sounds like a different issue - it is a particular check that is causing the problem. If a rebuild doesn't fix it then start a new thread and, if possible, include a screenshot of the check and describe which accounts it is hitting.
Not applicable

I see this thread is pretty old but I'm hoping there has...

I see this thread is pretty old but I'm hoping there has been a resolution and I just haven't seen it yet but we have the same problem... Ours is off by a consistent amount $77,953.77 and the rebuild didn't fix the problem. It seems another user has a work around by creating another account so perhaps we will do that... In the meantime, is there a real fix? And, yes, it's a mac.
Established Community Backer ***

If the rebuild data doesn't fix it, it could be a particu...

If the rebuild data doesn't fix it, it could be a particular transaction.  The snapshot uses different code than the rest of QuickBooks. It should of course be correct but occasionally we uncover some new type of transaction that isn't handled the same way - if you have something like that I'm very interested in hearing about it so that we can correct the snapshot.

Generally now when we find one of these it is something really weird like a check written for negative amount. QuickBooks allows users to do a lot of things that on the surface don't make much sense. But people do them and it should handle it consistently. 

Not applicable

Biscotti, yes the rebuild did the trick. Thank you very m...

Biscotti, yes the rebuild did the trick. Thank you very much. My client is happy now.
Not applicable

I have had the same problem.  Rebuilding the data fixes i...

I have had the same problem.  Rebuilding the data fixes it - for the moment.  But the problem continues to occur.  I have to "rebuild the data" every time I write a check or the chart of accounts shows a higher balance than we have.  The register does show the correct balance.
Established Community Backer ***

That shouldn't happen of course. Does it really go off li...

That shouldn't happen of course. Does it really go off literarily every time you write a check? If so that might be a good file for an engineer to look at it if you are ok with submitting the file to Intuit.  Let me know here.
Not applicable

I have the same issue, it's only of by 36 cents, but it s...

I have the same issue, it's only of by 36 cents, but it still drives me nuts. I've tried the suggestions mentioned above, but nothing changes. Is there anything else that can be done?
Established Community Backer ***

Is it an account that differs from the check register bal...

Is it an account that differs from the check register balance? Are you on QuickBooks Mac 2015?