Quickbooks IIF Overview
What is Quickbooks IIF file? IIF stands for Intuit Interchange Format. IIF files are text files that QuickBooks uses to import and export data. You can use IIF files to do the following:
- Export lists from one QuickBooks company file and import them into another.
- Import transactions into QuickBooks from another program.
- Import QuickBooks Timer activities into a company file.
- Share data between different QuickBooks editions and platforms (such as Pro, Premier, and Enterprise; or Windows and Macintosh)
Limitations of IIF files:
- Imported IIF files do not create links between transactions. This means you have to manually link, for example, an invoice to a payment.
- You must be in single-user mode to import or export data.
- Only the Admin user can import or export data.
- Payroll data cannot be imported or exported.
- Transactions can be imported but not exported.
- The amount of imported data.
Lists that can be imported and exported using IIF files:
|Chart of Accounts||Payment Terms||Budgets|
|Customer Message||Price Level||Class|
|Customer Type||Sales Rep||Employee|
|Customer:Job||Sales Tax Code||Item|
|Other Names List||Shipping Method||Job Type|
|Payment Method||To Do Notes||Vendor|
Transactions that can be imported using IIF files:
|Account beginning balances||Checks||Cash sales to customers|
|Account transfers of funds||Deposits||Credit card transactions|
|Cash refunds to customers||Estimates||General journal entries|
|Credit card refunds to customers||Invoices||Purchase orders|
|Credit memos to customers||Vendor bills||Vendor bill refunds|
|Payments from customers|
You can download the Quickbooks IIF Import Kit to work with IIF import files. It contains the following components:
- IIF Import Manual (a PDF document that outlines IIF common pitfalls and best practices)
- IIF Header Help (the column headings used to import list data)
- IIF Example Files (a folder that contains version specific IIF transaction examples)