OFX import - role of FITID for matching

[Andy Den Tandt]

I want to import an OFX file into my usual data file, GnuCash but GnuCash
only shows (and imports) a few transactions. The majority are not shown. A
bit of troubleshooting shows that the FITID in the OFX is a key factor here.

 

My oldest transactions don't have a transaction number in my GnuCash file
(<trn:num> in the raw XML). I probably imported them from CSV files. At a
certain point in time, my bank started providing OFX. From that point in
time, I have transaction numbers starting at 0150 and increasing; but when a
new year starts, my bank starts numbering from 1 again.

 

So my transaction numbers in GnuCash are like: empty,..,empty, 0150, 0151,
., 0220, 0221, 0001, 0002, . 0145, 0146.

 

I'm now importing an OFX file and the FITID's in there start at 0147. The
import wizard of gnucash only shows the first 3 statements. I suspect that
GnuCash thinks that the FITID of 0150 already matches an existing
transaction and does not need to be imported. (I.e. 0150 of year 2009 is
mistaken as identical to 0150 of year 2010).

 

Do you have any suggestions on how I should proceed here? Is this a
bug/missing feature in GnuCash? Is my bank abusing the OFX format? My idea
now is a search&replace in the OFX file converting FITID=0150 into FITID
20100150. 

 

I'd like some feedback from the guru's first so that I find myself facing
new problems later.

 

PS. running gnucash 2.2.9 on Vista

 

Kind regards,

 

Andy