Conversion of xls files to iif file format
It seems that that xls to iif conversion is pretty much only related to export of accounting data from Excel spreadsheet (.xls) to the interchange format (.iff), which can be done through QuickBooks and only works for Excel files that were previously exported in QuickBooks.
A valid .xls file can be imported back to QuickBooks by doing the following procedure.
Open XLS file
Open IIF file
- 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.
A business accounting software from Intuit
An OS X version of popular accounting software