IIF Viewer: Complete Feature Guide & Reference

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

What Is the IIF Viewer?

The FinancialDataTools.com IIF Viewer is a free, browser-based tool for opening and exploring QuickBooks IIF files as a spreadsheet-style table organized by record type. It parses your file entirely inside your browser using JavaScript — no file is ever transmitted to any server.

The viewer is designed for accountants, bookkeepers, financial analysts, and QuickBooks administrators who need to inspect, audit, or convert IIF export files without installing additional software.

What Is an IIF File?

IIF stands for Intuit Interchange Format. It is a tab-delimited plain text format used by QuickBooks Desktop to import and export financial data. IIF files are organized into sections, where each section begins with a header line starting with an exclamation mark (!) that defines the record type and its columns.

For example, an account section in an IIF file looks like this:

!ACCNT	NAME	ACCNTTYPE	OBAMOUNT
ACCNT	Checking	BANK	5000.00
ACCNT	Savings	BANK	12000.00

The !ACCNT line defines the columns. The following ACCNT lines are data records. The IIF Viewer automatically parses all these sections and presents each record type in its own tab.

Supported Record Types

The viewer supports all standard IIF record types. Each type that has data records in your file appears as a tab:

Any record type found in your IIF file will appear as a tab, including custom or less common types. Only record types that have at least one data row are shown.

The Toolbar

The toolbar runs across the top of the viewer and provides all primary actions:

You can also drag and drop an IIF file anywhere onto the viewer to open it — no need to click the Open button.

Record Type Tabs

This is the IIF Viewer's key feature. After opening a file, a row of tabs appears below the toolbar — one tab for each record type found in the file. Each tab shows the record type name and a count of how many rows it contains.

Clicking a tab loads that record type's data into the grid. Each record type has its own columns, so the grid layout changes when you switch tabs. Sorting, filtering, and search state are reset when switching record types to avoid confusion between different schemas.

For example, a QuickBooks export might produce tabs for ACCNT (accounts), TRNS (transaction headers), SPL (transaction splits), and CUST (customers) — all from a single IIF file.

Stats Bar

The stats bar below the toolbar provides at-a-glance information about the currently active record type:

• Rows: Total number of data rows for the active record type
• Showing: Number of rows currently visible after applying search and column filters
• Cols: Number of columns defined for this record type
• Type: The active record type name (e.g., TRNS, ACCNT)
• Filter badge: Pink badge showing active column filters; click it to clear all filters

Sorting Columns

Click any column header to sort the table by that column. The first click sorts ascending (A–Z, smallest to largest), the second click sorts descending, and a third click returns to the original file order. A small arrow indicator in the column header shows the current sort direction.

The viewer automatically infers whether a column contains numeric or text data by sampling the first 200 rows. Numeric columns are right-aligned and highlighted in blue, and sort numerically rather than lexicographically. This is particularly useful for amount and balance columns in TRNS and ACCNT records.

Row Filtering

Each column header contains a filter icon (funnel) that opens an advanced filter panel for that column. The filter panel has two modes:

• Values mode: Shows a checklist of all distinct values in that column. Uncheck values to hide rows containing them. A search box inside the panel lets you find specific values in long lists.
• Conditions mode: Apply up to two custom conditions using operators including contains, equals, does not equal, begins with, ends with, greater than, less than, is empty, and is not empty. Combine two conditions with AND or OR logic.

Multiple column filters stack with AND logic — a row must satisfy every active filter to remain visible. Active filters show as a pink badge in the stats bar; clicking it clears all column filters at once.

Filtering is particularly useful in IIF files for tasks like finding all transactions of a specific type (e.g., filtering TRNSTYPE = INVOICE in the TRNS tab), or isolating all accounts of a certain account type in the ACCNT tab.

Global Search

The search input in the toolbar performs a global text search across all columns in the active record type simultaneously. This is useful when you know a value exists somewhere in the data but aren't sure which column contains it. Search results update instantly as you type.

Global search works in combination with column filters — both the search term and all column filters must be satisfied for a row to appear.

File Info Panel

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

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

You can copy the entire column list as plain text using the Copy Column List button — useful for documentation, schema mapping, or when building a database import from IIF data.

Pagination for Large Files

Record types with more than 50,000 rows are automatically paginated to 5,000 rows per page. The page bar at the bottom of the grid shows the current page, total pages, and the absolute row range on screen. Navigation buttons — First, Previous, Next, Last — let you move through pages quickly.

A pagination badge appears in the stats bar when viewing a paginated record type. Sorting and filtering work correctly across the entire dataset even when pagination is active — filters are applied to all rows before pagination, not just the current page.

Export Options

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

Two export scopes are available: Filtered view exports only the rows currently visible after applying search and column filters, and Full record type exports all rows for the active tab ignoring any active filters. Export applies only to the currently active record type tab.

Privacy & Security

The IIF Viewer is built privacy-first. Your file is parsed entirely inside your browser tab using JavaScript — no file content is ever transmitted to any server. The only network requests are to load the viewer tool itself (the HTML, CSS, and JS files) and the ExcelJS library from a CDN used when exporting to Excel.

This makes the viewer appropriate for sensitive financial data including:

• QuickBooks account and transaction exports
• Customer and vendor lists with contact information
• Payroll and employee data in EMP record types
• Inventory and pricing data in INVITEM records
• Chart of accounts with opening balances

Closing the browser tab clears all data from memory immediately. No data is written to localStorage or any persistent browser storage.

Use Cases for Financial Data

IIF is the primary data interchange format for QuickBooks Desktop. Common scenarios where the IIF Viewer adds immediate value:

• Pre-import audit: Before importing an IIF file into QuickBooks, open it in the viewer to verify the data is correct — check account types, transaction amounts, and date formats without risking changes to your live company file.
• Transaction review: Browse TRNS and SPL records to review transaction history, reconcile against source documents, or identify data entry errors in exported bookkeeping data.
• Account list inspection: Open the ACCNT tab to view the complete chart of accounts, verify account types (BANK, AREC, APAY, etc.), and confirm opening balances before a migration or audit.
• Customer and vendor data migration: When migrating QuickBooks data to another platform, export to IIF and use the viewer to inspect CUST and VEND records, clean up duplicates, and export to CSV for the target system.
• Format conversion: Convert IIF data to CSV, JSON, or Excel for use in tools that don't support the IIF format natively — such as modern cloud accounting platforms, spreadsheet models, or data warehouses.
• Training and documentation: Use the viewer to create column reference documentation for each IIF record type, making it easier to onboard staff or build custom import scripts.

Related Articles