Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Yes. While older versions of Quicken did not have this capability, there are no longer limitations on the types of accounts you can import using QIF.

...

The Quicken Interchange Format (QIF) is an open file format used for transferring financial data between software programs. QIF files store data in plain-text, ASCII format, making them easily readable and editable. Each file begins with a header indicating the type of account (e.g., banking, credit card, or investment) and contains detailed transaction records with fields such as dates, amounts, payees, and categories.

Info
titleCan I import data from a QIF file into a banking or investment account?

Yes. While older versions of Quicken did not have this capability, there are no longer limitations on the types of accounts you can import using QIF.

See Exporting data from Quicken for more informationinformation about setting up your export.

Importing a QIF file

To import a QIF file into Quicken for Windows, follow these steps:

  1. Open the import tool:

    • Go to the File menu in Quicken.
    • Select File Import > QIF File.
  2. Set import preferences:

    • Use the dropdown menu to select the appropriate account. 
    • Browse for and select your QIF file.
    • Set the date range and check options like duplicate detection.
  3. Import the file:

    • Click OK to import the file.
    • Review the imported transactions in the account register for accuracy.
  4. Move transactions (optional):

    • If you imported into a temporary cash account, copy and paste the transactions into the intended account.
  5. Verify and adjust:

    • Ensure all transactions are correctly categorized, reconciled, and in the appropriate account.

Tip: Always back up your Quicken data before importing to avoid accidental changes or data corruption.