OK, that would have been too easy :D... Any chance you could send me the
OFX? Remove anything that's private in it if you want. I'll debug on my
end. If you get a chance, open a bug, and put the file there, otherwise
send it to me directly...
Thanks!
Jean
On 12/29/2021 7:58 PM, Steve Cohen wrote:
There do not appear to be any duplicate FITIDs here.
I ran the command
grep FITID downloaded.QFX | sort > fitid.txt
and could easily see that there were no duplicates in the 136 entries
in the file. The bank (Chase) appears to assign FITIDs of the form
YYYYmmDD# where # is a consecutive number from 0-9. What it would do
if there were more than 10 entries isn't clear to me but that
eventuality did not occur in this file which has only 136 entries over
a year.
On Wed, Dec 29, 2021 at 4:18 PM Jean Laroche <rip...@gmail.com
<mailto:rip...@gmail.com>> wrote:
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 <stevec...@gmail.com
<mailto:stevec...@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@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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@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.
