Bank download results in duplicative files (650!) MD V 2019.3 (1880)

david dirig's Avatar

david dirig

20 Aug, 2019 01:01 AM

Greetings. I am a satisfied MD client and have been for many years. interesting occurrence this week with importing bank-sourced QFX files that I need help.

I've ben downloading for years without incident, but this weekend the same import of QFX files resulted in a duplication of records that required to be merged. Opening the file attached the records to the correct account, and selecting MERGE instead of confirm limited the damage. Problem is that when I imported again a few days later (expecting this tone a one time occurnce), the duplicative records appeared again to be reconciled. perhaps there is another option than QFX I should be using (screen shot attached) or a change in process with the latest update?

Thank you in advance for your assistance.

  1. 1 Posted by derekkent23 on 20 Aug, 2019 11:26 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    OFX/QFX 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.


    DEBIT

        <DTPOSTED>20190806000000</DTPOSTED>
    
        <TRNAMT>-2.90</TRNAMT>
    
        <FITID>20190806000000001</FITID>
    
        <NAME>Southend On Sea Boroug, Southend</NAME>
    
        <CARD>Visa</CARD>
    
        <MEMO>On S XXXX/2.90 POUND STERLING GREAT BRITAIN</MEMO>
      </STMTTRN>
    

    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 to make sure they have included a FITID for each transaction.

    Also If you right click on a transaction imported via a OFX file and select “Show transaction details” it should include the FITID

    Hope this helps.

  2. 2 Posted by David Dirig on 20 Aug, 2019 02:02 PM

    David Dirig's Avatar

    Good moring,

    Thank you. That makes sense.
    Might be on the bank side if they are no longer including the FITID.

    I appreciate the lead.

    David Dirig
    Los Angeles, CA

  3. 3 Posted by derekkent23 on 20 Aug, 2019 02:23 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Best way to check is open the OFX file in a text editor and check each transaction is formatted with a FITID in a similar manner to the example I gave.

    Hope this helps.

  4. System closed this discussion on 19 Nov, 2019 02:30 PM.

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

Keyboard shortcuts

Generic

? 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