Updating Accounts

Stuart Swenson's Avatar

Stuart Swenson

21 Nov, 2018 05:08 PM

We have Moneydance version 2017.7.1 (1671), and recently opened another bank account (German American bank, germanamerican.com), We now update/download the expenses/deposits daily for this and other accounts. On many occasions (not all the time), when doing the first update download of the day, the new account not only gives us the new deposits and expenses, it also enters the old ones, so we have to go through the file (still small) and eliminate the double entries. What can I do about that? Our other bank accounts in Moneydance don't do this.

  1. 1 Posted by mhoggie on 21 Nov, 2018 05:53 PM

    mhoggie's Avatar

    just a user,

    Do you have the QFX download format available on your bank downloads? I've been told QFX has features that avoid duplicates

  2. 2 Posted by Stuart Swenson on 21 Nov, 2018 07:42 PM

    Stuart Swenson's Avatar

    I think I do. I'll try it. Thank you. Let's see how it goes.

  3. 3 Posted by dwg on 21 Nov, 2018 07:52 PM

    dwg's Avatar

    I'm a fellow user.

    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.

    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.

  4. System closed this discussion on 20 Feb, 2019 08:00 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

19 May, 2019 11:16 PM
19 May, 2019 10:54 PM
19 May, 2019 08:36 PM
19 May, 2019 08:30 PM
19 May, 2019 08:17 PM