tag:infinitekind.tenderapp.com,2009-01-14:/discussions/switching-from-another-personal-finance-program/15517-quicken-import-issuesInfinite Kind: Discussion 2020-04-21T01:00:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/480184552020-01-20T20:53:34Z2020-01-20T21:21:27ZQuicken import issues<div><p>Just a user here who went through this process in the last couple of months.<br>
(It will be TMI, but you can read the very long "Vicissitudes of Moving..." in this forum, where I address your issues above plus many others, since I also encountered them)</p>
<p>You appear to have two primary questions: cash balances are off, and "duplicate" ACCOUNTX accounts are created.</p>
<p>The ACCOUNTX accounts tend to be created because Quicken allows you to create or destroy money (i.e. doesn't follow accounting methods). I mostly found these happening in accounts where I placed a transaction against its own account - i.e. basically destroying money - like depreciating a car. There are other ways you can create or destroy money in Quicken, but that should get you started. Moneydance won't let you create or destroy money - so it creates a "where does that money disappear to?" account.</p>
<p><strong>How to fix? I think you can hide the account and also tell it not to impact your net worth. That seems to be moneydance's normal answer. [Basically instead of destroying money, Moneydance lets you hide the money.... :) ]</strong></p>
<p>As for cash balances - that's more of a problem as there are many transactions especially for investment accounts, that don't move to Moneydance properly - though it's usually the inadequacies of the QIF file export/import process. The good news is that Moneydance does a great job imo of making sure the investment non-cash balances are correct.</p>
<p><strong>How to fix? I think Moneydance would say "compare the cash balance in Quicken to the cash balance in Moneydance - go to the initial Moneydance balance and enter a 'corrective' entry that makes your current Moneydance balance match Quicken". (Caveat by me: your historical cash balances will forever be wonky, but going forward should work). This seems to be the standard fix.</strong></p>
<p>I went further, by changing the Quicken issues in Quicken, then created a QIF file that Moneydance liked, but that took a bit of massaging. It all depends on how far you want to go with your historical data vs. wanting to move forward...</p>
<p>Now that I'm done with my conversion, I think it was worth it, but your mileage may vary.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/480184552020-01-20T21:18:12Z2020-01-20T21:18:12ZQuicken import issues<div><p>I'm a fellow user.</p>
<p>Ahh yes Quicken's amazing ability to create money out of thin air - wish I could do it.</p>
<p>The most common occurrence for this is how Quicken allows you to do Opening balances in some versions, the money just appears. Moneydance is based on accounting rule however so money cannot just appear.</p>
<p>It seems it got really confused in this case though and came up with a negative amount on import. The easiest solution for opening balances is to place the value in the Initial balance field. You do this by clicking on the account in question in the side bar to make its register have focus. Select menu item Account -->Edit Account and enter the opening balance in the Initial Balance field.</p>
<p>Then delete the rubbish 12/12/14 transaction and finally delete the account with the X at the end of its name which should now have no transactions in it.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/480184552020-01-20T21:27:53Z2020-01-20T21:34:04ZQuicken import issues<div><p>I agree with dwg's response for your particular uploads, especially since this ACCOUNTX account appears to have only one entry. My response was more generic, covering things like the WITHDRAWX issue, which doesn't transfer properly, causing cash balance issues.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/480184552020-01-21T00:55:35Z2020-01-21T00:55:36ZQuicken import issues<div><p>dantdavis and dwg,<br>
Thank you both for your assistance. The Edit Account step to access the opening balance was probably the most important piece, as I had looked around but did not see how to change the opening balance. I look forward to reading the Vicissitudes of Moving post to hopefully learn of other issues and fixes I have not encountered yet.</p>
<p>Thanks again to both of you.</p></div>dschaller78