tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/49043-updating-accountsInfinite Kind: Discussion 2019-02-20T20:00:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/465323942018-11-21T17:53:57Z2018-11-21T17:53:57ZUpdating Accounts<div><p>just a user,</p>
<p>Do you have the QFX download format available on your bank downloads? I've been told QFX has features that avoid duplicates</p></div>mhoggietag:infinitekind.tenderapp.com,2009-01-14:Comment/465323942018-11-21T19:42:52Z2018-11-21T19:42:52ZUpdating Accounts<div><p>I think I do. I'll try it. Thank you. Let's see how it goes.</p></div>Stuart Swensontag:infinitekind.tenderapp.com,2009-01-14:Comment/465323942018-11-21T19:52:00Z2018-11-21T19:52:00ZUpdating Accounts<div><p>I'm a fellow user.</p>
<p>The OFX specification has a Transaction ID field, this is supposed to be a unique transaction number assigned by the bank. Moneydance (and other programs) can use this ID to prevent the loading of duplicate transactions. No other format has this, including QIF which was not designed for transaction downloads but has been in use for many years by vendors for this purpose.</p>
<p>If you do not have the OFX/QFX format available the best approach is to limit the dates that are downloaded each time, many banks have filter settings that will achieve this and this should also prevent the duplicate problem.</p></div>dwg