Quicken QIF splits import incorrectly when transactions in split accounts are incomplete
-
Virgil Dupras
- State changed from new to accepted
- Tag set to bug
That's a tricky one to solve. In QIF files, what we have are entries, not transactions, so when a transaction involves a transfer between two assets/liabilities, we get the same transaction twice. Initially, the problem was that moneyGuru would mistakenly see these as two transactions. I solved this problem by simply saying "if we have a transaction with a transfer to an account that we've already seen, we've therefore already seen this transaction and we can safely skip it".
Now, this problem makes the whole duplicate detection more complicated because instead of ignoring the transaction, it will have to parse it and verify whether it has more splits than the transaction it already parsed and then replace it if it's the case.
Does quicken produce this kind of QIF export consistently for transactions involving splits and asset/liability transfer at the same time?
-
Geoffrey Lowney
I only have Mac Quicken 2006, so I am not sure if all versions of Quicken are like this. I did do a few tests, exporting only individual accounts and only a couple transactions. They all have the same thing going on. The transactions in the split accounts only contain limited information (even when the main account is not included in the export). It seems like the code for comparing the transactions, and replacing ones that are incomplete, might be relatively straight forward, if you give ma few hints about how to start :)
-
Virgil Dupras
I don't think that it's straightforward to fix. The current "account seen" mechanism is simply inadequate to solve this problem.
I'd replace it with a post-loading duplicate matching mechanism where we'd go over all loaded transaction. Then, for each transaction, if there's a split that goes to another asset or liability, check to see if that asset/liability contains a transaction on the same date for the same amount back to our account. If yes, we delete the transaction that has the smallest number of splits.
-
Virgil Dupras
- Milestone set to v2.5
- Milestone order changed from 195317 to 0
-
Virgil Dupras
- Assigned user set to Virgil Dupras
-
Virgil Dupras
- State changed from accepted to fixed
(from [1941a8dd5d86]) [#290 Quicken QIF splits import incorrectly when transactions in split accounts are... state:fixed] Fixed bug in QIF import.
Some splits could be ignores in cases where there was duplicate entries but one entry had more splits than the other (Quicken 2006 exports).
https://bitbucket.org/hsoft/moneyguru/changeset/1941a8dd5d86/
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
