How to convert Microsoft Money file

From MTHWiki

Revision as of 15:50, 9 June 2008 by Wikiadmin (Talk | contribs)
Jump to: navigation, search

Contents

Converting data from Microsoft Money file

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

Here is a step-by-step instructions:

  • Create an account 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 Account transactions. If the Account 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 Account transaction option.


Microsoft Money 2004 or 2003

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

Image:C1.jpg

  • 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.

Image:C2.jpg

  • In the Rows & Columns tab, in the Include fields area, select the Memo, Account, Cleared status, and Category options.
  • In the Subtotal by field, select None.
  • Select the Show splits checkbox, and then click OK.
  • In the Accounts field, select All Accounts.

Image:C4.jpg

  • In the Date range field, select All dates.

Image:C3.jpg

  • In the Category field, select All Categories.

Image:C7.jpg

  • In the Payee field, select All Payees.

Image:C6.jpg

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

Image:C8.jpg

  • When the transfer is complete, click OK.


Next Steps

  • Close Microsoft Money.
  • Open MyMoney, select File-Import-Import Microsoft Money.

Image:C9.jpg

  • Review your transactions for accuracy.
  • Reconcile your converted data before adding new data (the Data Converter does not retain the reconciliation state of your accounts).
  • 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:

 
Num,Date,Payee,C,Account,Memo,Category,Amount

,9/19/06,INTEREST PAYMENT,E,Citibank Online Interest Checking,INTEREST,Income/Interest,0.4

Please note that:

  • 1) There are 8 fields separated by commas
  • 2) The fields are: Num,Date,Payee,C,Account,Memo,Category,Amount
  • 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 9/19/06, or September 19th, 2006.

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 Account Manager tab, your imported accounts and balances should appear there. If you mark any of the accounts as favorites they will also appear in the chart of accounts on the Transaction Register tab.

Personal tools