How to Open & Browse a QuickBooks IIF File: Step-by-Step Tutorial

By FinancialDataTools.com Team  ·  March 2026  ·  7 min read  ·  Last updated March 17, 2026

This tutorial walks you through opening and exploring a QuickBooks IIF file using the free FinancialDataTools.com IIF Viewer. The tool parses your .iif file entirely inside your browser — nothing is ever sent to any server.

Step 1: Locate Your IIF File

Find the .iif file you want to inspect. IIF files are exported from QuickBooks Desktop and contain one or more record types in a single file. Common sources include:

• QuickBooks Desktop → File → Utilities → Export → Lists to IIF Files
• QuickBooks Desktop → File → Utilities → Export → Timer Activities
• IIF files received from a bookkeeper, accountant, or data migration service
• IIF files generated by third-party QuickBooks integration tools

The file extension is .iif (Intuit Interchange Format). Some tools may export IIF content inside a .txt file — the viewer accepts both.

Step 2: Open the IIF Viewer

Navigate to financialdatatools.com/viewers/iif-viewer/ in any modern desktop browser. No login, account, or installation is required.

Step 3: Load Your File

There are two ways to open your file:

• Click the green "Open File" button in the toolbar and select your file using the system file picker.
• Drag and drop your IIF file anywhere onto the viewer window.

The viewer parses the file immediately. For most IIF files this is nearly instantaneous. The parser reads all section headers (lines beginning with !), identifies each record type and its column definitions, and organizes the data into tabs — one per record type.

Step 4: Understand the Interface

Once your file loads, several key areas appear:

• Record type tabs — a row of tabs just below the toolbar, one for each record type found in the file. Each tab shows the record type name and its row count.
• Stats bar — shows the total row count for the active record type, visible row count after filters, column count, and the active record type name.
• Column headers — each header shows the column name, an inferred type badge (NUM for numeric columns, TEXT for string columns), and a filter button. Click a header to sort.
• Data grid — rows from the active record type displayed in a spreadsheet-style table. Row numbers appear on the left. Numeric values are right-aligned and highlighted in blue.

Click any cell to open the Cell Detail Panel on the right, which shows the full untruncated value, the record type, row number, and column name — and lets you copy the value to the clipboard.

Step 5: Browse Record Type Tabs

This is the IIF Viewer's most important feature. A typical QuickBooks export may contain several record types in one file. Click each tab to inspect its contents:

• ACCNT — your chart of accounts with account names, types (BANK, AREC, APAY, etc.), and opening balances
• TRNS — transaction headers with dates, types (INVOICE, CHECK, DEPOSIT, etc.), accounts, and amounts
• SPL — split lines associated with each transaction, showing the detailed accounting entries
• CUST — customer list with names, addresses, and terms
• VEND — vendor list with names, contact information, and payment terms
• INVITEM — inventory items with descriptions, prices, and linked accounts

Sorting, filtering, and search state reset when you switch tabs, since each record type has a different column structure.

Step 6: Sort Columns

Click any column header to sort the table by that column:

• First click: sorts ascending (A → Z, smallest to largest)
• Second click: sorts descending (Z → A, largest to smallest)
• Third click: returns to original file order

A small arrow in the column header shows the current sort direction. Numeric columns (detected as NUM) sort numerically rather than alphabetically — particularly useful for amount and balance columns in TRNS and ACCNT records.

Step 7: Search and Filter Rows

The IIF Viewer offers two ways to narrow down rows within the active record type:

Global search — type in the search box in the toolbar to instantly search across all columns simultaneously. Any row that doesn't contain your search term in any column is hidden. Results update as you type with no need to press Enter.

Column filters — click the filter icon (funnel) in any column header for column-specific filtering. Two modes are available:

• Values mode: A checklist of all distinct values in that column. Uncheck values to hide rows containing them. Particularly useful for filtering TRNS records by TRNSTYPE (e.g., showing only INVOICE or only CHECK records).
• Conditions mode: Apply a custom condition such as "contains", "begins with", "equals", "greater than", or "is empty". Combine two conditions with AND or OR logic for advanced filtering. Useful for filtering ACCNT records by ACCNTTYPE or isolating transactions above a certain amount.

Multiple column filters are combined with AND logic — a row must satisfy all active filters to remain visible. The pink badge in the stats bar shows how many column filters are active; click it to clear them all at once.

Step 8: View File Info

Click the Info button in the toolbar to open the file info modal. This shows:

• The loaded file name
• Total number of record types found in the file
• Total row count for the active record type
• Column count for the active record type
• A column overview listing each column name and its inferred type (NUM or TEXT)

Use the Copy Column List button to copy the column names and types as plain text — useful when mapping IIF fields to a target database schema or building a data migration template.

Step 9: Export Your Data

Click the Export button in the toolbar to open the export dialog. Four formats are available:

• CSV — properly quoted comma-separated file, ideal for importing into databases or other tools
• JSON — array of objects with column names as keys, ideal for developers or API-based import workflows
• Excel (.xlsx) — a workbook with a frozen header row, ready to share or further analyze
• TSV — tab-separated export, preserving the original IIF delimiter style

Two export scopes let you control what gets exported:

• Filtered view — exports only the rows currently visible after applying your search and column filters
• Full record type — exports all rows for the active tab, ignoring any active filters

Export applies only to the currently active record type tab. To export multiple record types, switch to each tab and export separately.

Related Articles