tag:infinitekind.tenderapp.com,2009-01-14:/discussions/switching-from-another-personal-finance-program/17752-quicken-2007-qif-import-double-debits-buyx-transactionsInfinite Kind: Discussion 2021-02-03T02:20:22Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/487904412020-11-02T03:32:35Z2020-11-02T03:32:35ZQuicken 2007 QIF import double-debits BuyX transactions<div><p>another user here... I understand your question, and it is indeed an issue. MD is able to import non investment transactions almost perfectly, and for investment transactions, at least the securities end up being imported correctly as well.</p>
<p>The issue is investment cash balances. MD doesn't import some of quicken's action steps correctly, while at the same time getting most everything else right.</p>
<p>When moving to MD early this year, I created a very long discussion on this topic (if you want a very long and often TMI read, search for the word "Vicissitudes").</p>
<p>What you mention and a lot more is discussed there, but it gets tedious as it was a learning process thread. If I have one post to suggest, I suggest post 66, which at least gives an overview of what to "simply" do to fix most of the numbers, but not the history. of the cash balances.</p>
<p>Hope that helps.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/487904412020-11-02T03:34:53Z2020-11-02T03:34:53ZQuicken 2007 QIF import double-debits BuyX transactions<div><p>another user here - could you please describe which products handle everything from a QIF properly? I'd like to know them, so that I could recommend them.</p>
<p>Even Quicken, creating their own QIF export, could not properly import that same QIF file (it was worse than Moneydance) into a new file.</p>
<p>Thanks!</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/487904412020-11-03T01:19:32Z2020-11-03T01:19:33ZQuicken 2007 QIF import double-debits BuyX transactions<div><p>What you see in the QIF is simply:</p>
<ul>
<li>In the split transaction, it is simply a transfer of money to the investment account</li>
<li>In the investment account, it is simply a BuyX transaction with the money coming from the bank account.</li>
</ul>
<p>Since Moneydance created the BuyXfr transaction in the investment account, it does seem to understand Trasnfer/Buy transactions. The fact that it created an extra Xfr transaction would seem to be a bug. It isn't like there are not exactly matching transactions in the QIF.</p>
<p>I have a reduced test case with a small QIF that demonstrates this problem, which I can upload.</p>
<p>As far which products handle everything from a QIF: The last time I tested, SEE Finance had a 100% accurate import, and iBank was pretty close. Quicken 2020 can import these the problem transactions correctly from Q2007, but we don't actually know how it is doing it.</p>
<p>I can re-test and see if the other products are still able to import correctly.</p></div>mschmitttag:infinitekind.tenderapp.com,2009-01-14:Comment/487904412020-11-03T01:30:49Z2020-11-03T01:30:49ZQuicken 2007 QIF import double-debits BuyX transactions<div><p>So is your primary QIF import concern the same as in your other thread?</p>
<p>I won't deny the problem, as I found many more issues with QIF import from Quicken to Moneydance - and yes they are problematic. The main issues end up within cash balances.</p>
<p>I used Quicken 2017 to import their own QIF file, and it was miserable (worse than Moneydance). Good to hear that Quicken 2020 has improved the import, though I have no wish to go back.</p>
<p>Thanks for the comments on SEE Finance and iBank.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/487904412020-11-03T06:02:12Z2020-11-03T06:02:14ZQuicken 2007 QIF import double-debits BuyX transactions<div><blockquote>
<p>So is your primary QIF import concern the same as in your other thread?</p>
</blockquote>
<p>I don't know what you mean. I have two different import issues, both of which generate extra transactions, which throw off the account balance. There are more than 100 of them, so I can't fix them within the demo restrictions. That means I can't see if there are other import issues masked by these problems.</p>
<p>What I am hoping is that Infinite Kind will fix the problem, which is why I reported it for MD 2017, 2019, and now for 2021.</p>
<p>Note: The test case I posted in the other thread also demonstrates this Transfer/Buy issue.</p></div>mschmitttag:infinitekind.tenderapp.com,2009-01-14:Comment/487904412020-11-03T06:31:19Z2020-11-03T06:31:21ZQuicken 2007 QIF import double-debits BuyX transactions<div><p>The current version of SEE Finance does a 100% correct import, in the sense that every account balance is correct down to the penny. This is a 538,000 line QIF with transactions going back to 1997.</p>
<p>However, it appears that it sidesteps the matching issue by doing no matching; it is creating independent transactions on both sides of the transfer -- they're not linked. That's probably left over from how in SEE Finance 1 transfers were never linked.</p></div>mschmitttag:infinitekind.tenderapp.com,2009-01-14:Comment/487904412020-11-04T01:39:16Z2020-11-04T01:39:17ZQuicken 2007 QIF import double-debits BuyX transactions<div><p>For what it's worth, Banktivity 7 (used to be iBank) imports 100% correct for non-investment transactions, but is off on the investments. The non-investments transactions do correctly match transfers.</p>
<p>For the Transfer/Buy transactions, it looks like it is just doing the transfer with no share purchase. That's not good. And from previous testing, I think it has other problems on the investment import.</p></div>mschmitttag:infinitekind.tenderapp.com,2009-01-14:Comment/487904412020-11-04T02:13:58Z2020-11-04T02:13:58ZQuicken 2007 QIF import double-debits BuyX transactions<div><p>As I dealt with this early this year, MD does a good job on import overall (gets noninvestment accounts that don't interact with investment accounts correct, and gets securities correct.</p>
<p>The main problem is the lack of proper support for some investment account action types.</p>
<p>I proposed a "quick and dirty" solution in post 66 of the "Vicissitudes" thread<br>
<a href="https://infinitekind.tenderapp.com/search?utf8=%E2%9C%93&q=vicissitudes&t=d&recommend=1">https://infinitekind.tenderapp.com/search?utf8=✓&q=vicissitudes...</a></p>
<p>but, I will admit that wasn't good enough for me.<br>
If you read that way too long thread, I ended up changing the data IN QUICKEN, by moving action items that MD did not support to actions that MD did support. It usually wasn't hard, and batch actions in quicken fixed most things. (There was one notable and screamworthy exception)</p>
<p>Then I'd reexport the QIF file and upload it again. And again. And again.<br>
But it kept getting better, and no manual transactions had to occur, since the work was done in Quicken, massaging it to MD.</p>
<p>As for asking Moneydance to "fix it" - i.e. adopt these action steps, and incorporate them, I do not think there is much interest in that, as I asked for the same.</p></div>dtd