In microsoft.public.money, John Smith wrote:

- quote -

Neat. Thanks for the information. It will be useful. I suspect that
you already know about ofx.net having the OFX specs available.
Section 2.2 explains the headers.


- quote -

is in the OFX 2.0.2 spec.

I don't know of a utility you could download to convert the file to
an OFX 2 file. Such a program would require swapping out the
headers, and adding end tags . For example, <SEVERITY> INFO" would
become "<SEVERITY> INFO</SEVERITY> ". In OFX 1, some things get end
tags, and other things do not.

Hi Cal,

I apoligize for the delay in responding. It has been a while since I've had
a chance to spend time on this issue. This is what I've learned.

The file is made available only in the QFX format. As you indicated, it
looks remarkably similar to OFX files that I've seen. However, there are
two sections in particular that prevent it from even starting the import
process.

The first is the header section. This is how it looks when I download it
from Merrill Lynch. If I attempt to import this header as is, it fails. It
is not until I remove the spaces between the labels and values that it will
import.

OFXHEADER: 100
DATA: OFXSGML
VERSION: 102
SECURITY: NONE
ENCODING: USASCII
CHARSET: 1252
COMPRESSION: NONE
OLDFILEUID: NONE
NEWFILEUID: NONE

In addition, the file will not import with the following setion in place.

<INV401K<EMPLOYERNAME> Merrill Lynch</EMPLOYERNAME<PLANID> 606100</PLANID<PLANJOINDATE> 20041201000000</PLANJOINDATE<INV401KSUMMARY<YEARTODATE<DTSTART> 20050101000000</DTSTART<DTEND> 20051201000000</DTEND<CONTRIBUTIONS<PRETAX> 11334.85</PRETAX<TOTAL> 11334.85</TOTAL</CONTRIBUTIONS<WITHDRAWALS<TOTAL> 0</TOTAL</WITHDRAWALS</YEARTODATE</INV401KSUMMARY</INV401K

Now, if I fix the spaces in the header and remove the INV401K section, the
file will start the import process. It is here, however, where things get
really bizarre. While attempting to import the file it will not allow me to
pick a given security/fund from an existing fund in my money file. I can
only guess that this is because there are addition, less obvious differences
in the file.

If you are interested in taking a look at the entire file, please let me
know. My permenant email address is dwayne.cox[at]mci.com.

Thanks in advance for your help.

Dwayne Cox






"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:m4jhb19vlvlps73oqsio26aj2m5hn12spd[at]4ax.com...
- quote -

I know that this topic has come up before. I find that I simply open
the qfx file from TIAA-CREF and import it without either changing the
name or editing anything in the file. When you select import, you will
need to open up the file chooser menu so that you can see the QFX file.
I am not an OFX expert but so many of these files have check sums, I
would not delete anything.

Art

Cal Learner-- MVP wrote:
- quote -

In microsoft.public.money, John Smith wrote:

- quote -

QFX is a ************ of the OFX format.

Look at your QFX file with Notepad. Does it say "OFX" somewhere in
the first several lines of the file?

I compared an OFX file and a QFX file from the same institution.
Numbers in the following comparison are replaced with "n"
characters. Institution name replaces with "x" characters. There was
more information in the files. The QFX file had 6 extra lines.
Otherwise the files were identical. However these were in OFX 1
format. With OFX 2 files, the method may differ.


Comparing files test.ofx and test.QFX
***** test.ofx *******************************
<LANGUAGE> ENG
</SONRS********************************************* *******
***** test.QFX *************************************
<LANGUAGE> ENG
<FI<ORG> xxxxxxxxxxxx</ORG<FID> nnnnnnnnnn</FID</FI<INTU.BID> nnnn
<INTU.USERID> nnnnnnnnn
</SONRS********************************************* *******


So, if you have a similar file, try deleting the extra lines before
the </SONRS> line, and rename the file to *.ofx


If your file does not have lines similar to the above, paste the
beginning lines of your file into a response posting.

As I did, you can replace identifying numbers with "n" and
identifying letters with "x".

Hi Cal,

Thanks for your suggestion. I followed the steps you provided.
Unfortunately, it did not work. I got an error message that said 'The file
.... is not recognized by Money as an Active Statement file. No information
has been added to your money file.'

Its hard to believe that I'm the only one who has had this problem. I cant
find any reference at all to the qfx format on the Microsoft web page. It
would appear that the only way to import this file is to use Quicken.. (

Thanks.. Dwayne



"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:rmqeb152m4q6sucfuc7p3krav78bea59v7[at]4ax.com...
- quote -

In microsoft.public.money, John Smith wrote:

- quote -

To try to use the QFX file as an OFX file in Money, I would
try this:

Rename the file to *.ofx. (this step may not be needed)

Edit the file with a text editor such as Notepad.
Remove the <INTU.BID> including the number that follows, if there
is such a tag.


File-> Import the resulting file into Money.

Let us know how it works for you.

The only format that my 401k provider offers for statement download is QFX
(that is Q as in quicken, not O as in Oscar). Is there anyway to import
this format into Microsoft Money 2004 Premium? The 'convert quicken file'
and 'import' menu options do not seem to work. The process of manually
entering transaction takes forever. Can anyone help me?

Thanks.. Dwayne