Importing Data in QIF Format
[Note: if you are trying to move from Quicken 2019, please read this important update.]
Transferring financial data into Moneydance requires that the data first be exported 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.
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.
-
Purchasing and Upgrading
-
Accounts and Categories
-
Register and Transactions
-
Budgeting
-
Online Banking and Bill Pay
-
Moneydance+
-
Reminders
-
Graphs and Reports
-
General
-
Investment Accounts
-
Loan Accounts
-
Syncing and Sharing Data
-
Currency and VAT/GST
-
Backups and Exporting
-
Importing Data from Other Programs
-
Customizing and Preferences
-
File Locations and Changes
-
Foresight
-
Extensions
-
Moneydance 2017
-
Linux
-
Older Versions
-
ARCHIVE - Getting Started
-
ARCHIVE - Moneydance 2017
- Archive - Moneydance 2017 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2017 from Moneydance 2012, 2014 and 2015
- Archive - Upgrading to Moneydance 2017 from Moneydance 2011 or earlier
- Archive - Changing colours and theme in Moneydance 2017
- Archive - Sharing data using the Moneydance 2017 syncing engine
- View all (15 more)
-
ARCHIVE - Moneydance 2014 and 2015
- Archive - Moneydance 2015 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2015 from Moneydance 2012 and 2014
- Archive - Upgrading to Moneydance 2015 from Moneydance 2011 or earlier
- Archive - Opening a backup file in Moneydance 2015
- Archive - How to restore from a checkpoint in Moneydance 2012 and 2014
- View all (3 more)
-
ARCHIVE - Program Basics
-
ARCHIVE - Account Basics
-
ARCHIVE - Entering Transactions
- Archive - Does Moneydance allow for assigning 'classes' to transactions?
- Archive - How do I get the Register to auto fill todays date instead of the last entered date?
- Archive - How do I move a transaction to a different account?
- Archive - How do I enter my Paycheck?
- Archive - How do I create a split transaction?
- View all (2 more)
-
ARCHIVE - Online Banking
-
ARCHIVE - Mobile
- Archive - Syncing Moneydance 2015 with your Mobile Device
- Archive - Syncing Moneydance 2012 and 2014 with your Mobile Device
- Archive - How to sync with Moneydance 2008, 2010, and 2011
- Archive - How do I delete a transaction on the iPhone, iPad, or iPod touch?
- Archive - How to sync one data file with multiple iOS devices using different Dropbox accounts
- View all
-
ARCHIVE - Budgeting and Reminders
- Archive - Creating reminders (automatic repeating transactions or notes)
- Archive - Creating a budget using the 'Newer' format
- Archive - Creating a budget using the 'Mixed Interval' (Older) format
- Archive - What's the difference between a General and Transaction reminder?
- Archive - How do I have a reminder automatically entered into my register?
- View all (1 more)
-
ARCHIVE - International Tools
- Archive - Setting up VAT/GST
- Archive - Can you change the word "Check" to "Cheque" anywhere in the programme?
- Archive - How can I enter the exact amounts on both sides of a foreign currency transfer?
- Archive - My household/country/company uses a fiscal year instead of a calendar year. Can I do this in Moneydance?
- View all
-
ARCHIVE - Investments
- Archive - How do I add Securities to a new Investment Account?
- Archive - How can I import security, stock or mutual fund prices?
- Archive - Entering your current holdings
- Archive - Creating a new investment subtype
- Archive - Downloading security, stock or mutual fund prices from non-US stock exchanges
- View all (5 more)
-
ARCHIVE - Extensions
-
ARCHIVE - Everything Else