|
#3
| |||
| |||
| 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
| |||
| |||
| 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
It's not a rounding "problem". Money is rounding to two decimal places. The> 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. "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
| |||
| |||
| 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 |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |