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 revision Previous revision
Next revision
Previous revision
gl_-_bank_reconciliation [2015/06/10 14:59]
cliff [OFX file Format]
gl_-_bank_reconciliation [2019/08/26 13:42] (current)
craig [OFX file Format]
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.1433973573.txt.gz ยท Last modified: 2015/06/10 14:59 by cliff