IIF to QIF Converter Online for Quicken

Why QIF?

Quicken for Windows imports QIF under File → File Import → QIF File, not IIF. Utilly reads each TRNS row and writes a bank or card QIF with posted dates, signed amounts and payees. Prefer a spreadsheet with SPL accounts as Category? Use IIF to CSV or IIF to Excel. Going the other way? Use QIF to IIF.

How to convert IIF to QIF

Get the IIF. Use a Desktop .IIF you exported, one from Review now after a failed import, or a converter-made file. Our sample IIF file shows a working bank file. Prefer dates that aren't already in Quicken.
Upload it above. Each TRNS / SPL / ENDTRNS block becomes one Quicken row. Signs stay as written on the TRNS amount; TRNSTYPE tells bank CHECK/DEPOSIT rows from CREDIT CARD / CCARD REFUND.
Check the preview. Money out should be negative. Create the Quicken account first if it isn't there yet (checking/savings for a bank IIF, credit card for a card IIF).
Download the .QIF and back up your Quicken data file (steps below).
Import in Quicken for Windows: File → File Import → QIF File, choose the download and pick the Quicken account it belongs to. Quicken for Mac does not import QIF into an existing account (see below).

IIF vs QIF

People search "iif to qif" with a QuickBooks Desktop .IIF in hand and Quicken waiting for a format it can import. Side by side:

You have	What it is	What to do
A QuickBooks Desktop `.iif`	Tab-separated TRNS / SPL / ENDTRNS for local Desktop import: no bank check, no transaction IDs, SPL rows hold offset accounts	Upload it here when you need a Quicken .qif for Windows File Import.
A Quicken Classic `.qif`	Plain-text export: one letter-coded field per line (D, T, P, M), caret between transactions, no bank check, no transaction IDs	Already the right shape for Quicken for Windows. Going the other way into Desktop? Use the QIF to IIF converter.
A QuickBooks Web Connect `.qbo`	OFX plus Intuit tags for QuickBooks (not "QuickBooks Online" the product)	Prefer IIF to QBO when Online or a supported Desktop version needs Web Connect instead of Quicken.

IIF is Desktop-only. Quicken never imports IIF. Converting writes a bank or card QIF Quicken for Windows can import under File → File Import → QIF File.

What carries over from the IIF

One payroll debit in our sample QuickBooks Desktop IIF (made-up data):

!TRNS	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	MEMO
!SPL	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	MEMO
!ENDTRNS
TRNS	CHECK	09/01/2026	Business Checking		-6420.18		ACH DEBIT GUSTO PAYROLL 0912
SPL	CHECK	09/01/2026	Payroll		6420.18		
ENDTRNS

becomes this in the QIF:

!Type:Bank
D09/01/2026
T-6420.18
PACH DEBIT GUSTO PAYROLL 0912
MACH DEBIT GUSTO PAYROLL 0912
^

In the IIF	In the QIF
DATE on the TRNS row	D line, written MM/DD/YYYY for Quicken's US format.
AMOUNT on the TRNS row	T line, the same signed amount, two decimals: negative for money out.
NAME, or MEMO when NAME is empty, or DOCNUM as CHECK n	P payee line (cut to 64 characters) and the full text on the M memo line.
TRNS ACCNT (for example Business Checking)	Names the account's tab and download. The QIF itself has no account name inside — Quicken asks which account to put the rows in.
CREDIT CARD / CCARD REFUND types	`!Type:CCard`. Import it into a credit card account.
SPL ACCNT (Payroll, Office Expenses, Split: …)	Dropped. The QIF we write has no category line. A multi-SPL transaction comes through as one line for the TRNS total. (The Clean CSV keeps the category: see IIF to CSV or IIF to Excel.)
Balances	An IIF has none, so the QIF carries no ending balance. Reconcile against your statements.
Transaction IDs	None in an IIF, and QIF has no ID field either — Quicken can't skip repeats.

Before you import: Quicken for Windows vs Mac

Every QIF record letter, including the ones this converter does not write, is explained with a real sample on QIF file format.

Back up your Quicken data file. A QIF import can't be undone in one step, and a QIF has no transaction IDs, so Quicken can't tell a repeat from a new row.
Create the account first if it isn't in Quicken yet: a checking or savings account for a bank IIF, a credit card account for a card IIF. Quicken's help says the account must already exist and appear in the QIF Import dialog's account list.
Quicken for Windows: File → File Import → QIF File, choose the download and pick that account under Quicken account to import into.
Quicken for Mac: QIF import is not for an existing file. Quicken for Mac reads a QIF only when you choose File → New → Start from a .QIF file. For ongoing transactions on a Mac, Quicken takes your bank's own Web Connect (QFX) download, or a CSV in its Mint column layout — we don't write that CSV layout yet, so this converter isn't the right fit for Quicken for Mac into an existing account.
Check the register afterwards. Categories from the IIF's SPL rows aren't in the QIF, so Quicken's renaming and category rules apply after import. Compare the account's balance on the last imported date with your statement.

QuickBooks Desktop and QuickBooks Online never import QIF. Going back into Desktop without Web Connect? Keep the original IIF, or use QIF to IIF if you already have a Quicken file. Online never takes IIF — use IIF to QBO instead.

Which IIF files work

