You cannot link an existing account as a cash or a contribution account to an investment or a retirment account in Money (199439)



The information in this article applies to:

  • Microsoft Money 2007 Deluxe
  • Microsoft Money 2007 Home & Business
  • Microsoft Money 2007 Premium
  • Microsoft Money Deluxe 2006
  • Microsoft Money Premium 2006
  • Microsoft Money Small Business 2006
  • Microsoft Money Standard 2006
  • Microsoft Money 2005 Deluxe
  • Microsoft Money 2005 Premium
  • Microsoft Money 2005 Small Business
  • Microsoft Money 2005 Standard
  • Microsoft Money 2004 Deluxe
  • Microsoft Money 2004 Premium
  • Microsoft Money 2004 Small Business
  • Microsoft Money 2004 Standard
  • Microsoft Money 2003 Deluxe
  • Microsoft Money 2002
  • Microsoft Money 2001
  • Microsoft Money 2000
  • Microsoft Money 2000 Business and Personal
  • Microsoft Money 99
  • Microsoft Money 98
  • Microsoft Money 98 Deluxe Edition
  • Microsoft Money 98 Financial Suite

This article was previously published under Q199439

SYMPTOMS

In Microsoft Money, you cannot change an existing account to become an associated cash account for a new investment account.

CAUSE

This behavior is by design. When you create an investment account, you can associate a cash account at that time.

RESOLUTION

To work around this issue, copy the transactions from an existing account to an associated cash account. To do this, follow these steps.

Enable a cash account

To make sure that your investment account or your retirement account has its associated cash or contribution account enabled, follow these steps:
  1. Locate the Account list.
  2. Right-click the investment account that you want, and then click See Account Settings. In earlier versions of Money, right-click the investment account that you want, and then click Account Details.
  3. Scroll down to see if Cash Portion Details is listed. If Cash Portion Details is not listed, select Option to Track Cash Transactions. To do this in Microsoft Money 2004 and later versions, click Rename next to the account name.

Transfer transactions

Note In the main investment or retirment account, the Transfer field for each investment transaction lets you select a cash type account. It does not have to be the associated cash or contribution account.

To transfer transactions from one account to another, follow these steps:
  1. On the File menu, click Export.
  2. When you are prompted with the question What format would you like to export in?, click Loose QIF, and then click OK.
  3. Type a filename with a .qif extension, and then click OK.
  4. Click either Regular, and then click OK.
  5. In the Account list box, select the account that has the existing cash transactions, and then click Continue.
  6. When you are prompted with the message Export is Complete, click OK.
  7. On the File menu, click Import.
  8. Click the file name you want, and then click Import.

    Note If you are prompted to back up, do so, and then continue to the next step.
  9. Click the account where you want to move the data (the investment (cash) account), and then click OK.
  10. When you are prompted with the message Import is Complete, click OK.
  11. Verify that the data in the cash account is accurate and does not have duplicate entries.
There may have been some existing transactions in this cash account if the associated investment or retirement account had transactions with transfers to or from this account.

You can delete or close the original "cash" account. Fore more help, see the Help file in Money.

Modification Type:MinorLast Reviewed:7/3/2006
Keywords:KB199439