As I understand the ofx spec*, the fitid should be an invariant for the bank and account. By any chance do you have older qfx files to compare?
* https://www.ofx.net/downloads.html On Tue, 28 Jul 2020, 4:34 am Fross, Michael, <mich...@fross.org> wrote: > Thanks Jean / John for your thoughts. There is a register entry that > matches, IMHO, very closely. I increased the Match Display Threshold from > 1 to 3, and then to 6 (which appears to be the highest value allowed.) > Every transaction from the import says "Match Missing." > > Digging around a bit, for the transaction in question, the QFX file > contains the FITID of 202007210003: > > <STMTTRN> > <TRNTYPE>CREDIT > <DTPOSTED>20200721120000 > <TRNAMT>54.00 > <FITID>202007210003 > <NAME>ACH Electronic Credit > <MEMO>Expenses > </STMTTRN> > > My GNUCash file contains, for the same transaction has the online id being > 202007210002 > <split:slots> > <slot> > <slot:key>online_id</slot:key> > <slot:value type="string">202007210002</slot:value> > </slot> > > The online_ID is ...002 instead of ...003. Changing the QFX file to match > the online_id value seemed to work. Now my question is why would this be > different for *lots* of transactions. Everything worked normally in v3, > but this would not have changed as part of the release. I'll check a few > more problem transactions and see if I can detect a pattern. Perhaps > Citibank is paying games.... > > Michael > > On Sun, Jul 26, 2020 at 4:57 PM jean laroche <rip...@gmail.com> wrote: > > > To get a match you have to have a transaction in the register that's > > sufficiently similar to the one you're importing, and that has not been > > imported/matched before. > > In your case, it could be one of these reasons (I can't see the image): > > - There's no matching transaction in your register (no existing > > transaction has amount close, and a date close to the imported one) > > - There's a matching transaction but it's already been matched to an > > imported transaction at some point so it's not available to be matched > > to the new imported one. > > - There's a matching transaction that's available, but the match score > > is below the threshold that allows the transaction to be shown as a > > potential match. Too large a date mismatch can cause that. > > > > Can you check whether you're in one of these 3 cases? If you're in case > > 3, you can lower the minimum matching threshold in the preferences and > > see if that helps. > > J. > > > > > > On 7/26/2020 2:44 PM, John Ralls wrote: > > > If there's no matching transaction already in the account then there's > > nothing to clear. In that case only adding or not makes sense. > > > > > > Regards, > > > John Ralls > > > > > > > > >> On Jul 26, 2020, at 1:56 PM, Fross, Michael <mich...@fross.org> > wrote: > > >> > > >> Hello all, > > >> > > >> I sent this earlier this month and didn't see any reply so I thought I > > >> would try again. Has anyone else seen these issues? I use Citibank > > and > > >> perhaps it's a Citibank issue, but I did not have this problem on v2 > or > > v3. > > >> > > >> Thanks all. I appreciate the help. > > >> > > >> Michael > > >> > > >> > > >> On Sat, Jul 4, 2020 at 9:48 AM Fross, Michael <mich...@fross.org> > > wrote: > > >> > > >>> Hello all, > > >>> > > >>> I typically download QFX files from my banks every day or two, import > > them > > >>> to clear them in Gnucash. Worked great. However, ever since > > upgrading to > > >>> v4, the importer seems to have trouble matching. Most of the > imported > > >>> transactions are listed in the importer as (A)dd, but when I select > > >>> (C)lear for them it says match missing. > > >>> > > >>> This has occurred for several accounts. Here is a simple credit card > > >>> example, although for my checking account, there are dozens like > > this. The > > >>> top portion shows the register with the Sprint bill cleared. The > date, > > >>> amount, and name (mostly) match. > > >>> > > >>> [image: image.png] > > >>> > > >>> Not sure if there is just something wrong with my setup or not. > > Perhaps a > > >>> bug? Are others experiencing this? Any ideas to get the matcher > > matching > > >>> again? Something need to get cleared out? > > >>> > > >>> For those of us in the US, happy Independence Day. Thank you all for > > your > > >>> assistance. > > >>> > > >>> Michael > > >>> > > >> <image.png>_______________________________________________ > > >> 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. > > > _______________________________________________ > 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.