[GNC-dev] [GNC] QIF file import failed -- but no errors or warnings

Christopher Lam christopher.lck at gmail.com
Thu Feb 20 18:09:03 EST 2020

Sorry to see you go.

You have, in one swoop, uncovered 3 issues:

1. S field being empty is not processed correctly. It would still be nice
if you could attach some screenshots from quicken, and a tiny qif.

2. Duplicated transactions. This happens because I think qif is not limited
to 1 account. If it has more than 1 account and there are internal
transactions, qif importer cannot reliably detect those because the
specification, unlike ofx, does not have a unique transaction ID. Not sure
whether KMyMoney handles this well. Again a small test case is still
welcome to try fix this, including quicken screenshots.

3. Importing stock or multi currency transactions is difficult. The
importer does try to handle it. Ditto test case and screenshots.

Lastly someone else said gnuc 3.1 managed to import; may be worth trying?

On Fri, 21 Feb 2020, 1:46 am James Peterson, <lyle at austin.rr.com> wrote:

> I appreciate your responses to my postings -- you really helped
> me find why gnucash did not like my particular QIF file.
> But once I got past that, it's clear that gnucash is badly
> mangling the meaning of the transactions I have.  I end up
> with an overall balance of -2 million.  And my investment accounts
> (like my IRA) with multiple mutual funds are particularly
> mangled.  Plus treating categories as accounts makes it hard
> to concentrate on just the account balances. And it seems that
> when I write a check from my checking account to Discover
> to cover my balance, it ends up being creditted twice, so
> instead of a zero balance, I end up knowing that I paid $518K
> over the past 27 years.  While I want to be able to find that
> out (maybe), it's not something I need to know all the time.
> (I realize this is a problem of some kind with double entry
> bookkeeping, but that means everything like this is probably
> wrong.)
> So gnucash does not look like a suitable replacement for
> my use of Quicken.  KMyMoney seems to be closer to being
> correct, so I'm going to see if I can fix the problems I'm
> running into with that, and see if that works better.
> jim
> On Thu, 2020-02-20 at 11:47 +0800, Christopher Lam wrote:
> > Qif importer does have special handling for empty categories. Changing
> this
> > is likely to break things elsewhere though.
> >
> > It would be useful to attach the minimal qif file from selective qif
> export
> > from quicken, and insert screenshots from quicken too. Maybe best file
> bug
> > in Bugzilla.

More information about the gnucash-devel mailing list