Transaction IIFs with !TRNS / !SPL / !ENDTRNS headers and matching data rows. Column order can vary; we read the header names.
Bank types (CHECK, DEPOSIT, …) and card types (CREDIT CARD, CCARD REFUND). Card files keep charges negative and refunds positive when signed that way.
Files with several accounts (different TRNS ACCNT values): one tab and one QIF per account, plus a combined CSV whose first column is the Account.
List-only IIFs (accounts, customers, vendors with no TRNS rows) are refused with a message — there's nothing to put in a QIF.
Free up to 100 transactions, and up to 20,000 per file.

Common problems

Problem	Fix
Quicken for Mac has no QIF import into an existing account	Expected. Use File → New → Start from a .QIF file only for a brand-new data file, or import your bank's QFX / a Mint-layout CSV on Mac instead.
The same transactions appear twice	A QIF has no transaction IDs. Import only dates that aren't in the account yet.
Categories / SPL accounts missing	Expected. The QIF we write has no category line. Use IIF to CSV if you need the Category column, or let Quicken's rules categorize by payee after import.
"No transactions found in that IIF file"	The file only had lists (accounts, names) or the keywords were renamed. Rebuild with TRNS/SPL/ENDTRNS rows, or check it with the free IIF file checker.
Card payments show as charges	Choose Credit card as the account type, check the signs in the preview and tick Flip signs if they're backwards.
Want QFX instead of QIF?	We don't write QFX. Quicken for Windows reads QIF directly; a converted QFX usually fails Quicken's bank check anyway.
Need the rows in QuickBooks Online instead	Online never takes IIF or QIF. Use the IIF to QBO converter and upload the .qbo under Bank transactions → Upload from file.

Other conversions

Just need to open or view the .IIF? How to open an .IIF file covers QuickBooks Desktop (Windows and Mac), Excel's Text Import Wizard and opening it without QuickBooks.
IIF to CSV or IIF to Excel for a spreadsheet with SPL accounts as Category: the IIF to CSV converter and IIF to Excel converter.
IIF to QBO for QuickBooks Online or a supported Desktop version: the IIF to QBO converter.
Going the other way (QIF → IIF) for QuickBooks Desktop: the QIF to IIF converter.
QIF to CSV or QIF to Excel when you already have a Quicken file: the QIF to CSV converter and QIF to Excel converter.
QBO to IIF: the QBO to IIF converter. Bank CSV or Excel to QIF: CSV to QIF and Excel to QIF.
Only have PDF statements? The PDF statement to QIF converter checks each statement against its balances first.
Not sure which format you need? See QBO vs IIF vs QIF and the sample IIF file guide.

Pricing

Free for files up to 100 transactions, which covers a typical month of activity. Larger files (a year of catch-up, a client's full history) use 1 credit from the same $9 pack of 5 as our PDF statement converter, or unlimited on Pro at $19/month. The preview is always free.

FAQ

Questions

Is it free?

Yes for files up to 100 transactions: no sign-up, no watermark. Bigger files (multi-month catch-up work) use 1 credit from the same $9 / 5-credit pack as our PDF converter, and the preview is always free.

Is my file stored?

No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.

Can I try it without uploading my own file?

Yes. Click a sample button under the upload box. It opens a made-up export from a fictional bank in the same preview your own file gets, and every format is free to download, so you can test an import in a test or backup company file first. Don't import a sample into your real books.

What's the difference between IIF and QIF?

IIF is QuickBooks Desktop's tab-separated import (TRNS/SPL/ENDTRNS): local, no bank check, no transaction IDs, with offset accounts on SPL rows. QIF is Quicken's plain-text format: one letter-coded field per line, also no bank check and no transaction IDs. Quicken never imports IIF; QuickBooks never imports QIF.

Does Quicken for Mac import the QIF?

Not into an existing account. Quicken for Mac reads a QIF only when you choose File → New → Start from a .QIF file. For an existing Mac file, Quicken takes your bank's own Web Connect (QFX) download, or a CSV in Quicken's Mint column layout. We don't write that CSV layout yet.

Are my SPL accounts kept?

No. The QIF we write has the date, amount, payee and memo for each TRNS row, no category line. A multi-SPL transaction comes through as one line for the TRNS total. Use IIF to CSV or IIF to Excel if you need the Category column.

Will Quicken skip rows I've already imported?

Don't count on it. A QIF has no transaction IDs, so Quicken can't match rows it already has. Import only dates that aren't in the account yet.

Can I convert a credit card IIF to QIF?

Yes. CREDIT CARD and CCARD REFUND types are detected and written as !Type:CCard. You can also choose Credit card as the account type in the preview.

My IIF has several accounts. Will that work?

Yes. Each TRNS account gets its own tab in the preview and its own QIF, named after the account. Import each into its matching Quicken account. One credit covers the whole file.

Can I convert QIF back to IIF?

Yes, with the QIF to IIF converter. For QuickBooks Online (which never takes IIF), use IIF to QBO instead.

Can I convert IIF to QFX?

Not here: we don't write QFX. Quicken for Windows reads QIF directly under File → File Import → QIF File, so you usually don't need a QFX.

Convert IIF to QIF for Quicken

Why QIF?

How to convert IIF to QIF

IIF vs QIF

What carries over from the IIF

Before you import: Quicken for Windows vs Mac

Which IIF files work

Common problems

Other conversions

Pricing

Questions

Other converters

Convert CSV to QBO for QuickBooks

Convert Excel (.xlsx) to QBO for QuickBooks

Convert CSV to IIF for QuickBooks Desktop

Convert Excel to IIF for QuickBooks Desktop

Convert OFX or QFX to IIF

Convert a .QBO file to IIF

More bookkeeping tools

Receipts & invoices to CSV

Bank reconciliation checker

QuickBooks reconciliation discrepancy finder