System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
The bank rec import converts an OFX file (open financial exchange) to an XML file. If you locate your .OFX file you should see a corresponding .XML file. Simply double click on this file to open in Internet explorer. Scroll down to the bottom of the file to see if you have an error message or a problem in the XML document. Often the problem may be resolved by editing the OFX file and fixing the problem.
The ofx file format is similar to below. The file can be viewed with notepad to determin if you have an OFX file.
OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:TYPE1 ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:NONE <OFX> <SIGNONMSGSRSV1> <SONRS> <STATUS> <CODE>0 <SEVERITY>INFO <MESSAGE>OK </STATUS> <DTSERVER>20060404160753[-5:EST] <USERKEY>--NoUserKey-- <LANGUAGE>ENG <INTU.BID>00002 </SONRS> </SIGNONMSGSRSV1> <BANKMSGSRSV1> <STMTTRNRS> <TRNUID>QWEB - 200604041607537951 <STATUS> <CODE>0 <SEVERITY>INFO <MESSAGE>OK''
<STMTTRN><TRNTYPE>SRVCHG<DTPOSTED>20150529172447.000[-5:EST]<TRNAMT>-1.82<FITID>15149153052514253474570000<MEMO>OVERDRAFT INTEREST CHARGE;Branch Transaction</STMTTRN>
Some exports are missing the line breaks at the end of each tag. It looks like
<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>OK</STATUS>
instead of
<OFX> <SIGNONMSGSRSV1> <SONRS> <STATUS> <CODE>0 <SEVERITY>INFO <MESSAGE>OK </STATUS>
Here is how they can fix the file format. They can use the qfx for ofx file format.