There do not appear to be any duplicate FITIDs here. I ran the command
grep FITID downloaded.QFX | sort > fitid.txt and could easily see that there were no duplicates in the 136 entries in the file. The bank (Chase) appears to assign FITIDs of the form YYYYmmDD# where # is a consecutive number from 0-9. What it would do if there were more than 10 entries isn't clear to me but that eventuality did not occur in this file which has only 136 entries over a year. On Wed, Dec 29, 2021 at 4:18 PM Jean Laroche <rip...@gmail.com> wrote: > 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 <stevec...@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@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. > _______________________________________________ > gnucash-user mailing list > gnucash-user@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. > _______________________________________________ gnucash-user mailing list gnucash-user@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.