cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Unlock the full power of QuickBooks with our Training Classes - Discover more
jkugler1024
Level 1

Balance Sheet Report Grouping and Ordering of Accounts

Hello everyone, despite having what I believe to be appropriate configuration in my Chart of Accounts, I am seeing unexpected grouping and order of accounts on my Balance Sheet report.  Accounts receivable, bank accounts, and other current asset accounts are all grouped together in "Current Assets".  And furthermore, Accounts Receivable is displayed above the bank accounts.

I was expecting three separate groups ordered as follows:
Cash/Cash Equivalents
Accounts Receivable
Other Current Assets

I guess I was expecting the grouping on the balance sheet to be based on the "Type" field from the Chart of Accounts configuration.  I'm using "Cash and cash equivalents", "Accounts receivable (A/R)", and "Current assets" for the "Type" field. 

 

Does anyone know if there is a way to achieve the desired grouping and ordering on the Balance Sheet report?  Ideally, I would like to avoid the manual step of re-ordering in Excel.  


Thank you for any feedback!

Josh

 

 

Solved
Best answer August 20, 2021

Accepted Solutions
GeorgiaC
QuickBooks Team

Balance Sheet Report Grouping and Ordering of Accounts

Hi Josh, thanks for joining us on the Community :) 

 

The BS report is defaulted to show in this way and is designed in line with standard accounting formatting with grouped assets, liabilities, and capital, and as such, it's not possible to re-order this (sorry to be the bearer of bad news!).

 

View solution in original post

3 REPLIES 3
GeorgiaC
QuickBooks Team

Balance Sheet Report Grouping and Ordering of Accounts

Hi Josh, thanks for joining us on the Community :) 

 

The BS report is defaulted to show in this way and is designed in line with standard accounting formatting with grouped assets, liabilities, and capital, and as such, it's not possible to re-order this (sorry to be the bearer of bad news!).

 

jkugler1024
Level 1

Balance Sheet Report Grouping and Ordering of Accounts

So the intended design is to group accounts of Type="Bank" together with accounts of Type="Current Assets"?  And to place Accounts Receivable above these?  I understand that there might not be a way to change it, but I'm rather surprised to hear that this is an intended design since its a presentation format I've not encountered elsewhere.  

AbegailS_
QuickBooks Team

Balance Sheet Report Grouping and Ordering of Accounts

 

Yes, you're right, @jkugler1024.

 

Your chart of accounts gives you different account types to categorise transactions into.

 

If you need assistance with categorisation or setting up accounts for a specific industry, then I suggest you speak with your accountant for advice on how to proceed. 

 

For more details about the Chart of Accounts, check out these articles: 

 

Don't hesitate to leave a comment below in case there's anything else I can assist you with. I'll get back to you as soon as I can. 

 

Need to get in touch?

Contact us