Gyle, this import problem was the subject of my email a little while ago. In my case, not so much the need for a split transaction as a method to identify the specific transfer account needed and then the ability to add it to the import information. My work around is to import the data file, hit finish, and deal with the imbalances. Not at all elegant but I only have to look up the information one time. Then I reconcile with my statement.
Liz suggested setting up a scheduled transaction with the proper number of splits and filling them in when the bill was received. She does that for her utility bills. I have a few regular transactions that have the same amount but GNU has not learned which is which ( which $10 belongs to which subscription, for example.) I thought the amount and usual date of the transaction could be enough. If it is a specific amount GNU wants to associate it with the first time that amount was imported (I think) I use QFX on a Windows 11 pc and GNUcash Version 4.13, I was seeing so much chatter about the newer versions that I've held off updating. Regards, Phyllis B On Tue, Apr 23, 2024 at 2:48 PM Gyle McCollam <gmccol...@live.com> wrote: > 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 > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > ________________________________ > From: David Carlson <david.carlson....@gmail.com> > Sent: Tuesday, April 23, 2024 11:59 AM > To: Gyle McCollam <gmccol...@live.com> > Cc: gnucash-user@gnucash.org <gnucash-user@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 <gmccol...@live.com<mailto: > gmccol...@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 > > gmccol...@live.com<mailto:gmccol...@live.com><mailto: > gmccol...@gyleshomes.com<mailto:gmccol...@gyleshomes.com>> email > > ________________________________ > From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org > <mailto:gmail....@gnucash.org>> on behalf of Gyle McCollam < > gmccol...@live.com<mailto:gmccol...@live.com>> > Sent: Monday, March 11, 2024 3:49 PM > To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> < > gnucash-user@gnucash.org<mailto:gnucash-user@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 > > gmccol...@live.com<mailto:gmccol...@live.com><mailto: > gmccol...@gyleshomes.com<mailto:gmccol...@gyleshomes.com>> email > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org<mailto:gnucash-user@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 > _______________________________________________ > gnucash-user mailing list > gnucash-user@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@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.
