The OFX file should contain an account ID (ACCTID) number usually the last 4 digits of your account.
Extract from OFX file.
XXXX (XXXX last 4 digits of account number)
When you import the OFX file Moneydance will open a window asking you to confirm the import is going to the correct account based on the ACCTID. See screen shot. If it I not the correct account you can change it using the dropdown.
Also, the OFX files should contain a "Unique Transaction ID" (FITID) for each transaction. Moneydance uses this ID to prevent duplicates.
The following is an extract of one transaction from my credit card downloaded OFX file. Note the FITID number.
<NAME>Southend On Sea Boroug, Southend</NAME>
<MEMO>On S XXXX/2.90 POUND STERLING GREAT BRITAIN</MEMO>
I am running Moneydance 2019.4(1884). It does not matter how many times I import this file the transaction only appears once.
Worth opening your OFX file from your bank in a text editor to make sure they have included a ACCTID and for each transaction a FITID.
Also, if you right click on a transaction imported via a OFX file and select “Show transaction details” it should include the FITID
David and Penel...
on 20 Aug, 2019 07:52 PM
Thanks for replying.
However, when I import (for instance) a file of credit card
transactions into a credit card account, it is adding transactions
from earlier imports which were to other accounts.
I have checked the FITIDs and they are okay in the bank file, but I
end up with duplicates in MD. In other words, the SAME transaction is
appearing in two different MD accounts!
So, MD is not preventing duplicate FITIDs! Not only that, FITIDs that
are NOT in the import file are appearing in the MD accoubnt.
I have 700 transactions in a credit card file and the structure looks
When I import it into the matching MD account, I now get over 4,000
If I delete them all and import again, the number imported grows
Something has gone terribly wrong with this 1880 release.
I've been using MD for many years and never seen anything like this
On Wednesday 21/08/2019 at 1:30 am, derekkent23 wrote: