Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to troubleshoot error messages that you may receive when you import OFX statements into Money
Article ID: 179836 - View products that this article applies to.
This article was previously published under Q179836
NoticeIf 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?
When you try to download statement information from your financial institution or from your brokerage house, you may receive an error message that resembles one of the following:
There was a problem with the data received from your financial institution. If this problem persists, call the Customer Support number for your financial institution, listed on the Contact Information tab in the Online Banking area.
Or, if you try to import an Active Statement file that has an OFX extension, you may receive the following error message:
Your last call encountered an error.
The file 'path\file name.ofx' is not recognized by Money as an Active Statement file. No information has been added to your Money file.
This problem may occur if the *.ofx file that you are downloading or the response file that was sent for your statement request is not correctly formatted according to the Open Financial Exchange (OFX) standards that Microsoft Money expects.
A specific error code in the ofx/response file may also identify the problem. This is a number following CODE that is eight to 10 lines under the header in the OFX file or statement response.
Look up the error code number in the "Microsoft Money OFX Error Messages" document. To download this document, visit the following Microsoft Web site:
http://download.microsoft.com/download/a/3/d/a3da081d-333e-4c5b-8029-815a932e5b19/OFX_Error_Messages.docThis issue can also be caused by an incorrect account number or a problem with the current set up of your online services.
The following causes for these error messages are listed in the order of frequency:
To resolve this issue, try to connect again, and then force Money to save log files. Once you have collected the log file, you can review it for specific error codes and troubleshoot them accordingly. If there are no error codes or you cannot resolve the issue, you may need to contact your financial institution so that they can resolve the formatting error.
Note The financial institution that creates the response files and Active Statement files is responsible for formatting the files correctly.
Capture the Log files from the connection between Money and your financial institution
For more information about how to capture log files, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/911941/ )How to capture an OFX log file in Money
Note After you capture the log files, it is advised that you contact your financial institution to walk through the analyzing of the files. If you would like to analyze the files on your own, please proceed with the following steps to determine what is causing the error.
Analyze the data fileMicrosoft has created tools to enable our financial institution partners to verify the formatting of files that are sent to Money users. http://www.microsoft.com/money/fi/tools.mspx
The following tools are available from the Microsoft Partner support site:
Use Ofxanlyz.exeTo verify that the contents of the response file are correctly formatted, each response is the correct length, and each response has the correct sign for tag values, follow these steps:
Verify the headerTo verify that the header of the OFX response file contains the required components, follow these steps:
Check for missing cookieEvery Cookie in an OFX request file must have an answering Cookie in the response file. To see whether a missing Cookie is the cause of the error, follow these steps.
Checking for Corresponding ResponsesEvery tag in a request file must receive a corresponding response, even if the response is empty. To verify that every request has a response, follow these steps:
If you and your financial institution determine that this issue did not occur because of a formatting error, try to disable and then re-enable online services for this financial institution.
To work around this issue, download the statement in a different format. Typically when you download the statement from the bank's Web site, you can specify the format that you want to use. If you have problems downloading in the Active Statement format (OFX), select the option to download in the QIF format instead.
For more information about other issues or difficulties with downloadig your online statements, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/889930/ )How to troubleshoot issues that you may experience with the online download of Microsoft Money
Article ID: 179836 - Last Review: February 11, 2011 - Revision: 17.0