Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > Money

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-17-2008, 09:52 PM
=?Utf-8?B?bmVpbDE1NA==?=
 
Posts: n/a
Money Market Fund

I have a money market fund that when I created it I mistakenly said it was a
mutual fund. Is there any way to change the designation back to money market
fund?

Thanks
Reply With Quote
  #2 (permalink)  
Old 07-17-2008, 10:03 PM
Cal Learner-- MVP
 
Posts: n/a
Re: Money Market Fund

In microsoft.public.money, neil154 wrote:

>I have a money market fund that when I created it I mistakenly said it was a
>mutual fund. Is there any way to change the designation back to money market
>fund?


1. What program are you using?

2. Do you download transactions from your broker?
Reply With Quote
  #3 (permalink)  
Old 07-18-2008, 01:44 AM
=?Utf-8?B?bmVpbDE1NA==?=
 
Posts: n/a
Re: Money Market Fund

Sorry about not supplying any details, I should know better.

I am using money plus home & business (2008) and I do download my
transactions from my brokers

"Cal Learner-- MVP" wrote:

> In microsoft.public.money, neil154 wrote:
>
> >I have a money market fund that when I created it I mistakenly said it was a
> >mutual fund. Is there any way to change the designation back to money market
> >fund?

>
> 1. What program are you using?
>
> 2. Do you download transactions from your broker?
>

Reply With Quote
  #4 (permalink)  
Old 07-18-2008, 05:24 PM
Cal Learner-- MVP
 
Posts: n/a
Re: Money Market Fund

In microsoft.public.money, neil154 wrote:

>Sorry about not supplying any details, I should know better.
>
>I am using money plus home & business (2008) and I do download my
>transactions from my brokers
>
>"Cal Learner-- MVP" wrote:
>
>> In microsoft.public.money, neil154 wrote:
>>
>> >I have a money market fund that when I created it I mistakenly said it was a
>> >mutual fund. Is there any way to change the designation back to money market
>> >fund?

>>
>> 1. What program are you using?
>>
>> 2. Do you download transactions from your broker?
>>


This process should work for you. Let me know if something is
confusing. Make an extra copy/backup of your Money file before
starting in case you want to undo something.

================================================== ================

HOWTO change fund that was incorrectly called a Mutual Fund into a
Money Market Fund in Money 2007 or later. This will allow your
Schedule D (Capital Gains transactions) to not include the MMF
sells. It deals with causing statement downloads from your broker
to be associated with the MMF too.

Money market funds are mutual funds with the special property of an
almost-always $1 share price. In addition, Money treats them
differently by not making a Schedule D entry when you have a sell.

To cure this takes some effort, and in the case of a MMF with a lot
of existing transactions, that effort can be considerable. Yet
working at it intently, the time involved is not so great as it
first seems.


1. Create a new mutual fund called "HistoricMMF" or some such.
This will be the name that your existing transactions will show up
as, at least for a while.

2. Pretend that your present MMF name (which was erroneously set
up as a Mutual fund) is "ExistingMF" Then go to the Details of
ExistingMF and blank out the symbol. Then choose CombineWith
(upper right) to combine with HistoricMMF. All of your earlier
transactions would now show up as HistoricMMF transactions, as
would new downloads if you stopped now.

3. But you want Money to ask about ExistingMF the next time it
downloads. So you will next go to the settings for HistoricMMF and
click ManageCombinedInvestments (lower). Tick the box for
ExistingMF and click Remove. Accept the warning. At this point,
there are no transactions for ExistingMF and Money would ask about
it upon next download. As far as I know, ExistingMF is gone. Your
existing transactions are now shown as HistoricMMF.

4. Optionally, pre-create a Money Market Fund called RealMMF or
whatever is appropriate. One way is with
Portfolio->WorkWithInvestments->SetUpANewInvestment. Leave the
symbol blank.


