A User's Experience of an Intuit Quicken to Microsoft Money Conversion
The following is a slightly edited account of a user converting from Intuit Quicken
to Microsoft Money. Thanks to Harprit for allowing me to publish it here.
There are a few tips that I've picked up along the way that might be useful for
other people. Some of these may have been repeated in other threads so apologies
if there are duplications. First thing to do is backup your Quicken file. As you'll
see, I had to do the conversion several times so a good backup is vital. Here goes
for the rest:
1) First problem was the one other people have seen that I couldn't open the Money
file after conversion since it complained about custom currencies. Changed my default
currency in Quicken from 'Pound' to 'British Pound' and reconverted and all was
fine - see also FAQ Article 38.
2) The transaction category disappeared on hundreds of transactions after conversion.
I believe this is due to Quicken having categories that overlap with those in Money.
For instance, I have an 'Education' category in Quicken and, after conversion, all
transactions with this category were now uncategorised. Resolved this by going back
to the Quicken file and renaming 'Education' to 'Educate' and then running the conversion
again. The transactions now show up properly in Money. Had to do this with several
3) Even after step 2), some transactions (only a few in my case) still show up as
uncategorised. Check by looking at 'Reports->Spending by Category->All Dates'
and assign categories to currently unassigned.
4) A large number of transactions show up with 'QUICKEN: modified transaction'.
Most of these are transfers to investment accounts but not exclusively. Do a search
for this text and check. I found most of these to be innocuous and the transaction
was actually correct in Money.
5) A couple of investment account issues. The first one is the most common one other
people have seen. All my investment accounts came across to Money as 'managed fund'
even though they were correctly labelled as 'unit/inv trust' or 'share' in Quicken.
None of these were associated with a custom account type in Quicken (as has been
claimed by others on this newsgroup). The only 'solution' I've seen is to create
another investment of the required type in Money and move all the transactions from
one investment to the other.
I tried this and didn't go for it for 2 reasons. The first is it would be very laborious
for me. The second (and more important) one was that I lost all my price history
for that investment by doing this. So, for now, I'm living with one investment type
for all my investments. The limitation within Money to not be able to change investment
type once the investment is set up seems like a severe one to me.
6) A weird problem hit me as I also have a separate Quicken file which only has
investment accounts in it. After the conversion, I went into the converted Money
file and all seemed fine. Then I exited Money and tried to go back in and it complains
about not having a banking account and wouldn't let me open up the Money file at
all. Did this conversion several times so it's definitely a problem. Resolved this
by doing the conversion one more time and then setting up a dummy banking account
before shutting down for the first time. Then was able to go back into the file
Forward to Part 2
Thanks to Harprit for allowing me to republish his words to the newsgroup here.