Opening IIF files

Did your computer fail to open an IIF file? We explain what IIF files are and recommend software that we know can open or convert your IIF files.

What is an IIF file?

The .iif file extension is a proprietary file type that is being utilized in Intuit Quickbooks. QuickBooks is an accounting software package that is mainly designed to work with the accounting processes of small and medium-size businesses. QuickBooks also offer in- house accounting applications that can process business payments, manage and pay bills, and perform payroll functions.

The .iif files are in the generic data format used by the application. It is generated to export various financial data. The IIF is text-based and in tab-delimited format, which is very similar to TSV file format. It can be imported to other file types using QuickBooks and other spreadsheet- based applications.

A valid .xls file can be imported back to .iif. In order to do so the user should open the QuickBooks company file to import the new .xls account list. Resume to the "File" section, click on "Utilities", followed by the "Import" option, and select Excel files. Search through the .xls file and select. Go to the "Choose a sheet" using the Excel workbook drop-down arrow, after which choose Accounts. Select Mappings option (may have to select new mapping). Provide a Mapping title such as "Map QuickBooks Headers to Excel Columns." Select the Import classification before clicking Account. Under the Import data column, click the blank row heading, allowing you to display all of the columns in the Excel file. Select Column E. This will match the column to the QuickBooks account type. Map Name to Column B, Description of Column G, and Opening Balance to Column F. Click Save and then select Import to move the list of accounts in QuickBooks and view the file in IIF format.

Try a universal file viewer

In addition to the products listed above, I would suggest that you try a universal file viewer like Free File Viewer. It can open over 200 different types of files - and very likely yours too! Download Free File Viewer.

By Prof. Jones (The File Expert)

Chief Content Editor and File Expert

Suggestions for this page? Mail me.