The next time you download a reference to your real MMF from your
broker, Money should ask if that is a new investment or matches an
existing investment from the drop-down list. If you have not
already made the RealMMF MMF identify, specify it is a new
investment called RealMMF. Be *careful* to set the type as
MoneyMarketFund!. If you did pre-create a Money Market Fund called
RealMMF, select that from the drop-down-list to say the downloaded
security is the same as RealMMF.

5. At this point, there is a range of ways to handle the existing
transactions. You can change all of the occurrences of HistoricMMF
to RealMMF, you can change just the newer ones (maybe back through
January), or you can change none and just let past downloads stay
as HistoricMMF while the new ones are RealMMF.

If you do not change them all, add a Sell of HistoricMMF dated for
the last remaining HistoricMMF transaction in the amount needed to
bring your HistoricMMF holdings to zero. Do this for each account
that still holds HistoricMMF transactions.

6. Here is how you would change them all:


6a. To avoid problems with sells where Money thinks you don't have
enough shares to sell, you can simply enter two bogus initial
transactions (with date 1/1/1970 for example) into each affected
account. These should be an AddShares of both HistoricMMF and
RealMMF. Add with enough shares to cover all subsequent sales.
You should then be able to move the transactions in any order you
like. After all transactions have been moved, delete the dummy
entries. You could wait until you encounter a problem before doing
this, if you prefer.

6b. Go to Investment HistoricMMF and choose InvestmentActivities.
Edit each transaction you intend to change to change the Investment
from HistoricMMF to RealMMF. If you may not want to change them
all, you would probably want to start with the newest in case
fatigue sets in.

6c. When no more HistoricMMF transactions remain except the bogus
AddShares, then delete the bogus AddShares. At that time, you
could delete that HistoricMMF investment. If some remain and you
are going to let them remain, then create the compensating
transactions dated appropriately.

Do this for each account that still holds HistoricMMF transactions
along with some that you changed from HistoricMMF to RealMMF.

Check that RealMMF has the right symbol (Investment Details). It
may have been updated during the download, but if it was not, you
can put the proper symbol in. If you leave it blank, that is not a
problem though; the price of a MMF is always $1.00.

6d. Delete the bogus early-dated AddShares transactions.

================================================== ================


Reply With Quote
  #5 (permalink)  
Old 07-19-2008, 12:31 PM
=?Utf-8?B?bmVpbDE1NA==?=
 
Posts: n/a
Re: Money Market Fund

Cal,

Thanks it worked like a charm. Two interesting things happened when I went
through the process. If I did not predefine the money market fund, Money
would automatically define it as a mutual fund and not allow me to choose
money market. The other strange thing was that I went thru the entire
process with all of my open accounts and everything was fine. I then
realized that I had several closed accounts with the same "mutual fund" that
should I should also convert to make everything correct. I changed the
status of those accounts to open and then checked them out and they showed
the fund as a money market rather than mutual fund. So somehow it
automatcially made the change because the names were idenitcal.

Again, thanks for the help.

"Cal Learner-- MVP" wrote:

> In microsoft.public.money, neil154 wrote:
>
> >Sorry about not supplying any details, I should know better.
> >
> >I am using money plus home & business (2008) and I do download my
> >transactions from my brokers
> >
> >"Cal Learner-- MVP" wrote:
> >
> >> In microsoft.public.money, neil154 wrote:
> >>
> >> >I have a money market fund that when I created it I mistakenly said it was a
> >> >mutual fund. Is there any way to change the designation back to money market
> >> >fund?
> >>
> >> 1. What program are you using?
> >>
> >> 2. Do you download transactions from your broker?
> >>

