Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 02-10-2007, 05:20 PM
Ken
Guest
 
Posts: n/a
Default Re: 401K Question

Excellent reply, Mark - thank you!

I think I didn't notice the behavior you describe because my Contribution
Date (to the 401k from my Paycheck) is the same Date that my 401k downloaded
transactions - perhaps if the Cash was there prior it would attempt to
reconcile it.

I added a Wages line to my Paycheck deposit to indicate Employer Matching
(and a corresponding After Taxes Deduction that will show up in the Cash
portion of my 401 along with my own Contribution) -- prior to my next
paycheck cycle I'll make sure to enter the paycheck prior to d/l-ing my 401k
info electronically.

Thanks again, Mark!




"Mark Horn" wrote:

- quote -

> On 2007-02-09, Ken <Ken[at]discussions.microsoft.com> wrote:
> > I'm wondering; however, what the best method is to track my 401K deduction
> > in terms of my Budget -- I currently have my Gross Paycheck Itemized but if I
> > deduct my 401K Contribution to my 401k account it adds a duplicate value
> > (since I'm d/l-ing transactions automatically already).

> I don't do this for my 401k, since it's not at a provider who allows
> me to d/l transactions into Money. But for my Roth IRA accounts, and
> contributions to my kids' 529 accounts, I do it this way:
> I have a scheduled transfer from my checking to the investment
> account. The transfer goes into the cash portion of the investment
> account. Then when I download the transactions from the brokerage,
> they show up as purchase of the investment. I get a quantity
> purchased and total price. These end up being purchases made out
> of the funds in the cash account.
> So for example, on the first of the month, I have a scheduled
> bill which is a transfer from checking to my IRA for $100.
> Total account value = $100 ($100 cash + $0 holdings).
> A few days later, I download a transaction from the brokerage that
> says I bought 10 shares of stock X for $10 each (for example).
> Money makes a $100 deduction from the cash account to pay for
> that purchase.
> Total account value = $100 ($0 cash + holding 10 shares of X [at] $10)
> I'm fairly certain that if my 401k offered downloads, that it would
> work exactly the same way. Are you doing something differently
> that prevents this from working for you?

 
Old 02-09-2007, 06:29 PM
Mark Horn
Guest
 
Posts: n/a
Default Re: 401K Question

On 2007-02-09, Ken <Ken[at]discussions.microsoft.com> wrote:
- quote -

> I'm wondering; however, what the best method is to track my 401K deduction
> in terms of my Budget -- I currently have my Gross Paycheck Itemized but if I
> deduct my 401K Contribution to my 401k account it adds a duplicate value
> (since I'm d/l-ing transactions automatically already).


I don't do this for my 401k, since it's not at a provider who allows
me to d/l transactions into Money. But for my Roth IRA accounts, and
contributions to my kids' 529 accounts, I do it this way:

I have a scheduled transfer from my checking to the investment
account. The transfer goes into the cash portion of the investment
account. Then when I download the transactions from the brokerage,
they show up as purchase of the investment. I get a quantity
purchased and total price. These end up being purchases made out
of the funds in the cash account.

So for example, on the first of the month, I have a scheduled
bill which is a transfer from checking to my IRA for $100.
Total account value = $100 ($100 cash + $0 holdings).

A few days later, I download a transaction from the brokerage that
says I bought 10 shares of stock X for $10 each (for example).
Money makes a $100 deduction from the cash account to pay for
that purchase.
Total account value = $100 ($0 cash + holding 10 shares of X [at] $10)

I'm fairly certain that if my 401k offered downloads, that it would
work exactly the same way. Are you doing something differently
that prevents this from working for you?
  #-1  
Old 02-09-2007, 04:57 PM
Ken
Guest
 
Posts: n/a
Default 401K Question

I currently have tied my 401k account into MS Money electronically and it is
downloading everything fine, etc.

I'm wondering; however, what the best method is to track my 401K deduction
in terms of my Budget -- I currently have my Gross Paycheck Itemized but if I
deduct my 401K Contribution to my 401k account it adds a duplicate value
(since I'm d/l-ing transactions automatically already).

Should I just setup a 'phantom' account for Budget purposes (that captures
my deduction each time yet doesn't inflate my 401k erroneously)?

Thanks.
 

Tags
401k, question
Similar Threads
Thread Forum Replies Last Post
401k question money 2006 deluxe
Jeff W: I set up my paycheck to automatically report 401k contributions into the 401k account. I set up 401 k account using 401k manager Money never...
Microsoft Money 6 01-26-2007 08:19 PM
401K Manager or Balancing 401K Account
Joe Doe: Can anyone make the case for me to go through th exercise of balancing a 401k account or balancing through the 401K manager? I am careful to enter...
Microsoft Money 2 01-08-2007 05:14 PM
401k Qty/Price/Toal question (Money 2002)
johnmohlengraft@gmail.com: I just started contributing to my 401k and MSMoney disagrees with my 401k statement. Sample line for a Buy... I bought .09 shares at $144.31...
Microsoft Money 2 07-31-2006 04:00 PM
Quicken 401k to Money 401k
Jim: Just replaced my Quicken with Money 2004. Everything converted well. Only thing I can't figure out: I have an account "My 401k" ... in Quicken.. ...
Microsoft Money 1 10-05-2003 01:07 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 08:29 PM.