OFX and QFX are identical for the data used by GnuCash. There is some additional marketing data in QFX that Quicken inserts in the QFX headers, but Gnucash ignores that.
The biggest win for OFX is that the unique FITID number in each transaction makes it extremely easy for the importer to automaticallly avoid duplicate transactions in sequential downloads from showing up in your data file. Unfortunately, some banks botch the FITID generation, which creates problems. Citibank uses date+4 digit sequence number to generate FITID numbers. And they appear to be regenerating the QFX file every time you request data. So I’ve had old transactions proposed as new entries because on sequential days, Citi changed the FITID on one or two transactions. Gnucash’s QIF importer does a reasonable job of trying to identify duplicates as already entered, but it requires manual intervention for each transaction. The QIF format has some gray areas that different banks interpret differently. The oddities can cause problems. The CSV importer works way better than it used to. I haven’t figured out all the details. I’m getting experience because more and more financial institutions are bailing on QFX entirely. -- Dave Reiser dbrei...@icloud.com > On Dec 28, 2024, at 16:47, Simon Roberts <si...@dancingcloudservices.com> > wrote: > > Hi all, is there any wisdom regarding which transaction import formats are > preferred given a choice of CSV, QXF, and QIF. I am adding a new credit > card company and these are the options. I've used OFX and CSV in the past > (so I know how to configure a CSV import). And it seems, from the import > menu, that QXF and OFX might be similar / identical? > > But if you had this choice, which route would you be inclined to take? > > TIA, > Simon > > -- > Simon Roberts > 303 249 3613 > https://www.youtube.com/@DancingCloudServices > https://www.linkedin.com/in/simonhgroberts/ _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
