User Tools

Site Tools


gl_-_bank_reconciliation

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
gl_-_bank_reconciliation [2015/06/10 14:59 (9 years ago)] – [OFX file Format] cliffgl_-_bank_reconciliation [2019/08/26 13:42 (5 years ago)] (current) – [OFX file Format] craig
Line 72: Line 72:
 <STMTTRN><TRNTYPE>SRVCHG<DTPOSTED>20150529172447.000[-5:EST]<TRNAMT>-1.82<FITID>15149153052514253474570000<MEMO>OVERDRAFT INTEREST CHARGE;Branch Transaction</STMTTRN> <STMTTRN><TRNTYPE>SRVCHG<DTPOSTED>20150529172447.000[-5:EST]<TRNAMT>-1.82<FITID>15149153052514253474570000<MEMO>OVERDRAFT INTEREST CHARGE;Branch Transaction</STMTTRN>
 </code> </code>
 +
 +=== OFX files missing line breaks ===
 +Some exports are missing the line breaks at the end of each tag. It looks like 
 +<code><OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>OK</STATUS></code>
 +instead of
 +<code>
 +  <OFX>
 +    <SIGNONMSGSRSV1>
 +    <SONRS>
 +    <STATUS>
 +    <CODE>0
 +    <SEVERITY>INFO
 +    <MESSAGE>OK
 +    </STATUS>
 +</code>    
 +Here is how they can fix the file format. They can use the qfx for ofx file format. 
 +
 +  * Download notepad++ from https://notepad-plus-plus.org/   They must use notepad++ as most other search and replace editors do not have the regular expression option.
 +  * Open the file in netpad++
 +  * Select Search, Replace.
 +  * Find <
 +  * Replace with \n<
 +  * Search mode = Extended 
 +  * Replace All,
 +  * Save with a new file name and then import into System Five.
 + 
 +
 +
gl_-_bank_reconciliation.txt · Last modified: 2019/08/26 13:42 (5 years ago) by craig