Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #13  
Old 07-08-2006, 01:21 AM
Mike 'Flyin'8'
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

:-)

You are probably right....

I am sure, well almost sure, that I did that last night... oh well...
Important thing is it is working right now.

Thanks Again!

On Fri, 7 Jul 2006 18:38:54 -0600, "Dick Watson"
<littlegreengecko[at]mind-enufalready-spring.com> wrote:

- quote -

> I think you just got the sequence I describe right this time. I don't think
> rebooting had anything to do with it.
> "Mike 'Flyin'8'" <yeah.right[at]guess.again> wrote in message
> news:e8sta25cj8kpgrgvr9e320ijlheq7d6q75[at]4ax.com...
> > I rebooted my PC, and then went through the procedure you described
> > (deleting all the data for a transaction) and try to start with the
> > $125. I then added the price per share, and the qty updated to the
> > proper amount. There is now no commission. Who knows what happened,
> > but something made it start working.


Mike Flyin' 8
  #12  
Old 07-08-2006, 12:38 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

I think you just got the sequence I describe right this time. I don't think
rebooting had anything to do with it.

"Mike 'Flyin'8'" <yeah.right[at]guess.again> wrote in message
news:e8sta25cj8kpgrgvr9e320ijlheq7d6q75[at]4ax.com...
- quote -

> I rebooted my PC, and then went through the procedure you described
> (deleting all the data for a transaction) and try to start with the
> $125. I then added the price per share, and the qty updated to the
> proper amount. There is now no commission. Who knows what happened,
> but something made it start working.



  #11  
Old 07-07-2006, 11:42 PM
Mike 'Flyin'8'
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

I rebooted my PC, and then went through the procedure you described
(deleting all the data for a transaction) and try to start with the
$125. I then added the price per share, and the qty updated to the
proper amount. There is now no commission. Who knows what happened,
but something made it start working.

Thanks for your assistance.
Mike Flyin' 8
  #10  
Old 07-07-2006, 11:25 PM
Mark
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

Concerning:
- quote -

> I use advanced for everything EXCEPT the budget, which I can
> not get to switch from essential to advanced for some reason. I use MS
> Money 2006.


Have you referenced the following KB article:
http://support.microsoft.com/kb/899628/en-us

-Mark


<Flyin'8[at]here.com> wrote in message
news:20060707171119.038$wP[at]newsreader.com...
- quote -

> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote:
> > Then I guess I can't help you. Whenever I do this for the 401ks I track,
> > I:
> > > 1) Have investments defined as mutual funds.

> > 2) Use Buy Investment/CD transactions in the cash account with the total
> > amount for each investment set to the dollar figure of the contribution.
> > Depending on the plan, I then either use $1 per share and let Money
> > compute the shares as equal to the total, or enter, as available, the

NAV
> > or the quantity purchased. If the NAV is input, I tab to the next field,
> > letting Money compute the number of shares, then I tab back to price,
> > delete it, tab back to number of shares and round to the digits used by
> > the plan.
> > > This has always worked and, done correctly, never thrown a commission or

> > changed the total value. I have experience with this method in Money
> > versions from whichever was the first to support investments (M95? M97?)
> > through M06.
> > > I can also say this: IF you start a transaction that has any of the

> > values filled in, Money relentlessly tries to hold QTY/PRICE/TOTAL
> > constant and, as long as it can solve that equation, will put any change
> > in commission. That's why I emphasized the **technique** I did. I have
> > certainly seen cases where Money relentlessly tries to do the kind of
> > thing you describe until I get all the data out and then start putting
> > back only the known/fixed quantities of Total and Shares or Total and
> > Price.
> > > Is downloaded data involved?
> > > Is Essential (anything) involved (M05/6 only)?

> I do not download any data for the 401K transactions. The paycheck data

is
> downloaded. I use advanced for everything EXCEPT the budget, which I can
> not get to switch from essential to advanced for some reason. I use MS
> Money 2006.
> Do I need to delete ALL of my transactions in the 401K and then use the
> technique you mention?
> --
> Mike Flyin'8
> PP-ASEL
> Temecula, CA
> http://flying.4alexanders.com



  #9  
