QIF files created by csv2ofx fail to be imported by GnuCash

djmuhlestein / csv2ofx

Convert CSV files from Yodlee (or other sources) into OFX files for import into other financial software.

66 stars 28 forks source link

QIF files created by csv2ofx fail to be imported by GnuCash #2

Open MountainX opened 15 years ago

MountainX commented 15 years ago

I'm running GnuCash 2.2.9 on Ubuntu 9.04. The QIF file created by csv2ofx from Yodlee data fails without an explanation in GnuCash. I think it is a date format issue. The Yodlee date format is like this: 2009-09-03 (e.g., YYYY-MM-DD). I think the QIF format expects the year to be last (maybe MM-DD-YYYY).

MountainX commented 15 years ago

I temporarily worked around this by opening the Yodlee CSV file in Open Office and then saving again as a CSV file. Doing this changes the way the dates are written.