missing transactions after importing QFX file

kas4's Avatar

kas4

21 Feb, 2024 03:37 PM

Running version 2023.3. I manually download CC activity to QFX and import into MD.

If I don't tick the box for "automatically merge downloaded transactions" then all txns from CC file are imported even if there's a duplicate that was entered manually.

If I tick the box, then the manual txns are not duplicated (good). However some new activity from the QFX file is not imported (bad). The txns that are not imported are recurring charges with the same payee and amount as a txn from a prior month's file but the FITIDs are different. Is this correct? I thought a different FITID would tell MD it's not a duplicate.

  1. 1 Posted by dtd on 22 Feb, 2024 03:56 AM

    dtd's Avatar

    Good analysis. Basically what is happening is the recurring transactions are attaching themselves to an earlier recurring transaction (and different FITIDs say "this is different, ignore the old, use me instead). This happense because banks sadly do send the same transaction with a different FITID occasionally, but in your case it is connecting improperly.

    This doesn't usually impact me, as I tend to enter transactions manually as well, and the download is a verification, and it grabs my manual entry versus a previous one.

    Solution? Not an automatic one, as there are so many scenarios. I do use automatically merge, but tend to enter transactions to "hook" to, as well as have very few recurring charges.

    One: lower the search day length. If your recurring items are monthly, make sure that value is like 14.

    Look over your scenario. Given your knowledge (like FITID), you can probably come up with something that works well for you.

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