How to Import IIF File into QuickBooks?

Have you already started using QuickBooks? Going through this write-up, you will be able to know the various steps to be followed to import the IIF file into QuickBooks.

For importing IIF files into the latest software solution you are using, the first thing that is required to be done is the export followed by Import with an option to edit the IIF file if needed.

Process I: Standard Import of IIF File into QB

Step 1: Export IIFs

• Log in to the company file
• Sign in as Administrator
• Click on the displayed File menu
• Choose the mode- Switch to Single-user
• Again click on the displayed File menu
• Choose Utilities
• Click Export
• Choose Export IIF Files
• There is a Save in the drop-down
• Click to select the particular location where you desire to save the specific IIF file
• Enter a File name
• Click Save
• Click OK

Step 2: Import IIFs

• Log in to your company file
• Log in as Admin
• Click on the displayed File
• Choose the mode- Switch to Single-user
• Take a backup of the company file
• Click on the displayed File menu
• Choose Utilities
• Click Import
• Choose the particular Import IIF Files
• Browse the IIF file that needs to be imported
• Select it and click Open
• Click OK to confirm the import

Step 3: Edit the IIF File

• Open MS Excel
• Go to the displayed File
• Choose Open
• Browse the particular IIF file you want to edit
• Specify the File type in the drop-down
• Choose All Files
• Choose the specific IIF file and click Open
• You will get a Text Import Wizard
• Click Next
• Click Next and Finish
• Make the required changes
• Again, click on the File menu
• Select Save
• Click Yes
• Close Excel
• You will receive a prompt asking you save the IIF File again
• Click Don’t Save

Process II – Improved Import of IIF File into QB

• Move to the File menu
• Choose Utilities
• Select Import
• Choose the displayed IIF Files
• Click on Import IIF
• Locate the specific file
• Select OK

[NOTE: It is advisable not to select the Import it for me option. I’ll fix it later. This is because this alternative bypasses the review made to the data and the information imported might be incorrect or incomplete when compared to the original file. Secondly, you also need to Switch to Single-user Mode to accomplish this mode of import.]

1. When the import is accomplished, click Done

The step-wise instructions are provided to assist you in importing IIF files into QuickBooks in whatever way you want. However, if you get stuck somewhere while following the directions, you can contact experts immediately.
Our representatives are available at 18008166849 24/7 and hence you can connect with them anytime.