tag:infinitekind.tenderapp.com,2009-01-14:/discussions/switching-from-another-personal-finance-program/15012-the-vicissitudes-of-quicken-to-moneydanceInfinite Kind: Discussion 2023-03-15T23:50:17Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082021-03-04T16:13:26Z2021-03-04T16:13:26ZThe Vicissitudes of Quicken to Moneydance<div><p>@dwg: yes, I had imported all my data from Quicken into MD but I lost the ability to download bank transactions in 2019 so I have not been using Quicken since then. I had lost the ability to download investment transactions in Quicken after the bank made some changes many years ago, so it will be a step up if I can download the investment transactions in CSV format into a new dummy bank account and cut and paste the data into the investment account (rather than doing it all by manually entering the data).</p>
<p>I am still hoping that the QFX file I that is available from the Holding page of the bank actually can be downloaded directly into the investment account. I just opened it with Notepad and find that other than the mystery “sample security” that is the only item downloaded (listed at the very end), it actually contains CASHBALANCE, MARGINBALANCE, SECNAME, TICKER, UNITS, UNITPRICE, MKTVAL, but no interest charges, divident payments or reinvestments or other cash transactions.</p>
<p>Does the OFX format not include cash transactions?</p>
<p>I just called the broker TD Direct Investing, and they have no information at all on any of this.<br>
Thanks</p></div>haroldtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082021-03-04T19:46:43Z2021-03-04T19:46:43ZThe Vicissitudes of Quicken to Moneydance<div><p>If you are going to cut and paste data you might as well just load the CSV file into a spreadsheet program and do it from there, it is only possible to cut and paste field by field. Banks account registers do not support all the fields that are in Investment Accounts.</p>
<p>Support people at a bank should either know or be able to find out about the files they make available on their website for customers to download. OFX files support all transactions, it sounds like you have downloaded a summary file rather than a transaction file. Perhaps the institution provide different files at different places in the on the site.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082021-03-04T21:19:54Z2021-03-04T21:19:54ZThe Vicissitudes of Quicken to Moneydance<div><p>I just found a help file in an obscure place of the site that states that TD only supports Quicken 2017 and 2018. So it seems that the new owners of Quicken are squeezing not only their customers but also the banks, and TD at least has dropped support of the current versions of Quicken.</p></div>haroldtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082021-03-21T16:05:49Z2021-03-21T16:05:52ZThe Vicissitudes of Quicken to Moneydance<div><p>I can identify with many of the points in this discussion. having some 20+ years of banking and investment data from before Quicken (MSMoney anyone) and now trying to get out of Q and stay out of the cloud, MD seem the best alternative. I seem to have an upgraded version of Q 2017 that still exports QIF but doesn't work with TD bank anymore. In the past 2 years a number of mutual funds exchanged for slightly different names and ticker symbols which the Q magic handled well, but I'm looking through everything in the MD migration now, since the balances certainly don't match. At least I know where to look thanks to this thread.</p>
<p>I also miss the concept of a payee list, since some of them provide multiple services: How much did Verizon get altogether for TV, Internet, phone, wireless; or the local handyman company for electrical, storm repairs, etc without having to create a specially filtered report.</p>
<p>Personally I'd say MD still has a way to go to be as powerful and convenient as the Q, but still attractive as one of a few tools with local, not cloud based, data storage.</p></div>olsenhatag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082022-02-26T23:17:35Z2022-02-26T23:17:35ZThe Vicissitudes of Quicken to Moneydance<div><p>Popping this discussion, as for some reason SEARCH will not find it.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082022-02-27T10:50:33Z2022-02-27T10:50:33ZThe Vicissitudes of Quicken to Moneydance<div><p>Hi,</p>
<p>As there is no payee list you could try using " tags " to collect together<br>
payee information.</p>
<p>Davud</p>
<p>From: dtd <a href="mailto:tender+dd22a6a72d@tenderapp.com">tender+dd22a6a72d@tenderapp.com</a><br>
Sent: Saturday, 26 February, 2022 11:18 PM<br>
To: <a href="mailto:davidvernonlong@gmail.com">davidvernonlong@gmail.com</a><br>
Subject: Re: The Vicissitudes of Quicken to Moneydance [Switching to<br>
Moneydance #15012]</p></div>davidvernonlongtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082022-09-08T19:53:57Z2022-09-08T19:53:57ZThe Vicissitudes of Quicken to Moneydance<div><p>Popping this again, as an interested user is pursuing this exact issue, and I hope to provide an answer here versus in their thread.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082022-09-08T20:02:37Z2022-09-08T20:18:28ZThe Vicissitudes of Quicken to Moneydance<div><p>I found this thread from Nov 2019 (about when this thread was created) that is extremely useful. As I am not the originator, I cannot reopen it, but I can link to it:</p>
<p><a href="https://infinitekind.tenderapp.com/discussions/problems/57338-notes-on-importing-25-years-of-complex-quicken-data">https://infinitekind.tenderapp.com/discussions/problems/57338-notes...</a></p>
<p>Another good one about the vicissitudes:</p>
<p><a href="https://infinitekind.tenderapp.com/discussions/switching-from-another-personal-finance-program/16455-importing-files">https://infinitekind.tenderapp.com/discussions/switching-from-anoth...</a></p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082022-09-08T22:59:33Z2022-09-08T22:59:33ZThe Vicissitudes of Quicken to Moneydance<div><p>Copied from a newer thread:</p>
<p>Ok, here goes, while I'm in the mood. Realize all of this is from my 3 year old memory, so I'm willing to edit when called out.</p>
<p>1) Extract to one QIF file with everything checked. Import to a new MD File. Note what works, and what does not. Banks/credit cards should basically work, investment accounts should have all security values correct (though current stock value may be wrong - Quote Loader can help there). Balances for all accounts could be very crazy.</p>
<p>You may find the existence of many ACCOUNTX accounts, some of which may have one entry, some many.</p>
<p>You can stop here by changing the initial balance to an arbitrary value that causes each account to have the correct value for TODAY. Hide the ACCOUNTX accounts. This SHOULD give you something you could work with, but some will want to go further. If you do not have something you MIGHT work with, there may be a different problem.</p>
<ol>
<li>Start to fix things (I did it in Quicken). This is an ITERATIVE process. I imported QIF exports many times to observe what I'd improved and what I had not.</li>
</ol>
<p>ACCOUNTX: If one entry - go fix the entry in Quicken, if many - well, maybe make a category (CAR-Change in Asset Value) and point the transaction to that versus to the account itself.</p>
<p>Cash Balance Issues between investments/banks - XIN/XOUT is your friend. Find where this happens and understand the action is probably not supported outside of Quicken. Quicken DOES allow batch changes to Action Types (MD does not). Change all BLAHBLAH actions to something like XIN/XOUT or some other type MD recognizes.</p>
<p>Investment account cash balances - Whatever makes BUYXFER/SELLXFR from Quicken in MD doesn't work. Change to BUY/SELL in Quicken or something that works. (I don't remember them all after 3 years)<br>
Do this iteratively and see the cash balances at least improve.</p>
<p>IRA Accounts. I pray you don't have to deal with this, so I will leave it alone for now.</p>
<p>The two primary things that have to be fixed are ACCOUNTX items and Daily cash balances. Again - there are ways to leave them alone (hide accountx, and live with historical cash balances)</p>
<p>That's at least a start on a process article. Going to get dinner</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082022-12-14T23:38:02Z2022-12-14T23:49:54ZThe Vicissitudes of Quicken to Moneydance<div><p>Anyone who has taken the time to check this long thread out - I am in a sense passing on the baton to someone who would like to condense it and make it more usable (since it is currently way too long). I have done some of the condensing near the end of the thread, but I don't plan to personally take it further, other than mentioning some import concepts elsewhere to those in need of help.</p>
<p>I look forward to someone to bring this all together "after the fact", since most was created (with dwg and derrekkent23 helping me out) as I learned it.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/478219082022-12-14T23:49:08Z2022-12-15T00:16:26ZThe Vicissitudes of Quicken to Moneydance<div><p>If I were "that person", I'd start with the derrekkent23 post that is posted about preparing the QIF file and so on....<br>
<a href="https://infinitekind.tenderapp.com/discussions/switching-from-another-personal-finance-program/21672-how-do-i-incorporate-old-quicken-files#comment_55919792">https://infinitekind.tenderapp.com/discussions/switching-from-anoth...</a></p>
<p>Then I'd point to post 66 here<br>
<a href="https://infinitekind.tenderapp.com/discussions/switching-from-another-personal-finance-program/15012-the-vicissitudes-of-quicken-to-moneydance/page/3#comment_48074651">https://infinitekind.tenderapp.com/discussions/switching-from-anoth...</a></p>
<p>Then I'd edit in post 99 and 98 in some fashion [just scroll up]</p>
<p>There would be more to do, but that might get some folks to have at least a working data set in MD and they could decide if they even needed to go further (like me).</p></div>dtd