[GNC] Import Transaction Matcher issue in v4

[John Ralls]

No. Section 3.2.3 of the OFX 1.6 spec:
"An FI (or its Service Provider) assigns an <FITID> to uniquely identify a financial transaction
that can appear in an account statement. Its primary purpose is to allow a client to detect
duplicate responses. Open Financial Exchange intends <FITID> for use in statement download
applications, where every transaction (not just those that are client-originated or serveroriginated)
requires a unique ID."

Regards,
John Ralls



> On Jul 27, 2020, at 2:20 PM, Christopher Lam <christopher.lck at gmail.com> 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, <michael at 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 <ripngo at 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 <michael at 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 <michael at 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 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.
>>>> _______________________________________________
>>>> 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.
>>> 
>>> _______________________________________________
>>> 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.
>>> 
>> _______________________________________________
>> 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.
>> 
> _______________________________________________
> 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.