Convert QIF Files to
QuickBooks IIF

Why Convert QIF Files to IIF for QuickBooks Desktop

QIF (Quicken Interchange Format) is one of the oldest financial data exchange formats still in active use today. Originally developed by Intuit in the 1990s for Quicken, it remains a common export option at banks and financial institutions worldwide. However, if you're using QuickBooks Desktop rather than Quicken, you need your transaction data in IIF (Intuit Interchange Format) — the native import format that QuickBooks Desktop understands. While both formats were created by Intuit, they serve fundamentally different purposes and use completely different structures. Converting QIF to IIF bridges the gap between Quicken-style exports and QuickBooks Desktop's double-entry bookkeeping requirements.

Understanding the QIF Format

QIF is a plain-text, single-entry format where each transaction is represented as a block of field-per-line entries terminated by a caret (^) character. Each line starts with a single-character field code: D for date, T for total amount,P for payee, M for memo, N for check number, andL for category. A typical QIF file begins with a !Type: header that identifies the account type — Bank, CCard,Cash, Invst, or Oth A/L. This simplicity made QIF a universal format that virtually every financial application could read, but it also means QIF lacks the double-entry structure that accounting software like QuickBooks requires for proper bookkeeping. QIF dates can appear in several formats includingMM/DD/YYYY, M/D/YY, and the older Quicken apostrophe styleMM/DD'YY, which our converter handles automatically.

Understanding the IIF (Intuit Interchange Format)

IIF is a tab-delimited format designed specifically for QuickBooks Desktop data import and export. Unlike QIF's single-entry approach, IIF enforces double-entry bookkeeping through its TRNS/SPL/ENDTRNS structure. Every transaction consists of at least three lines: a TRNS line representing the primary account entry (e.g., your bank account), a SPL (split) line representing the offset account entry (e.g., an expense or income account), and anENDTRNS marker that closes the transaction block. The amounts on TRNS and SPL lines must balance to zero, ensuring proper debit-credit accounting. IIF files begin with header rows (!TRNS, !SPL, !ENDTRNS) that define the column structure, followed by the transaction data rows. This format has been the standard QuickBooks Desktop import method since the earliest versions and remains fully supported in Pro, Premier, Enterprise, and Accountant editions.

Common Challenges When Migrating from Quicken to QuickBooks

Users migrating from Quicken to QuickBooks Desktop frequently encounter these issues when trying to work with QIF files:

• QuickBooks cannot open QIF files directly — While QuickBooks was built by the same company that created QIF, QuickBooks Desktop does not natively import QIF files. Attempting to open a QIF file via File > Open will fail. You must convert to IIF or QBO format first.
• Single-entry vs. double-entry mismatch — QIF records only one side of each transaction (the bank account entry). QuickBooks requires both sides (debit and credit) to maintain balanced books. The converter automatically creates the offset entry using your configured expense account.
• Category mapping differences — Quicken uses categories (specified with the L field code) that may not match your QuickBooks chart of accounts. The converter preserves category information in the memo field so you can re-categorize in QuickBooks after import.
• Date format inconsistencies — QIF files from different Quicken versions and banks may use different date formats. Our converter handles all standard QIF date formats automatically, including two-digit years and the apostrophe year separator used in older Quicken exports.

How the QIF to IIF Converter Works

Our converter transforms QIF files into QuickBooks Desktop-ready IIF format through a precise three-stage process:

1. Parse the QIF file — The converter reads your QIF file line by line, extracting transaction data from field codes: dates (D), amounts (T/U), payees (P), memos (M), check numbers (N), and categories (L). The !Type: header is recognized to determine the account type. Records missing required fields (date or amount) are flagged as warnings and skipped.
2. Build double-entry structure — Each parsed transaction is converted into an IIF TRNS/SPL pair. The TRNS line carries the bank account name and original amount. The SPL line carries the offset account with the opposite sign — expenses use your configured expense account, while income entries use an “Income” offset. Transaction types are determined automatically from the amount sign: negative amounts are debits, positive amounts are credits.
3. Generate IIF output — The final IIF file is assembled with proper header rows, tab-delimited columns (TRNSID, TRNSTYPE, DATE, ACCNT, AMOUNT, MEMO), and the complete set of TRNS/SPL/ENDTRNS blocks. Special characters like tabs, newlines, and quotes are sanitized to prevent import errors in QuickBooks.

Importing IIF Files into QuickBooks Desktop

After converting your QIF file to IIF format, follow these steps to import into QuickBooks Desktop:

