How to troubleshoot issues that you may experience when you try to download and import a statement from your financial institution into Money

Article translations Article translations
Article ID: 829143 - View products that this article applies to.
Notice
If you've been managing your finances with the help of Microsoft Money, you should be aware that Microsoft discontinued all online services and assisted support for all versions of Money on January 31, 2011. (Microsoft discontinued sales of Money on June 20, 2009.) If you're looking for an alternative program, Microsoft has made the Money Plus Sunset versions available as a replacement for the following expired programs: Microsoft Money Essentials, Microsoft Money Deluxe, Microsoft Money Premium, Microsoft Money Home, and Microsoft Money Business. For more information about Money Plus Sunset, refer to this article in the Microsoft Knowledge base: What Is Microsoft Money Plus Sunset?
Expand all | Collapse all

On This Page

SYMPTOMS

When you try to download and import a statement from your financial institution by using one of the programs that is listed in the "Applies To" section, you may experience one of the following symptoms:
  • You receive the following error message:
    This action is only valid for products that are currently installed.
    The file you attempted to import appears to be invalid or contains corrupt data. Please download the file again. If this problem continues, contact your financial institution.
  • After you download online statements from your financial institution, Microsoft Money indicates that there are statements to be read. However, you may be unable to view the downloaded transactions in the account register.
  • The download process appears to work correctly. However, the statement does not open.

    Note You do not receive an error message, and the Web site stops responding.
  • You are prompted for a program to open the downloaded file.
  • Account Balances for a specific account display differently between the Account Register view and the Account List view.
  • After you download a statement and matching transactions, you may be unable to accept specific transactions that were transfers from another account.

    Note You have to run the Standard Repair feature in Money to resolve this specific issue. To do this, follow the steps listed in Method 1 in the "Resolution" section.

CAUSE

This issue may occur if one of the following conditions is true:
  • Apple QuickTime for Windows is installed on the computer. The QIF file name extension can be associated with both Money and QuickTime for Windows. When you try to import a QIF file, QuickTime may convert the file into a format that Money cannot recognize.
  • The size of temporary Internet files is over the Amount of disk to use setting in Microsoft Internet Explorer.
  • A damaged file is located in the Temporary Internet files folder.
  • The statement was not downloaded correctly.
  • The Money file is damaged.
  • The file that was downloaded from the financial institution is formatted incorrectly.
  • The file type of the downloaded file is not associated with Money.
If you are receiving an error message when you try to download the statement from your Financial Institution, you may have to use different troubleshooting steps to resolve the issue.

The file that you downloaded contains double quotation marks around the payee name. This is a formatting issue that is controlled by the financial institution that provides the downloaded file. For more information, see the "Advanced troubleshooting" section.

For more information about how to troubleshoot error messages, click the following article number to view the article in the Microsoft Knowledge Base:
179836 How to troubleshoot error messages when you import OFX statements into Money

RESOLUTION

To resolve this behavior, use the following methods in the order that they appear in.

Method 1: Repair the Money file

For more information about how to repair damage to the Money data file, click the following article number to view the article in the Microsoft Knowledge Base:
182608 How to diagnose and repair damage in a Money data file
Verify that the downloaded transactions are listed as expected in bold text in the account register. If this method does not resolve the issue, go to the next method.

Method 2: Empty the Temporary Internet Files folder

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Open Internet Options. To do this in Windows Vista, click Start
    Collapse this imageExpand this image
    the Start button
    , type Internet Options in the Start Search box, and then click Internet Options in the Programs list.

    Collapse this imageExpand this image
    User Account Control permission
    If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.

    To open Internet Options in Windows XP and earlier versions, click Start, click Run, type inetcpl.cpl, and then click OK.
  2. In the Temporary Internet files pane, click Delete Files.

    When you are prompted to confirm the deletion, click OK.
  3. Click OK to close the Internet Options dialog box, and then close Control Panel.
  4. Start Money.
If this method does not resolve the issue, go to the next method.

Method 3: Show Standardized Payee names

  1. Start Money.
  2. On the Tools menu, click Settings.
  3. Click Online service settings.
  4. Click to select the Show standardized payee names for which a name match is not found check box.
  5. Click OK.
  6. Read your statement.
If this method does not resolve this issue, go to the next method.

Method 4: Delete the old statement and download a new copy of the statement

