[GNC] Import matching

[Gyle McCollam]

David,
1st thanks for the reply.

When you ask for more information, I assume you are asking for OS and version?  If so, Windows11 and at the time probably GNUCash 5.5, but currently 5.6.

I seem to have the issue with CSV import, more than ODX/QFX imports.  The original post, to which you replied, was on 3/11.  When I did the next CSV import on 4/11 it worked better.  Good thing most of my imports are OFX/QFX as it seems to work a lot better.  However, I would think the matching process would work the same, even using the same coding, regardless of the import type.

As for the Amazon splitting one order into 2 invoices, I understand that GNUCash couldn't match that and I didn't expect it to.  That is why I split my GNUCash entry into 2 entries, each matching one of the import values.  GNUCash still wouldn't match the 2 import values to the 2 GNUCash transactions.

Overall, the matching process works well for OFX/QFX most of the time with only occasional hiccups.  CVS imports are more problematic, but still save time.  I also agree, that some institutions matching are worse than others.

Thaks again for your time.


Thank You,

Gyle McCollam

Gyle McCollam

gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email

________________________________
From: David Carlson <david.carlson.417 at gmail.com>
Sent: Tuesday, April 23, 2024 11:59 AM
To: Gyle McCollam <gmccollam at live.com>
Cc: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: Re: [GNC] Import matching

Gyle,

Please provide more information.  Not only have the import functions changed over recent releases, but there is more than one type.

Even without that information, I am sure that GnuCash cannot figure out how Amazon split one transaction into two.  You would have to manually check those and not expect a match.  My experience with matching in the OFX type has never been perfect and I plan on taking extra time to manually match or even just delete duplicates later for some transactions.  Results with some banks or credit cards are worse than others.

On Mon, Mar 11, 2024 at 4:06 PM Gyle McCollam <gmccollam at live.com<mailto:gmccollam at live.com>> wrote:
Additional information.  Another credit card that can only import CSV, a fast-food establishment submits information the day after the actual transaction.  90% of the time it said there was no match, but on a few occasions, it actually did match the transaction.  Import information in preferences was not changed from the earlier submission.

BTW, it would be nice to have a reset to defaults on these preferences.


Thank You,

Gyle McCollam

Gyle McCollam

gmccollam at live.com<mailto:gmccollam at live.com><mailto:gmccollam at gyleshomes.com<mailto:gmccollam at gyleshomes.com>>           email

________________________________
From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org<mailto:gmail.com at gnucash.org>> on behalf of Gyle McCollam <gmccollam at live.com<mailto:gmccollam at live.com>>
Sent: Monday, March 11, 2024 3:49 PM
To: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org> <gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
Subject: [GNC] Import matching

I tried importing credit card transactions.  There were 2 with no match information.  Turns out Amazon split the order to 2 different transactions.  I changed the transaction in the account to 1 of the amounts and added a transaction for the other amount.  They were both dated 02/09/2024.  The transactions on the credit card account were 02/13/2024.  When I tried double clicking on the transaction in the import window it said there were not matching transactions.  I checked the preferences and change the # of days to the attached information.  It still won't find these transactions.  I tried closing GC and then opened and tried to import them again, still no luck.  Obviously, I'm missing something, what am I doing wrong?[cid:9657ec02-19b5-48f1-a2e9-0393f5c44ecf]


Thank You,

Gyle McCollam

Gyle McCollam

gmccollam at live.com<mailto:gmccollam at live.com><mailto:gmccollam at gyleshomes.com<mailto:gmccollam at gyleshomes.com>>           email
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org<mailto: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.


--
David Carlson