Using the OFX download script, my experience thus far results in many transactions duplicating themselves in Money, because the 7th character after the decimal in the transaction ID (FITID) changes. If the OFX download option is chosen from Discover’s website, only the first 3 characters after the decimal show up, leaving me to believe that the last 4 characters need to be “truncated” from the string so that Money processes the transactions properly.
Example:<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20100128170000.000<TRNAMT>-10.85 <FITID>FITID20100130-10.8500005<NAME>CVS/PHARMACY </STMTTRN>
Anyone care to come up with a Python subroutine to accomodate this?
My first inclination is to use the Round(x,3) function on all numerical characters after the decimal between <FITID> and <NAME> (for Discover transactions only).