Importing a QIF file that conforms to the format documented in http://xl2qif.chez-alice.fr/download/QIF99.pdf can abort with "Date format errors" even though all the date fields are in ISO 8601 Skrooge/Linux format. The error is due to the import process assuming all lines beginning with "D" are date fields, but there are sections of the QIF file where the "D" field is used for a Description. At least the presence of a Description in an Account Definition, Category and Budget will raise this error. It may also occur in the Security, Payee and Class sections of the QIF file, but that wasn't tested/observed. The error message produced is somewhat ambiguous because it doesn't identify where in the QIF file the error was seen, and in this case the error itself is incorrect as it's not a QIF file format error, it's a Skrooge processing error.
Could you provide me a QIF sample file to reproduce the issue ?
!Option:AutoSwitch !Account NAIM D5009091932 X ABrokerage TPort B0.00 ^ NAmerican Express D3700-000000-06009 L15,500.00 X ACredit Card TCCard B0.00 ^ !Clear:AutoSwitch !Type:Cat NAuto DAutomobile Expenses E ^ NAuto:Fuel DAuto Fuel E ^ NAuto:Insurance DAuto Insurance E ^ !Type:Payee !Type:Cat NAuto DAutomobile Expenses E ^ NAuto:Fuel DAuto Fuel E ^ NAuto:Insurance DAuto Insurance E ^ !Type:Budget NAuto DAutomobile Expenses B-5.00 B-5.00 B-5.00 B-5.00 B-5.00 B-5.00 B-5.00 B-5.00 B-5.00 B-5.00 B-5.00 B-5.00 ^ NAuto:Fuel DAuto Fuel B-84.00 B-84.00 B-84.00 B-84.00 B-84.00 B-84.00 B-84.00 B-84.00 B-84.00 B-84.00 B-84.00 B-84.00 ^ NAuto:Insurance DAuto Insurance B0.00 B0.00 B0.00 B0.00 B0.00 B0.00 B0.00 B0.00 B0.00 B0.00 B0.00 B0.00 ^ !Type:Class NSample Class DTesting purposes only ^ NSample Class:Sample subclass DJust another test ^ !Account NAIM D5009091932 X ABrokerage TPort B0.00 ^ !Type:Invst D1996-07-19 NShrsIn YAIM Value Fund I28.830 Q260.219 CX T0.00 MFrom IDS Savings ^
Git commit 1ba4d7e60a35331a236b0a35a21ba93c69ffe85b by Stéphane MANKOWSKI. Committed on 20/12/2025 at 12:25. Pushed by smankowski into branch 'master'. QIF import errors M +1 -0 CHANGELOG M +4 -0 plugins/import/skrooge_import_qif/skgimportpluginqif.cpp A +116 -0 tests/input/skgtestimportqif2/513589.qif M +14 -0 tests/skgbankmodelertest/skgtestimportqif2.cpp https://invent.kde.org/office/skrooge/-/commit/1ba4d7e60a35331a236b0a35a21ba93c69ffe85b