1. Open QuickBooks Desktop and go to File → Utilities → Import → IIF Files.
2. Browse to and select your downloaded .iif file.
3. QuickBooks will process the file and display a confirmation message with the number of transactions imported.
4. Open the bank register for the account you imported into and verify that all transactions appear correctly.
5. Review and re-categorize transactions as needed — the converter uses your configured expense account for all debits, so you may want to assign more specific categories.

Important: The bank account name in the IIF file must exactly match an existing account in your QuickBooks chart of accounts. If the name does not match, QuickBooks will create a new account automatically, which may not be what you want. Double-check the account name before importing. You can view your chart of accounts in QuickBooks via Lists → Chart of Accounts.

Best Practices for Quicken to QuickBooks Migration

When migrating your financial data from Quicken to QuickBooks Desktop using QIF files, keep these tips in mind:

• Export by account — Export each Quicken account as a separate QIF file and convert them individually. This ensures each IIF file maps to the correct QuickBooks account.
• Match account names exactly — Before importing, create the bank accounts in your QuickBooks chart of accounts with the exact names you'll use in the converter. This prevents QuickBooks from auto-creating accounts.
• Start with a small date range — Test with a single month of transactions first to verify everything imports correctly before processing your full transaction history.
• Back up QuickBooks first — Always create a QuickBooks backup (File → Back Up Company → Create Local Backup) before importing IIF files. IIF imports cannot be easily undone.

Related QuickBooks Conversion Tools

The QIF to IIF Converter is part of PrimeConnect's comprehensive suite of free QuickBooks utilities. Whether you're converting between file formats, importing from payment processors, or cleaning up financial data, we have a tool for every workflow.

QIF Format Tools

• QIF to QBO Converter — Convert Quicken QIF files to QuickBooks Online QBO Web Connect format.
• QIF to CSV Converter — Export QIF transaction data to CSV spreadsheets for Excel and Google Sheets.

IIF Format Tools

• CSV to IIF Converter — Convert bank CSV files to QuickBooks Desktop IIF format with column mapping.
• QBO to IIF Converter — Convert QBO or OFX files to QuickBooks Desktop IIF format.
• OFX to IIF Converter — Convert OFX bank statement files directly to IIF for QuickBooks Desktop.
• IIF to QBO Converter — Upgrade legacy IIF files to modern QBO Web Connect format.
• IIF to CSV Converter — Export IIF transaction data to CSV for spreadsheet analysis.
• IIF Viewer and Validator — Preview and validate IIF files before importing into QuickBooks Desktop.

QBO Web Connect Tools

• CSV to QBO Converter — Convert bank CSV files to QBO Web Connect format for QuickBooks Online.
• OFX to QBO Converter — Convert OFX bank statements to QuickBooks QBO format with INTU.BID tag.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format.
• PDF to QBO Converter — Extract transactions from PDF bank statements and convert to QBO, CSV, or IIF.
• MT940 to QBO Converter — Convert SWIFT MT940 European bank statements to QuickBooks QBO format.
• XLSX to QBO Converter — Convert Excel XLSX spreadsheets to QBO Web Connect format.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 XML bank statements to QBO format.
• QBO to CSV Converter — Export QBO transaction files to clean CSV spreadsheets.
• QBO to PDF Converter — Generate professional PDF statements from QBO transaction files.
• QBO to OFX Converter — Convert QBO files to standard OFX format for other financial software.
• QBO Viewer — Preview and inspect QBO file contents before importing into QuickBooks.

OFX and CSV Format Tools

• OFX to CSV Converter — Convert OFX bank files to structured CSV for spreadsheet analysis.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format.
• MT940 to CSV Converter — Convert SWIFT MT940 statements to CSV for Excel and Google Sheets.
• OFX Viewer — Preview and inspect OFX bank statement file contents.

Payment Processor Converters

• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks-compatible CSV with fee splitting.
• PayPal to QuickBooks Converter — Convert PayPal activity exports to QuickBooks CSV with fee separation.
• Square to QuickBooks Converter — Convert Square POS transaction exports to QuickBooks CSV.
• Amazon to QuickBooks Converter — Convert Amazon Seller settlement reports to QuickBooks CSV.
• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks CSV.
• Etsy to QuickBooks Converter — Convert Etsy shop payment exports to QuickBooks CSV.

Data Cleanup and Analysis Tools

• Bank CSV Cleaner — Clean messy bank CSV exports into QuickBooks-ready format.
• Chart of Accounts Generator — Generate industry-specific chart of accounts for QuickBooks.
• Duplicate Transaction Detector — Find and remove duplicate transactions before importing.
• Import Troubleshooter — Diagnose and fix common QuickBooks import errors.
• File Format Detector — Automatically identify unknown financial file formats.