Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
T
tergeoboa
December 12, 2019
Question

Cannot open IIF file for review.

  • December 12, 2019
  • 1 reply
  • 1 view
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?

1 reply

AlcaeusF
AlcaeusF
Level 14
December 12, 2019

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 Open. 
  4. Select the IIF file.
  5. Click Open. 
  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.

N
NickelPayroll
February 27, 2020

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
Ashley H
Level 4
February 27, 2020

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement