missing transactions after importing QFX file
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.
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
1 Posted by dtd on 22 Feb, 2024 03:56 AM
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.
System closed this discussion on 23 May, 2024 04:00 AM.