Home → Switching to Moneydance →

Quicken export to QIF options?

• Edit

Jim

Feb 25, 2018 @ 04:48 PM

What do I include when exporting data from Quicken for importing to MoneyDance?

When I do File->Export->QIF... I get a dialog box (see attached picture).

By default, only Transactions is selected. Do I want to select others as well?
All of them?
Some of them (which ones)?

Thanks

• quicken.JPG 41.3 KB

1. 1 Posted by derekkent23 on Feb 25, 2018 @ 05:06 PM

   

   I am not support staff, just a user.

   Many people have successfully transferred from Quicken.
   To transfer data from Quicken you need to export a QIF file, you can't import Quicken files directly. See the set of articles relating to this topic at http://help.infinitekind.com/kb/importing-data-from-other-programs
   Check the date format Quicken has used when it created the QIF file. Open it in a text editor, Make sure you use the select the same format when you import into Moneydance even if it is different to the one you wont yo use when running Moneydance,
   When you follow the steps in the article above make sure you follow the steps accurately, in particular, make sure you specify to Import into a new account rather than an existing account. Also make sure you set the source to "From another program".
   It is highly recommended to export all data into a single QIF file, as doing so makes the import process much smoother. Please use the option in Quicken to export "all accounts" if available.
   Quicken does not always export the initial balance for each account. After importing into Moneydance, highlight an account, click on ACCOUNT – EDIT ACCOUNT and set an “Initial Balance”. Do this for each account.

   For general information see http://help.infinitekind.com/kb

   If you have specific issues give as much detail as you can and support or others will answer your questions.

   Hope this helps.

   • Edit

2. 2 Posted by Jim on Feb 25, 2018 @ 05:33 PM

   

   I've seen your replies many times, derekkent23. However, neither your reply nor the articles pointed to by your reply answer my question:

   Which export options do I use?

   • Edit

3. 3 Posted by whitedavidp on Mar 02, 2018 @ 05:30 PM

   

   I have to disagree a bit with the recommended approach. What I did was first export for all accounts selecting everything except transactions. I imported this into MD. I then went account by account selecting ONLY transactions and imported them into MD. With each import, I have to check for errors and mis-match between quicken and MD. It took some time. But I managed to work it all out. And this was for decades of quicken data. Now have cut quicken loose once and for all.

   • Edit

4. 4 Posted by dwg on Mar 02, 2018 @ 08:24 PM

   

   I'm a fellow user.

   David,

   FWIW You can take this type of approach without performing multiple exports from Quicken - not all versions of Quicken offer these choices either.

   In the Moneydance Import options there is an option to Import account details only. this effectively brings in all details bar the transactions.

   It's an approach that I would also recommend be taken. After bringing in the "account details" and this is a little misleading in that it really means bring in all details except the transactions I recommend checking to make sure that all accounts have been created and as their correct types, categories are set up as categories and are correctly defined as Income or expense, categories have not been set up as an account etc. But do not change any names, spellings, or where categories sit in the structure.

   This may all sound strange but the QIF format is somewhat ambiguous in places, it was really designed to bring transactions into a pre-existing account/category structure so using its contents to create the structure is not perfect. Also if you change a name or structure when you bring in the transaction data it will create new accounts/categories that it thinks matches to the contents of the QIF file. That all being said it is the best format available for migrating data.

   To answer your question Jim, I would suggest trying to select all options except Memorized Payees and see how it goes.

   • Edit

5. 5 Posted by Jim on Mar 02, 2018 @ 10:05 PM

   

   Thanks for the suggestions.

   What I've found is that for bank accounts and credit cards, it appears that only the transactions gives the best results.

   Investing accounts are another matter altogether and nearly everything I've tried up to this point requires a significant amount of work no matter what options I've used.

   And since Quicken doesn't track my investment accounts 100% accurately, I've decided to track those on the financial institution's website only. Then both Moneydance and Quicken both do exactly what I need them to do.

   • Edit

6. 6 Posted by Jim Kellerman on Mar 02, 2018 @ 10:08 PM

   

   ---
   Jim Kellerman

   • Edit

7. System closed this discussion on Jun 01, 2018 @ 10:10 PM.