Invalid Data During Download Process

tross45's Avatar

tross45

23 Aug, 2020 10:55 PM

Each time I do a manual download from my bank, I get invalid data, that is not coming from my bank. When I first started using Monydance, I first downloaded my data from Quicken and then later deleted a lot of this data due to the slow lag time I was experiencing. Now when I do a manual download from my bank, the data from the bank comes over correctly, but, I also get several incorrect items that appear to be coming from some where else. I have tried confirming and then deleting the items, but the show up again the next time I do the download. Is there a way to eliminate these transactions, or should I just save this file and then start over again with a new clean file?
I am using MoneyDance version 2019.3 on a Windows 10 computer.

  1. 1 Posted by tross45 on 23 Aug, 2020 10:57 PM

    tross45's Avatar

    If I have posted this problem in the wrong area, please move to the appropriate place.

  2. 2 Posted by derekkent23 on 24 Aug, 2020 08:11 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi tross45

    I think for support or other to be able to help you will need to provide more information.
    1. When you manually download from you bank what is the file type, e.g. OFX, QFX or QIF?
    2. Can you define and give examples of what you mean by “several incorrect items that appear to be coming from somewhere else”?
    3. are these items duplicates of transaction that were imported from Quicken?
    4. Have you opened the downloaded file in a text editor to determine if in fact these item are included in the file you have downloaded from your bank?

  3. 3 Posted by tross45 on 24 Aug, 2020 03:04 PM

    tross45's Avatar

    I am downloading the QFX file.
    Examples: Shelter insurance for $300 or $30.00, when I have had no payments for these amounts.
    I don't know if these items are duplicates from Quicken, but I do suspect that they are.
    I have not opened the downloaded file to see if the errors were in the downloaded file. I will try to do this.

  4. 4 Posted by derekkent23 on 24 Aug, 2020 03:19 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi tross45

    As you are importing a OFX file the following is worth knowing.

    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
    20190806000000

    <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>
    

    It does not matter how many times you import this file into Moneydance the transaction only appears once.
    Also, If you right click on a transaction imported via an OFX file and select “Show transaction details” it should include the FITID
    The QIF file specifications do not include the equivalent to FITID and thus you can get duplicates on importing if transitions already exist in Moneydance.
    If you are setting up Moneydance and have imported your initial QIF file and then either import a second QIF file or OFX/QFX file from your bank which contains duplicates these duplicates will appear in Moneydance. If the duplicates were due to an OFX/QFX files import its important to delete the QIF file duplicates thus leaving the FITID transaction in tack. This will prevent duplicates on the next OFX/QFX files import.

    Hope this helps.

  5. 5 Posted by tross45 on 24 Aug, 2020 04:05 PM

    tross45's Avatar

    I reviewed my QFX file and did not see any of the incorrect data in that file. It may to be coming from the data that I deleted from MoneyDance.

    The following is the data I see when I click on Show Transaction Detail. It looks a little different the the info posted above.

    0.acctid: 7cc30b11-bb61-4335-8e9c-ab35e8adc9a6
    0.desc: Melissa Dougherty
    0.id: daddc15f-d61d-462c-a512-9630f796bb5a
    0.obj_type:
    0.oldid: -1
    0.pamt: -4000
    0.samt: 4000
    0.tags:
    acctid: 3ca7d564-82a2-4061-b3ef-a012e457ac80
    chk: 1089
    desc: Melissa Dougherty
    dt: 20200723
    dtentered: 1596716553011
    id: a0724cfe-ea46-4afe-a0c4-c7bdfd7713fb
    memo:
    obj_type: txn
    oldid: -1
    stat: X
    td: 20200723
    ts: 1597680180692

  6. 6 Posted by derekkent23 on 25 Aug, 2020 08:31 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi tross45

    The info I posted was from the OFX file.

    After import clicking “Show transaction details” give:

    0.acctid: 3aeb1ad8-1a51-4e73-92ee-a98205fdd6ca
    0.desc: Southend on sea
    0.id: c0e7db04-5c0d-4325-871b-6baefd0c0334
    0.obj_type:
    0.pamt: -290
    0.samt: 290
    acctid: ced1a7e0-e60a-4452-ac3e-c9047191cbd2
    chk:
    desc: Southend on sea
    dt: 20190806
    dtentered: 1598279690328
    id: c35b2d0a-9384-43ae-8b18-709c43a3ebae
    memo:
    obj_type: txn
    td: 20190806
    ts: 1598266651985

    which is the same structure as you are seeing.

  7. System closed this discussion on 24 Nov, 2020 08:40 AM.

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

Recent Discussions

18 Jan, 2021 12:26 AM
17 Jan, 2021 11:08 PM
17 Jan, 2021 11:08 PM
17 Jan, 2021 10:49 PM
17 Jan, 2021 09:58 PM