Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 01-16-2005, 07:00 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Money 2005 rounding problem on IRA's

You don't have to do anything on the price field. Give it qty and total and
hit Enter. Done. Move on to next one.

As to the IRS and cost basis, since the odds Money will round up any given
transaction roughly match the odds it will round down, it seems your cost
basis is unlikely to end up off by more than mere pennies. I'm betting IRS
doesn't care.

I do agree it would be nice if it handled this better. I'm not sure how it
would do that though, short of just ignoring the relationship between
qty*price=total. You give it the first two and it's going to round the
third. I put mine in the way I do because I know that's how the fund company
handles--I'm usually entering the transaction long before seeing a
confirmation given only total and price and I know that the qty will be
rounded to three places.* Perhaps Money should just force price to two
decimal digits? Given that Microsoft claims to comply with the Region
Currency settings (that's the control panel they are referring to) you'd
think that they could know and enforce two digits after decimal. Even at
that, they'd still have to select to round **something**. If you give it
price and qty then all that's left for them to round is total.

* This is an ugly dance when I enter these from scheduled transactions:
enter price from Yahoo quotes, hit Shift+Tab to get it to compute qty, hit
Tab to get back to price, hit delete to remove the quote price I already
entered so Money can compute one from qty and total, hit Shift+Tab to get
back to qty, hit End to go to the nth digit, backspace and change as
appropriate to get to three decimal place rounding.

"Celticbloodline" <Celticbloodline[at]discussions.microsoft.com> wrote in
message news:B651F2A6-3C3D-44AD-913C-8F418AC8A57C[at]microsoft.com...
- quote -

> Dick, your solution works, and I appreciate your idea and will now be
> going
> back and re-doing numerous transaction in this manner....delete the
> "price"
> item, change "total" to the amount on the trade confirmation, them double
> click on the price box and it will fill in a value to 5 decimal places to
> approximate what the price really was.
> BUT, Microsoft, it should not have to be done this way. Please fix the
> program so that it has some value to serious investors and can REALLY be
> used
> for tax basis purposes.



  #2  
Old 01-16-2005, 06:46 PM
Ron Rosenfeld
Guest
 
Posts: n/a
Default Re: Money 2005 rounding problem on IRA's

On Sun, 16 Jan 2005 10:31:03 -0800, Celticbloodline
<Celticbloodline[at]discussions.microsoft.com> wrote:

- quote -

> I'm having the same problem. A more specfic example: placed and order to
> buy $5,000 worth of a mutual fund. Trade confirmation comes back showing
> that I purchased 214.777 shares at $23.28 for $5,000 even. I enter the
> quantity and price in Money, and it fills in the "total" as $5,000.01.


It's not a rounding "problem". Money is rounding to two decimal places. The
"problem" is the data entry. 214.777 * 23.28 does NOT equal $5,000.00. Rather
it equals 5000.00856 which, when properly rounded to two decimal places,
becomes 5000.01

Since the problem is data entry, changing your method of data entry is the
recommended method of fixing the problem. Since your broker is presumably
accurately keeping and reporting your number of shares and your value, those
should be the numbers entered. Allow Money to compute the price, because that
will not make any difference in future reconciliations.

Actually, you wind up a little ahead on this transaction, since you should have
only received about 214.7766323 shares :-)).

So you received an extra 0.000367698 share at no charge!
--ron
  #1  
Old 01-16-2005, 05:31 PM
Celticbloodline
Guest
 
Posts: n/a
Default RE: Money 2005 rounding problem on IRA's

Gary and Dick,

I'm having the same problem. A more specfic example: placed and order to
buy $5,000 worth of a mutual fund. Trade confirmation comes back showing
that I purchased 214.777 shares at $23.28 for $5,000 even. I enter the
quantity and price in Money, and it fills in the "total" as $5,000.01. I
read a couple of the Knowledge Based Articles on this and they say the
rounding mechanism is based on the Contol Panel Settings (they don't bother
to state where in CP, or how, to change those settings). So, in my instance,
if you multiply the price per share by the number of shares you come up with
$5,000.0086 for the total cost, and Money calls that $5,000.01. My broker
calls it $5,000.00, and so does the IRS since they are going to go by the
trade confirmation, not so print out from Money. Unfortunately, when you
carry this out over numberous transactions per year and many years of
investing, what you end up with in Money is an incorrect cost basis, thus
greatly reducing the functionality of the software. It's nice that Money can
trasfer all my capital gains information over to a tax program, but if the
information is wrong, it is really of no use. Microsoft, if you are
listening, users of Money ought to be able to adjust the handling od decimals
and rounding FROM WITHIN Money, and for that "total" box within the
transaction entry there ought to be a way for the user to override what Money
says is the "total" when that figure does not match what is on the user's
trade confirmation. Just seems like it would add credibility to the
software.

Dick, your solution works, and I appreciate your idea and will now be going
back and re-doing numerous transaction in this manner....delete the "price"
item, change "total" to the amount on the trade confirmation, them double
click on the price box and it will fill in a value to 5 decimal places to
approximate what the price really was.

BUT, Microsoft, it should not have to be done this way. Please fix the
program so that it has some value to serious investors and can REALLY be used
for tax basis purposes.

Scott

"Gary44" wrote:

- quote -

> Hi,
> When I set up my Roth IRA on Money 2005, my $2,000 investment becomes
> $1999.99.
> Is this a rounding problem, and how do I fix it?
> Thanks,
> Gary

 
Old 12-29-2004, 01:39 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Money 2005 rounding problem on IRA's

You don't really give enough information to answer for sure. (Was it one
investment or multiple? What was it invested in? Is it an Investment
Account? Etc.) Probably the way you fix it--given my guess of what your
issue is--would be to edit the buy transaction and delete the share price
and reenter the total value. You may have to delete all four of shares,
share price, total value and commission and then go back and re-enter
everything BUT share price. This lets Money compute the un-rounded price
appropriate to the number of shares and the total value.

"Gary44" <gary.rose8[at]verizon.net> wrote in message
news:R2zAd.13893$152.566[at]trndny01...
- quote -

> When I set up my Roth IRA on Money 2005, my $2,000 investment becomes
> $1999.99.
> Is this a rounding problem, and how do I fix it?



  #-1  
Old 12-29-2004, 01:20 PM
Gary44
Guest
 
Posts: n/a
Default Money 2005 rounding problem on IRA's

Hi,

When I set up my Roth IRA on Money 2005, my $2,000 investment becomes
$1999.99.

Is this a rounding problem, and how do I fix it?

Thanks,

Gary


 

Tags
2005, ira, money, problem, rounding
Similar Threads
Thread Forum Replies Last Post
2005 Small Business// Invoice rounding unwanted
RogerW: I sell business forms, enveopes, and other items in quantity and the rounding of the price/rate field will not work. 10,000 Imprinted calendars...
Microsoft Money 2 09-24-2004 07:11 PM
Money 04 account balance rounding error
M Glass: I am using Money 2004 Deluxe, and when I was checking my account balance (checking account) against what the bank said, I found I was off by $0.01...
Microsoft Money 2 02-14-2004 11:35 PM
How to prevent Money from rounding off the numbers?
George: Hello, Is it possible to prevent MS Money from rounding off the numbers to the right of the decimal point? MS Money changes $42.079 to $42.08. ...
Microsoft Money 3 01-13-2004 05:21 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 04:36 AM.