Hi Christopher. Alas I do not keep the QFX files. I'll hang on to them for now and see if the FIDID does change.
On Mon, Jul 27, 2020 at 4:20 PM Christopher Lam <[email protected]> wrote: > 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, <[email protected]> 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 <[email protected]> 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 <[email protected]> >> 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 <[email protected]> >> > 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 >> > >> [email protected] >> > >> 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 >> > > [email protected] >> > > 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 >> > [email protected] >> > 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 >> [email protected] >> 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 [email protected] 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.
