Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHello, I want to use sub categories in our COA. We have created a budget with sub categories for each ledger and I want to track the actual expenses the same way. An example of what we want to do follows:
8150 Conferences (would be the rollup account)
8150.1 would be for the Pretzel conference
8150.2 would be for the Tacos conference
8150.3 would be for the Steak conference
I read that QB online sorts the COA by the first 3 digits so the above traditional method of tracking would not necessarily sort properly. Is it possible to extend the default sort to 4 or 5 characters? Should I use letters after the period instead of numbers? Any suggestions on how to accomplish this would be appreciated.
Thanks,
Susan
Thank you for posting, @LBSusan.
I can share some information about adding account numbers for the Chart of Accounts in QuickBooks Online (QBO).
Yes, you can add those numbers to your Chart of accounts. You'll just have to turn on account numbers. Then, assign any number to your accounts.
Here’s how to turn it on:
To add the account numbers:
You can refer to this article for more information about the number range based on account types and following the Generally Accepted Accounting Principles (GAAP): Use account numbers in your chart of accounts in QuickBooks Online.
Check this article for more information about the maximum number of accounts allowed for your current QuickBooks plan: Add an account to your chart of accounts in QuickBooks Online.
Let me know if you need further help with your chart of account. I'm always here to help. Have a wonderful day!
Hello and thank you for the response. I neglected to state that we are already using numbers in our ledger. Susan
Hello there, @LBSusan. I'll help you get through this to accomplish your tasks inside QuickBooks Online (QBO).
If you're referring to having the accounts, follow their assigned number. You'll want to ensure you're sorting them out by Numbers and not by Name. This way, the program will recognize the task you're trying to perform and re-arrange the accounts to follow the numbers system you set.
Also, I'd like to confirm that you can extend and use 4 or 5 characters or even use letters after the period instead of numbers. The program will still recognize the action you're trying to accomplish.
To add up, I've got this article to help you manage accounts in your COA: Manage default and special accounts in your QuickBooks Online chart of accounts.
Feel free to post here again if you need further assistance with your QuickBooks-related concerns, @LBSusan. Stay safe, and have a good one!
Good morning
Thank you for the information. I have reviewed the articles. We are already using numbers in our chart of accounts. When I click sort on the numbers column, I get the following:
10010
10012
10040
1040
1050
I expected the sort to give me traditional COA returns in that the 4 digit codes would come before the 5 digit codes.
Regarding my original issue of creating sub-accounts, QBO sorts those funny too. For example:
8205 - rollup
8205.1 - type a
8205.15 - type 0
8205.2 - type b
8205.3 - type c
In this example, I would expect 8205.15 to show up after the single digit extensions.
Is there any way to change this sort order so it shows like the example below?
8205 - rollup
8205.1 - type a
8205.2 - type b
8205.3 - type c
8205.15 - type 0
Thanks again!
Hi there, LBSusan.
Allow me to join the thread and help share a little more information about sorting orders on the chart of the account page.
In the Chart of Accounts page, you can click the arrow up beside Number to show you its sorted order. I've added screenshots for your reference.
I've included an article about using numbers in your chart of accounts (COA). This will help keep your records organized: Use account numbers in your chart of accounts in QuickBooks Online.
Reach out to me with whatever questions you may have about managing COA. I’m here to assist you further. Have a good one.
Thank you for the suggestion. Again, I have not been clear in my desire. I know how to change the up/down sort order. What I am asking is for QBO to recognize that the sort order should be .1, .2., .3, .15, not .1, .15, .2, .3. Seems that QBO cannot make that distinction.
Thanks for getting back with the Community, LBSusan.
If you want accounts to display in a 1, 2, 3, 4, etc. type sorting when using your sort options, you'll need to begin each account's number with an appropriate whole number for how you want them ordered.
For example, if you want a checking account to display as number 1 when sorted by account number, you'll have to make its account number 1. This will assure that they sort in the proper order you're looking for.
In the event you have a series of numbers/characters (example: 8205.) displayed before the number you want it to sort by, it's going to be reading those numbers/characters that come before the number you'd prefer it to sort by.
I can certainly understand how an ability to sort accounts by the fifth digit in their account numbers could be useful and have submitted a suggestion about it as of today.
You can also submit your own feature requests while signed in.
Here's how:
Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing Intuit's Product Updates webpage.
I'll be here to help if there's any questions. Have a wonderful day!
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