cancel
Showing results for 
Search instead for 
Did you mean: 
tergeoboa
Level 1

Cannot open IIF file for review.

Imported IIF from ADP payroll first time since updating to QB 2019.    Saying it had errors and to review but cannot open file.  How to I open the file for review?
8 Comments 8
AlcaeusF
Moderator

Cannot open IIF file for review.

Thank you for posting here in the Community, @tergeoboa.

 

I’m here to make sure your you're able to open the IIF file. For me to provide the best solution, I need to gather more data about the issue.

 

Can you share with me what happened when you attempt to open it? Any additional information you can add will help ensure a timely solution.

 

While waiting for the details, let’s try following these steps:

 

  1. Open Microsoft Excel.
  2. Click the File menu.
  3. Select Open1.JPG
  4. Select the IIF file.
  5. Click Open2.JPG
  6. Select Next twice and Finish in the Text Import Wizard.
  7. Make the necessary edits.
  8. Save changes.

I suggest visiting the Export, import, and edit IIF files article. It also contains an overview of importing and exporting Intuit Interchange Format files and how you can edit them.

 

Reach out to me anytime if you have any other concerns. I’ll be right here ready to help you. Enjoy the rest of the day.

NickelPayroll
Level 2

Cannot open IIF file for review.

This is exactly my issue too. I attempted to import an IIF file and upon finding errors when I go to review, the file won't open. According to your instructions (open excel, find the file and open it) I get stuck right there because I do not see the file. I'm confused - the file is not an excel formatted file? It is a .IIF. How would excel be able to open it? I am not that tech savvy so I'm sure I'm missing something.

Ashley H
QuickBooks Team

Cannot open IIF file for review.

Good evening, @NickelPayroll

 

To better assist you, I recommend reaching out to our Desktop Support. They can look further into this issue you're having with the IIF files not importing properly. Here's how to get in touch:

  1. Follow this link: https://help.quickbooks.intuit.com/en_US/contact.
  2. Click QuickBooks Desktop.
  3. Select Pro or Premier.
  4. Pick the main topic and a sub-topic.
  5. Scroll down, and click the Get Phone Number.

Let me know how the conversation goes. Feel free to comment below if you have other questions.

ttime2
Level 1

Cannot open IIF file for review.

COULD YOU SHARE SOLUTION?  I AM HAVING SAME ISSUE WITH NOT BEING ABLE TO OPEN THE REVIEW NOW IIF....

JoesemM
Moderator

Cannot open IIF file for review.

Hello there, @ttime2.

 

Have you tried the steps shared by my colleague AlcaeusF? Or any error or prompt message when you review the file? 

In case you encounter an error, you can follow the steps on how to check the error.

 

  1. Select Review now on the error message or prompt.
  2. Search for the error.
  3. Make corrections to the error.
  4. Click Save.
  5. Close the File not imported window.
  6. Import the IIF file again.

 

Also, to import the IIF file successfully, you must double-check the account names used, the spelling, and any other typographical error. Ensure that the names used exist and are acceptable in QuickBooks.

 

For more details, you can check out this helpful article: Tasks You Can Do With IIF Files

 

However, if the issue persists, I'd recommend contacting our Customer Support Team. They can create a case regarding this matter. You can follow the steps shared by my colleague Ashley H to contact us.

 

To learn more about importing these files, and the maximum number of entries allowed, you may check out these articles:

 

 

Please stay in touch with me if you have other questions. I'm here to help however I can. Have a great weekend!

 

 

 

 

Top Quality Motors
Level 1

Cannot open IIF file for review.

I click Review now and the file doesnt open and Microsoft wants me to pick the program to open the file with...i select QB and it says only QB can open a file like this....

 

MirriamM
Moderator

Cannot open IIF file for review.

Thanks for joining the thread and letting us know your concern, Top Quality Motors.

 

The issue happened when the file association of the .iif file change to other applications other than MS Excel. You'll want to verify the type of file you are opening by right-clicking the file and choosing Properties. The file type is listed under Type of File.

 

You may also want to change the file association of the .iif file to open with MS Excel. This way, you'll be able to open the file.

 

To learn more about importing files in QuickBooks, visit these useful articles: 

Please know I'm always here if there's anything else I can do for you. The Community will always have your back. Have a great day!

ChanceGardener
Level 1

Cannot open IIF file for review.

I'm having the same problem importing IIF files from TimeMaster, having all the entries rejected, not being able to open the file for review. I think the above reply may be the solution: correcting the file association to MS Excel. However, when I clicked the "not recommended" option to import the file without review, it imported perfectly.

Need to get in touch?

Contact us