[GNC] Incorrect QFX Import

[Jean L]

There a debug flag you can enable to have info printed out when 
transactions are skipped, but I don't remember off the top of my head 
which flag that is.


On 12/29/2021 3:42 PM, Christopher Lam wrote:
>
> It would be nice to have visibility of these imported transactions? 
> Checkbox at the bottom would reveal them, all grayed out, and clicky 
> link to the matched split in the register?
>
> *From: *Jean Laroche <mailto:ripngo at gmail.com>
> *Sent: *Thursday, 30 December 2021 6:18 AM
> *To: *gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> *Subject: *Re: [GNC] Incorrect QFX Import
>
> GC will not import an ofx transaction it thinks it already has imported.
>
> To determine whether a transaction has been imported GC looks at the
>
> FITID. So if two transactions in your OFX file have the same FITID, the
>
> second one won't be imported.
>
> Can you check that the transactions that are missing don't have the same
>
> FITID as some of the transactions that were imported?
>
> Some banks are not good at assigning unique FITID to transactions, and
>
> that can cause a problem for GC.
>
> Jean
>
> On 12/29/21 2:13 PM, Steve Cohen wrote:
>
> > Additionally, I tried exiting GnuCash and trying the import again.  This
>
> > made no difference.
>
> >
>
> > On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen <stevecoh2 at gmail.com> wrote:
>
> >
>
> >> I downloaded all of 2021's transactions from my bank in QFX format and
>
> >> tried to import the file.
>
> >>
>
> >> As I was doing so, I noticed an anomaly.  I receive monthly direct
>
> >> deposits from a pension, all arrive on or shortly after the first 
> of each
>
> >> month, the same amount every month. But on the QFX import screen, 
> only 5 of
>
> >> the months showed the deposit,
>
> >> for January, May, August, September and December.  The other seven 
> months
>
> >> were not on the import screen. I tried sorting by date, by amount, by
>
> >> description - they aren't there.
>
> >>
>
> >> In an attempt to learn what was going on, I first checked my bank
>
> >> statements.  Was the pension not being deposited?  No, that wasn't 
> it, the
>
> >> deposits came in every month as they were supposed to. I then 
> opened the
>
> >> QFX file in a text editor to see if the deposits were listed in the 
> QFX.
>
> >> They all were.  So I am trying to understand if there's a bug in 
> the import
>
> >> function that would throw these transactions away.
>
> >>
>
> >> Here are the QFX entries from December and November. Perhaps someone
>
> >> looking at them can tell me why the first one was accepted and the 
> second
>
> >> not? I see no important difference.
>
> >>
>
> >> <STMTTRN>
>
> >> <TRNTYPE>CREDIT
>
> >> <DTPOSTED>20211201120000[0:GMT]
>
> >> <TRNAMT>1772.79
>
> >> <FITID>202112010
>
> >> <NAME>COOK COUNTY PENS PENSIONS
>
> >> <MEMO>PPD ID: 3660023021
>
> >> </STMTTRN>
>
> >>
>
> >> <STMTTRN>
>
> >> <TRNTYPE>CREDIT
>
> >> <DTPOSTED>20211101120000[0:GMT]
>
> >> <TRNAMT>1772.79
>
> >> <FITID>202111010
>
> >> <NAME>COOK COUNTY PENS PENSIONS
>
> >> <MEMO>PPD ID: 3660023021
>
> >> </STMTTRN>
>
> >>
>
> > _______________________________________________
>
> > 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.
>