I am also interested in this issue. My internet banking presents CSV, XLSX, OFX, TXT, QIF formats for downloading. I need to know the unique ID from the bank's side so that I can avoid having duplicates on my side. OFX seems to cater for this, but I've also noticed that the FITID seems to increment based on the download date. Surely this ID should remain unique? More information: https://www.quicken.com/support/about-fitid-requirements-quicken "FITIDs need to be persistent for the lifetime of the transaction. If a customer downloads the same transaction multiple times, then this transaction always has the same FITID value." CSV won't suffice and no IDs whatsoever are present, TXT doesn't have any, QIF also not. HELP?
... View more