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 <[email protected]> To: GnuCash Users <[email protected]> Subject: Re: [GNC] Single mutual fund held in multiple accounts in gnucash Message-ID: <[email protected]> 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, [email protected] 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 <[email protected]> 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 <[email protected] <mailto:[email protected]>> 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 <[email protected] <mailto:[email protected]>> 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 _______________________________________________ gnucash-user mailing list [email protected] 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.
