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

Why is my Chart Of Accounts Balance Total empty/blank on all items?

All of my items in the COA have nothing showing in the column Balance Total.  If I double click on the item, I see the balance.

 

Why isn't it showing on the page that lists all the COA.   The column is there for the Balance Total, but nothing shows

 

Thanks

Solved
Best answer April 17, 2019

Best Answers
HoneyLynn_G
QuickBooks Team

Why is my Chart Of Accounts Balance Total empty/blank on all items?

I'm here to make sure the Balance Total column will show the amounts, @Anonymous.

 

Generally, the banks, Accounts Receivable, Other Current Asset, Fixed Asset, Accounts Payable, Credit Card, and Equity accounts must have amounts on the Balance Total column. Others not mentioned remains blank for they don't require an opening balance.

 

Since all of your items in the COA don't have amounts on the Balance Total column, let's try performing some troubleshooting steps. This is to verify if this is a data-related issue.

 

Let's begin with opening a sample file:

  1. Open your QuickBooks.
  2. Click the Open a sample file button.
  3. Select a company file.
    1.JPG
  4. Once done, go back to your Chart of Accounts (Lists > Chart of Accounts).

If there are amounts on the Balance Total column, this means the data in your company file is damaged. What we need to do next is run the Verify/Rebuild tool.

 

Here's how to verify data:

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Verify Data.
  4. Click OK when you see the message, QuickBooks detected no problem with your data.
  5. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
  6. Click Close or View Errors and take note of the specific error message.
    2.JPG

Here's how to rebuild data:

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Verify Data.
  4. Click OK if you receive a prompt to back up your company file.
  5. Click OK when you get the message, Rebuild has completed and proceed to the next step.
  6. Run Verify Data again to make sure there's no error.
    3.JPG

Please let me know how it goes or if you have any follow-up questions. I'll be here if you need further assistance. Just leave a comment below.

View solution in original post

vpcontroller
Level 11

Why is my Chart Of Accounts Balance Total empty/blank on all items?

@Anonymous 

@HoneyLynn_G 

 

In the Chart of Accounts, "Balance Total" column shown is for Balance Sheets accounts only. But in QuickBooks Desktop, you can customize the COA and show "Balance" column for the account list.
Just right-click on any one of your accounts > Select "Customize Columns" > Select "Balance" from the Available Columns > Click ADD and OK. See screenshot below for reference.

 

COA_add_column.PNG

View solution in original post

6 Comments 6
HoneyLynn_G
QuickBooks Team

Why is my Chart Of Accounts Balance Total empty/blank on all items?

I'm here to make sure the Balance Total column will show the amounts, @Anonymous.

 

Generally, the banks, Accounts Receivable, Other Current Asset, Fixed Asset, Accounts Payable, Credit Card, and Equity accounts must have amounts on the Balance Total column. Others not mentioned remains blank for they don't require an opening balance.

 

Since all of your items in the COA don't have amounts on the Balance Total column, let's try performing some troubleshooting steps. This is to verify if this is a data-related issue.

 

Let's begin with opening a sample file:

  1. Open your QuickBooks.
  2. Click the Open a sample file button.
  3. Select a company file.
    1.JPG
  4. Once done, go back to your Chart of Accounts (Lists > Chart of Accounts).

If there are amounts on the Balance Total column, this means the data in your company file is damaged. What we need to do next is run the Verify/Rebuild tool.

 

Here's how to verify data:

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Verify Data.
  4. Click OK when you see the message, QuickBooks detected no problem with your data.
  5. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
  6. Click Close or View Errors and take note of the specific error message.
    2.JPG

Here's how to rebuild data:

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Verify Data.
  4. Click OK if you receive a prompt to back up your company file.
  5. Click OK when you get the message, Rebuild has completed and proceed to the next step.
  6. Run Verify Data again to make sure there's no error.
    3.JPG

Please let me know how it goes or if you have any follow-up questions. I'll be here if you need further assistance. Just leave a comment below.

Anonymous
Not applicable

Why is my Chart Of Accounts Balance Total empty/blank on all items?

Thanks, I was expecting to see a # on every line item not just the ones you mentioned.  So thank you for explaining that!!

vpcontroller
Level 11

Why is my Chart Of Accounts Balance Total empty/blank on all items?

@Anonymous 

@HoneyLynn_G 

 

In the Chart of Accounts, "Balance Total" column shown is for Balance Sheets accounts only. But in QuickBooks Desktop, you can customize the COA and show "Balance" column for the account list.
Just right-click on any one of your accounts > Select "Customize Columns" > Select "Balance" from the Available Columns > Click ADD and OK. See screenshot below for reference.

 

COA_add_column.PNG

Anonymous
Not applicable

Why is my Chart Of Accounts Balance Total empty/blank on all items?

THANK YOU!  That is exactly what I needed

tmalloy
Level 2

Why is my Chart Of Accounts Balance Total empty/blank on all items?

In the Chart of Accounts, "Balance Total" column shown is for Balance Sheets accounts only. But in QuickBooks Desktop, you can customize the COA and show "Balance" column for the account list.
Just right-click on any one of your accounts > Select "Customize Columns" > Select "Balance" from the Available Columns > Click ADD and OK. See screenshot below for reference.

 

Can this be done for Quickbooks online version?

LieraMarie_A
QuickBooks Team

Why is my Chart Of Accounts Balance Total empty/blank on all items?

Glad you're here, @tmalloy.

 

The closest way to show all the balances in the Chart of Accounts achievable in QuickBooks Online is to run the Trial Balance report. It can be customized to show all accounts regardless of zero activity. I'll show you how.

 

  1. Go to Reports.
  2. In the Find report by name field, type in "Trial Balance," then press Enter.
  3. Click on the Customize button.
  4. Modify the reporting date.
  5. Under General, you can uncheck the Except zero amount box to show 0.00 on zero balances. (Optional)
  6. Under Rows/Columns, click the Show non-zero or active only drop-down menu, then select All both Show rows and Show columns.
  7. Click Run report.
    Capture.JPG

 

You can also save this customization so that you won't be doing the same process again. Doing so helps speed up your work. Just click the Save customization button at the upper right-hand corner of the screen, then give this report a name and click Save.

 

To learn a bunch of ways to customize your reports, refer to these articles:

 

You can leave a comment below if you have any questions. The Community is always here to help. Have a good one, @tmalloy!

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

Need to get in touch?

Contact us