Convert QIF Files to
QuickBooks QBO Format

Why Convert QIF Files to QBO for QuickBooks

QIF (Quicken Interchange Format) was the original financial data exchange format created by Intuit in 1988 for their Quicken personal finance software. For over two decades, QIF was the de facto standard for exporting and importing transaction data between financial applications. However, as the industry moved toward more structured formats like OFX and its QuickBooks-specific variant QBO, QIF has become a legacy format. If you're migrating from Quicken to QuickBooks, or working with historical QIF archives, you'll need to convert your QIF files to QBO (QuickBooks Web Connect) format for a seamless import experience.

Understanding the QIF Format

QIF is a plain-text format that uses single-character field codes to represent transaction data. Each transaction is a block of field lines ending with a caret (^) character as a record separator. The file typically begins with a !Type: header that identifies the account type — Bank for checking and savings accounts, CCard for credit cards, Cash for cash accounts, and Invst for investment accounts.

The field codes in a QIF file are straightforward:

• D — Transaction date (typically in MM/DD/YYYY or M/D'YY format)
• T — Transaction amount (negative for debits, positive for credits)
• P — Payee name (the person or business you paid or received money from)
• M — Memo (additional notes about the transaction)
• N — Check number or reference number
• L — Category (e.g., “Groceries”, “Utilities:Electric”)
• C — Cleared status (asterisk for cleared, X for reconciled)
• S, E, $ — Split transaction fields for multi-category entries

While this simplicity made QIF easy to generate and parse, it lacks the structure and metadata that modern accounting software requires — particularly unique transaction IDs, account identification, and financial institution routing information.

Quicken to QuickBooks Migration Context

Many users find themselves needing to convert QIF files when migrating from Quicken to QuickBooks. While Quicken remains available as a personal finance tool, businesses that outgrow Quicken's capabilities often transition to QuickBooks for its invoicing, payroll, and multi-user features. During this transition, years of historical transaction data stored in Quicken needs to be transferred. Since Quicken's primary export format is QIF and QuickBooks' primary import format is QBO, a reliable conversion tool bridges this gap.

Additionally, some users have archived QIF files from older versions of Quicken, Microsoft Money, or other personal finance applications that supported QIF export. Converting these historical files to QBO allows you to import decades of financial history into QuickBooks for comprehensive reporting and analysis.

How the QIF to QBO Converter Works

The converter transforms QIF's field-per-line format into QBO's SGML-based structure through a four-step process:

1. Parse the QIF file — The converter reads the !Type: header to detect the account type, then iterates through each transaction record. For every record, it extracts the date (D), amount (T/U), payee (P), memo (M), check number (N), and category (L) fields. Records missing a date or amount are flagged as errors and skipped, while all other fields are optional.
2. Map QIF fields to OFX tags — Each QIF transaction is transformed into an OFX <STMTTRN> block. The payee becomes <NAME>, the memo and category are combined into <MEMO>, the check number maps to <CHECKNUM>, and the amount sign determines the <TRNTYPE>(DEBIT for negative, CREDIT for positive). A unique <FITID> is generated using a deterministic hash of the transaction content to prevent duplicate imports.
3. Add QuickBooks metadata — The INTU.BID tag with value3000 is inserted into the signon response block — this is the generic financial institution identifier that works universally across all QuickBooks versions. Account type is set based on the QIF header (Bank → CHECKING, CCard → CREDITCARD).
4. Generate QBO output — The final QBO file is assembled with proper OFX headers, signon response, and either bank statement (BANKMSGSRSV1) or credit card statement (CREDITCARDMSGSRSV1) message sets, depending on the selected account type.

QIF to QBO Field Mapping Reference

Understanding how QIF fields map to QBO/OFX tags helps you verify the conversion output:

• D (Date) → <DTPOSTED> — QIF dates in MM/DD/YYYY format are converted to OFX's YYYYMMDD format
• T (Amount) → <TRNAMT> — Amount is preserved as-is; sign determines TRNTYPE
• P (Payee) → <NAME> — Payee name becomes the transaction name in QuickBooks
• M (Memo) → <MEMO> — Memo text is preserved; combined with category if both exist
• N (Check #) → <CHECKNUM> — Check numbers are fully preserved for reconciliation
• L (Category) → <MEMO> suffix — Category is appended to memo in brackets since OFX has no native category field
• !Type: header → Account Type — Bank suggests CHECKING, CCard suggests CREDITCARD in the account configuration

Importing QBO Files into QuickBooks Online

After converting your QIF file to QBO format, follow these steps to import into QuickBooks Online:

1. Log into QuickBooks Online and navigate to Banking from the left sidebar.
2. Click Upload transactions (or “Link account” → “Upload from file” if this is your first import).
3. Select the converted QBO file from your computer.
4. QuickBooks will display a preview of the imported transactions — verify that dates, payee names, and amounts are correct.
5. Choose the QuickBooks account to import into (e.g., your checking or credit card account).
6. Click Import to complete the process. Transactions will appear in the “For Review” tab.

Importing QBO Files into QuickBooks Desktop

For QuickBooks Desktop (Pro, Premier, or Enterprise), use the Web Connect import:

1. Open QuickBooks Desktop and go to File → Utilities → Import → Web Connect Files.
2. Browse to and select your converted QBO file.
3. QuickBooks will prompt you to select or create the account for the imported transactions.
4. If this is your first import for this account, QuickBooks will ask whether to create a new account or use an existing one. Select the appropriate bank account from your chart of accounts.
5. Click Continue to import. Transactions will appear in the bank register for review.

After import, review the bank register to verify that all transactions were imported correctly. QuickBooks uses the FITID values from the QBO file to prevent duplicate imports, so you can safely re-import updated files without creating duplicate entries. Check numbers from the original QIF file will appear in the check number field, making reconciliation straightforward.

Related Free Accounting Tools

The QIF to QBO Converter is part of our complete suite of free QuickBooks conversion tools:

• CSV to IIF Converter — Convert bank CSV files to QuickBooks Desktop IIF format.
• CSV to QBO Converter — Convert bank CSV files to QBO Web Connect format.
• QBO to IIF Converter — Convert QBO/OFX files to QuickBooks Desktop IIF format.
• IIF to QBO Converter — Upgrade legacy IIF files to QBO/OFX format.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF.
• OFX to QBO Converter — Convert OFX bank statement files to QBO Web Connect format.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format.
• QBO to CSV Converter — Export QBO transaction files to CSV spreadsheets.
• OFX to CSV Converter — Convert OFX bank files to CSV for Excel and Google Sheets.
• OFX to IIF Converter — Convert OFX files to QuickBooks Desktop IIF format.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format.
• QBO to PDF Converter — Generate professional PDF statements from QBO files.
• MT940 to QBO Converter — Convert SWIFT MT940 European bank statements to QBO.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks CSV.
• PayPal to QuickBooks Converter — Convert PayPal activity exports to QuickBooks CSV.
• Square to QuickBooks Converter — Convert Square POS exports to QuickBooks CSV.
• Amazon to QuickBooks Converter — Convert Amazon Seller reports to QuickBooks CSV.
• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks CSV.
• IIF Viewer — Preview and validate IIF files before QuickBooks import.
• Chart of Accounts Generator — Generate industry-specific chart of accounts.
• Bank CSV Cleaner — Clean messy bank CSV exports.
• QIF to CSV Converter — Convert legacy Quicken QIF files to clean CSV spreadsheets for analysis.
• QIF to IIF Converter — Convert Quicken QIF files directly to QuickBooks Desktop IIF format.
• IIF to CSV Converter — Export QuickBooks Desktop IIF files to CSV for spreadsheet analysis.
• QBO to OFX Converter — Convert QuickBooks QBO files to standard OFX format for other financial software.
• MT940 to CSV Converter — Convert SWIFT MT940 European bank statements to CSV spreadsheets.
• QBO File Viewer — Preview and inspect QBO Web Connect files before importing into QuickBooks.
• OFX File Viewer — Preview and inspect OFX bank statement files in a readable format.
• XLSX to QBO Converter — Convert Excel spreadsheets directly to QuickBooks Web Connect QBO format.
• Etsy to QuickBooks Converter — Convert Etsy shop payment exports into QuickBooks-compatible format.
• Duplicate Transaction Detector — Scan QuickBooks files to find and flag duplicate transactions before import.
• Import Troubleshooter — Diagnose and fix common QuickBooks file import errors automatically.
• File Format Detector — Identify unknown financial file formats and get conversion recommendations.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 bank statements to QuickBooks QBO format.