|
#2
| |||
| |||
| In microsoft.public.money, kepenner wrote: - quote - > Ah yes...that would be a simple explanation. Unfortunately that's not it,
Presumably those accounts have something to do with each other: you> because none of the dividends it paid in any other accounts were ever > re-invested. (That DOES happen in my mutual funds, but not here). I guess it > could be trying to cost average...but across accounts which basically have > nothing to do with each other? Makes no sense. own them. I think it is based on an interpretation Canadian tax law as of 2004. Do you disagree with that interpretation, or are you trying to apply logic to tax law? |
|
#1
| |||
| |||
| Ah yes...that would be a simple explanation. Unfortunately that's not it, because none of the dividends it paid in any other accounts were ever re-invested. (That DOES happen in my mutual funds, but not here). I guess it could be trying to cost average...but across accounts which basically have nothing to do with each other? Makes no sense. -- Ken "Cal Learner-- MVP" wrote: - quote - > In microsoft.public.money, kepenner wrote: > > I have used Microsoft Money for years so am not a novice user. Lately I've > > done some day trading and noticed to my annoyance that when I run the > > Reports/Taxes/Capital Gains from the Microsoft Money menu, it gives me > > incorrect values under the 'Purchase Cost' column. Sale Proceeds are correct. > > Consequently the overall Capital gains is also wrong. > > > Further, I notice that this happens ONLY to stocks for which dividends have > > been paid to me in one of my 4 or so accounts at ANY time in the past. It > > doesn't even have to be the account in which the day trading occurred. I can > > fix the problem by giving the stock a different name - say 'Nortel' - which > > never pays dividends. Then everything works perfectly. But as soon as I > > switch back to the correct name (which has never paid a dividend in this > > account, but HAS paid dividends in other accounts) the Capital Gains Report > > gets messed up and I'm out anywhere between 30 and 150 dollars in the > > Purchase Cost. > > > Of course I can solve this by never day trading stocks which pay dividends. > > Or I could solve it by giving the stocks a 'fake name' by adding a (1) at the > > end or something, but then if I want to get a report on a particular stock, > > it's no longer a true report because it excludes dividends. > > > One other thing. I've got the Canadian edition of Microsoft Money 2004, and > > have FIFO checked in the options. > Special case. From what I understand, Microsoft Money for Canada, in > attempting to follow Canadian rules, uses an *average* of the costs > of that security across all accounts in the file. > So what I suspect is that your dividends involved reinvesting the > dividends. Thus the average to get the acquisition price would > include the money spent on those reinvestment buys. Would that > explain what you see? > > > Any suggestions? |
| | |||
| |||
| In microsoft.public.money, kepenner wrote: - quote - > I have used Microsoft Money for years so am not a novice user. Lately I've
Special case. From what I understand, Microsoft Money for Canada, in> done some day trading and noticed to my annoyance that when I run the > Reports/Taxes/Capital Gains from the Microsoft Money menu, it gives me > incorrect values under the 'Purchase Cost' column. Sale Proceeds are correct. > Consequently the overall Capital gains is also wrong. > Further, I notice that this happens ONLY to stocks for which dividends have > been paid to me in one of my 4 or so accounts at ANY time in the past. It > doesn't even have to be the account in which the day trading occurred. I can > fix the problem by giving the stock a different name - say 'Nortel' - which > never pays dividends. Then everything works perfectly. But as soon as I > switch back to the correct name (which has never paid a dividend in this > account, but HAS paid dividends in other accounts) the Capital Gains Report > gets messed up and I'm out anywhere between 30 and 150 dollars in the > Purchase Cost. > Of course I can solve this by never day trading stocks which pay dividends. > Or I could solve it by giving the stocks a 'fake name' by adding a (1) at the > end or something, but then if I want to get a report on a particular stock, > it's no longer a true report because it excludes dividends. > One other thing. I've got the Canadian edition of Microsoft Money 2004, and > have FIFO checked in the options. attempting to follow Canadian rules, uses an *average* of the costs of that security across all accounts in the file. So what I suspect is that your dividends involved reinvesting the dividends. Thus the average to get the acquisition price would include the money spent on those reinvestment buys. Would that explain what you see? - quote - > Any suggestions? |
|
#-1
| |||
| |||
| I have used Microsoft Money for years so am not a novice user. Lately I've done some day trading and noticed to my annoyance that when I run the Reports/Taxes/Capital Gains from the Microsoft Money menu, it gives me incorrect values under the 'Purchase Cost' column. Sale Proceeds are correct. Consequently the overall Capital gains is also wrong. Further, I notice that this happens ONLY to stocks for which dividends have been paid to me in one of my 4 or so accounts at ANY time in the past. It doesn't even have to be the account in which the day trading occurred. I can fix the problem by giving the stock a different name - say 'Nortel' - which never pays dividends. Then everything works perfectly. But as soon as I switch back to the correct name (which has never paid a dividend in this account, but HAS paid dividends in other accounts) the Capital Gains Report gets messed up and I'm out anywhere between 30 and 150 dollars in the Purchase Cost. Of course I can solve this by never day trading stocks which pay dividends. Or I could solve it by giving the stocks a 'fake name' by adding a (1) at the end or something, but then if I want to get a report on a particular stock, it's no longer a true report because it excludes dividends. One other thing. I've got the Canadian edition of Microsoft Money 2004, and have FIFO checked in the options. Any suggestions? -- Ken |
| Tags |
| capital, gains, report |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Capital Gains Report Stevo: When I do a Capital Gains Report for shares that I have reinvested the dividend the report gives an average cost for all shares and not the actual... | Microsoft Money | 1 | 01-12-2007 04:13 AM | |
| Capital gains distribution shows up as a loss in report Niranjan Nilakantan: Hi, I recorded a distribution from a mutual fund as an "S-Term Cap Gains Dist". When I look at the capital gains report, it shows up as a negative... | Microsoft Money | 2 | 09-08-2004 02:02 AM | |
| Re: Capital Gains Report is Incorrect Cal Learner-- MVP: In microsoft.public.money, Paul Galbraith wrote: >I'm using Money 2003, and have a mutual fund that shows (correctly) a cost >basis of ~ $4200,... | Microsoft Money | 4 | 09-06-2003 11:54 PM | |
| Thread Tools | |
| Display Modes | |
| |