Tracking funds in a 401k

Fred Frigerio frigerio at bellsouth.net
Sat Sep 17 08:10:12 EDT 2005


The way I set it up was under Assets:
I have an Investments Acct:
                         Retirement Acct (Type Bank)
                                    403b Acct (Type Bank)
                                            Employer Contributions (Bank)
                                                      Fund 1(Mutual Fund)
                                                      Fund 2(Mutual Fund)
                                                      Fund 3(Mutual Fund)
                                            Employee Contributions (Bank)
                                                      Fund 1(Mutual Fund)
                                                      Fund 2(Mutual Fund)
                                                      Fund 3(Mutual Fund)

Of course you don't have to break into Employee/Employer contributions 
if you don't want. I also create a sub account that is 
Contributions/2001, /2002, etc. so that I know how much has gone to 
every year without having to do a report. In particular that is usefull 
for IRA types where you can have a 2002 contribution in 2003. That helps 
me to stay within the allowable limits.

Then when you get paid you have a split
       Expenses:Taxes:Federal                                            
       Expenses:Taxes:Soc Sec
       Expenses:Taxes:Medicare
       Expenses:Insurance:Life Insurance
       Expenses: whatever other deductions
       Assets:Current Assests:Direct Deposit Account
       Assets:Investments:Retirement:403b:Employee
       Assets:Investments:Retirement:403b:Employer
       Income:Salary
       Income:Matching 403b

Then you just need to do a transaction for the funds purchase in the 
403b account.

Bradford R. Bowman wrote:

>I am having trouble figuring out the best way to track the value of a
>403(a) (a 401(k)-like account for non-profits).  Perhaps someone can
>suggest a simpler method that the one I am thinking of. I have no
>accounting knowledge at all, as will be obvious.
>
>The situation is fairly typical: each pay period there is an employee
>contribution to the fund that is matched by the employer (up to an
>annual cap).  These contributions are divided according to set
>percentages and applied to the purchase of shares in four different
>funds managed by TIAA-CREF. The per share value of each fund fluctuates
>separately, so that even if she splits the contributions across the four
>funds evenly for a given pay check, she acquires a different number of
>shares in each fund. 
>
>I want to be able to account for the employee contribution that is
>deducted from her paycheck, but the nature of the retirement account
>makes this complicated, as it appears that I need to reference the
>current share prices of each separate fund and then calculate the
>increase in shares.
>
>Originally, I just had one account, labeled 401k, which was a "bank"
>type account. But that is not accurate.  It seems to me that the only
>way I can track the value of this is by making the 401k a "mutual fund"
>type account, and then splitting it into four separate accounts -- one
>for each of the four funds, like so:
>
>9/16 Teacher Salary 
>	Income:Salary				1,000.00
>	Investments:401k:fund1		25.00
>	Investments:401k:fund2		25.00
>	Investments:401k:fund3		25.00
>	Investments:401k:fund4		25.00
>	Expenses:Taxes:etc...
>
>9/16 Employer 401k contribution
>	Equity:Employer match		25.00
>	Investments:401k:fund1
>	etc...
>
>This just seems crazy though. Is it? Is there an easier or better way?
>Any advice would be appreciated.
>
>  
>



More information about the gnucash-user mailing list