Please note: we've moved our customer support and forums. Please join us at the new location!

Importing Data from Quicken using multiple QIF files

Angie Rauscher -

These instructions involve exporting your data into multiple QIF files, one file per account.  You should ONLY use these instructions if your version of Quicken does not permit exporting into a single QIF file, or if your Quicken data file contains accounts in more than one currency. If this does apply to you, please follow the instructions here.

  1. First you will need to export your data from Quicken in QIF format. Open your data file in Quicken, then in the menu bar select File->Export->Selected Items to QIF.  Most versions of Quicken will permit you to export transactions in "Selected Accounts" - export one account at a time.  Export all accounts from Quicken before moving on to step 2.
  2. If this is the first time you have run Moneydance you will be presented with 3 options. Click the button that says "Import File..." and skip to step 4. If you already have run Moneydance and have an existing Moneydance data file open your existing data file. If you would like to open a new, blank data file before importing go to File->New and select the "Minimal Account Set."
  3. In the menu bar go to File->Import.
  4. A file browser will be displayed. Use it to locate the first of your QIF files. It is best to import the QIF file for your most complex account(s) (such as your primary checking account) first.  Select the file and Click "OK".
  5. The "Import QIF File" window will appear.  Select "Import To: New Account", "File Source: From Another Program", and set the date, decimal character, and currency as desired. Click OK.
  6. Repeat steps 3-5 for each account you want to import. 
  7. You may find that importing multiple QIF file creates duplicate transactions, especially those transactions which record transfers between accounts.  You will need to manually delete these duplicate transactions.
  8. If after importing data your balances are incorrect, the most likely cause is the QIF file did not include an initial balance transfer as the first transaction for the account. You will need to set the initial balance on your accounts in Moneydance manually as described here.
Have more questions? Submit a request

Comments