Skip to main content
J
jkugler1024
August 20, 2021
Solved

Balance Sheet Report Grouping and Ordering of Accounts

  • August 20, 2021
  • 1 reply
  • 0 views

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

 

 

Best answer by GeorgiaC

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

 

1 reply

G
GeorgiaCAnswer
August 20, 2021

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

 

J
jkugler1024Author
August 21, 2021

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.  

A
AbegailS_
August 21, 2021

 

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. 

 

Terms & ConditionsAccessibility statement