Skip to the converter
StatementZap

Guides

How to import a QIF bank statement into Quicken

Download a QIF file from a bank statement and import it into a Quicken account.

  1. 1

    Choose QIF when Quicken asks for it

    QIF is the older Quicken import. Use it when the account does not accept QFX, or when you are moving a statement into a Quicken edition that still imports QIF.

  2. 2

    Convert the statement

    Upload the CSV, Excel file, text PDF, or an existing QFX or QBO file and download QIF. Dates and signed amounts are the same transactions as the other downloads.

  3. 3

    Import the file

    In Quicken choose File, then File Import, then QIF. Select the bank or card account. Confirm the date order Quicken shows if it asks.

  4. 4

    Watch for a second import

    QIF matching is weaker than a Web Connect fit id. Importing the same QIF twice can add the rows twice. Import a period once.

Questions

Will this QIF file open in QuickBooks?

QuickBooks Desktop wants QBO or IIF, not QIF. Quicken is the program this download is for.