Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello All,
I've been planning to ask this for a very long time but never found the time. Nevertheless I am curious to hear your opinion.
In our business we configured the charts of accounts as nested tree.
Top-level 1
Sub-Sub-Account1
Top-level 2
etc etc etc.....
The idea behind this is to track Expenses, COGS, Income and other financial transactions on different levels. For example we have an expense tree as follows:
Office Expenses
Software Purchases
Software Subscriptions
Hardware Purchases
Repair
Printing Paper
Ink
Water
etc...etc....
When running reports, we can compare the expense of water for example to Office Supplies and Office Expenses totals which is very useful.
I am curious to know if this is completely wrong and are we causing QB to miscalculate the sums or is this actually just another, more granular, way of tracking transactions in QB?
Thanks much for your help and input.
This is absolutely correct to do. The main benefit of structuring the Chart of Accounts as you describe, is that *you* get to decide how information is grouped and subtotaled on reports, to make the information most useful to you.
@FTechThank you so much for the quick reply.
Yeah, I think the nested chart of accounts can be pretty powerful in reports. I wonder why this methodology is not being promoted as a recommendation or best practice (i guess in the name if keeping things simple)
The only problem I saw over the years is that our accountant was complaining that our P&L reports are too detailed. I wish there was a way to select how many nesting levels to include on the report rather than just Detail or Summary (all or nothing)
I have a nested chart of accounts however I am not seeing a way to import the nested chart of accounts. Can anyone help me out?
Yes, we can help you out in importing your chart of accounts, kristine1991.
There are two ways to get to the import option for the chart of accounts. You can go to either of the following:
Here' are the detailed steps:
Or
You can also use this link on how to prepare and complete the import process: Move your chart of accounts to QuickBooks Online.
We'll be right here if you need additional assistance in importing the list. Have a great day!
This doesn't appear to allow for subaccounts of subaccounts (e.g. Expenses: Travel And Meals: Travel).
Good day, omnyacoustics.
Importing a nested chart of accounts is currently unavailable in QuickBooks. You'll need to manually add the sub-accounts of sub-accounts.
If you're using QuickBooks Desktop, here's how:
If you're using QuickBooks Online, see the steps below
To know more about the chart of accounts in QuickBooks, you scan through the articles below. These will provide you steps on how to edit an account as well as delete them:
Create subaccounts in your chart of accounts in QuickBooks Online.
Add, edit, or delete accounts in QuickBooks Desktop.
Feel free to drop me a reply below if there's anything else I can help you with. I'd be more than willing to lend you a hand.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here