Home > Search converters: xls to iif

Conversion of xls file format to iif file format beta

Search for xls to iif converter or software able to handle these file types.

Find any file converter

from    to  

Bookmark & share this page with others:

Convert Microsoft Excel 97 to 2003 workbook to QuickBooks interchange format.

We have found 2 software records in our database eligible for .xls to .iif file format conversion.

It looks that xls to iif conversion means only one thing and that is import of accounting data from Excel spreadsheet (.xls) to QuickBooks where it can be exported in the interchange format (.iff). This only works on Excel files that were previously exported in QuickBooks.

A valid .xls file can be imported back to QuickBooks by doing the following procedure.

  • Open the QuickBooks company file to import the new Excel .xls accounts list.
  • Go to File, select Utilities, choose Import, and Excel files.
  • Browse to the .xls file and select.
  • Click the Choose a sheet in this Excel workbook drop-down arrow and select Accounts.
  • Click the Mappings button (may have to select new mapping).  Enter a Mapping name such as "Map QuickBooks Headers to Excel Columns."
  • Click the Import type and click Account.
  • Click the blank row under the Import data column heading to display all the columns in the Excel file.
  • Click Column E. This will match the column to the QuickBooks account type.
  • Map Name to Column B, Description to Column G, and Opening Balance to Column F.
  • Click Save and click Import to import the account list into QuickBooks.

Updated: March 28, 2017

Microsoft Windows software Microsoft Windows icon - convert xls to iif on Windows

QuickBooks icon QuickBooks

QuickBooks is a family of business accounting software developed and sold by Intuit Inc. The software is highly popular among small business owners.

File extension

Convert

Open

Save

Edit

Create

Import

Export

Extract

Convert from xls file

NoNoNoNoNoYesNoNo

to iif file

NoYesYesiif editorYesYesYesNo

The tables with software actions are a good pointer for what a certain program does with various file types and often may give users a good hint how to perform certain file conversion, for example the above-mentioned xls to iif. However, it is not perfect and sometimes can show results which are not really usable because of how certain programs work with files and the possible conversion is thus actually not possible at all.

Apple macOS / Mac OS X software Apple macOS / Mac OS X icon - convert xls to iif on OS X

QuickBooks for Mac icon QuickBooks for Mac

QuickBooks for Mac is financial manager used to organize finances in one place, track money going in and out of business etc.

File extension

Convert

Open

Save

Edit

Create

Import

Export

Extract

xls

NoNoNoNoNoYesNoNo

iif

NoYesYesYesYesYesYesNo

Previous conversion
convert xls to html

Next conversion entry
convert xls to mdb

 

Follow us!

Enter any file extension without dot (e.g. pdf)
Search for file extension details and associated application(s)

RSS feed