Importing QFX files into Money 2003 (downloaded financial statemen


H

H Luedke

I have noticed that some people have issues trying to import QFX files and
are getting error messages.


"The file you attempted to import appears to be invalid or contains corrupt
data. Please download the file again. If this problem continues, please
contact your financial institution."

I was getting this when trying to import a QFX file from an AIM TRIMARK RRSP
account that only offers QFX downloads. I was importing into Money 2003
Deluxe & Business


I have already done the registry edit so that Money recognizes QFX files
(you could also just rename the file to .ofx extension). It will ignore the
extra tags for Quickens call home feature.

The file is a standard 1.02 version QFX file: (Header from file)

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

<OFX>


What I fould the problem was is that this particular QFX file did not follow
the order as specified in the OFX 1.02 specifications.

By using the OFX analyzer that is available for download from microsoft I
found that the QFX file had two areas (in my case) that tags did not follow
the order specified in the 1.02 specification.

In <REINVEST> tags, the QFX file as provided by AIM has the UNITS and
UNITPRICE in the wrong spot in order to meet the OFX standard) When Money
checks the file it notes that UNITS is in the wrong spot and immediately
rejects the file.

<REINVEST>
<INVTRAN>
<FITID>DIVxxxxxxxxxxxxxxxxxxxxxxxx
<DTTRADE>20051220
<DTSETTLE>20051220
<MEMO>This is a reinvest transaction
</INVTRAN>
<SECID>
<UNIQUEID>TRI1651
<UNIQUEIDTYPE>CANMFID
</SECID>
<INCOMETYPE>DIV
<UNITS>15.355
<UNITPRICE>6.07
<TOTAL>93.25
<SUBACCTSEC>OTHER
</REINVEST>

By putting the UNITS and UNITPRICE in the correct spot, the file can be
imported.

<REINVEST>
<INVTRAN>
<FITID>DIVxxxxxxxxxxxxxxxxxxxxxxxx
<DTTRADE>20051220
<DTSETTLE>20051220
<MEMO>This is a reinvest transaction
</INVTRAN>
<SECID>
<UNIQUEID>TRI1651
<UNIQUEIDTYPE>CANMFID
</SECID>
<INCOMETYPE>DIV
<TOTAL>93.25
<SUBACCTSEC>OTHER
<UNITS>15.355
<UNITPRICE>6.07
</REINVEST>


The same issue occurs for <TRANSFER> with regard to the position of
<SUBACCTSEC> being in the wrong location for the specification.


<TRANSFER>
<INVTRAN>
<FITID>589xxxxxxxxxxxxxxxxxxxxxxx
<DTTRADE>20051003
<DTSETTLE>20051004
<MEMO>Reversal/Adjustment
</INVTRAN>
<SECID>
<UNIQUEID>TRI501
<UNIQUEIDTYPE>CANMFID
</SECID>
<UNITS>50.237
<TFERACTION>IN
<POSTYPE>LONG
<SUBACCTSEC>OTHER
</TRANSFER>

by moving it to the location specified in the 1.02 standard, money can
import the file:


<TRANSFER>
<INVTRAN>
<FITID>589xxxxxxxxxxxxxxxxxxxxxxx
<DTTRADE>20051003
<DTSETTLE>20051004
<MEMO>Reversal/Adjustment
</INVTRAN>
<SECID>
<UNIQUEID>TRI501
<UNIQUEIDTYPE>CANMFID
</SECID>
<SUBACCTSEC>OTHER
<UNITS>50.237
<TFERACTION>IN
<POSTYPE>LONG
</TRANSFER>

As far as I can tell, the QFX files could be used by those using Microsoft
Money if the files were presented with the data in the correct position as
specified by the OFX 1.02 specifications. I don't know whether Quicken cares
or not about the position of the tags in the file, but the Microsoft importer
certainly does. I would think that providing the data in the specification
order would not affect Quicken users, but this could simply be tested.

The two examples above were the only issues I found in trying to import the
Quicken file into Money. By correcting all occurrences I am able to import
the file. There may be other transaction types that were not in my specific
file that may cause money to fail because they do not follow the order set
out in the specification but I have no way to verify them. My suggestion
would be to follow the specification for all tag types in the 1.02 specs.

My only other thought is that maybe Quicken or AIM TRIMARK has does this
intentionally to prevent Money users from importing Quicken data.

I am just posting this so hopefully if anyone else is trying to import QFX
files into Money and they get error message that the file is corrupt that
this may be the answer.


I have told AIM about this because it seems it would be so simple to support
Money users by just making the file they provide match the specifications.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

importing qfx files 2
Importing QFX Files 6
QFX File Imports 6
Importing QFX files 4
money 2005 qfx file import 6
Downloading "QFX" Files to Money 2004 1
Importing .qfx file to Q2000 9
Re-importing a QFX file 0

Top