|
#4
| |||
| |||
| In microsoft.public.money, PTH wrote: - quote - > Just a folow up on a solution to the problem:
It works in theory. If the bug were fixed it could work in practice.> 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. - 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
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, PTH wrote: - quote - > Cal, thanks for the advice. The tax is Canadian, but similar to the U.S.
Do the ROC and then a Buy.> 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. - quote - > 2: For the capital gains, again since I don't really receive the Cap Gains;
No sells. Instead, adjust the holdings via an appropriate split.> 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? 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
| |||
| |||
| 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. |
| | |||
| |||
| In microsoft.public.money, PTH wrote: - quote - > I hold mutual funds that report both capital gains and return of capital at
If this is a taxable account, I expect there is more on that paper> 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. than a balance number. - quote - > Appreciate any advice on what is the best way to handle (enter them) in
What does your 1099 say (if this is US investment)?> 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. 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
| |||
| |||
| 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 | |
| |