Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 09-23-2008, 05:44 AM
harrelsonesq
Guest
 
Posts: n/a
Default Re: Entering Rollover Transaction

Cal --

I too doubt that the distribution was more than the source account value. It
was definitely more than the source account value as shown in MS Money,
either because money went into it that I couldn't record, or because of
market gains.

It could be either. My former employer made some contributions after I
stopped working there, probably because it missed making some before --
there was a good reason I left -- so the contributions account was out of
whack. The same period was also a good one for the markets.


"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:3l5ed4dtcv58cab3tl3mve4tv1tvjljdt5[at]4ax.com...
- quote -

> In microsoft.public.money, harrelsonesq wrote:
> > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message

> > news:ukvdd4tau0rdsf8itht5gvvpk5s4brcd8k[at]4ax.com...
> > > In microsoft.public.money, harrelsonesq wrote:
> > > > > > > Here are my thoughts...
> > > > > I would probably do a Sell of everything in the 401k. Transfer the
> > > amount of cash that made it from the 401k to the IRA (in the cash
> > > transactions register). If you were not tracking cash transactions,
> > > I don't know how you would want to do it. The rest of any difference
> > > in amounts should be accounted for by a possible fee from the 401k
> > > provider and possible withholding if it was not a direct custodian
> > > to custodian transfer.
> > > Actually, the increase in value would be due to net market gains. No fees,

> > no withholding.

> I am glad to hear that. I had guessed the change was in a negative
> direction. There is going to be some amount entered on form
> somethingOrOther by the 401K custodian. If you can access the new
> IRA account, you can find the amount received from the web site
> without waiting for the form.


I do know the amount. I just don't know the quantity or price of the shares
of the funds in the old account that were liquidated
- quote -

> > In those cases, I believe it would show up as the
> > distribution being less than the source account balance, not more. Market
> > gains(losses) don't go into the cash account. In my opinion, that is one
> > of
> > the major shortcomings of MS Money: you can never balance an investment
> > account -- only the associated cash -- so the total account value is
> > always
> > off.

> I doubt that the distribution was more than the source account
> value. You might have lucked out by having the 401K custodian having
> sold your holdings earlier than you were calculating, and the check
> was in the mail during a market down time.


I too doubt that the distribution was more than the source account value. It
was definitely more than the source account value as shown in MS Money,
either because money went into it that I couldn't record, or because of
market gains.

It could be either. My former employer made some contributions after I
stopped working there, probably because it missed making some before --
there was a good reason I left -- so the contributions account was out of
whack. The same period was also a good one for the markets.

- quote -

> > > > > Then enter Buys for the new holdings.
> > > That's something I can do ( the IRA custodian provides sufficient

> > detail --
> > otherwise they wouldn't be the IRA custodian)

> So anyway, I guess you could just enter a Deposit for the amount in
> the 401K, and do what you do to zero out that 401K account. That
> would be simpler than creating a cash transactions register for the
> 401K and then doing a Transfer.
> > > > > I assume that you are looking into the underlying actual amounts.
> > > I can't. All I know is the amount of the rollover, not quantity, price, or

> > the source of the extra money. I'm just assuming market gain.

> I agree.
> > > The amount was less than it would have been a month ago, but still more

> > than
> > the balance shown in MS Money. The check reached the IRA last Monday. I
> > was
> > hoping for Thursday. Oh well.

> That would have been nice to have the transferred funds used to buy
> MFs at the close of Thursday.


I agree.


  #2  
Old 09-22-2008, 04:06 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Entering Rollover Transaction

In microsoft.public.money, harrelsonesq wrote:

- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:ukvdd4tau0rdsf8itht5gvvpk5s4brcd8k[at]4ax.com...
> > In microsoft.public.money, harrelsonesq wrote:
> > > Here are my thoughts...
> > > I would probably do a Sell of everything in the 401k. Transfer the

> > amount of cash that made it from the 401k to the IRA (in the cash
> > transactions register). If you were not tracking cash transactions,
> > I don't know how you would want to do it. The rest of any difference
> > in amounts should be accounted for by a possible fee from the 401k
> > provider and possible withholding if it was not a direct custodian
> > to custodian transfer.

> Actually, the increase in value would be due to net market gains. No fees,
> no withholding.


I am glad to hear that. I had guessed the change was in a negative
direction. There is going to be some amount entered on form
somethingOrOther by the 401K custodian. If you can access the new
IRA account, you can find the amount received from the web site
without waiting for the form.

- quote -

> In those cases, I believe it would show up as the
> distribution being less than the source account balance, not more. Market
> gains(losses) don't go into the cash account. In my opinion, that is one of
> the major shortcomings of MS Money: you can never balance an investment
> account -- only the associated cash -- so the total account value is always
> off.


I doubt that the distribution was more than the source account
value. You might have lucked out by having the 401K custodian having
sold your holdings earlier than you were calculating, and the check
was in the mail during a market down time.

- quote -

> > > Then enter Buys for the new holdings.
> That's something I can do ( the IRA custodian provides sufficient detail --
> otherwise they wouldn't be the IRA custodian)


