Quicken 2002, XG, 2004

Can I convert my existing Microsoft® Money 2000 files to Quicken?

Background: Yes. Converting data from Microsoft Money 2000 requires the use of a Quicken Interchange Format (QIF) export and import that is performed one account at a time.

Solution: The following items cannot be converted using the export/import procedure:

Loans

Budgets

Online Account Information

Classification 2

Planner Information

Abbreviations, Comments

Special steps must be taken to convert the following items:

Long account and classification names

Securities

Stock splits

Prepare your Microsoft Money 2000 data file for export to a QIF file:

Account names should be less than 15 characters in length and contain no punctuation marks. To rename your Microsoft Money 2000 accounts:

Open Microsoft Money 2000.

At the top of the screen, click Accounts.

Right-click on an account and select Rename.

Type a new name for the account that is less than 15 characters, contains no punctuation, and does not duplicate any other account or category names.

Categories and classifications should be less than 15 characters in length and should contain no punctuation marks.

From the More menu, choose Categories & Payees.

On the left side of the screen, click Categories.

Select a category to be renamed and click Rename at the bottom of the screen.

Enter in a new name for the category that is less than 15 characters, contains no punctuation, and does not duplicate any other account or category names.

Note all stock splits. This is required for both current and closed security positions.

From the Investing menu, select Portfolio.

Double-click to select a security.

In the left panel, choose Investment Activities.

Look at the Price column. If there is an "S" next to the price, a split exists for this security.

In the left panel, choose Update Prices, and then Update Prices Manually.

Note the Date and Ratio for all stock splits. This information will have to be manually entered into Quicken before the file is converted.

Repeat for each security, including those with closed positions or already sold.

Print a list of all securities and ticker symbols.

From the Investing menu, select Portfolio.

On the left side of the screen, choose See A Different View.

Choose the Holdings view.

From the File menu, choose Print.

Print a list of all account balances.

At the top of the screen, click Reports.

On the left side of the screen, choose What I Have.

Select the Account Balances Report.

At the bottom of the screen, click Go to Report/Chart.

From the File menu, choose Print.

Note online account information.

At the top of the screen, click Accounts.

Click the account that is enabled for online access.

On the left side of the screen, choose Change Account Details.

Toward the bottom of the screen, click Go to Online Setup.

Click the Modify button. This will take you through the set up information. Take note of your online account information, such as your routing number and customer identification number (ID).

Print reports or screenshots of other information to be manually recreated. This type of information might include areas, such as loans and budgets, which cannot be exported.

Creating the QIF files:

To create the QIF files, you will need to export each account:

From the File menu, select Export.

Select Strict QIF, and then click OK.

Choose a location and a name for the QIF file to be created. It is recommended that you use the name of the account that you are exporting.

Click OK.

Choose the type of account you are exporting (regular or investment) and click OK.

Select the account you want to export, and click Continue.

Preparing the Quicken data file:

To prepare your Quicken data file, you need to create the appropriate accounts in Quicken:

Open Quicken. If necessary, create a new Quicken file.

From the Finance menu (Tools Menu in Quicken XG), select the Account List.

Click New.

Choose the type of account.

Name the account. It is recommended that you use the same name as the account you are importing.

If available, select your financial institution from the list. If your financial institution is not available in the list, manually enter the name.

Note: Do not enter any account balances or opening dates. For investment accounts, do not create securities. Investment information will be transferred in the QIF file created from your Microsoft Money 2000 file.

Repeat this process for each account you are importing.

Note: Online account setup can also be completed during this process.

Import an account.

From the File menu, select Import, and then select QIF File.

Click the Browse button and find the QIF you are importing.

Select the account that will be receiving the QIF information. Generally, these will have the same or similar names as your corresponding export accounts from Microsoft Money 2000.

Select Transactions and Special Handling for Transfers only, and click OK.

If you receive a message that an unrecognized Category, Class, or security was found, click Yes to create new categories or classes for these items.

Note: If an imported transaction has a category with the same name as an existing account, the transaction will become a transfer between the accounts.

After the transactions have successfully been imported, open the register by opening the Finance menu (Tools menu in Quicken XG), and selecting Account List. Double-click on the account in question.

If a Compare to Register screen is open when you open a register, accept the transactions into the register by clicking Accept All, and then clicking Done. The transactions will be entered into the register.

Manually enter all stock splits.

From the Account List, double-click an investment account that has stock splits.

Click Easy Actions (record Transaction in Quicken XG).

Choose Stock Split, and enter the necessary information.

Complete the set up information.

Verify account balances.

From the Finance menu (Tools menu in Quicken XG), select Account List.

Compare and verify the account balances listed here to those from your Microsoft Money 2000 file.

Repeat steps 3 and 4 for each account. Check balances for all imported accounts after each import, not just the most recently imported account.

Edit securities to include ticker symbols.

From the Investing menu, choose Security List.

Edit each security and enter the ticker symbols as printed from your Microsoft Money 2000 file.

Customize the download sessions (One-Step Update).

From the Edit menu, choose Options, and then select Internet Options. In Quicken XG, choose Preferences and Customize Online Updates instead.

On the Customize window that appears, select the Quotes tab.

Place a check mark in the left column for each security you want included when downloading quotes, and click OK.