Old 07-07-2006, 10:35 PM
Flyin'8@here.com
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote:
- quote -

> You shouldn't need to. I certainly never have. Is Money auto-completing
> the transaction when you start it and enter a payee? If so, what if you
> skip the payee and do a new transaction from blank?
> Cal mentions Repair. I don't know that I've gotten there yet on your
> case, but it might be worth a try.
> I was going to run this tonight (if I get time) and get you keystrokes
> that work/"fail".
> <Flyin'8[at]here.com> wrote in message
> news:20060707171119.038$wP[at]newsreader.com...
> > Do I need to delete ALL of my transactions in the 401K and then use the
> > technique you mention?


Cool! That would be helpful. In my transaction there is no payee. Am I
entering the data in the wrong place? Geesh, that would be a bummer.

I go to the portfolio manager and add my transactions there. When I do it
that way, there is not even a prompt for a payee. It is simply a transfer
from my 401K cash account to the selected mutual fund within the 401k
account.

--
Mike Flyin'8
PP-ASEL
Temecula, CA
http://flying.4alexanders.com
  #8  
Old 07-07-2006, 10:02 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

In microsoft.public.money, Dick Watson wrote:

- quote -

> Cal mentions Repair. I don't know that I've gotten there yet on your case,
> but it might be worth a try.


If he was entering 100 shares, and it wanted to say total $125 was
$100 plus $25 commission, I would think he had accidentally set up
that mutual fund as a money market fund. That does not seem to quite
match what he is describing. In that case, he would have described
the fixed $1 price.

So it seems way weird.
  #7  
Old 07-07-2006, 09:40 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

You shouldn't need to. I certainly never have. Is Money auto-completing the
transaction when you start it and enter a payee? If so, what if you skip the
payee and do a new transaction from blank?

Cal mentions Repair. I don't know that I've gotten there yet on your case,
but it might be worth a try.

I was going to run this tonight (if I get time) and get you keystrokes that
work/"fail".

<Flyin'8[at]here.com> wrote in message
news:20060707171119.038$wP[at]newsreader.com...
- quote -

> Do I need to delete ALL of my transactions in the 401K and then use the
> technique you mention?



  #6  
Old 07-07-2006, 09:08 PM
Flyin'8@here.com
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote:
- quote -

> Then I guess I can't help you. Whenever I do this for the 401ks I track,
> I:
> 1) Have investments defined as mutual funds.
> 2) Use Buy Investment/CD transactions in the cash account with the total
> amount for each investment set to the dollar figure of the contribution.
> Depending on the plan, I then either use $1 per share and let Money
> compute the shares as equal to the total, or enter, as available, the NAV
> or the quantity purchased. If the NAV is input, I tab to the next field,
> letting Money compute the number of shares, then I tab back to price,
> delete it, tab back to number of shares and round to the digits used by
> the plan.
> This has always worked and, done correctly, never thrown a commission or
> changed the total value. I have experience with this method in Money
> versions from whichever was the first to support investments (M95? M97?)
> through M06.
> I can also say this: IF you start a transaction that has any of the
> values filled in, Money relentlessly tries to hold QTY/PRICE/TOTAL
> constant and, as long as it can solve that equation, will put any change
> in commission. That's why I emphasized the **technique** I did. I have
> certainly seen cases where Money relentlessly tries to do the kind of
> thing you describe until I get all the data out and then start putting
> back only the known/fixed quantities of Total and Shares or Total and
> Price.
> Is downloaded data involved?
> Is Essential (anything) involved (M05/6 only)?


I do not download any data for the 401K transactions. The paycheck data is
downloaded. I use advanced for everything EXCEPT the budget, which I can
not get to switch from essential to advanced for some reason. I use MS
Money 2006.

Do I need to delete ALL of my transactions in the 401K and then use the
technique you mention?

--
Mike Flyin'8
PP-ASEL
Temecula, CA
http://flying.4alexanders.com
  #5  
Old 07-07-2006, 08:54 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

In microsoft.public.money, Flyin'8[at]here.com wrote:

