Importing Data in QIF Format

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

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 data into a single QIF file. Doing so makes the import process much smoother. Please use the option to export "all accounts," if available.

The one exception to this is if you have accounts in more than one currency. If thats the case, you should export multiple QIF files, one for each account.

Import a Single QIF File -

  • If this is the first time you have run Moneydance you will be presented with 3 options within the 'Welcome to Moneydance' window. Click the button that says "Import File...".

  • If you already have run Moneydance and have an existing Moneydance data file, navigate to File -> Import.

  • If you would like to open a new, blank data file before importing go to File -> New and choose "Minimal Account Set," then go to File -> Import.

  • A file browser will be displayed. Navigate to your QIF file, select the file, and click "OK".

  • The "Import QIF File" window will appear. It's very important that you select -
    "Import To: New Account" and "File Source: From Another Program".

  • You can set the date, decimal character, and currency as desired. Click OK.

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.

QIFsingleimport.png

Import Multiple QIF Files

  • If this is the first time you have run Moneydance you will be presented with 3 options within the 'Welcome to Moneydance' window. Click the button that says "Import File...".

  • If you already have run Moneydance and have an existing Moneydance data file, navigate to File --> Import.

  • A file browser will be displayed. Navigate to your QIF file, select the file, and click "OK".

  • The "Import QIF File" window will appear. It's very important that you select -
    "Import To: New Account" and "File Source: From Another Program".

  • You can set the date, decimal character, and currency as desired.

  • Ensure that the option to "Import account Info Only" has been enabled. Then click OK.

This will import your account information like account, categories etc - without your transactions

  • Navigate again to File -> Import to import your data into the newly created accounts.

  • The "Import QIF File" window will be displayed as before.

  • Set the"File Source: From Another Program". Then choose to "Import To: Existing Account" and select the Moneydance account that you want to import the data into.

  • You should ensure that this time, the option "Import Account Info Only" is disabled.

  • Click OK and the transactions should populate into the designated account.

  • Repeat these steps for all the accounts you want to import.

QIFmultipleimport.png