Note If you saved any OFX or QIF statement files on the computer, delete or rename them before you follow these steps.
  1. Start Money.
  2. Open the Account list. To do this, follow these steps:
    1. In Microsoft Money 2005 and later versions of Money, click Account List on the Money Home page.
    2. In Microsoft Money 2001 through Microsoft Money 2004, click Accounts & Bills, and then click Account List.
  3. Right-click Transactions to Read, and then click Delete Statement.
  4. When you are prompted to continue to delete the statements, click OK.
  5. Connect to the Web site for your financial institution, and then download the new statement.

    Note The procedure to download a statement from a Web site may vary. For more information about how to download a statement, visit your financial institution's Web site.
If this method does not resolve this issue, go to the next method.

Method 5: Verify the Microsoft Internet Explorer settings

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Open Internet Options. To do this in Windows Vista, click Start
    Collapse this imageExpand this image
    the Start button
    , type Internet Options in the Start Search box, and then click Internet Options in the Programs list.

    Collapse this imageExpand this image
    User Account Control permission
    If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.

    To open Internet Options in Windows XP and earlier versions, click Start, click Run, type inetcpl.cpl, and then click OK.
  2. On the Advanced tab in the Security section, click to clear the Do not save encrypted pages to disk check box.
  3. Click OK to close the Internet Options dialog box, and then close Control Panel.
  4. Start Money.
If this method does not resolve this issue, go to the next method.

Method 6: Verify the file associations

  1. Open Folder Options. To do this in Windows Vista, click Start
    Collapse this imageExpand this image
    the Start button
    , type Folder Options in the Start Search box, and then click Folder Options in the Programs list.

    Collapse this imageExpand this image
    User Account Control permission
    If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.

    To open Folder Options in Windows XP and earlier versions, click Start, click Run, type Control folders, and then click OK.
  2. Double-click Folder Options.
  3. On the File Types tab in the Registered file types list, click OFX in the Extensions column.
  4. Click Delete, and when you are prompted to confirm deleting the file, click Yes.
  5. Repeat steps 3 and 4 for the file name extensions QIF and OFC.

    Note The OFC format is no longer supported in Money 2005 and later versions of Money. For more information about how to troubleshoot OFC downloads, click the following article number to view the article in the Microsoft Knowledge Base:
    890400 The import of the .ofc file fails when you try to download and then import an Open Financial Connectivity (OFC) statement from your financial institution in Money 2005
  6. Click Close.
  7. Download the file from your financial institution, select Microsoft Money when you are prompted for a program to use to open the file, click to select the Always use this program to open this file check box, and then click OK.
If this method does not resolve the issue, go to the next method.

Method 7: Use standardized payee names

  1. Start Money 2006, and then click Settings on the Tools menu.
  2. Click Online service settings, and then click to select the Show standardized payee names for which a name match is not found check box.
  3. 3. Click OK, and then check whether the issue still occurs.

Method 8: Remove and then reinstall Money

For more information about how to remove and reinstall Microsoft Money, click the following article numbers to view the articles in the Microsoft Knowledge Base:
895866 How to remove and reinstall Microsoft Money


Note If you are running any antivirus programs, temporarily disable them when you install Money.

Advanced troubleshooting

Examine the formatting of the financial institution statement

Note You may want to view this file together with your financial institution.

If your statement contains special characters in the payee or account name or in the payee or account memo or description, Money may be unable to read this information. To look for special characters, from the folder options, change the file type of OFX to Confirm after download. To do this, follow these steps:
  1. Click Start, click Control Panel, and then double-click Folder options.
  2. On the File Types tab, click the file type (OFX) that you want to change, and then click Advanced.
  3. Click to select the Confirm open after download check box, and then click OK.
  4. Download the file from your financial institution. When you are prompted to, save the file on the desktop.
  5. Right-click the file, and then open the OFX file by using WordPad.
  6. Search for any special characters in the <NAME>, <DESC> and <MEMO> tags. If the file is large, you can use the Find option in WordPad to search for the following special characters:
    • < (Greater than)
    • > (Less than)
    • [ (Left square bracket)
    • ] (Right square bracket)
    • " (Quotation marks)
    • : (Colon)
    • & (Ampersands)
    If any special characters are found, replace all instances of these special characters with a space.
When you are finished, save the OFX file. Open the Microsoft Money data file, and then open the Account List. You should see the option for Transactions to read listed next to your account. Right-click Transactions to read, and then select Delete Statement. Re-import the file that you saved in step 6.

