Unable-to-Open-.IIF-file-into-QuickBook

Question 1: My payroll was saved to desktop then i import to quick but data did not open .iff file….2018 new computer.

Intro: QuickBooks is a software tool that enables users to handle records hassle-freely. The payroll and accounting function of organizations are well dealt with by the software product. But the software comes with a few cons that emerge as technical issues while working on it.

Question 2: “My question is importing an IFF file. What do I need to set up to import a transaction report I have into QuickBooks ?…I know the headers in the IFF need to match whats in QuickBooks , but where do I put that information in setting up QuickBooks ? Also are there required fields that need to be filled out to import into QuickBooks.

QuickBooks uses .IIF file to export or import data from or to the software. However, sometimes the IIF file doesn’t open because of some or the other software problem.

One such error is the Unable to open .IIF file into QuickBooks. If you consult Fastfix247 experts, you will get to know more about the issue and therefore be assisted in resolving the same.

Causes, Symptoms & Impact

When the .IIF file doesn’t open into the software, the reason can be the incompatibility in terms of values contained in the fields or the incorrect format. It appears to be a big issue when you need to view the data immediately to process it to carry out a function. In such a scenario, you should simply export the file to a compatible form and then open it.

How to Ensure Opening .IIF file?

Step 1: Export the file

Sign in to the QB company file as Admin

  1. Ensure you have selected Single User mode
  2. Browse to File menu
  3. Choose Utilities
  4. Select Export
  5. Click Lists to IIF Files
  6. Tick the checkbox beside each of the list that you need to export
  7. Click OK
  8. You will get the Export From there:
    1. Go to Save in drop-down menu
    2. Select the location where you want to save the file
    3. Delete the asterisk (*) mark on the File name field and enter a desirable file name
    4. Choose file type as IIF File (*.IIF)
    5. Click Save
  9. Click OK when you get a prompt, stating the successful saving of the file

Step 2: Open the file

Option 1

  1. Browse to the location
  2. Right-click the file that you exported
  3. Select Open with
  4. Select Microsoft Office Excel
  5. In case, you receive a wizard to convert the file, select Next
  6. Click Next and then Finish

Option 2

  1. Generally, the file is exported to Microsoft Excel
  2. Open Microsoft Excel
  3. Select File
  4. Click Open
  5. Choose the location the file is saved in
  6. Select the IIF file
  7. Click Open
  8. You will get a Text Import Wizard, click Next twice
  9. Click Finish

Option 3

  1. Save the Iif file on your local PC
  2. Open MS Excel
  3. Go to File menu
  4. Click Open
  5. Browse to the lower right and click on the drop-down list
  6. Change the setting to All Files
  7. Select the .IIF Files
  8. On the Text Import Wizard, select Delimited
  9. Click Next
  10. Choose Tab as the Delimiter
  11. Click Finish

Once the file opens, you will not only be allowed to view it but also edit and modify the contents. In case, you face any kind of difficulty in following the above-mentioned process or steps, you can connect with Fastfix247 experts for assistance.

In fact, for any further QuickBooks-related queries, you can call on our QuickBooks phone number given above and take expert advice from Fastfix247 representatives.

Related Posts

1 Comment

  • Avatar for Insta Jackson Insta Jackson

    I just started working for a company that uses QuickBooks Desktop Pro 2018. I am unable to get invoices on my emails that is linked with QuickBooks.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fastfix247.com Disclaimer

We don’t represent the brands & products as shown on the website, we’re 3rd party company and do not have any direct connection. (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8)