[GNC] How to reorganize the account tree

[Gyle McCollam]

Jay,
As someone suggested, you could assign account codes and sort on them.  I would use at least a four digit number, so you have room to add accounts in between in the future.  I would suggest 1000s for assets, 2000s for liabilities, 3000s for income, and 4000s for expense.  You could use the 100s in each for subaccounts and 10s for subs within that etc.  Using this numbering scheme your accounts would line up more like your balance sheet and income/expense report.  Using this scheme, you could also list the accounts in any order you wish, not necessarily alphabetic. You could also assign orphan and imbalance as 9999 and 9998 to have them at the end, the same as Alan does by sorting on hidden.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326                     Mobile

gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email

________________________________
From: jaypj at comcast.net <jaypj at comcast.net>
Sent: Monday, June 13, 2022 9:42 AM
To: 'Gyle McCollam' <gmccollam at live.com>
Subject: RE: [GNC] How to reorganize the account tree

I am now sorting on the account and it seems to be working well.  I just
wish that there was a way to move the accounts around in the list a little
more easily. Thank you for your help

-----Original Message-----
From: gnucash-user <gnucash-user-bounces+jaypj=comcast.net at gnucash.org> On
Behalf Of Gyle McCollam
Sent: Sunday, June 12, 2022 12:07 PM
To: Alan A Holmes <gnucash at alanaholmes.me.uk>; gnucash-user at gnucash.org
Subject: Re: [GNC] How to reorganize the account tree

Alan,
It sorts correctly in my GnuCash as well.  Are you sure it is sorting on the
account column, it the only explanation I can think of?  Can't tell that
from the narrow view in the attachment. I understand why the narrow view as
you don't want to display the full account names.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326                     Mobile

gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email

________________________________
From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on
behalf of Alan A Holmes <gnucash at alanaholmes.me.uk>
Sent: Sunday, June 12, 2022 11:52 AM
To: stepbystepfarm at comcast.net <stepbystepfarm at comcast.net>;
gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: Re: [GNC] How to reorganize the account tree

I wasn't complaining, it was just a comment.

But see the attachment, where "G" and "P" both come before "C". And there
are no leading spaces or non-printable characters.


Alan A Holmes

-----Original Message-----
From: gnucash-user
<gnucash-user-bounces+gnucash=alanaholmes.me.uk at gnucash.org> On Behalf Of
Michael or Penny Novack
Sent: 12 June 2022 14:52
To: gnucash-user at gnucash.org
Subject: Re: [GNC] How to reorganize the account tree



> What I do notice sorting this way is that within the top level
> accounts (Assets, Expenses, Income, etc.) that the 2nd and subsequent
> level Accounts under Assets AREN'T sorted alphabetically, while those
> under Expenses and Income ARE. I have insufficient sub-accounts under
> Equity and Liabilities to be able to say.

WHAT are you saying, exactly?

The CoA is a TREE structure. The accounts at the same level of the tree
should be sorted in alpha-meric order. The sibling accounts (children of the
same parent account) should also be sorted that way AMONG THEMSELVES (but
not sorted that way with respect to children of different parents)

You aren't seeing the ultimate top level parent (aka "root") but "top level"
accounts like "asset", "liability", "equity", "income", "expense",
"Imbalance" are its children and so appear in sorted order.
In other words, they are siblings at the highest level.

Michael D Novack


_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.