[GNC] Account Sort Order

Eric Coates TwistedWood at talktalk.net
Fri Feb 26 08:47:21 EST 2021


Another idea:

Set the Cash account as a separate sub-account under the broker account. 
Please see attached screen shot. (Sorry about the rather 
over-complicated account names but they work for me!) For non-UK users 
(but of no real consequence): An ISA (Individual Savings Account) is a 
tax-light savings vehicle.

Eric
==============================

On 25/02/2021 23:12, D. via gnucash-user wrote:
> That's certainly less onerous than renumbering over and over again, but it's not great. But thank you for one idea!
>
>
> -------- Original Message --------
> From: Geoff <cleanoutmyshed at gmail.com>
> Sent: Thu Feb 25 15:43:52 EST 2021
> To: "David T." <sunfish62 at yahoo.com>, Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Account Sort Order
>
> Hi David
>
>   > Can anyone tell me if there is some way I can get the Cash
>   > account to appear before the commodities, without assigning account
>   > codes to them all? Assigning codes is out of the question because I'd
>   > have to resequence every commodity account after the purchase of any
>   > new commodity, which would get old very quickly.
>
> As a workaround, you can achieve the desired result if you assign the
> *same* account code to all of the broker's commodities (which avoids
> resequencing), and a lesser (or blank) account code to the cash account.
>
> See attached screenshot.
>
> Hope this helps.
>
> Regards
>
> Geoff
> =====
>
> On 26/02/2021 5:40 am, David T. via gnucash-user wrote:
>> Hello,
>>
>> I'm using GnuCash 4.4 under Windows 10, and I am wondering how GnuCash
>> sorts accounts in the Chart of Accounts window. My chosen sort order is
>> by Account Code; however, I choose not to assign account codes for a
>> large number of accounts (such as individual commodities in a brokerage
>> account). For these accounts, I assumed that GnuCash sorts accounts by
>> their names, based on an ASCII sort--which is generally what I see. The
>> result is something like:
>>
>> 1599 - Broker A
>> -- 21st Century Fox
>> -- Alphabet
>> -- IBM
>>
>> 1600 - Alphabetically Earlier Account with higher account code
>>
>> and so forth. And, indeed, that is how I see most of these accounts.
>>
>> However, I decided to change up my structure and add a cash account to
>> one of my brokerage accounts, and  no matter what I name this account,
>> it shows up after every commodity account, like so:
>>
>> 1599 - Broker A
>> -- 21st Century Fox
>> -- Alphabet
>> -- IBM
>> -- 1 Cash
>>
>> I've tried putting "*" "-" " ", and the result is the same; Cash appears
>> after the commodities. Can anyone explain to me how GnuCash is arriving
>> at this sort? Can anyone tell me if there is some way I can get the Cash
>> account to appear before the commodities, without assigning account
>> codes to them all? Assigning codes is out of the question because I'd
>> have to resequence every commodity account after the purchase of any new
>> commodity, which would get old very quickly.
>>
>> TIA,
>>
>> David
>>
>> _______________________________________________
>> 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.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: Separate Cash Account.png
Type: image/png
Size: 17906 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210226/52d881ce/attachment.png>


More information about the gnucash-user mailing list