Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 03-19-2008, 11:08 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How best to enter paper Capital gains and return of capital

In microsoft.public.money, PTH wrote:

- quote -

> Just a folow up on a solution to the problem:
> Whenever a mutual fund reinvests a distribution (say a capital gain) without
> adding units, the cost basis needs to be increased by the amount of the
> reinvested distribution.
> One way seems to be:
> 1: Enter the distribution as an income (whichever type fits the tax
> category, e.g. Cap gain)
> 2: Enter a Negative Return of Capital for the same amount. (MONEY accepts
> negative ROC) This increases the cost without changing the number of units
> and MONEY seem to track ROC pretty well.


It works in theory. If the bug were fixed it could work in practice.

- quote -

> Both transactions can be handled with associated cash account.
> Any pitfall I have not thought of which will trip me up later?
> Appreciate your thoughts on this

  #3  
Old 03-19-2008, 09:46 PM
PTH
Guest
 
Posts: n/a
Default Re: How best to enter paper Capital gains and return of capital

Hi Cal,

Just a folow up on a solution to the problem:

Whenever a mutual fund reinvests a distribution (say a capital gain) without
adding units, the cost basis needs to be increased by the amount of the
reinvested distribution.

One way seems to be:

1: Enter the distribution as an income (whichever type fits the tax
category, e.g. Cap gain)
2: Enter a Negative Return of Capital for the same amount. (MONEY accepts
negative ROC) This increases the cost without changing the number of units
and MONEY seem to track ROC pretty well.

Both transactions can be handled with associated cash account.

Any pitfall I have not thought of which will trip me up later?

Appreciate your thoughts on this

cheers
PTH
  #2  
Old 03-17-2008, 11:14 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How best to enter paper Capital gains and return of capital

In microsoft.public.money, PTH wrote:

- quote -

> Cal, thanks for the advice. The tax is Canadian, but similar to the U.S.
> A few more questions:
> 1: For return of capital, yes I can do the ROC activity and Money will
> handle the cost basis adjustment. However, since I don't really receive the
> ROC; The ROC activity will increase the cash account. The only way I can
> see how to handle this is to do a SELL and BUY to adjust the cost basis and
> absorb the ROC.


Do the ROC and then a Buy.

- quote -

> 2: For the capital gains, again since I don't really receive the Cap Gains;
> the same problem in cash account will occur unless I do the same SELL and BUY
> again. Since Canada does not have different tax rate for whether the cap
> gains is long or short, the buy/sell would work.
> Do you think the above is a good work around or do you have other
> alternatives?


No sells. Instead, adjust the holdings via an appropriate split.
Post the ratio you are trying to achieve (afterBuyTotal)/(OldTotal).



- quote -

> thanks again
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, PTH wrote:
> > > > I hold mutual funds that report both capital gains and return of capital at
> > > the end of year for tax purposes. Neither of these are actually paid out.
> > > And they do not increase the number shares of the fund. Rather these "paper"
> > > transactions will only be reflected by the change of the fund value.
> > > If this is a taxable account, I expect there is more on that paper

> > than a balance number.
> > > > > > Appreciate any advice on what is the best way to handle (enter them) in
> > > Money 2006 so that :
> > > > > 1: these "paper" transactions can be tracked for tax purpose; and
> > > 2: their effect on the cost bsis and future capital gains/loss will be
> > > correct.
> > > What does your 1099 say (if this is US investment)?
> > > You should be able to enter the activities as ReturnOfCapital and

> > ReinvestLTerm-CG transactions and then do an appropriate split to
> > bring you back to the original number of shares.
> >
  #1  
Old 03-17-2008, 11:01 PM
PTH
Guest
 
Posts: n/a
Default Re: How best to enter paper Capital gains and return of capital

Cal, thanks for the advice. The tax is Canadian, but similar to the U.S.

A few more questions:

1: For return of capital, yes I can do the ROC activity and Money will
handle the cost basis adjustment. However, since I don't really receive the
ROC; The ROC activity will increase the cash account. The only way I can
see how to handle this is to do a SELL and BUY to adjust the cost basis and
absorb the ROC.

2: For the capital gains, again since I don't really receive the Cap Gains;
the same problem in cash account will occur unless I do the same SELL and BUY
again. Since Canada does not have different tax rate for whether the cap
gains is long or short, the buy/sell would work.

Do you think the above is a good work around or do you have other
alternatives?

thanks again


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, PTH wrote:
> > I hold mutual funds that report both capital gains and return of capital at
> > the end of year for tax purposes. Neither of these are actually paid out.
> > And they do not increase the number shares of the fund. Rather these "paper"
> > transactions will only be reflected by the change of the fund value.

> If this is a taxable account, I expect there is more on that paper
> than a balance number.
> > > Appreciate any advice on what is the best way to handle (enter them) in

> > Money 2006 so that :
> > > 1: these "paper" transactions can be tracked for tax purpose; and

> > 2: their effect on the cost bsis and future capital gains/loss will be
> > correct.

> What does your 1099 say (if this is US investment)?
> You should be able to enter the activities as ReturnOfCapital and
> ReinvestLTerm-CG transactions and then do an appropriate split to
> bring you back to the original number of shares.

 
Old 03-17-2008, 09:50 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How best to enter paper Capital gains and return of capital

In microsoft.public.money, PTH wrote:

- quote -

> I hold mutual funds that report both capital gains and return of capital at
> the end of year for tax purposes. Neither of these are actually paid out.
> And they do not increase the number shares of the fund. Rather these "paper"
> transactions will only be reflected by the change of the fund value.


If this is a taxable account, I expect there is more on that paper
than a balance number.

- quote -

> Appreciate any advice on what is the best way to handle (enter them) in
> Money 2006 so that :
> 1: these "paper" transactions can be tracked for tax purpose; and
> 2: their effect on the cost bsis and future capital gains/loss will be
> correct.


What does your 1099 say (if this is US investment)?

You should be able to enter the activities as ReturnOfCapital and
ReinvestLTerm-CG transactions and then do an appropriate split to
bring you back to the original number of shares.

  #-1  
Old 03-17-2008, 09:25 PM
PTH
Guest
 
Posts: n/a
Default How best to enter paper Capital gains and return of capital

I hold mutual funds that report both capital gains and return of capital at
the end of year for tax purposes. Neither of these are actually paid out.
And they do not increase the number shares of the fund. Rather these "paper"
transactions will only be reflected by the change of the fund value.

Appreciate any advice on what is the best way to handle (enter them) in
Money 2006 so that :

1: these "paper" transactions can be tracked for tax purpose; and
2: their effect on the cost bsis and future capital gains/loss will be
correct.

Thanks

P.S. Also appreciate any information regarding lasterst version of Money
(08? 09?) which improved on Money06.

 

Tags
capital, enter, gains, paper, return
Similar Threads
Thread Forum Replies Last Post
Capital gains for day trades
Brucefan: I'm using Money 2006. I own shares of XYZ at different cost basis acquired on different dates. At times, I do day trades of XYZ where I buy and...
Microsoft Money 14 09-07-2005 05:34 AM
capital gains error
Tom: When Money 2004 Premium calculates capital gains, it is incorrect when a sale occurs that includes more than 1 tax lot. It does not subtract the...
Microsoft Money 2 07-11-2004 05:15 PM
reporting capital gains
tictoc: How do I get an investment accout to be included on the capital gains report? One transaction does not appear and i know you have to check...
Microsoft Money 1 11-22-2003 10:49 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 06:09 PM.