Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 04-02-2005, 06:47 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: How do I post 401k "Earnings" Entries

This is possible if your statements list periodic contributions by fund and
you crank in lots of data.

For each statement, enter appropriately dated Buy transaction(s) for the
fund(s) in the amount of the invested contributions, but leave the transfer
account field blank. The money for these Buys will appear as though from
thin air. After entering the contribution Buys, compare Account Summary fund
totals with the statement totals. Enter corrective Add/Remove shares
transactions (I think these will be treated as "earnings/losses" but you may
want to test to see for sure before getting crazed cranking in data) to
match the statements. Repeat until done.

Note that these "thin air" purchases may hose up other reports because they
may appear as something like unassigned income. Test to find out.

Note that performance reporting may still be distorted depending on your
plan's mechanics. If it actually purchases weekly with a one day lag from
contributions and you show it as purchasing quarterly from the statement
data, this will affect the calculations.

"DiverScott" <DiverScott[at]discussions.microsoft.com> wrote in message
news:7B9B2700-C5A0-4170-9A3A-736B614EED14[at]microsoft.com...
- quote -

> Thanks for your answer, but I'm still missing a piece. What you suggest
> works, but it doesnt allow me to see the growth in the fund from my
> contributions vs. the 'earnings' as they're listed on my statement. I
> need
> to figure out a way to post my contributions separate from the earnings.
> My
> reference to past statements is that I'm just setting up my 401k tracking
> with Money (I'm a quicken convert). I have statements back to 97 and I'd
> like to enter all the quarterly data with the hope of being able to see
> how
> much of the current and future balance is from the growth.



  #1  
Old 04-02-2005, 04:09 PM
DiverScott
Guest
 
Posts: n/a
Default Re: How do I post 401k "Earnings" Entries

Thanks for your answer, but I'm still missing a piece. What you suggest
works, but it doesnt allow me to see the growth in the fund from my
contributions vs. the 'earnings' as they're listed on my statement. I need
to figure out a way to post my contributions separate from the earnings. My
reference to past statements is that I'm just setting up my 401k tracking
with Money (I'm a quicken convert). I have statements back to 97 and I'd
like to enter all the quarterly data with the hope of being able to see how
much of the current and future balance is from the growth.

"Dick Watson" wrote:

- quote -

> If you use the Account Summary|Account Update (or similar, I'm not sure of
> the exact path and can't look from here) It will allow you to enter a
> statement total for each holding/cash position. It will then enter either
> Add Shares or Remove Shares to get back to the statement balance. This is
> very similar to what you propose doing. As to entering previous statements,
> once you get to a reconciled balance with a current statement, I'm not sure
> there is any value to doing so.
> "DiverScott" <DiverScott[at]discussions.microsoft.com> wrote in message
> news:BFF001E8-0D32-4991-BBA5-CB00A8167416[at]microsoft.com...
> > I'm new to Money and am posting my first question. I've looked through

> the
> > BB and also the FAQ, and didn't see anything that quite fit the bill.
> > > My 401k statements tell me my contributions and display "earnings" to the

> > fund, to give a current value. Obviously somewhere in the background are
> > shares and prices, but that's not supplied on the statement. Any
> > suggestions how to track that within Money? I'm attemping to show
> > contributions as a Add Share transaction with a price of 1 and a quantity

> the
> > actual contribution. I do similar for Earnings but use Reinvest Interest.
> > This seemed clunky, but functional, until you get to negative earnings.

> If
> > I had share price data that would simply be a drop in share price, but I

> just
> > have it as +/- earnings. I used Remove Shares for this one, but I'm sure
> > there must be a more consistent technique. Before I get to far with

> entering
> > past statements, I thought I'd ask.
> > > Thanks

> > Scott

 
Old 03-28-2005, 06:06 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: How do I post 401k "Earnings" Entries

If you use the Account Summary|Account Update (or similar, I'm not sure of
the exact path and can't look from here) It will allow you to enter a
statement total for each holding/cash position. It will then enter either
Add Shares or Remove Shares to get back to the statement balance. This is
very similar to what you propose doing. As to entering previous statements,
once you get to a reconciled balance with a current statement, I'm not sure
there is any value to doing so.

"DiverScott" <DiverScott[at]discussions.microsoft.com> wrote in message
news:BFF001E8-0D32-4991-BBA5-CB00A8167416[at]microsoft.com...
- quote -

> I'm new to Money and am posting my first question. I've looked through
the
> BB and also the FAQ, and didn't see anything that quite fit the bill.
> My 401k statements tell me my contributions and display "earnings" to the
> fund, to give a current value. Obviously somewhere in the background are
> shares and prices, but that's not supplied on the statement. Any
> suggestions how to track that within Money? I'm attemping to show
> contributions as a Add Share transaction with a price of 1 and a quantity

the
> actual contribution. I do similar for Earnings but use Reinvest Interest.
> This seemed clunky, but functional, until you get to negative earnings.

If
> I had share price data that would simply be a drop in share price, but I

just
> have it as +/- earnings. I used Remove Shares for this one, but I'm sure
> there must be a more consistent technique. Before I get to far with

entering
> past statements, I thought I'd ask.
> Thanks
> Scott



  #-1  
Old 03-28-2005, 03:03 PM
DiverScott
Guest
 
Posts: n/a
Default How do I post 401k "Earnings" Entries

I'm new to Money and am posting my first question. I've looked through the
BB and also the FAQ, and didn't see anything that quite fit the bill.

My 401k statements tell me my contributions and display "earnings" to the
fund, to give a current value. Obviously somewhere in the background are
shares and prices, but that's not supplied on the statement. Any
suggestions how to track that within Money? I'm attemping to show
contributions as a Add Share transaction with a price of 1 and a quantity the
actual contribution. I do similar for Earnings but use Reinvest Interest.
This seemed clunky, but functional, until you get to negative earnings. If
I had share price data that would simply be a drop in share price, but I just
have it as +/- earnings. I used Remove Shares for this one, but I'm sure
there must be a more consistent technique. Before I get to far with entering
past statements, I thought I'd ask.

Thanks
Scott
 

Tags
401k, earnings, entries, post
Similar Threads
Thread Forum Replies Last Post
Post MS05 "fix" - Money crapping out.. :-(
wiredup: Since updating Money yesterday, here's my new error: Money is not able to load some or all of your financial planner data. please note the error...
Microsoft Money 7 11-22-2004 07:45 AM
Money 2005: "Spending by Category" says "No data to display"?
Bob Parker: Hi all, On the Home tab under "Spending by Category" I see: 8/30/04 through 9/28/04 No data to display Well, I do have spending during...
Microsoft Money 1 09-29-2004 01:42 AM
Money 2002 transaction status flags ("E", "C", "R") have all disappeared
Nick Tonkin: Hi, After many months of using Money 2002, yesterday I suddenly noticed that the column in my resgister that shows the cleared status of each...
Microsoft Money 4 02-28-2004 04:39 AM
Deleting "Pay to" entries
Crazy man: I've running Money 2000 v8 on ME. I got big list in my "PAY TO" category when I use withdrawal folder. I'd like to tidy this up and delete most...
Microsoft Money 2 02-25-2004 03:46 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 06:55 AM.