Download Problems between MoneyDance and Bank

tross45's Avatar

tross45

15 Jan, 2022 03:09 PM

I am still having the same problem with bad data each time I do manual bank download. I am not using Direct Connect. I am downloading a qfx file. There are no error messages. My bank is Equity Bank. I get all the correct information from the bank plus about 20 incorrect items. For example, I write checks to my family members a gifts. These all come across correctly from the bank. I also get several transactions that are for the gifting amount, but no check number, and they are bad data. Each time I do a download I have to go through my transactions and delete the incorrect ones. Some are dated with recent dates and others are older. Is there a fix for these incorrect transactions? At one point I started over with Moneydance thinking this might help, but, the problem showed up with this account. I am using version 2021.1 (3069)

  1. Support Staff 1 Posted by Ethan on 15 Jan, 2022 04:46 PM

    Ethan's Avatar

    Hello,

    That sounds like your bank is sending a misformatted QFX file. Moneydance can only work with the information that is contained in the files. If you open the file with a text editor, can you find the misformatted transactions in there? Alternatively, you could post a selection of the file here, but keep in mind you've started a public thread.

    Ethan
    Infinite Kind Support

  2. 2 Posted by tross45 on 17 Jan, 2022 09:03 PM

    tross45's Avatar

    I think this is one of the bad transmissions:
    200.00</TRNAMT><FITID>BB9A870AF03B8D800490A40397A42FF4</FITID><NAME>ATM Withdrawal</NAME></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20211221120000.000[0:GMT]</DTPOSTED><TRNAMT>

    The following is the data set from MoneyDance:

    0.acctid: 0185f57d-276b-4547-abdb-053b8a52457c
    0.desc: Kerri Shinabery
    0.id: a3add614-97bf-4db8-ab6a-028cda1cd009
    0.obj_type:
    0.oldid: -1
    0.pamt: -20000
    0.samt: 20000
    acctid: 75d72e7e-bb54-47af-98e2-8e5c6d899e63
    chk:
    desc: Kerri Shinabery
    dt: 20211221
    dtentered: 1642451600580
    id: 6d74139c-2cc1-4b5d-bd32-c66124b03dca
    memo:
    obj_type: txn
    ol.match-status: y
    ol.match-type: 1
    ol.orig-memo:
    ol.orig-payee: Check #195 REF#195
    ol.orig-txn: {
      "dtpstd-int" = "20211221"
      "name" = "Check #195 REF#195"
      "fitxnid" = "C4807565911D18A8DB93FBA2180863BE"
      "orig_data" = "<STMTTRN>
    <TRNTYPE>DEBIT
    <DTPOSTED>20211221120000.000[0:GMT]
    <TRNAMT>-200.00
    <FITID>C4807565911D18A8DB93FBA2180863BE
    <NAME>Check #195 REF#195
    </STMTTRN>
    "
      "txntype" = "DEBIT"
      "amt" = "-20000"
    }

    ol_fitid_1: C4807565911D18A8DB93FBA2180863BE
    oldid: -1
    td: 20211221
    ts: 1642451600580

  3. 3 Posted by tross45 on 19 Jan, 2022 05:13 PM

    tross45's Avatar

    How do you fix a misformatted QFX that is coming from your bank?

  4. 4 Posted by tross45 on 19 Jan, 2022 05:48 PM

    tross45's Avatar

    Looking at the data set from MoneyDance above, the Check # is 195. When this transaction shows up on the ledger in MD, there is no check number. Check #195 was already used on a different transaction.

  5. 5 Posted by tross45 on 22 Jan, 2022 04:30 PM

    tross45's Avatar

    At this point I just want to know if there is a way to resolve this problem, or do I have to keep wasting time finding and deleting the bad data?

  6. 6 Posted by dtd on 22 Jan, 2022 08:32 PM

    dtd's Avatar

    just a user

    Given the data is given to you by the bank, MD can only deal with it by assuming it is valid. If it is not valid, you need to contact your bank to see if they will fix the bad data transmissions they send to Moneydance.

    The only other thing I can think of is that I've seen where Moneydance will store old transaction history and keep regurgitating it. So that might be the problem as well. There is an extension called "Toolbox" which fixes all sorts of things, and if I remember correctly, getting rid of stale transaction records is one of them - but I'm not totally sure which command that is.

    Hope that helps provide a direction.

  7. 7 Posted by tross45 on 05 Feb, 2022 11:06 PM

    tross45's Avatar

    Thanks for the response. I will look into your suggestion.

  8. System closed this discussion on 07 May, 2022 11:10 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