Note This problem is caused by the way that the information was packaged in the OFX file. If this issue continues to occur, contact your financial institution to inform them that an incorrect character was used in the OFX file. Some versions of Money are stricter with regard to the OFX specifications for special characters than other versions. So, you may notice that one version of Money may import the file fine where a different version does not.
  1. Use a program such as Notepad or WordPad to manually open the OFX file.
  2. Delete half the transaction lines, and then import the online statement. To do this, locate File, and then select Import in Money.
If these steps resolve the issue, we know that the problematic line is part of the lines that we deleted. If the issue continues, we know that the problematic line is still in the file. Continue steps 1 and 2 until you determine the transaction line. At this point, you have two options. You can delete the full transaction line, or you can examine the line to determine the character that is located in this line that is causing the issue. If you delete the line, manually type it in. If you delete the character that is causing the problem, save the file. After you save the file, try to re-import the file into Money.

Note This problem is caused by the way that the information was packaged in the OFX file. If this issue continues to occur, contact your financial institution to inform them that an incorrect character was used in the OFX file.

If your statement contains special characters in the payee name, Money may be unable to read this information.

To look for special characters, follow these steps:
  1. From the folder options, change the file type of OFX to Confirm after download. To do this, follow these steps:
    1. Click Start, click Control Panel, and then double-click Folder options.
    2. On the File Types tab, click the file type (OFX) that you want to change, and then click Advanced.
    3. Click to select the Confirm open after download check box, and then click OK.
  2. Download the file from your financial institution. When you are prompted to, save the file on the desktop.
  3. Right-click the file, and then open the OFX file by using WordPad.
  4. Search for any special characters in the <NAME> and <MEMO> tags. If the file is large, you can use the Find option in WordPad to search for the following special characters:
    • < (Greater than)
    • > (Less than)
    • " (Quotation marks)
    • & (Ampersands)
  5. If any special characters are found, replace all instances of these special characters with a space.
  6. When you are finished, save the OFX file.
  7. Open the Microsoft Money data file, and then open the Account List.
  8. You should see the option for Transactions to read listed next to your account. Right-click Transactions to read, and then select Delete Statement.
  9. Re-import the file that you saved in step 6.

MORE INFORMATION

For more information about other troubleshooting methods, click the following article number to view the article in the Microsoft Knowledge Base:
178830 How to export and import account information in Microsoft Money
For more information about how to run a deeper level of repair on the Money data file, click the following article number to view the article in the Microsoft Knowledge Base:
902466 How to use the Microsoft Money Standard File Repair utility
If you experience issues when you set up your online services, click the following article number to view the article in the Microsoft Knowledge Base:
246544 How to troubleshoot setting up or connecting to your financial institution
If the issue that you are experiencing is actually with duplicate account information being downloaded, click the following article number to view the article in the Microsoft Knowledge Base:
889926 Duplicate accounts are created after you set up Money 2005 or Money 2006 to download your online information
If the issue that you are experiencing is with your statement being downloaded into the incorrect account, click the following article number to view the article in the Microsoft Knowledge Base: For more information, click the following article number to view the article in the Microsoft Knowledge Base:
179836 How to troubleshoot error messages when you import OFX statements into Money

Properties

Article ID: 829143 - Last Review: February 11, 2011 - Revision: 12.0
APPLIES TO
  • Microsoft Money Plus Deluxe
  • Microsoft Money Plus Home & Business
  • Microsoft Money Plus Premium
  • Microsoft Money 2007 Deluxe
  • Microsoft Money 2007 Home & Business
  • Microsoft Money 2007 Premium
  • Microsoft Money 2006 Deluxe
  • Microsoft Money 2006 Premium
  • Microsoft Money 2006 Small Business
  • Microsoft Money 2006 Standard
  • Microsoft Money 2005 Deluxe Edition
  • Microsoft Money 2005 Premium Edition
  • Microsoft Money 2005 Small Business Edition
  • Microsoft Money 2005 Standard Edition
  • Microsoft Money 2004 Deluxe Edition
  • Microsoft Money 2004 Premium Edition
  • Microsoft Money 2004 Small Business Edition
  • Microsoft Money 2003 Deluxe Edition
  • Microsoft Money 2003 Deluxe and Business Edition
  • Microsoft Money 2003 Standard Edition
  • Microsoft Money 2002 Standard Edition
  • Microsoft Money 2002 Deluxe and Business Edition
Keywords: 
kbui kberrmsg kbprb KB829143

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com