Import of OFX duplicating records

David Kerr's Avatar

David Kerr

20 Aug, 2019 02:26 AM

Hi, I've been successfully using MD for years and it has been great. Never affected by a bug. Updated to the latest version a few months ago and am doing our tax.
Have always imported OFX files from several institutions.
However, NOW, each time I import a file, it is adding in records from a previous import!
In my case, bank records are getting merged in with credit card transactions.
Each time I run any import from a single file, the total number of records grows!
I am now up to thousands of records resulting from import of a file containing a few hundred records.
Running on Ubuntu Linux. problem is with two different computers with different Ubuntu and Java revisions.
Please help with any suggestions as I cannot do my Tax!
This seems to have started with the latest upgrade- I've never had the problem prevuiously.
Regards,
David

  1. 1 Posted by derekkent23 on 20 Aug, 2019 03:30 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    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.

        <TRNTYPE>DEBIT</TRNTYPE>
    
        <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 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

    Hope this helps.

  2. 2 Posted by David and Penel... on 20 Aug, 2019 07:52 PM

    David and Penelope Kerr's Avatar

    Hello,
    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
    fine.
    When I import it into the matching MD account, I now get over 4,000
    transactions loaded.
    If I delete them all and import again, the number imported grows
    again.
    Something has gone terribly wrong with this 1880 release.
    I've been using MD for many years and never seen anything like this
    before.

    Dave

    On Wednesday 21/08/2019 at 1:30 am, derekkent23 wrote:

  3. 3 Posted by derekkent23 on 20 Aug, 2019 08:10 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi, for info as I stated I am running 2018.4(1888) and not seeing duplicates when I import the same OFX file multiple time.

    I reverted back to 2019.3(1880) and still don’t see an issue.

    So, for you something strange is going on with the OFX file you are importing.

    SUPPORT STAFF PLEASE STEP IN.

    Hope this helps.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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