>
> This process should work for you. Let me know if something is
> confusing. Make an extra copy/backup of your Money file before
> starting in case you want to undo something.
>
> ================================================== ================
>
> HOWTO change fund that was incorrectly called a Mutual Fund into a
> Money Market Fund in Money 2007 or later. This will allow your
> Schedule D (Capital Gains transactions) to not include the MMF
> sells. It deals with causing statement downloads from your broker
> to be associated with the MMF too.
>
> Money market funds are mutual funds with the special property of an
> almost-always $1 share price. In addition, Money treats them
> differently by not making a Schedule D entry when you have a sell.
>
> To cure this takes some effort, and in the case of a MMF with a lot
> of existing transactions, that effort can be considerable. Yet
> working at it intently, the time involved is not so great as it
> first seems.
>
>
> 1. Create a new mutual fund called "HistoricMMF" or some such.
> This will be the name that your existing transactions will show up
> as, at least for a while.
>
> 2. Pretend that your present MMF name (which was erroneously set
> up as a Mutual fund) is "ExistingMF" Then go to the Details of
> ExistingMF and blank out the symbol. Then choose CombineWith
> (upper right) to combine with HistoricMMF. All of your earlier
> transactions would now show up as HistoricMMF transactions, as
> would new downloads if you stopped now.
>
> 3. But you want Money to ask about ExistingMF the next time it
> downloads. So you will next go to the settings for HistoricMMF and
> click ManageCombinedInvestments (lower). Tick the box for
> ExistingMF and click Remove. Accept the warning. At this point,
> there are no transactions for ExistingMF and Money would ask about
> it upon next download. As far as I know, ExistingMF is gone. Your
> existing transactions are now shown as HistoricMMF.
>
> 4. Optionally, pre-create a Money Market Fund called RealMMF or
> whatever is appropriate. One way is with
> Portfolio->WorkWithInvestments->SetUpANewInvestment. Leave the
> symbol blank.
>
>
> The next time you download a reference to your real MMF from your
> broker, Money should ask if that is a new investment or matches an
> existing investment from the drop-down list. If you have not
> already made the RealMMF MMF identify, specify it is a new
> investment called RealMMF. Be *careful* to set the type as
> MoneyMarketFund!. If you did pre-create a Money Market Fund called
> RealMMF, select that from the drop-down-list to say the downloaded
> security is the same as RealMMF.
>
> 5. At this point, there is a range of ways to handle the existing
> transactions. You can change all of the occurrences of HistoricMMF
> to RealMMF, you can change just the newer ones (maybe back through
> January), or you can change none and just let past downloads stay
> as HistoricMMF while the new ones are RealMMF.
>
> If you do not change them all, add a Sell of HistoricMMF dated for
> the last remaining HistoricMMF transaction in the amount needed to
> bring your HistoricMMF holdings to zero. Do this for each account
> that still holds HistoricMMF transactions.
>
> 6. Here is how you would change them all:
>
>
> 6a. To avoid problems with sells where Money thinks you don't have
> enough shares to sell, you can simply enter two bogus initial
> transactions (with date 1/1/1970 for example) into each affected
> account. These should be an AddShares of both HistoricMMF and
> RealMMF. Add with enough shares to cover all subsequent sales.
> You should then be able to move the transactions in any order you
> like. After all transactions have been moved, delete the dummy
> entries. You could wait until you encounter a problem before doing
> this, if you prefer.
>
> 6b. Go to Investment HistoricMMF and choose InvestmentActivities.
> Edit each transaction you intend to change to change the Investment
> from HistoricMMF to RealMMF. If you may not want to change them
> all, you would probably want to start with the newest in case
> fatigue sets in.
>
> 6c. When no more HistoricMMF transactions remain except the bogus
> AddShares, then delete the bogus AddShares. At that time, you
> could delete that HistoricMMF investment. If some remain and you
> are going to let them remain, then create the compensating
> transactions dated appropriately.
>
> Do this for each account that still holds HistoricMMF transactions
> along with some that you changed from HistoricMMF to RealMMF.
>
> Check that RealMMF has the right symbol (Investment Details). It
> may have been updated during the download, but if it was not, you
> can put the proper symbol in. If you leave it blank, that is not a
> problem though; the price of a MMF is always $1.00.
>
> 6d. Delete the bogus early-dated AddShares transactions.
>
> ================================================== ================
>
>
>

Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > Money


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 07:58 PM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109