Want to create an IIF file for QuickBooks Desktop? If so, then you're in the right place. Here you can get complete guidelines on how easily you can create an IIF file. Let’s start exploring.
Before creating an IIF file you should be aware of what IIF means and why it is required. IIF stands for the Intuit Interchange Format. It is simply a text file that is mostly generated by the users on the first day of the month as it is related to the Payroll.
We can see its content by using the spreadsheet or Excel programs. IIF file is required because it comprises the data like which payroll amount lines up with which accounts in QuickBooks Desktop.
Steps To Create an IIF file for QuickBooks Desktop
- First of all, open your QuickBooks Desktop.
- Then you need to run your Payroll software.
- Next, click on the Reports tab.
- After that hover your cursor on the payroll that was run in step second.
- Now click on the view details option to see the necessary details.
- Then click on the Export button next to the QuickBooks
- Once you click on the export button IIF file gets downloaded to your system.
How To View The Content Of The IIF File Created
- In the QuickBooks software go to the Billing Admin tab and click on the QuickBooks import.
- After that select and click on the required .iif file.
- Now press the ctrl plus T key to open the new tab of your browser.
- Next by using the ctrl plus o key open the .iif file in your browser.
Issues While Creating An IIF File For QuickBooks Desktop
- Error on line xx: Cannot record invalid transaction
- Warning number larger than the maximum allowed
- Cannot import, too many records exist
- Unrecoverable error: QuickBooks has experienced an error and can shut down. 14667 90004.
- Warning: Unable to add the item to the list.
How to FIX issues of IIF File For QuickBooks Desktop
QuickBooks not importing IIF files - multiple line errors (error lines 6,9,15, etc) on the first import.
To solve this issue, follow the steps given below:
- First of all, navigate to the Lists tab and select the Others name option.
- Then search the name of your website, it is generally in capital letters XYZ website.
- Next, delete your customer name.
- After that locate the customer center tab and select the add new customer option.
- Now enter the name of your website the same that was found in the ‘others list’ by doing this there will be no need to fill in any other information.
- Further, you have to import your .iif file again.
Issues Users Face Related to this Error
The issue that is usually faced by users is like, I am trying to import a .iif file but I keep getting a pop-up window that says "Unable to change the type of a name or add the duplicate name”.
Unable to change the type of a name or add a duplicate name
To resolve this error, you need to sort the employee list by the first name:
● Open the QuickBooks Desktop and select the Edit tab.
● Then click on the preferences option now a window will appear, you need to select the Company Preferences tab.
● Now select the payroll option and click on the employee's tab.
● Then select the display employee name by the first name and click on the OK button.
If you face any issues while creating or importing the IIF file, you can contact our SMB QuickBooks Customer Support, Help team. We provide technical support for all QuickBooks-related issues. SMB Tech support has extremely talented and motivated people who give their best to find the easiest and quickest way to solve an error.
Frequently Asked Questions
What are the uses of IIF files in QuickBooks Desktop?
You can use IIF files for many purposes such as:
- Import transactions into some other program in QuickBooks.
- Export and import lists from one company enterprise record of QuickBooks into another.
- Share records between specific versions of QuickBooks and systems, including Pro, Premier, and Business, or Windows and Macintosh.
- Import QuickBooks timer operations into a record of the organization.
How do I make essential edits in QuickBooks Desktop IIF files?
Initially, go to the File main menu and select Apply to save all changes that you have made before. Next, click yes when it prompts. Press the Alt + F4 keys from your keyboard to close the Excel sheet. This process is already saved. IIF file once again so you have to click the doesn’t save option if asked to save again.
How do I view my exported IIF files in QuickBooks Desktop?
First, go to the location of the file. Next, select the open section by right-clicking on the exported file. Now, select the Microsoft Office Excel sheet. If it allows you to get a wizard and convert it into a text file then click the Next >> Next >> Finish button.
+1-800-961-4963