Importing data from Quicken in QIF format

Transferring financial data from Quicken into Moneydance requires that the data first be exported from Quicken as a QIF file. This can be accomplished from the File -> Export... menu option within Quicken.

There are essentially two types of QIF files. Those that contain only one accounts worth of data and those that contain all account information for multiple accounts. The import process is slightly different depending on whether your QIF file contains one or many accounts.

It is highly recommended to export all Quicken data into a single QIF file. Doing so makes the import process much smoother. Please use the option in Quicken to export "all accounts," if available.

If you exported your Quicken data into a single file -

  1. If this is the first time you have run Moneydance you will be presented with 3 options. Click the button that says "Import File...". If you already have run Moneydance and have an existing Moneydance data file, in the menu bar go to File->Import. If you would like to open a new, blank data file before importing go to File->New and select the "Minimal Account Set," then in the menu bar go to File->Import.
  2. A file browser will be displayed. Navigate to your QIF file, select the file, and click "OK".
  3. 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.
  4. It may take a few minutes to import your QIF file, this time will vary depending on the size and complexity of the file being imported.

Import_QIF_file.png

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.

If you run into any issues after the import, you'll find solutions for the most common import problems here.

If you exported your Quicken data into multiple QIF files, one for each account -

  1. If this is the first time you have run Moneydance you will be presented with 3 options. Click the button that says "Import File...". If you already have run Moneydance and have an existing Moneydance data file, in the menu bar go to File->Import.
  2. A file browser will be displayed. Navigate to your QIF file, select the file, and click "OK".
  3. 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.
  4. Ensure that the option to "Import account Info Only" has been enabled. Then click OK.
  5. Navigate again to File --> Import to import your data into the newly created accounts.
  6. The "Import QIF File" window will be displayed again. From this window set the "File Source:" to "From Another Program". This time do NOT check the "Import Account Info Only" box.
  7. From the "Import To:" option Select "Existing Account" and select the Moneydance account that you want to import the data into.
  8. Click OK and repeat these steps for all the accounts you want to import.

If you run into any issues after the import, you'll find solutions to the most common import problems here.