The Vicissitudes of Quicken to Moneydance

dtd's Avatar

dtd

10 Nov, 2019 05:57 AM

Ok. I'm ready to move. I did the QIF dance (thankfully I'm still on Quicken 2017) and am majorly impressed by what I end up with in Moneydance.

There are two big issues that I currently see. (I've only been looking things over for an hour or so)

CASH BALANCES are wonky. YES - I know the "Initial balance" bit. All those are fine (now). Most credit cards, cash, and accounts that never interacted with other accounts are beautiful. But with 20 years of data, and with tons of investment accounts that came and went, transfers between accounts (like creating an account, and populating it with securities) totally mess up the cash balance.
This is a pretty big deal as it affects tons of my older accounts that should have a zero CASH balance, but scream "fix me"!

The securities, their amounts, and balances are fine. But Quicken has an "ADD-Shares Added" attribute which specifically says "add shares to this account without affecting the cash balance". I doubt the QIF file tells Moneydance this, so no blame, but sure enough a lot of negative cash balance occurs as the transaction "buys" these shares. In fact it is doubly bad, as it ends up being a BUYXFR in Moneydance, so that ends up doubling the cash change.

Another bit is an account charging an item to its own category. (i.e. a writeoff - I have a CAR category and occasionally depreciate the car by putting in a transaction that just writes off a few thousand bucks on it) - whatever the QIF sends causes Moneydance to create a CARX category that I guess "absorbs" the writeoff. Makes it difficult to figure out, again with years of data.

Thirdly - sometimes it seems the positive/negative is backwards for the Quicken QIF import - so what is a charge becomes a deposit or vice versa. This seems to be a well known issue here, but still a pain to reverse everything by hand. I tried the find/replace extension, but since values are different, it looks like I will have to do each of the "bad" accounts by hand.

As a point of order - what determines for an investment account what goes into register, bank register, and securities detail? Although these seem accurate (other than, again cash balances), I'm trying to figure out Moneydance's categorization for those three tabs.

Overall, I'm impressed, but with 20 years of data, there's a lot of cleanup (mostly cash balances) to do. I'm tempted to just have a transition day that has tons of entries of cash changes to zero and call it quits and move forward since most of the securities and credit cards and such are perfect, but I'm afraid that would ultimately give me nightmares.

Thoughts appreciated.

Showing page 4 out of 4. View the first page

  1. 91 Posted by harold on 04 Mar, 2021 04:13 PM

    harold's Avatar

    @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).

    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.

    Does the OFX format not include cash transactions?

    I just called the broker TD Direct Investing, and they have no information at all on any of this.
    Thanks

  2. 92 Posted by dwg on 04 Mar, 2021 07:46 PM

    dwg's Avatar

    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.

    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.

  3. 93 Posted by harold on 04 Mar, 2021 09:19 PM

    harold's Avatar

    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.

  4. 94 Posted by olsenha on 21 Mar, 2021 04:05 PM

    olsenha's Avatar

    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.

    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.

    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.

  5. System closed this discussion on 20 Jun, 2021 04:10 PM.

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