Fwd: Re: Tracking a TIAA mixed fund account

Dale Alspach alspachde at gmail.com
Sun Jul 23 00:55:58 EDT 2017


I have two TIAA contracts which contain mutual funds and other similar
investments. I have a top level asset account named Retirement and below
that are asset accounts for each contract. Under each contract are accounts
for each mutual fund, ETF, etc. As far as I am aware all TIAA funds now
have symbols and quotes can be obtained from Yahoo. The only exception is
the TIAA guaranteed or stable-value fund. For that one I use pseudo shares
with 1 dollar = 1 share. So each underlying mutual fund is setup to use
prices updated by finance-quote. I download transactions
once a month from the TIAA site.

To keep things organized I have separate income accounts for tax sheltered
income and taxed income. Transactions
under the Retirement account only affect the tax sheltered income accounts.

Dale

On Jul 22, 2017 10:38 PM, "AC" <gnucash at acarver.net> wrote:

> I may be misunderstanding,  but it seems like the following would work:
> Assets:TIAA (cash)Assets:TIAA:Lifecycle 1 (commodity)Assets:TIAA:Lifecycle
> 2 (commodity)Assets:TIAA:TIAA Mutual Fund (commodity)
> My experience of the so called "Lifecycle" funds is that they are just
> like any other mutual funds.
> When I handle payroll deductions, the dollars go into the cash account,
> and a separate purchase transaction moves the cash into fund shares. It's a
> little cumbersome, but it allows me to ensure that the right numbers get
> in.
> HTH, David
>
>
>   On Sun, Jul 23, 2017 at 8:38, AC<gnucash at acarver.net> wrote:   I want
> to start tracking my TIAA retirement portfolio for informational
> purposes (no reporting needs, filings, etc.) but I need some suggestions
> on structuring the account trees so that it doesn't affect my existing
> accounts.  However, possibly later I'll edit things so that the paycheck
> contributions are directed accordingly so I'd want the new accounts to
> allow that eventually (i.e. for now I'll add contributions manually
> using a virtual source and eventually go back through and move those to
> withdraw from my paycheck, the amount withheld is already accounted)
>
> The trick with my TIAA portfolio is that it has three different products
> within it.  Two of them are TIAA funds (one of the lifecycle multi-asset
> funds) that does not have a breakdown of the individual holdings (like a
> mutual fund).  These two only document the employer contributions, my
> contributions, shares and interest/dividends.  The third product is a
> TIAA mutual fund for which the individual holdings are broken out with
> all the same data as a typical mutual fund (shares, prices, etc.)
>
> What I expect to have is some type of top-level account that tracks the
> overall value of the portfolio in dollars and then either within that or
> somewhere nearby an account or account tree for each of the three
> products.  At first I had considered just making the two TIAA funds into
> an account that was basically a mutual fund with a single holding but I
> wasn't quite sure how to combine that with the one real mutual fund when
> each of the three funds receives different amounts of contributions and
> individual dividends.  Perhaps it would be a top-level account then
> three sub-accounts that are all mutual funds with two of them having one
> holding and the last is the broken out holding?
>
> I don't plan on using this for any official reporting (I get those
> documents already), and I don't plan on downloading statements, quotes,
> or anything else.  I'll just manually track things as my statements come
> in and I enter the data from those, perhaps updating symbol share prices
> manually if I'm interested at a particular time.  I don't currently use
> much reporting as is with my existing accounts except an occasional cash
> flow report so as long as that isn't affected I'm fine.  I do currently
> have a mutual fund being tracked so I want to be careful not to cause
> trouble for that either.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list