[GNC] Missing payment items in OFX import from Bank
jean laroche
ripngo at gmail.com
Sat Oct 10 01:42:19 EDT 2020
It could indeed be an FTID problem: if a transaction in the OFX file has
an FTID (they are supposed to!) GC checks whether it has seen this
transaction before (by looking at all previous transactions in the
corresponding account). If it finds a transaction with the same FTID, it
assumes you're re-importing the same transaction and it's just ignoring it.
So the issue *could* be that the transactions that GC ignores have FTIDs
that already exist in the ledger transactions.
You could verify this hypothesis by opening the .gnucash file (go to the
options, select saving uncompressed, which then allows you to see the GC
file as plain text) and searching for the FTID of one of the
transactions that are not being imported. (or by exporting all
transactions to a csv file and checking there).
OR, you could hack the OFX file, change the FTID to a large string, and
trying re-importing it. If it works this time, you'll know what the
issue is.
Some banks have been known to re-use FTIDs which they're not supposed to
do. That causes a problem for GC.
J
On 10/9/2020 9:47 PM, David Cousens wrote:
> Has anyone else come across a problem importing payment information fro OFX
> files for a credit cardGNuCash 4.2? I used to have no problem with this but
> in bringing my accounts up to date I have noticed the importer is not
> recognising a transaction which occurs in the OFX file. The transactions
> other than payments I have made into the acount seem to be imported normally
> but the following and similar record are not appearing in the Import matcher
> window. In my case these normally match to transfers from a bank account
> into my credit card which already exist as I generally import the bank
> account records first but they usually come up in the import matcher as a do
> not import however now they do not appear at all in the import matcher
> window.
> <STMTTRN>
> <TRNTYPE>CREDIT
> <DTPOSTED>20200420
> <DTUSER>20200420
> <TRNAMT>1400.00
> <FITID>N042009047838
> <MEMO>PAYMENT RECEIVED, THANK YOU
> </STMTTRN>
>
> Another similar payment record into the account on another date also failed
> to be recorded and similarly in a previous import for the month before. Any
> payment records do not appear to be recognized in the OFX file. The records
> matching these payments into the account are not marked as cleared "c" when
> the records are imported. It may have something to do with FITID recognition
> as all the records which are not being imported have <FITID> values whereas
> all the records fo my purchases have a blank <FITID>. Just want to check
> that this is a general problem and not just my bank changing things before
> reporting it as a bug.
>
> David
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> 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.
More information about the gnucash-user
mailing list