Skip to main content
February 11, 2019
Question

Register balance and chart of account balance does not match.

  • February 11, 2019
  • 3 replies
  • 0 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. 

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! 

 

3 replies

February 11, 2019

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.

December 1, 2020

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.

May 19, 2021

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

May 19, 2021

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!

April 4, 2024

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

April 4, 2024

Hello there, nshannon43.

 

To assist you efficiently, kindly provide us with more specific details regarding your concern. Please let us know which activity you are trying to achieve and which part of QuickBooks you are facing difficulties with. This information will enable me to provide you with the appropriate guidance and instructions that you need. You can also send us screenshots for better visual understanding.

 

I am looking forward to your response.

April 4, 2024

This happened long ago enough that I've gotten it resolved and can't quite remember how.