So anyway, I guess you could just enter a Deposit for the amount in
the 401K, and do what you do to zero out that 401K account. That
would be simpler than creating a cash transactions register for the
401K and then doing a Transfer.

- quote -

> > > I assume that you are looking into the underlying actual amounts.
> I can't. All I know is the amount of the rollover, not quantity, price, or
> the source of the extra money. I'm just assuming market gain.


I agree.

- quote -

> The amount was less than it would have been a month ago, but still more than
> the balance shown in MS Money. The check reached the IRA last Monday. I was
> hoping for Thursday. Oh well.


That would have been nice to have the transferred funds used to buy
MFs at the close of Thursday.
  #1  
Old 09-22-2008, 03:35 AM
harrelsonesq
Guest
 
Posts: n/a
Default Re: Entering Rollover Transaction


"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:ukvdd4tau0rdsf8itht5gvvpk5s4brcd8k[at]4ax.com...
- quote -

> In microsoft.public.money, harrelsonesq wrote:


- quote -

> Here are my thoughts...
> I would probably do a Sell of everything in the 401k. Transfer the
> amount of cash that made it from the 401k to the IRA (in the cash
> transactions register). If you were not tracking cash transactions,
> I don't know how you would want to do it. The rest of any difference
> in amounts should be accounted for by a possible fee from the 401k
> provider and possible withholding if it was not a direct custodian
> to custodian transfer.


Actually, the increase in value would be due to net market gains. No fees,
no withholding. In those cases, I believe it would show up as the
distribution being less than the source account balance, not more. Market
gains(losses) don't go into the cash account. In my opinion, that is one of
the major shortcomings of MS Money: you can never balance an investment
account -- only the associated cash -- so the total account value is always
off.
- quote -

> Then enter Buys for the new holdings.

That's something I can do ( the IRA custodian provides sufficient detail --
otherwise they wouldn't be the IRA custodian)
- quote -

> I assume that you are looking into the underlying actual amounts.

I can't. All I know is the amount of the rollover, not quantity, price, or
the source of the extra money. I'm just assuming market gain.

The amount was less than it would have been a month ago, but still more than
the balance shown in MS Money. The check reached the IRA last Monday. I was
hoping for Thursday. Oh well.


 
Old 09-22-2008, 02:16 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Entering Rollover Transaction

In microsoft.public.money, harrelsonesq wrote:

- quote -

> I rolled over my 401(k) from a former job to a rollover IRA I set up for
> the last time I had a rollover transaction. I have two problems:
> The amount in the source account is less than the amount of the rollover,
> and I don't have the amount that was sold to provide the distribution.
> When I select "transfer in" as the transaction type, I get the following
> message, the only option is to enter "quantity." All I have is the amount
> transferred from the source account. It was a different investment anyway. I
> don't have enough information to enter a sell transaction in the source
> account, plus I don't want to mung the Tax Estimator.


You don't want to use TransferIn for this. That is for securities.
- quote -

> We all know that MS Money doesn't "do" 401(k)'s. What is the best way to
> work around it in this situation?


Here are my thoughts...

I would probably do a Sell of everything in the 401k. Transfer the
amount of cash that made it from the 401k to the IRA (in the cash
transactions register). If you were not tracking cash transactions,
I don't know how you would want to do it. The rest of any difference
in amounts should be accounted for by a possible fee from the 401k
provider and possible withholding if it was not a direct custodian
to custodian transfer.

Then enter Buys for the new holdings.

I assume that you are looking into the underlying actual amounts.


  #-1  
Old 09-22-2008, 01:37 AM
harrelsonesq
Guest
 
Posts: n/a
Default Entering Rollover Transaction

I rolled over my 401(k) from a former job to a rollover IRA I set up for
the last time I had a rollover transaction. I have two problems:

The amount in the source account is less than the amount of the rollover,
and I don't have the amount that was sold to provide the distribution.

When I select "transfer in" as the transaction type, I get the following
message, the only option is to enter "quantity." All I have is the amount
transferred from the source account. It was a different investment anyway. I
don't have enough information to enter a sell transaction in the source
account, plus I don't want to mung the Tax Estimator.

We all know that MS Money doesn't "do" 401(k)'s. What is the best way to
work around it in this situation?



 

Tags
entering, rollover, transaction
Similar Threads
Thread Forum Replies Last Post
Error message entering investment transaction as split transaction
Steven Wissler: I'm trying to enter an investment transaction (Buy Investment) as part of a split transaction on a Paycheck entry. Getting the following...
Microsoft Money 7 11-23-2007 10:01 PM
Entering Categories and Subcategories in a Transaction
DeeDeeCee: Hi. When I first started using Money a decade ago, the category and the subcategory were in separate drop-down boxes. This made entering very...
Microsoft Money 4 09-23-2007 07:24 AM
Sound when entering transaction into account
Norm: I just upgraded to Money 2004 from Money V5. Is it possible to change the lame "ding" sound when entering a transaction to the satisfying...
Microsoft Money 10 06-24-2004 04:27 AM



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 03:57 AM.