Register balance and chart of account balance does not match.

Hello @lakeshorebookkeeping,

Let’s go to your Chart of Accounts and match the balance from there.

You’ll need to make sure that the transaction is sorted "by date" so the Bank register balance will follow the ending balance. Let me guide you how.

1.    Click Accounting, then Chart of Accounts.
2.    Select your Bank account, then click View register.
3.    Click the Date under Filter icon to sort the transaction.

After sorting the date, the register balance and bank balance will be matched.

I’ve attached screenshots below for your visual reference.

For your future reference, you may also read this article: How to Fix Differences Between QuickBooks Balance and Bank Balance.

Fill me in if you have further question. I’ll be around if you need any help.

I have this issue. Chart of accounts balance does not match Register.

I go to chart of accounts and it reads a negative balance, then I click on the account and the register shows a positive balance.  I am not trying to match with the actual bank.

I have this same issue.  I am not connected to my financial institution.  My register is positive but shows negative in my chart of accounts.

Thanks for joining this conversation in the Community, @Bwood1968. I'm here to share insights about why your Chart of Accounts balance didn't match in the register. 

When transactions are imported manually, the bank balance and In QuickBooks balance are always different. It will only be updated if the bank account is connected to online banking. 

Also, the In QuickBooks balance will depend on the added or matched transactions.

To make sure your transactions are added to your books, you'll want to review them after being downloaded or imported. Read through this article for a more detailed guide: Assign, categorize, edit, and add your downloaded banking transactions.  

If you have additional questions, please don't hesitate to drop a comment below. 

I am referring to the "register" in QB, not the actual bank.

This was a problem in QB, the bank is not involved whatsoever.

I appreciate your advice.

I found a fix on an alternative site.

I verified data and rebuilt data within QB utilities.

This fixed the issue.

What alternative site did you find your answer? I have the same problem. My Transaction and checking account balance agree with the bank rec but the being bank balance for the bank reconciliation is off? It does not agree to the GL. (or the previous month's ending balance). 

Can you share where you found the way to fix it? My Register balance is correct and reconciled to my bank but when I go to reconcile the next month the beginning balance says it is wrong, but I do not know where that balance is coming from because the balance in the register is correct, and it will not let me change the beginning balance to what it actually is in the register. 

I went to QB online and was never trained on how to set it up. Right now I want to understand why, when the boss makes out a paycheck, the gross amount shows up in the bank register? It is adding a lot of money to the deposit balance that is not really there. I cannot get an accurate balance from the register like I used to be able to do with Desktop. 

I appreciate any response to help me out. I have been searching and cannot find this answer. I imagine this needs something in setup.

Thank you very much.

Christine

Hello there, Christine.

Did you just convert from QuickBooks Desktop to QuickBooks Online? If so, you'll want to check out this link that will give you an overview of what converts and not: What to expect when you switch from QuickBooks Desktop to QuickBooks Online.

Whenever you create paychecks, it posts to the accounts you set in your payroll settings. We can review it and make changes if necessary. Let me show you: 

1. Click the Gear icon and select Payroll Settings.
2. Select the pencil icon under the Accounting section.
3. Look into the accounts where payroll expenses should be posted and if you want to edit it, just click the pencil icon. Then, Continue.
4. Click Done to save your changes. 

Changes that you've made will affect future transactions. If you want to change existing ones, you can delete and recreate the paycheck.

If you're still the same thing, you can reach out to our Phone Support Team so they can thoroughly review your payroll setup. 

Let me know if you have other questions. Take care!

can you explain where to find QB utilities and the steps you did to correct this issue?  Thanks.

Having Same Issue, do we know if this is a known QB error?  

Having this same issue, if you find a fix will you report back here please :) 

Hi there, @SherryDial. 

Thanks for following along with the thread and sharing your concerns. I'm happy to lend a hand with accessing the Utilities to run a Rebuild and Verify on your company file just as the user above has. 

First, I wanted to explain a bit about what the Rebuild and Verify are designed to do. These utilities scan the company file and resolve any data damage within it. Data damage can cause issues like incorrect balances, duplicate transactions, etc. I've included the steps to run the utilities below. 

1. Close all windows opened in the company file.
2. Go to File > Utliities > Verify Data.
3. No action is needed when you're prompted with QuickBooks detected no problems with your data. The Your data has lost integrity message indicates that there's data damage in your file.
4. Continue to Rebuild data to correct the problem. File > Utilities > Rebuild Data.
5. You will receive a warning message to backup your company file, press OK.
6. Follow the onscreen instruction on where to save your company file. 
7. The Rebuild Data utility starts as soon as the backup is finished.
8. Click OK when you get the message "Rebuild has completed".

That should do it. Once the utilities have finished, let's check your balances.

You can see additional details about this process in Verify and Rebuild Data in QuickBooks Desktop. 

Please let me know if you have any questions or concerns. I'll be here every step of the way. Take care! 

I have 160 accounts in quickbooks. I am doing the utility fix all the time. Is there any way to keep this issue from happening permanently?

I'll make sure you'll run your business flawlessly, @Legacy11.

To get around this issue, you'll want to make sure your QuickBooks Desktop (QBDT) is updated to the latest release. This way, we can ensure the program is running with the newest patches and fixes. I'll show you how.

1. Go to the Help menu and select Update QuickBooks Desktop.
2. Select the Update Now tab. 
3. Click Get Updates to start the download.
4. When the download finishes, restart QuickBooks and accept the option to install the new release.

If this is not the case, I suggest downloading our QuickBooks Tool Hub and run the Quick Fix my Program to isolate and fix this issue. 

Once everything is all set, feel free to check out this link that consists of steps on how to seamlessly reconcile your accounts: Reconcile an account in QuickBooks Desktop.

You can always count on me whenever you have other questions about managing your accounts or QuickBooks. Just add the details in your response and I'll get back to you as soon as I can. Stay safe and have a great weekend ahead!

YES!  Ever since I started direct deposit, the chart of accounts balance was higher than the actual balance in the registry.  Verifying and rebuilding it fixed this problem.  It was driving me bonkers.  Thank you!!

YES! Thank you for the helpful step by step instructions Tori B, the verify and rebuild data did the trick and fixed our problem. 

Yes! Thank you, Tori B, for the helpful step by step instructions. The verify and rebuild data did the trick and fixed our problem. 

Hi there, Bookgirl1.

We're glad to know that the steps for rebuilding data resolved the issue. Please know that you can always reach out to us again anytime you need help. 

I've had this issue a couple of times now.

In Quickbooks go to File --> Utilities --> Verify Data. If it shows a problem then use the same menu but select Rebuild Data. It will request to do a backup first. After the rebuild, the numbers in the chart of accounts and the register should match.

Can you tell me what site helped you. I recently ran into the same issue. My register is correct but my chart of accounts is wrong on my balances!

This worked for me too! Thank you Tori.

What about this for QB online. We are having the same issue.

I can’t see the replies to this.  Did you figure out why this was happening?  Having the same issue.