From MTHWiki

Revision as of 03:57, 10 March 2010

Converting data from Microsoft Money Investments

To convert your data, you create a full Investments transactions report for the Investment transactions in Microsoft Money:

Here is a step-by-step instructions:

• Create an Investment transaction report using the procedure that applies to your version of Microsoft Money.

Microsoft Money 2008 through 2005

• Click the Reports tab.
• In the Income and expenses area, select Investment transactions. If the Investment transactions report is not in the list, display the advanced reports by selecting Change report settings in the Other tasks list. Select Switch from Essential Reports to Advanced Reports and click Use Advanced Reports to display the Investment transaction option.
• Select "All Accounts" and "All Dates" at the bottom of the screen.
• Proceed to Next Steps

Microsoft Money 2004 or 2003

• Select the Reports menu and select Reports Gallery.
• In the Pick a report or chart list, select Investment Transactions.

• Click the Go to Report/Chart button.
• In the Common tasks list, select Customize. If the Reset button is not available, proceed to step 3. Otherwise, click Reset. If a confirmation message appears, click Yes, and select Customize again.

• In the Rows & Columns tab, in the Include fields area, select the Memo, Account, Transfer Account, Cleared status, and Category options.
• In the Group Byby field, select None.
• In the Accounts field, select All Accounts.

• In the Date range field, select All dates.

Next Steps

• Select the Send to menu and select Desktop. This step might take some time, depending on the size of your data file.

• When the transfer is complete, click OK.

• Close Microsoft Money.
• Open MyMoney, select File-Import-Import CSV-12 File (MSMoney Investments).

• Review your transactions for accuracy.
• Don't forget to delete the Microsoft Money reports from your desktop by right-clicking the reports and selecting Delete.
• Empty your recycle bin by double-clicking the Recycle Bin icon on your desktop and selecting Empty Recycle Bin.

Troubleshooting

My Money is very sensitive to the CSV file format generated, it has to be just right for the import to go through.

If you have issues with importing please load your CSV file into a text editor or Excel/Numbers and compare it with the following CSV file fragment:

 
Investment Transactions Export
Fidelity Investments

Date,Account,Investment,Activity,C,Quantity,Price,Commission,Total,Memo,Transfer Account,Category

2010-03-09,Fidelity Investments,"Apple, Inc.",Buy,,100,$215.00,,21500.0000,,Fidelity Investments (Cash),

Please note that:

• 1) There are 12 fields separated by commas
• 2) The fields are: Date,Account,Investment,Activity,C,Quantity,Price,Commission,Total,Memo,Transfer Account,Category
• 3) The order of fields is important
• 4) It is ok for a field to be empty

Also, please make a note of a date, in this example the date is 2010-03-09, or March 9th, 2010.

If you have a different format of the dates you may want to adjust date format under preferences - Import/Export

For example, if your dates are 2006-19-09 please change the format to yyyy-MM-dd and re-import your data again. Once the transactions are imported to your liking we suggest to start a new brand new database and import transactions there if you had previous issues with the dates or reconciliation statuses.

Please note that imports are very CPU intensive operations so it may take a little while for the process to finish. After a successful import operation please switch to the Portfolio Manager tab, your imported Investments should appear there.