[GNC] Incorrect QFX Import

[Christopher Lam]

   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: [1]Jean Laroche
   Sent: Thursday, 30 December 2021 6:18 AM
   To: [2]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.

References

   1. mailto:ripngo at gmail.com
   2. mailto:gnucash-user at gnucash.org