On Tue, 14 Nov 2006 01:40:02 -0800, mickey71
<mickey71[at]discussions.microsoft.com> wrote:

- quote -

Money does not know how you want to round things. Probably the best way to
handle this issue, here and elsewhere, is to enter the payroll deduction and
the quantity, and allow Money to calculate the price per share.

As you have noted, it does make a difference in balancing if the total amount
is 20.70 vs 20.71. However, there shouldn't be any substantial difference in
anything having to do with balancing, taxes, etc, if Money calculates a price
per share of $29.45 vs $29.45527 for the purchase. Your basis remains accurate
as does the amount deducted from your pay check.



--ron

The way I deal with this is that I use the total amount and the # of
shares purchased from the statement and let Money figure out the price
per share. I realize that the purchase price calculated might be off
by off by some miniscule amount but I don't consider that a huge issue
as the purchase price is not really used for anything as far as
balancing the account. You might be off by a penny or two when
calculating capital gains, but I don't feel that's a big deal.


mickey71 wrote:
- quote -

I have been having an issue with rounding for several years now and I am very
frustrated. I am currently using Money 2007 Deluxe with SP1. With every new
Money release, I hope that my issue will be resolved, but so far, no luck.

Let's say that I have a payroll deduction of $20.70 for stock. The purchase
price per share on that date is $29.4500. There are no service fees. The
transaction shares are 0.7031. In Money, I enter a quantity of 0.7031 and
price $29.4500. Money calculates $20.71 ($20.7063 rounded) instead of $20.70
which messes up my paycheck deposit in my checking account.

I tried using a negative Commission, but Money wouldn't accept a negative
amount. I have also tried using 2 different fields (ie: using quantity and
total or total and price) and letting Money calculate the other, but that
doesn't match up with my statements either.

I read in another thread that Money uses the OS's currency settings (I have
XP Home SP2), so I changed my OS's settings out of desperation. It has not
helped the problem and as a result, ALL currency in Money shows 4 decimal
places (not an attractive result, especially since it didn't help), so I
changed it back to 2 decimal places.

Am I doing something wrong? Did I set up my account incorrectly somehow
(for example, should I have set it up as a 401K even though it's not)? Is
there a way around this? Shouldn't we users have the opportunity to override
this information if it doesn't match our statements (even though Money is
technically correct in it's calculations)? Please help me. Thanks in
advance for your suggestions.