Same transaction downloads from bank on every cycle

david's Avatar

david

21 Jul, 2021 05:28 PM

MD 2021.1 (3069) for Linux. A specific check recorded in MD was not cashed for > 30 days. Once downloaded from the bank, I had to change its date to fall within the match window. Once matched, I changed the date back to its true date. Now, no matter whether the transaction is in the register, is not in the register and regardless of date, the transaction appears in every download for that account.

I've tried deleting the transaction entirely and then saving it as new from the download. I've also tried using different confirm buttons for the downloaded transaction. Nothing works. Help!

  1. 1 Posted by dtd on 21 Jul, 2021 10:15 PM

    dtd's Avatar

    just a user...

    Saving it as new from the download is what is normally recommended, as then you get the FITID field (a hidden field) to match the bank, and the bank won't download it again.

    In your case, this doesnt appear to be working.

    A good first bit of detective work would be to look at the FITID field and see if it changes (I assume it would, but if not - well that's info)

    you can look at this field (assuming Linux is same as mac) by selecting the transaction, right click, and pick Show Transaction Details - look for FITID field and compare to when you get a duplicate.

    That won't fix anything, but it's a start to diagnose the issue.

    Another bit might be changing the transaction away from being in the match window. If you are continuing to do that, maybe you should just sigh, leave the date wrong, and change it after whatever period of time the bank downloads items (i.e. downloads do expire).

    Yet another thought - when the transaction downloads "again" - just zero out the new value, and let the bank see that it's been downloaded, and leaves it alone. Delete that zeroed value after the download expires.

  2. 2 Posted by david on 21 Jul, 2021 11:03 PM

    david's Avatar

    Thanks for the input dtd. The FITID remains the same on each download, though "Show Transaction Details" is disabled for unconfirmed items. I tried leaving the transaction in match window and also zeroing the amount. Neither fix the problem.

  3. 3 Posted by dtd on 22 Jul, 2021 01:37 AM

    dtd's Avatar

    just a user - well those were my best shots.

    If the FITID is constant, I don't understand why the bank keeps downloading it. That's the point of the FITID field.

  4. 4 Posted by dwg on 22 Jul, 2021 01:49 AM

    dwg's Avatar

    Has a downloaded transaction been confirmed in the register?

    I do not know that if you have a downloaded transaction that is not confirmed if another transaction will or will not be downloaded.

  5. 5 Posted by david on 22 Jul, 2021 01:51 AM

    david's Avatar

    Yes, it's confirmed.

  6. 6 Posted by dtd on 22 Jul, 2021 01:54 AM

    dtd's Avatar

    I think this is obvious, based on your statements, but you never know.

    Confirmed, and the date LEFT ALONE?

    i.e. you download, change nothing, confirm the transaction, then download again - and you get the transaction again?

    btw - I've seen that happen, but the FITID was different.

  7. 7 Posted by david on 22 Jul, 2021 03:49 AM

    david's Avatar

    Thanks for the question. I did correct the incorrect guesses as to payee and category made by MD. I did not alter the date or amount. In that scenario, it will download the transaction on the very next download, whether that is a minute later or the next day.

  8. 8 Posted by dtd on 22 Jul, 2021 05:00 AM

    dtd's Avatar

    If the FITID is the same - the bank is the issue, they are ignoring the FITID field. What bank?

  9. 9 Posted by david on 22 Jul, 2021 11:48 PM

    david's Avatar

    nbkc (national bank of kansas city). I also tried leaving the downloaded trans completely unmodified. Same result.

  10. 10 Posted by dtd on 23 Jul, 2021 12:54 AM

    dtd's Avatar

    and the fitids are the same, correct?

    moving further along, this is an automatic download, not a manual download correct?

    if the answer to both is yes, (i.e. fitid same, automatic download), you might want to contact nbkc and (saying you are using Quicken!) that your direct connect download for this item is consistent.

  11. 11 Posted by david on 23 Jul, 2021 01:02 AM

    david's Avatar

    Thanks again for your help on this. FITIDs are the same. The download is manual (Ctrl+D). I don't have automatic setup. Would the results be different? Yes, I guess I'll try the bank next.

  12. 12 Posted by dwg on 23 Jul, 2021 01:20 AM

    dwg's Avatar

    The results should be the same whethe it is a manual download and import or an automatic one, the data is OFX for an automatic download. and assuming you choose OFX it is the same for manual downloads.

    If possible I would suggest you post two files that exhibit the problem so the files can be examine and tested.

  13. 13 Posted by david on 25 Jul, 2021 03:17 AM

    david's Avatar

    I think I misunderstood auto vs manual. I don't download an OFX file, I just hit Ctrl+D or Ctrl+Shift+D to download transactions. I don't know how to obtain the source file from the bank. In any case, I'll call the bank on Monday to see if they can shed any light.

  14. 14 Posted by dwg on 25 Jul, 2021 03:37 AM

    dwg's Avatar

    Ctrl D is the Moneydance keyboard short cut to download the highlighted account. this is an Automatic download using Direct Connect.

    With these transactions if you right slick on the transaction in the register and select Show Transaction Details on the duplicated transactions we may be able to identify any differences.

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