How to import a QIF file into Quicken

Import a QIF file into Quicken (2017 or earlier) for Windows

Quicken Interchange Format (QIF) is a file format that is specifically designed to transfer financial data between different software programs, including personal finance management tools like Quicken. There are several reasons why QIF may be a better choice for importing data into Quicken compared to other file formats:

  1. Compatibility: QIF is specifically designed to be compatible with Quicken and other personal finance management software. This means that it can easily be imported into Quicken without any issues or errors. Other file formats, such as CSV (Comma Separated Values), may not be as compatible with Quicken and may require additional steps or conversions in order to be imported.
  2. Ease of use: QIF files are relatively easy to use and do not require any special software or technical skills to import into Quicken. As long as you have a QIF file and access to Quicken, you can import the data with just a few clicks.
  3. Data integrity: QIF files are designed to maintain the integrity of financial data during the import process. This means that the data in the QIF file will be imported into Quicken exactly as it appears in the file, without any loss of information or formatting errors.
  4. Customization: QIF files allow users to customize the data that is imported into Quicken. For example, you can choose to import only certain types of transactions or specify the date range for the imported data. This can be useful if you only want to import specific types of financial information into Quicken.

This tutorial works also on Quicken 2005-2017 Deluxe or higher editions, like Home Business. It doesn't work on the Quicken Starter Edition.

There are two types of QIF files:

IMPORTQIFQUICKEN Windows Step 1: types of Quicken

Now to import a QIF file into Quicken click 'File' - 'File Import' - 'QIF File'.

IMPORTQIFQUICKEN Windows Step 2: file import in Quicken

Then click the 'Browse' button and select a QIF file.

IMPORTQIFQUICKEN Windows Step 3: click browse in Quicken

In our case, we have a Checking Account Name. We can not select it in the 'Quicken account to import into' Tab. We have only 'All Accounts', that's what we must select.

IMPORTQIFQUICKEN Windows Step 4: checking in Quicken

A QIF file has an Account Name, as part of the QIF file. When you are using ProperSoft converter you have to enter that Account Name before converting to a QIF file. In this case, we have a Checking Account and we enter the Account Name, as Checking.

IMPORTQIFQUICKEN Windows Step 5: Account Name in Quicken

You can ignore 'Don't see your account?' (QIF import is not available for checking, savings, credit cards, 401(k) and all other brokerage accounts) as long as you select 'All Accounts'. To import a QIF file click the 'Import' button.

IMPORTQIFQUICKEN Windows Step 6: click Import in Quicken

All transactions are successfully imported. Click the 'Done' button.

IMPORTQIFQUICKEN Windows Step 7: transactions imported in Quicken

Transactions are not in the register yet.

IMPORTQIFQUICKEN Windows Step 8: transactions are not in register in Quicken

Review transactions before adding to the register. Click 'Edit' - 'Preferences'.

IMPORTQIFQUICKEN Windows Step 9: preferences in Quicken

Edit 'Downloaded transactions preferences'. 'Automatically add to banking registers' and 'Automatically add to investment transaction lists' must be unchecked.

IMPORTQIFQUICKEN Windows Step 10: edit preferences in Quicken

And when you like, what you see, you can accept all transactions. Click on 'Accept All' button.

IMPORTQIFQUICKEN Windows Step 11: accept all in Quicken

Now transactions are in the register.

IMPORTQIFQUICKEN Windows Step 12: transactions are in the register in Quicken

Related articles