[GNC] Single mutual fund held in multiple accounts in

[Kalpesh Patel]

Dave - not sure if you are aware of importing your transactions using
Quicken, OFX or CSV formatted file from your broker if they provide ability
to download.  OFX formatted file gives the best result with no
pre-processing required while CSV one will need pre-processing before
importing it. It then will be more like point & click rather than typing in
for both transactions and securities if encountered for first time. 

 

 

Message: 5

Date: Sat, 8 Jan 2022 14:34:32 -0600

From: William Prescott <will at theprescotts.com>

To: GnuCash Users <gnucash-user at gnucash.org>

Subject: Re: [GNC] Single mutual fund held in multiple accounts in

                gnucash

Message-ID: <9DA3A51F-ACBF-4778-9665-DA126EA06D1D at theprescotts.com>

Content-Type: text/plain;             charset=us-ascii

 

When you specify the source account, you can just type a few characters from
the name and it will move the entry to the first account with those
characters in it. It used to have to be characters at the start of the
account name but now it will find an account with those characters anywhere
in its name. I think that has been true for version 4+

 

Will

 

On 2022 Jan 8, at 01-08 14:25:13, dave_k90 at yahoo.com wrote:

 

 

My formatting was messed up - what you describe is what I was looking to do.
I've got several mutual funds and so there's lots of editing to get them
added to the security list, plus create multiple individual accounts. It
sounds like that's just what it takes. 

 

Is there any way to cut down on he number of accounts shown when you enter a
transaction and specify the source account?  Mine shows all the accounts in
a flat list which is already pretty long. 

 

Thanks for your help.

 

On Saturday, January 8, 2022, 01:35:19 PM EST, William Prescott
<will at theprescotts.com> wrote:

 

 

I probably should have added that in my case all of the index funds are only
held in one of the categories, but I see no reason why some fund could not
be held in more that one category.

e.g. Index fund 1 and Index fund 8 could both be the same mutual fund. There
would only be one entry for it in the Gnucash's Security Editor.

 

Will

 

On 2022 Jan 8, at 01-08 12:28:39, William Prescott <will at theprescotts.com
<mailto:will at theprescotts.com>> wrote:

 

I probably don't understand exactly how you are proposing to set it up, but
I can show you how I have mine set up.

 

Fund Manager A (e.g. Fidelity, Vanguard, other)

    Fund Manager A - IRA

        Index fund 1 (e.g. a single mutual index fund)

        Index fund 2 (e.g. another mutual index fund)

    Fund Manager A - Trust

        Cash Account

        Index fund 3

        Index fund 4

Fund Manager B (e.g. Fidelity, Vanguard, other)

    Fund Manager B - IRA

        Index fund 5 (e.g. a single mutual index fund)

        Index fund 6 (e.g. another mutual index fund)

    Fund Manager B - Trust

        Cash Account

        Index fund 7

        Index fund 8

etc

    

Will

 

 

On 2022 Jan 8, at 01-08 12:09:52, dave_k90--- via gnucash-user
<gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>> wrote:

 

I'm a new user trying to setup gnucash to track investments. I've read
through the documentation, googled etc, but haven't really seen this
addressed, so want to make sure I'm not missing something.

Say I have multiple mutual funds, FUNDA, FUNDB, FUNDC etc.  And I have a
brokerage account with several accounts - IRA, Spouse IRA, Non IRA etc.

 

I think my account list should look like:Investments    Brokerage
Brokerage - non IRA            Mutual Funds                  FUNDA
FUNDB

      Brokerage - IRA 

          Mutual Funds                  FUNDA                  FUNDB

      Brokerage - Spouse IRA            Mutual Funds                  FUNDA
FUNDB

            To create that I need to use the Security Editor to createthen
for each created fund, create multiple sub-accounts for each brokerage
account that holds that fund.

I think I need the separate sub-accounts so I can do reports that sub-total
share count and value based on the fund name, but it seems like a lot of
editing. Also creating all these sub-accounts seems like over time will make
the account list very difficult to scroll through to select accounts for
source/destinations of future transactions.

Any guidance in how to set this up, or pointers on where to read up more on
this would be appreciated.Thanks,

Dave