Import Quicken Data

DJ's Avatar

DJ

04 Jan, 2020 09:52 AM

I need to Import QUICKEN HOME and BUSINESS DATA FILES.

  1. 1 Posted by DJ on 04 Jan, 2020 09:55 AM

    DJ's Avatar

    The file "extension" is "QDF." Is this compatible?

  2. 2 Posted by dwg on 04 Jan, 2020 10:11 AM

    dwg's Avatar

    I'm a fellow user.

    The QDF format is proprietary to Quicken, other vendor's products cannot read these files.

    It is necessary to use Quicken itself to export the raw transaction data into, preferably, QIF files, which Moneydance and incidentally other vendor's product can read.

    Importing data from other vendor products is discussed in a series of articles in the Moneydance knowledge base:

    https://infinitekind.tenderapp.com/kb/importing-data-from-other-programs

    You can download the software and try it out in trial mode to experience the migration and see if the product suits you.

  3. 3 Posted by D Johnson on 05 Jan, 2020 05:08 AM

    D Johnson's Avatar

    Hi, DWG, I sure appreciate your help. I have a VERY big Data file. I
    did finally "export" a QIF and then imported that data and it resulted in a
    ton of errors and inflated balances.

    I am SURE it is a GIGO situation (Garbage in, Garbage out) because I have
    over 20 years of Quicken data in there, and it has not always balanced
    perfectly. For example, I traded Options in the stock market and those
    were difficult to registry enter.

    So, now that I can see my GIGO situation, I am thinking that I will need to
    simply REMOVE old unused/closed accounts but of course, those accounts were
    CLOSED and MONEY was transferred out and then re-established at other
    Brokerages or Banks.

    This is the hard part about transitioning data. I am not sure what to
    do. If I simply remove an account, will the INCOMING (transferred in
    balances) remain or not?

    So, I will test it out. I want to wander away from Quicken Slowly as they
    sold out and pretty much handed over a great program, allowed to be used
    "off-line" and into a situation where Quicken is a subscription model.
    This really ticked me off but I am older now and ticked off does not mean
    productive.

    Thanks, again....

    DJ

  4. 4 Posted by dwg on 05 Jan, 2020 06:02 AM

    dwg's Avatar

    I'm a fellow user.

    Moneydance is based on accounting rules, and specifically double entry accounting, if you delete an account it deletes any transfers from both accounts, there are no orphaned or one sided transactions.

    I migrated many years of data and in some cases investments going back 30 years and many closed accounts.

    I started by getting my open bank and credit card accounts correct. Progressively over time I worked on open Investment accounts and then back through closed bank, credit card and Investment accounts.

    Moving from Quicken is not an overnight task especially once you start to talk about Investment Accounts. Bank & Credit Card accounts generally come over pretty cleanly without too many problem, the biggest problem with these types of accounts is that the Quicken output often does not include an opening balance, which looks like it throws everything wildly out, by entering the initial balance into Moneydance makes it look a lot better.

  5. 5 Posted by DJ on 05 Jan, 2020 06:20 AM

    DJ's Avatar

    Man, I appreciate these replies. YOU ARE SO KIND to reply, esp so fast.

    I am mourning the loss of Quicken. Did you try Quicken 2017 before throwing out the program altogether. I might try that, pay for it and migrate my data (which has never been a problem, since I began using it way over 15 to 20 years ago as I cannot recall when I got myself started, but I have 1997 data in there).

    Anyway, it appears that I have a big job ahead of me. THANKS again.

    DJ

    Sent from Mail for Windows 10

  6. 6 Posted by dwg on 06 Jan, 2020 11:29 AM

    dwg's Avatar

    I migrated in 2012 and as I'm in Australia I was using the localized version of Quicken which is produced by Reckon, I have not tried any later versions, especially now that Reckon wants $170 per year and it keeps going up.

  7. 7 Posted by DJ on 06 Jan, 2020 12:09 PM

    DJ's Avatar

    I had to give up, DWG, on this program for now as I needed to clean up and archive old data which I would rather do upon our return home to the USA. We have a place in Portugal for wintering and I bring a rather small laptop….even more importantly, I have a dual monitor setup at home which will make that work easier as I have two big screens which enables me to look at two programs at once.

    So, I went to Ebay and found a new/used 2017 Version of Quicken Home and Business….he bad bought it and had never used it. This is the last year of Intuit’s ownership, I think and newer than my existing version. I got it for 20 dollars US.

    So, I will import my old data and use that version for a few years and then go from there.

    I will manually update my quicken file at home.

    Thanks, again, for your input.

    DJ

    Sent from Mail for Windows 10

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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