How to Import Microsoft Money Files Into Quicken
Users of the discontinued Microsoft Money software who are switching to Quicken can follow the steps laid out here to import and convert financial data from one program to the other. Some users prefer this process as an alternative to first creating financial accounts in Quicken and then entering or downloading transactions since that method usually only allows for three months of transaction data from financial institutions.
If you're deciding whether to convert your Money files or start from scratch, note that it's a multistep process that requires some tweaking after the import, and unfortunately, not all data can be converted.
Before importing Microsoft Money data into Quicken:
- Reconcile all accounts in Money.
- Remove duplicate, misspelled names in the payee list in Money.
- Remove unused categories from the category list.
- Check your account names, and rename any that are longer than 40 characters (the limit in Quicken).
- Make note of bills on the Money calendar since you'll need to re-enter then in Quicken. Cancel any automatic recurring payments.
- Plan for time after the data conversion to add or adjust budgets, loan accounts, and other items.
- Close out of Money to make sure it's not running during the import.
Create a Backup of Your Money Data
Back up Microsoft Money data files to a new folder on your computer or external drive. Although the data conversion should leave your Microsoft Money data intact, it's better to be safe than sorry.
If you already have transactions in Quicken that you want to keep separate from the imported Money data, then create a new Quicken data file for importing (if not, then you can skip this step). Do this by opening Quicken and clicking on File, New, then New Quicken File. Name the file, and choose it when you import the Money data.
Download Money Plus Sunset Deluxe
If you're using Microsoft Money 2007, 2008, or Money Plus Deluxe, you can skip to the next step.
Download Microsoft Money Plus Sunset Deluxe if you're not already using this version. This final version of Money was designed to replace expired versions. It's free, but some features are disabled.
Download and install the software, then let it convert the data from the earlier version of Money that you've been using.
Import and Convert in Quicken
If You Already Use Quicken
If you've been using Quicken or have already entered transactions, then don't import Money data into your current Quicken data file. The file must be empty for the conversion to be successful, so you need to create a new file:
- Click on File, New File, New Quicken File. Choose this file when you convert data from Money.
- Next, click on File, File Import, and Microsoft Money File. A window should pop up with the Money data file in it. If this is the case, double click on the Money file and start the conversion. If the file isn't listed in the pop-up window, then navigate to where it's saved and select it.
- Follow the process outlined below to convert the data.
If You Haven't Entered Transactions Into Quicken
If you haven't installed Quicken, do so now. If you've installed Quicken, gone through the setup process, and named a new data file, but you haven't entered transactions, then you're ready to convert the data.
First, open Quicken. You'll be given options for starting a new file, opening a Quicken data file or importing data from Microsoft Money (if you don't see this, refer to the procedure for those who already use Quicken). Select the option for importing Money data.
Quicken will find your .mny Money data file and will start converting it. If you have multiple Money data files that you want to convert, follow the steps for "If You Already Use Quicken" above to create new folders for the remaining data files.
While the file is converting, you may see one or more error messages about account names, payee memos, or other items being truncated, although you shouldn't if you've followed all of the previous steps. Quicken will offer a Review Log if there are any data conversion problems. Read the log to see if you'll need to fix any category or account names. You can also get to the Review Log by clicking on File, Log Files, Microsoft Money File Import Results.
After the conversion completes, you'll see Read Next Steps. Click on this and read the instructions given.
Once you close the Next Steps window, your converted file will open. Quicken will open and prompt you to update the data to the most current version. Go ahead and update it.
Review the Converted Data in Quicken
Your Microsoft Money data should now be imported into a Quicken data file. Next, review account and payee information to make sure it converted properly. You'll likely need to make some adjustments since Quicken can't convert all characteristics of Microsoft Money accounts, including some business-specific data.
Afterward, you'll want to set your accounts to automatically download transactions, as well as schedule bills and payments. Click on Help, Quicken Help, New to Quicken to learn more about how to use the software. Quicken is not difficult to use, but many functions are handled differently than in Microsoft Money.
If you have trouble with your Money to Quicken data conversion, refer to the Quicken Support page.