Microsoft Money investment conversion

jimjames

I know there are a few users of MS Money on here, just wondering if anyone had found a good way of recording transactions where investments are converted from dirty to clean funds? Many of mine have been converted over the last few weeks and just looking at best ways to record that in the portfolio.

Deneb

I'm using Quicken, not MS Money, but is there a fund conversion transaction or wizard in Money?

I used the Mutual Fund Conversion transaction in Quicken to show sale of all shares in the dirty fund and acquisition of the total number of shares in the clean fund. This automatically calculates the ratio of new shares for old, creates a single transaction for removal of all shares in the dirty fund and enters separate transactions in the new fund for each lot of shares previously acquired in the dirty fund, thus maintaining the original cost basis without affecting any cash balance in the account.

Edit: This might help -

https://social.microsoft.com/Forums/en-US/c779ef39-2a4b-41a2-aed4-f23e1d7964d6/how-to-enter-a-fund-conversion?forum=money

Linton

I did a sell and buy. This is simple but you lose the continuity of performance.

A possibly better alternative would be to record a split changing x dirty shares for y clean ones, but then you would have to change the name/code of the fund. If you have the same funds with several different providers changing at different times it wouldnt work. It could also lead to confusing historic data as well.

jimjames

Linton wrote: »

I did a sell and buy. This is simple but you lose the continuity of performance.

A possibly better alternative would be to record a split changing x dirty shares for y clean ones, but then you would have to change the name/code of the fund. If you have the same funds with several different providers changing at different times it wouldnt work. It could also lead to confusing historic data as well.

Thanks for the feedback.

I was looking at sell and buy too. I couldn't see a split giving the info for performance, some it would work ok as the price is the same but others have a significantly different clean price to the existing fund so would show a big jump. Looks like I'll be doing sell/buy too. The alternative was just adding/subtracting the units from the conversion and resetting the code for the fund so new prices then come in. Again would retain performance except where new fund price is quite different

Vortigern

jimjames wrote: »

I was looking at sell and buy too. I couldn't see a split giving the info for performance, some it would work ok as the price is the same but others have a significantly different clean price to the existing fund so would show a big jump. Looks like I'll be doing sell/buy too. The alternative was just adding/subtracting the units from the conversion and resetting the code for the fund so new prices then come in. Again would retain performance except where new fund price is quite different

I did a sell & buy, keeping the history, but changing the symbol on the changeover date. It creates a bit of a step in the price graph and may cause MSMoney to report a gain (or loss).

For small variations in number, I used add or remove shares.

Split ought to work - you might need to remove a fraction of a unit, do the split, then add back the appropriate fraction. I didn't use split with any UTs but split worked well when SMT did a 5 for 1 split in June 2014. What it did was rebase the historic data as though I'd held the new smaller shares all the time.

Chickereeeee

I asked the same question a few months back, and got no satisfactory answer.

The 'share split' process works well, and does preserve history, but has a problem if you have holdings with different platforms (even worse if they move you to different clean classes!)

I had to go the add/remove route, which messes up Cap Gains calculation for ever.

It is a mess.

(Thinking about it, when all the funds have converted, I may be able to undo the add/removes and 'do the splits' instead. Then I get (for most share classes anyway) true cap gains back).

C