QBO - Change chart of account sorting

Any non-Tax accounting topics go here.
#1
Wiles  
Posts:
5181
Joined:
21-Apr-2014 9:42am
Location:
CA
In QuickBooks Online, I am trying to change my client's chart of accounts out of alphabetic order. I cannot find where this is done and their Help function is giving me nothing. Can somebody please help? Thank you.
 

#2
KoiCPA  
Posts:
768
Joined:
8-May-2023 1:30pm
Location:
Washington
You should be able to click on the headers Name, Account Type, etc.
 

#3
Wiles  
Posts:
5181
Joined:
21-Apr-2014 9:42am
Location:
CA
Thanks for the reply, but I need to clarify. I am talking about how to change the order that these accounts are reported on the Balance Sheet and Profit & Loss.

For example, I want to change order in which the 10 partner capital accounts show up on the Balance Sheet. They are currently sorted alphabetically. I want them sorted in the same order that my tax software shows them.

QuickBooks Desktop has the diamond icon on the Chart of Accounts that you can use to drag an account to where you want it. Is there an equivalent feature in QuickBooks Online?
 

#4
Posts:
107
Joined:
14-May-2019 3:57pm
Location:
Idaho
Can you just assign account numbers to the chart of accounts? I believe QBO will then use the account number to sort instead of the alphabet.
 

#5
Wiles  
Posts:
5181
Joined:
21-Apr-2014 9:42am
Location:
CA
Is that the only way?
 

#6
Posts:
107
Joined:
14-May-2019 3:57pm
Location:
Idaho
Not necessarily. I suppose you could also add in the account description something like:
1-Partner Jones
2-Partner Able
3-Partner Don
I think QBO would then use the numerals at the beginning of the account description to sort.
 

#7
Wiles  
Posts:
5181
Joined:
21-Apr-2014 9:42am
Location:
CA
Thanks. I guess that's what we will do.
Capital (01) Jones
Capital (02) Able
Capital (03) Don
...
Capital (10) Cain
 

#8
KoiCPA  
Posts:
768
Joined:
8-May-2023 1:30pm
Location:
Washington
Oh, I see... no, QBO can't handle that kind of sorting. They did a lot of throwing out the baby with the bathwater when they built QBO. (Actually, in many cases they kept the bathwater.)

Account numbers is your best option for comprehensive control, but for something limited like partner accounts, it would work. I prefer to keep partner names anonymized on the capital accounts anyway, so I like the idea of using numbers. I tend to name it "Member 1 Equity" or "Partner 1 Capital" or equivalents.
 

#9
Posts:
83
Joined:
3-Nov-2023 2:21pm
Location:
Idaho
KoiCPA wrote:Oh, I see... no, QBO can't handle that kind of sorting. They did a lot of throwing out the baby with the bathwater when they built QBO. (Actually, in many cases they kept the bathwater.)

Account numbers is your best option for comprehensive control, but for something limited like partner accounts, it would work. I prefer to keep partner names anonymized on the capital accounts anyway, so I like the idea of using numbers. I tend to name it "Member 1 Equity" or "Partner 1 Capital" or equivalents.


Interesting. What size of companies are you typically working with? What are the primary reasons that you anonymize the accounts?
 

#10
KoiCPA  
Posts:
768
Joined:
8-May-2023 1:30pm
Location:
Washington
They're pretty small, so I'm not trying to protect information between the partners - they know each other well enough to decode anything I put there.

I just have a general operating procedure to minimize the use of personal and potentially confidential information unless there's a need for it. I try to keep in mind that these statements can get used in a lot of unanticipated places. If partner 1 has to show a P&L and Balance Sheet for his new mortgage, is anyone even thinking about how much information he's inadvertently sharing about the other partners?

So if it's just as easy to use partner 1, 2, 3, 4 as it is to use Joe, Jane, Jim and Judy, I'll go with the numbers. Even if I'm being slightly paranoid and it never actually matters.
 

#11
Posts:
83
Joined:
3-Nov-2023 2:21pm
Location:
Idaho
Got it. Thanks.
 


Return to General Accounting



Who is online

Users browsing this forum: No registered users and 2 guests