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! Go to Solution.
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!).
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!).
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.