- quote -

> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote:
> > Try this:
> > > Create the Buy transaction. Delete total dollar amount and then all other

> > quantities/amounts. Money can be persistent about trying to calculate
> > this out while you are trying to clear the values. Be persistent until it
> > has nothing to go by. Enter total dollar amount of the buy. Enter number
> > of shares. Then enter the transaction. Let Money figure out the price per
> > share. It should figure out that the commission is $0.
> > > Report the airport in sight.

> If you are talking about the single transaction (not the entire 2 years of
> transaction data already entered) I have already done this... over and over
> and over... It always seems to bring the $ total back to $100, remainder
> into Commission, and the qty adjusted accordingly...


Review your backup situation.

I would try File-> RepairMoneyFile-> QuickFileRepair first.

Then see http://support.microsoft.com/kb/902466/en-us if the problem
persists.

  #4  
Old 07-07-2006, 08:39 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

Then I guess I can't help you. Whenever I do this for the 401ks I track, I:

1) Have investments defined as mutual funds.
2) Use Buy Investment/CD transactions in the cash account with the total
amount for each investment set to the dollar figure of the contribution.
Depending on the plan, I then either use $1 per share and let Money compute
the shares as equal to the total, or enter, as available, the NAV or the
quantity purchased. If the NAV is input, I tab to the next field, letting
Money compute the number of shares, then I tab back to price, delete it, tab
back to number of shares and round to the digits used by the plan.

This has always worked and, done correctly, never thrown a commission or
changed the total value. I have experience with this method in Money
versions from whichever was the first to support investments (M95? M97?)
through M06.

I can also say this: IF you start a transaction that has any of the values
filled in, Money relentlessly tries to hold QTY/PRICE/TOTAL constant and, as
long as it can solve that equation, will put any change in commission.
That's why I emphasized the **technique** I did. I have certainly seen cases
where Money relentlessly tries to do the kind of thing you describe until I
get all the data out and then start putting back only the known/fixed
quantities of Total and Shares or Total and Price.

Is downloaded data involved?

Is Essential (anything) involved (M05/6 only)?

<Flyin'8[at]here.com> wrote in message
news:20060707140823.926$tU[at]newsreader.com...
- quote -

> If you are talking about the single transaction (not the entire 2 years of
> transaction data already entered) I have already done this... over and

over
> and over... It always seems to bring the $ total back to $100, remainder
> into Commission, and the qty adjusted accordingly...



  #3  
Old 07-07-2006, 06:05 PM
Flyin'8@here.com
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote:
- quote -

> Try this:
> Create the Buy transaction. Delete total dollar amount and then all other
> quantities/amounts. Money can be persistent about trying to calculate
> this out while you are trying to clear the values. Be persistent until it
> has nothing to go by. Enter total dollar amount of the buy. Enter number
> of shares. Then enter the transaction. Let Money figure out the price per
> share. It should figure out that the commission is $0.
> Report the airport in sight.



If you are talking about the single transaction (not the entire 2 years of
transaction data already entered) I have already done this... over and over
and over... It always seems to bring the $ total back to $100, remainder
into Commission, and the qty adjusted accordingly...

--
Mike Flyin'8
PP-ASEL
Temecula, CA
http://flying.4alexanders.com
  #2  
Old 07-07-2006, 05:57 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

Try this:

Create the Buy transaction. Delete total dollar amount and then all other
quantities/amounts. Money can be persistent about trying to calculate this
out while you are trying to clear the values. Be persistent until it has
nothing to go by. Enter total dollar amount of the buy. Enter number of
shares. Then enter the transaction. Let Money figure out the price per
share. It should figure out that the commission is $0.

Report the airport in sight.

<Flyin'8[at]here.com> wrote in message
news:20060707133452.996$qg[at]newsreader.com...
- quote -

