I have an account that when data is imported to it from an OFX file, entries imported and cleared during a previous import, are once again imported rather than ignored. The following image is a sample of what I see in the ledger following such import.
What is causing this?
Transactions being imported are checked for being duplicates based on a Message-ID assigned by the bank. With OFX, that ID is generally consistent if you re-export the same transaction. If the ID changes on a new export/import, the transaction will not be recognized as a dupliate, and thus imported again. For starts, check the Transaction/Show transaction detailes to see if the ID (shown in the column BankID) is the same or differernt for the two transactions. If they are the same, we need to dig more into how that happened. If they are different, the problem is at the bank.
@ostroffjh following your instruction, I discovered that transaction numbers for two like entries are not the same which leads me to believe the issue is being created by the bank. I’ll need to contact the bank to find out why this is occuring.
Thanks for your assistance.
We’ve seen this before and created our own weapon, so no need to talk to unresponsive banks:
Don’t use the OFX FITID in case it changes between downloads of transactions. Switch to KMyMoney Hash and you are safe.
Much appreciated. That has solved the issue for now.
