What file format are you downloading? If you have the option to
download a QFX/OFX file, you should choose that. The OFX format
includes transaction IDs, which allow Moneydance to uniquely
identify each transactions and automatically discard duplicates.
Other file formats don't include IDs, and so require manual
If you don't have the option to download OFX/QFX files, then
using your last download date is a good way to minimize the number
of duplicates you need to merge.
Thanks so much Jessica for the help. I was really excited to
hear about this feature and went to try it out as soon as I saw you
posted. I opened my checking account and saw that I had downloaded
transactions and accepted or merged them through the 5/25/2012. So
I went to the chase web site (my bank), and selected the QFX format
(they don't have OFX) and selected a date range of 05/01/2012 to
If this feature works then it should only bring in transactions
It did not. It brought in all transactions from the date range
that I specified. I have attached a picture showing the outcome of
Am I doing something wrong? Is there another step that I need to
do to get rid of the duplicate transactions?
Is the QFX format not providing the uniquely identifiers that
the OFX format should have?
The first time you import a QFX file, none of your current
transactions will have IDs, so Moneydance won't be able to match
them. So, you'll get a lot of duplicates (as you discovered).
However, when you match the transactions from the QFX file, the IDs
will be saved, so you should get less duplicates in future
downloads. Once most of your transactions are from QFX downloads,
you shouldn't get any duplicates at all.