Is there a character I can put at the beginning of an Account or Group name in
Chart of accounts to force that account to sort to the bottom of the list in the
Summary and on
The goal is to have my “Other” accounts (
Other business property) appear at the bottom of their respective groups.
I don’t want to use account
Codes because (1) I would have to assign a code to every account in order to have a single account sort to the bottom, because coded accounts always appear before un-coded accounts, and (2) I find the codes distracting when they appear in the
Summary pre-pended to the account name.
If I put a tilde, for example, at the beginning of an account name (like
~ Sales), it sorts to the top of its group. I can put a few z’s at the beginning of the name (like
zzz Other expenses) to cause the group to sort to the bottom, but that’s ugly. I’ve tried many ASCII characters that come after Z in the ASCII table, but they all seem to sort before A. Has anyone found one that works?
Other... is a real thing, perhaps a good enhancement would be to have a check box in
Chart of Accounts items that forces the account or group to sort to the bottom of its list. (All accounts or groups with the box checked would go to the bottom together, sorted alphabetically within.) Alternatively, allow for a special
z) that would force bottom-sort but that would not be displayed anywhere – or better yet, allow alphabetical account codes that affect sorting but that are never displayed (so account code A sorts after code 999, and B sorts after that, but neither A nor B are ever displayed anywhere). Or alternatively again, let items with codes sort after un-coded items instead of before them, so the
Other category can be given a code instead of having to assign codes to every single non-
Other category to get
Other to go to the bottom. Or, keeping it very simple, just automatically sort “Other” after Z – but this would be a very English-centric approach.