[GNC] List of fields checked by importer when matching transactions

GNUCash gnucash at boeziek.nl
Sat Jan 13 05:03:41 EST 2024


John,
Yes the description had to match the tranfer memo. To clarify.
In my transaction CSV I had 3 rows belonging to 1 transaction.
Description on all 3 rows: “Order 1234”
Receivables and deposit rows where identical in all fields (memo, transfer memo, description).
But the third row contained the transaction fee.
So I had in the transfer memo: “Order 1234; payment cost”. Then the importer failed to match it to the first 2 rows.

Etienne
On 12 Jan 2024 at 12:43 +0100, GNUCash via gnucash-user <gnucash-user at gnucash.org>, wrote:
> Perhaps related to your question.
> I did notice as I was closing last quarter that in the GNU Cash latest version something seems to have changed with the importer matching.
> I create my own CSV files in Python based on the export from suppliers/payments.
> I had to change the Transfer memo field I believe, to match either the Memo field or the description field. Else transactions no longer matched. Before, I could have different texts there.
>
> Etienne
> On 11 Jan 2024 at 18:01 +0100, John Haiducek <jhaiduce at gmail.com>, wrote:
> > Checking "Clear" (or "Update+Clear") doesn't work in my case. When I check
> > those it says "Match missing!", even for cases where every imported field
> > is identical to an existing transaction.
> >
> > On Thu, Jan 11, 2024 at 11:44 AM Gyle McCollam <gmccollam at live.com> wrote:
> >
> > > I've been having the same issue with qfx/ofx files, but I find when I
> > > click on the clear check box it finds the matching transaction. You might
> > > want to try that.
> > >
> > >
> > >
> > > Sent from Samsung Galaxy smartphone.
> > >
> > >
> > >
> > > -------- Original message --------
> > > From: John Haiducek <jhaiduce at gmail.com>
> > > Date: 1/11/24 10:43 AM (GMT-05:00)
> > > To: GNU Cash User <gnucash-user at gnucash.org>
> > > Subject: [GNC] List of fields checked by importer when matching
> > > transactions
> > >
> > > Hi,
> > >
> > > Is there a list somewhere of what fields are checked by the importer when
> > > matching transactions? I'm trying to import a CSV file that contains
> > > already-existing transactions and the importer is failing to detect them
> > > (there are hundreds so I don't want to manually de-select them all).
> > >
> > > John
> > > _______________________________________________
> > > 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
> > > -----
> > > 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
> > -----
> > 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
> -----
> 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