Hmmm....

Thought I would share a discovery I just made. I've just found one big
negative to the export then import method of movng a mutual fund into
another account:

Earlier this year, I sold a bunch of shares of the fund and used the
Specific Share method to identify the shares sold in order to minimize
the Cap Gains taxes.

Now, after performing the import, I just noticed that this sale was
reset to use the FIFO method. I have no idea why Money decided to make
this switch during the import (you would think an export would save ALL
related transaction info, but obviously it must not), but it did so not
only for the sale earlier this year, but also a different sale from
several years ago.

I plan to use the "ReAllocate Lots..." option when I right click on the
Sell transaction to re-enter the Specific Share method.

Please consider this a word of warning about attempting to use the
export - import method of moving your various fund acounts into other
Investment Accounts / Headings.

If you use the default FIFO method for any shares sold (or you haven't
sold any shares), this method may work fine for you. However, since I
have just stumbled across this issue, it makes me wonder what other
problems might occur...

Regards, Cuz.

PS: Since I now have all my accounts imported into a single Investment
Account, and I only sold shares from this one fund, I am staying as-is,
since I very much like having all my funds under a single account. As
usual YMMV...

Thanks again Cal for your info. I exported and then imported all my
accounts, then used your advice on unchecking the "Allow Cash
Transactions" checkbox on the Rename Investment Account dialog box, to
clear the cash transactions. I then rechecked the Allow Cash
Transactions checkbox, just so I have the Linked Cash Account in case I
ever decide to use it.

Everything looks good and the import/export was fast. I appreciate all
the assistance from everyone!

Regards, Cuz.

Thanks Dick & Cal, for your quick replies. I hope to have time this
weekend to try out your suggestions.

I'm running MS Money '04 Deluxe. Sorry I omitted that key detail.
Regards, Cuz.

In microsoft.public.money, mr_cuzy[at]yahoo.com wrote:

- quote -

Yes. Go to the Account Settings, and tick TrackCashTransactions.

- quote -

I like to track the cash transactions. It can serve to show missing
transactions. In many cases, the balance would typically be zero.
For example, suppose you download a Dividend. That cash may then be
used to reinvest into new shares. By tracking the cash, you could
see that the transaction to reinvest had not been entered.

You ask a LOT of questions here.

1) I'd move the investments one transaction at a time with transaction
Cut/Paste. This may take a while, depending on how many transactions we are
talking about, but it will have the best results and, once done, you will be
glad you went to the trouble. This will be complicated and may require
adding some temporary Add Shares transactions to prevent "shares negative"
error messages. You can just add these in both accounts BEFORE any other
activity for the investment. Add a huge number of shares. Delete this entry
when you are done.

2) Export/Import is probably not a good answer.

3) You can create a linked Investment Cash account from the Investment
Account Details/Settings page. How exactly this is done is version specific
and you neglect to mention the version you are using.

4) Whether you want a cash account depends on the nature of the real world
account you are modeling. Most investment accounts have holding accounts for
temporary cash while clearing transactions, etc.

<mr_cuzy[at]yahoo.com> wrote in message
news:1162194149.215872.22260[at]k70g2000cwa.googlegroups.com...
- quote -

Hello Everyone:

A long time ago I invested in several mutual funds all from the same
fund company. When I recorded this in MS Money, I created separate
accounts for each fund (investment).

Recently, I realized it might make more sense to have all these funds /
investments associated with a single account, to match the single
statement I receive from the fund company. It would also result in a
shorter Portfolio list in MS Money.

How would you recommend I move these seperate investment accounts into
a single account?

I tried the transfer account function, but it doesn't quite give me
what I want. I lose all the transaction history I painstakenly entered
over the years. It simply shows a single "transfered" entry in the
transaction log. This isn't what I want.

Next I tried exporting each of the mutual fund accounts, and then
importing them as investments under a single new account. I thought
this was going to work, until I saw the "linked" Cash account was
non-zero and it was affecting the Total $ (wrong value). When I
deleted the entries from the Cash account, it deleted the corresponding
entries from the mutual fund investments, and now my # of shares held
was wrong.

I deleted the new account, then redefined it and re-imported each of
the exported mutual funds again, and this time I deleted the entire
Cash account, instead of just the transactions within the Cash account.
This seemed to work, as the # of shares is correct and the Account
Total $, but now I no longer have a linked Cash account.

Is there a way to add the Cash account back? Do I even need to?

I've never used the Cash account for any of my other investments
either...but I'm planning on trying to use Money for more than just to
keep track of my investments. I'd like to configure it with my
checking acct and enter my paycheck stub info, so I'm wondering if
maybe I'll really be needing the Cash account.

What do you think? Thanks! Cuz.