[GNC] Missing Bank Interest Transactions When Importing with QFX

Chris Good goodchris96 at gmail.com
Tue Apr 28 01:15:37 EDT 2020


Message: 2
Date: Mon, 27 Apr 2020 18:51:41 -0700
From: Keith Fetterman <keithfetterman at gmail.com>
To: GnuCash users group <gnucash-user at gnucash.org>
Subject: [GNC] Missing Bank Interest Transactions When Importing with
	QFX
Message-ID: <5FC46E9E-F08A-4BA1-B13E-0DAD30C1F94D at gmail.com>
Content-Type: text/plain;	charset=us-ascii

When I import the transactions from my bank using QFX, the small interest
transactions are not appearing in the import screen?  The amounts are
usually less than a $1 dollar.  Does anyone know why this is?  Is there a
threshold somewhere that might be filtering them out?  I discovered it with
GnuCash 3.8 and 3.9 on MacOS.

Hi Keith,

Perhaps they are not being imported because the transaction has the same
<FITID> as a previous transaction?
FITID's must be unique for each transaction in an account.
Is your bank ING? The interest transactions from ING Australia bank have
this problem.
I have a java program that I run on my .ofx file before I import into
GnuCash to fix this problem.
QFX is effectively the same as OFX I believe.
See https://github.com/goodvibes2/IngAusOfxFixLinux
Or https://github.com/goodvibes2/IngAusOfxFixWin

Note my fix program has not been tested in MacOS but should work.

Regards, Chris Good



More information about the gnucash-user mailing list