cancel
Showing results for 
Search instead for 
Did you mean: 
lakeshorebookkeeping
Level 1

Register balance and chart of account balance does not match.

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. 

I can not figure out what is wrong here. My banking number matches my bank register perfectly. But the second I click on Chart of Accounts it is completely different.

 

I need help with this for Quickbooks Online! 

 

26 Comments 26
Mark_R
Moderator

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.

Bwood1968
Level 1

Register balance and chart of account balance does not match.

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.

Bwood1968
Level 1

Register balance and chart of account balance does not match.

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.

katherinejoyceO
QuickBooks Team

Register balance and chart of account balance does not match.

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. 

Bwood1968
Level 1

Register balance and chart of account balance does not match.

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.

Question2021
Level 1

Register balance and chart of account balance does not match.

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). 

Question2021
Level 1

Register balance and chart of account balance does not match.

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. 

flowers55
Level 1

Register balance and chart of account balance does not match.

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

Catherine_B
QuickBooks Team

Register balance and chart of account balance does not match.

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!

SherryDial
Level 1

Register balance and chart of account balance does not match.

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

C_Pelley
Level 1

Register balance and chart of account balance does not match.

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

C_Pelley
Level 1

Register balance and chart of account balance does not match.

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

Tori B
QuickBooks Team

Register balance and chart of account balance does not match.

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! 

Legacy11
Level 1

Register balance and chart of account balance does not match.

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?

JasroV
QuickBooks Team

Register balance and chart of account balance does not match.

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!

e1d inc
Level 2

Register balance and chart of account balance does not match.

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!!

Bookgirl1
Level 1

Register balance and chart of account balance does not match.

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

Bookgirl1
Level 1

Register balance and chart of account balance does not match.

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

JenoP
Moderator

Register balance and chart of account balance does not match.

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. 

smedmison
Level 1

Register balance and chart of account balance does not match.

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.

cody53
Level 1

Register balance and chart of account balance does not 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!

mommie-salami
Level 2

Register balance and chart of account balance does not match.

This worked for me too! Thank you Tori.

tucker55
Level 1

Register balance and chart of account balance does not match.

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

nshannon43
Level 1

Register balance and chart of account balance does not match.

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

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us