> I set up a new 401k account and have picked the two funds I have. These
> are Mutual funds. The price per share is the price that is listed the day
> of the transaction. (The actual transaction information as far as
> cost/share is kept at the broker I use for my 401k) As for the quantity,
> when I set the "Total" in money to $125 and put the cost/share info in the
> cost box, the qty is figured out by Money. The qty will vary for each
> transaction since the daily price/share changes on a daily basis. So...
> Here is an example of how it is working for me...
> If I buy $125 worth of Fund A [at] $10/share the transaction in money would
> show this: Total $100, Commission $25, # Shares 10
> In reality at the broker it is: Total $125, # Shares 12.5



  #1  
Old 07-07-2006, 05:31 PM
Flyin'8@here.com
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote:
- quote -

> Can't say just yet.
> What kind of Investment defined in Money are you trying to enter the buy
> for? What price per share are you using? What quantity of the investment
> are you trying to buy?


I set up a new 401k account and have picked the two funds I have. These
are Mutual funds. The price per share is the price that is listed the day
of the transaction. (The actual transaction information as far as
cost/share is kept at the broker I use for my 401k) As for the quantity,
when I set the "Total" in money to $125 and put the cost/share info in the
cost box, the qty is figured out by Money. The qty will vary for each
transaction since the daily price/share changes on a daily basis. So...
Here is an example of how it is working for me...

If I buy $125 worth of Fund A [at] $10/share the transaction in money would
show this: Total $100, Commission $25, # Shares 10

In reality at the broker it is: Total $125, # Shares 12.5

--
Mike Flyin'8
PP-ASEL
Temecula, CA
http://flying.4alexanders.com
 
Old 07-07-2006, 04:01 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: 401K Transaction & Commissions

Can't say just yet.

What kind of Investment defined in Money are you trying to enter the buy
for? What price per share are you using? What quantity of the investment are
you trying to buy?

<Flyin'8[at]here.com> wrote in message
news:20060707112757.426$4a[at]newsreader.com...
- quote -

> I have finally set up my 401K auto deduction on my paycheck in MS Money.
I
> have the 401K Transfered to my 401K account as a cash transaction. This

is
> working fine. I have the amount as $200/paycheck AND $50 Employer
> matching. When I go to the actual 401k account and try to "Buy" $125 in
> shares for each investment (I have 2 different ones... each gets
> $125/paycheck) the transaction will only let me put $100 and then puts the
> rest into commission. It does not seem to matter if I manually set the
> amount of the purchase to $125 or $2500, anything above $100 goes into
> commission.
> What could the problem be?



  #-1  
Old 07-07-2006, 03:25 PM
Flyin'8@here.com
Guest
 
Posts: n/a
Default 401K Transaction & Commissions

I have finally set up my 401K auto deduction on my paycheck in MS Money. I
have the 401K Transfered to my 401K account as a cash transaction. This is
working fine. I have the amount as $200/paycheck AND $50 Employer
matching. When I go to the actual 401k account and try to "Buy" $125 in
shares for each investment (I have 2 different ones... each gets
$125/paycheck) the transaction will only let me put $100 and then puts the
rest into commission. It does not seem to matter if I manually set the
amount of the purchase to $125 or $2500, anything above $100 goes into
commission.

What could the problem be?

--
Mike Flyin'8
PP-ASEL
Temecula, CA
http://flying.4alexanders.com
 

Tags
401k, commissions, transaction
Similar Threads
Thread Forum Replies Last Post
Entering realized gain transaction in 401k?
brett: I have a realized gain in my 401k and I'm not sure how to do the transaction. The account has two sections - Cash and Investment transactions. ...
Microsoft Money 9 05-06-2006 10:45 PM
Create a report showing investment commissions?
Miles: Is it possible in MS Money Premium 2006 to create a report that shows the amount of commissions charged in an investment account? My broker is...
Microsoft Money 1 07-28-2005 08:17 PM
Commissions report?
Mike B: Is there a way in Money 2002 Standard to get a total for commissions paid over a certain period of time? I know I can get a monthly report that...
Microsoft Money 2 01-16-2004 03:46 PM
expense category for commissions?
Paul: When I enter a buy/sell and indicate a broker's commission, what expense category does that commission show up under? I can't find it anywhere.
Microsoft Money 1 08-20-2003 04:43 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:15 PM.