[GNC] Incorrect QFX Import

[Jean Laroche]

GC will not import an ofx transaction it thinks it already has imported. 
To determine whether a transaction has been imported GC looks at the 
FITID. So if two transactions in your OFX file have the same FITID, the 
second one won't be imported.

Can you check that the transactions that are missing don't have the same 
FITID as some of the transactions that were imported?
Some banks are not good at assigning unique FITID to transactions, and 
that can cause a problem for GC.
Jean

On 12/29/21 2:13 PM, Steve Cohen wrote:
> Additionally, I tried exiting GnuCash and trying the import again.  This
> made no difference.
>
> On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen <stevecoh2 at gmail.com> wrote:
>
>> I downloaded all of 2021's transactions from my bank in QFX format and
>> tried to import the file.
>>
>> As I was doing so, I noticed an anomaly.  I receive monthly direct
>> deposits from a pension, all arrive on or shortly after the first of each
>> month, the same amount every month. But on the QFX import screen, only 5 of
>> the months showed the deposit,
>> for January, May, August, September and December.  The other seven months
>> were not on the import screen. I tried sorting by date, by amount, by
>> description - they aren't there.
>>
>> In an attempt to learn what was going on, I first checked my bank
>> statements.  Was the pension not being deposited?  No, that wasn't it, the
>> deposits came in every month as they were supposed to. I then opened the
>> QFX file in a text editor to see if the deposits were listed in the QFX.
>> They all were.  So I am trying to understand if there's a bug in the import
>> function that would throw these transactions away.
>>
>> Here are the QFX entries from December and November. Perhaps someone
>> looking at them can tell me why the first one was accepted and the second
>> not? I see no important difference.
>>
>> <STMTTRN>
>> <TRNTYPE>CREDIT
>> <DTPOSTED>20211201120000[0:GMT]
>> <TRNAMT>1772.79
>> <FITID>202112010
>> <NAME>COOK COUNTY PENS PENSIONS
>> <MEMO>PPD ID: 3660023021
>> </STMTTRN>
>>
>> <STMTTRN>
>> <TRNTYPE>CREDIT
>> <DTPOSTED>20211101120000[0:GMT]
>> <TRNAMT>1772.79
>> <FITID>202111010
>> <NAME>COOK COUNTY PENS PENSIONS
>> <MEMO>PPD ID: 3660023021
>> </STMTTRN>
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.