Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 04-06-2007, 10:23 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Capital gains Report

In microsoft.public.money, kepenner wrote:

- quote -

> 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.


Presumably those accounts have something to do with each other: you
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  
Old 04-06-2007, 09:10 PM
kepenner
Guest
 
Posts: n/a
Default Re: Capital gains Report

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?

 
Old 04-06-2007, 05:48 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Capital gains Report

In microsoft.public.money, kepenner wrote:

- quote -

> 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?

- quote -

> Any suggestions?
  #-1  
Old 04-06-2007, 04:56 PM
kepenner
Guest
 
Posts: n/a
Default Capital gains Report

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

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:47 PM.