Discover Card transactions


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).

– ameridan

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: