Matching problems when importing QFX transactions
david.carlson.417
david.carlson.417 at gmail.com
Tue Sep 29 21:27:54 EDT 2015
It it always possible to change the assigned account at the matching stage. It is also important to verify that any match to an existing transaction is correct. Also, it is possible to change a transaction later, but that does not train GnuCash .
It is somewhat disturbing that bayesian matching seems to have deteriorated for you. It never did work very well for me.
I know it is very dependent on the actual text in the description field and my banks do not excel in this area. If your bank has changed something recently due to some change in your account type, new credit card or whatever, that might make a difference.
From other related discussions, it seems that once a match has been established it becomes difficult to re-train GnuCash. I have no experience to help with that.
David C
Sent via the Samsung Galaxy S® 5 ACTIVE™, an AT&T 4G LTE smartphone
-------- Original message --------
From: Larry Bradley <gnucash.stz9z at ncf.ca>
Date: 09/29/2015 11:14 AM (GMT-05:00)
To: gnucash list <gnucash-user at gnucash.org>
Subject: Matching problems when importing QFX transactions
Running gnucash 2.6.3 on Ubuntu.
I am importing transactions from my bank in QFX format - thus using the
generic importer with Baysian matching. Some of the sources that once
imported to the proper category no longer do.
For example, we shop at several grocery stores. All of them except one
get assigned to the GROCERIES account. The 'bad' one gets assigned to
Imbalance. It used to work fine. Various other sources also now
misbehave.
The generic import parameters are set as follows:
Match display threshold=1
Auto-add threshold=3
auto-clear threshold=6
I have the ability to change the database tables if this is what is
necessary to fix things up. I can also write external programs to
manipulate the QFX file before GC sees it.
I have searched the archives but not found anything useful.
Just looking thru the XML and found this entry:
<slot>
<slot:key>Metro</slot:key>
<slot:value type="frame">
<slot>
<slot:key>Expenses:Food:Dining Out</slot:key>
<slot:value type="integer">5</slot:value>
</slot>
<slot>
<slot:key>Expenses:Food:Groceries</slot:key>
<slot:value type="integer">96</slot:value>
</slot>
<slot>
<slot:key>Imbalance-CAD</slot:key>
<slot:value type="integer">3</slot:value>
</slot>
</slot:value>
</slot>
Metro is one of the failing matches. The proper match is
"Food:Groceries". I get "Imbalance:CAD" when I import. Can I delete the
"Imbalance" entry?
Any help would be appreciated.
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user
mailing list