How to convert Microsoft Money file

From MTHWiki

(Difference between revisions)
Jump to: navigation, search
m (Reverted edits by Ogixidoni (Talk); changed back to last version by Wikiadmin)
Current revision (13:42, 24 November 2010) (edit) (undo)
m (Protected "How to convert Microsoft Money file" [edit=sysop:move=sysop])
 

Current revision

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


Next Steps

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


If File-Import options is missing in MY Money it means that you don't have an opened database to import your data into. Please start a new File first, using File - New - New File. Please place it into a location that you will remember later on, for example Documents/Financials.

Once you have a new file to import data into then Import options will become available


Troubleshooting

File Format Issues

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.


Reconciled Transactions are missing

Under certain circumstances reconciled transactions could be missing from a Microsoft Money generated CSV file.

To correct this please make sure that "Reconciled and Not Reconciled Transactions" is selected, as illustrated below in a French version of an appropriate Microsoft Money export dialog

Image:Details.png


VAT Import

In some European versions Microsoft Money allows to export VAT information. If this is present in your version of Microsoft Money, please uncheck this box, VAT information should not be present in the export file


Non-ASCII Characters Disappear

Microsoft generates CSV files to be US-ASCII Character set compatible, which means that some characters can disappear of get corrupted. For example à could be replaced by , é by È, etc. Once CSV is generated with corrupt characters they will get transferred into My Money verbatim.


The easiest way to address this is to open CSV file in a text editor before the conversion and search and replace for the corrupt characters. You will need to save the CSV back into an encoding that support extended characters set, for example UNICODE encoding.

Personal tools