Convert QIF to IIF for QuickBooks Desktop

How to convert QIF to IIF

1. Export the QIF. In Quicken for Windows: File → File Export → QIF File. Pick the account (or all accounts), set the dates and tick Transactions under Include in Export (steps from Quicken's help). A bank's own QIF download works the same way.
2. Drop the file above. Each transaction's date, signed amount and payee are read; bank registers are told apart from credit card registers (!Type:CCard).
3. Check the preview. Money out should be negative. If the dates are day-first (01/09/2026 for 1 September), pick that date format in the preview.
4. Type the QuickBooks account name exactly as it appears in Lists → Chart of Accounts (for example Business Checking). Leave it blank and the file uses Checking, or Credit Card for a card register.
5. Download the .IIF and back up the company file first (checklist below). In Desktop: File → Utilities → Import → IIF Files.
6. Open the register afterward. Each SPL posts to Uncategorized Expense or Uncategorized Income until you reclassify it.

Quicken QIF vs QuickBooks IIF

People search "qif to iif" with a Quicken export in hand when QuickBooks Desktop won't take QIF (it never did) and Web Connect isn't available. The two formats sit next to each other:

What carries over from the QIF

One transaction in a Quicken QIF export:

D9/ 1'26
U-6,420.18
T-6,420.18
PACH DEBIT GUSTO PAYROLL 0912
LPayroll
^

becomes this in the IIF (after the three header rows):

TRNS	CHECK	09/01/2026	Checking		-6420.18	ACH DEBIT GUSTO PAYROLL 0912
SPL	CHECK	09/01/2026	Uncategorized Expense		6420.18	ACH DEBIT GUSTO PAYROLL 0912
ENDTRNS

Before you import: account name and backup

The IIF we write puts every transaction into the QuickBooks account name you type in the preview (or Checking / Credit Card if you leave it blank), with the other side in Uncategorized Expense or Uncategorized Income. Type the name exactly as it is in Lists → Chart of Accounts — including any parent (Parent:Child) — or Desktop creates a new account.

1. Back up your company file. An IIF import can't be undone in one step, and IIF has no duplicate check: importing the same dates twice posts them twice.
2. Create the account first if it isn't in the Chart of Accounts yet: a bank account for a checking/savings register, a credit card account for a card register.
3. Go to File → Utilities → Import → IIF Files, choose the file, and let Desktop finish.
4. Check the register afterwards. Reclassify the Uncategorized lines, and compare the account's balance on the last imported date with your bank or Quicken register. The IIF carries no ending balance.

IIF import is a local Desktop feature. It does not go through Intuit's Web Connect service, which is why it still works on Desktop versions whose online services were discontinued (for example Desktop 2023 after May 31, 2026).

Import as QBO, or convert to IIF?

If your Desktop version still accepts Web Connect — or you're on QuickBooks Online — converting the Quicken QIF to a .QBO keeps transaction IDs. Convert to IIF when Web Connect is gone or Desktop rejects the bank ID.

Several accounts in one export. When a QIF holds more than one account (Quicken's account list followed by each register, or a bank and a credit card together), we read each account separately. Each account gets its own tab in the preview and its own IIF, named after the account, so their transactions never mix, and one credit covers the whole file. Import each IIF into its matching QuickBooks account.

Which QIF files work

• Bank, cash, credit card and other asset or liability registers (!Type:Bank, Cash, CCard, Oth A, Oth L).
• Several accounts in one file. Each account gets its own tab and its own IIF, named after the account, plus one CSV of every account with an Account column. One credit covers the whole file.
• Investment registers (!Type:Invst) aren't converted. Category, class and memorized payee lists in the file are ignored.
• Month-first and day-first dates, two- or four-digit years. Check the date format in the preview.
• Free up to 100 transactions, and up to 20,000 per file.

Common problems

Other conversions

• Just need to open or view the .QIF? How to open a .QIF file covers Quicken for Windows and Mac, Xero, GnuCash, Excel and opening it without Quicken.
• Prefer Web Connect (.QBO)? The QIF to QBO converter is the same Quicken file with a .qbo download — better when Desktop still accepts Web Connect, or for QuickBooks Online.
• Going the other way (IIF → QIF) for Quicken for Windows: the IIF to QIF converter.
• QIF to CSV or QIF to Excel for a spreadsheet with Quicken categories first: the QIF to CSV converter and QIF to Excel converter.
• OFX / QFX to IIF or QFX to IIF when you have a bank Web Connect download instead of QIF: OFX / QFX to IIF and QFX to IIF.
• Need an OFX for Wave or another non-QuickBooks importer? The QIF to OFX converter.
• QBO to IIF: the QBO to IIF converter. Bank CSV or Excel to IIF: CSV to IIF and Excel to IIF.
• Only have PDF statements? The PDF statement to QuickBooks converter checks each statement against its balances and includes the .IIF.
• Not sure which format you need? See QBO vs IIF vs QIF.
• Need to open the file first? How to open an OFX or QIF file.