Foreign Shares reassigned to Domestic Shares when converting a MS Money file to Quicken

Legacy KB ID: 4713

Question

Why are my foreign shares included in domestic shares when I convert my MS Money file to Reckon Accounts Personal Range (formerly Quicken) using the Data Converter?

Answer

Accounts Personal (formerly Quicken) cannot convert all components of a MS Money file.  Please refer to the Data Converter Guide on the Installation Disk (CD>HAB>DISK!>mny2qdf) for a full list of components that will convert and those that will not convert.

The Data Converter cannot maintain the specifications of foreign shares.  Foreign shares will have their currency set to the domestic currency and assigned to the domestic shares list.  Although you can edit the share and set its specifications to its foreign market, you cannot change the currency of the share – the share will remain in the domestic currency. 

The monetary balance of foreign brokerage accounts will be transferred. 

Note: the data conversion cannot maintain the integrity of Investment Accounts and Investment Transactions.  The balances and transactions that are converted may not be accurate or may not display properly in reports. 

 

Workaround

You cannot use the Data Converter to convert Microsoft Money files containing share transactions. 

You can export account transactions from each MS Money account into a separate export file and then import them manually into a blank Accounts Personal file.  You must omit all Investment accounts.

 

  1. MS Money > File > Export > Strict QIF > OK;
  2. Browse to export location & enter a filename > OK;
  3. Select to export a 'Regular' account type (IE: bank, credit card, cash, asset & liability);
  4. Select the account you wish to export > Continue > OK;
  5. Repeat steps 1-4 for each account you wish to transfer to Quicken;
  6. Open Accounts Personal;
  7. Setup new accounts that you have exported from Money in Accounts Personal & use the same name & account type;
  8. Delete opening balance transaction from these new empty accounts;
  9. Accounts Personal > File > Import > QIF;
  10. Browse to your Money QIF;
  11. Select the Accounts Personal account to import the data into;
  12. Tick 'transactions' only;
  13. Select the Australian date format;
  14. Click OK;
  15. Go to the account register & click the 'Downloaded Transactions' tab;
  16. Here you can accept/edit each transaction individually or accept all transactions;
  17. Review your transactions to ensure data has imported correctly;
  18. Repeat steps 10-18 for each Money QIF.

 

Create Investment Accounts in your new Accounts Personal datafile.  Use your Investment account balances in Microsoft Money as your opening positions in the new Accounts Personal data file.

Please note:  some functions that are associated with linking sales to purchases will not be available for the transactions in the opening position. These include:

1.            Matching sales to particular buying lots;

2.            Correct calculation of estimated Capital Gains Tax liability.

 

How did we do?

Customising a Cash Flow Report

The date on some reports gets "erased" when you scroll right then left

Related Articles

Account Balances incorrect after converting a MS Money file to Quicken
Converting Quicken Data to QuickBooks 2004
Converting an Estimate to an Invoice in Quicken
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)