- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Cannot open IIF file for review.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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:
- Open Microsoft Excel.
- Click the File menu.
- Select Open.
- Select the IIF file.
- Click Open.
- Select Next twice and Finish in the Text Import Wizard.
- Make the necessary edits.
- 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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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:
- Follow this link: https://help.quickbooks.intuit.com/en_US/contact.
- Click QuickBooks Desktop.
- Select Pro or Premier.
- Pick the main topic and a sub-topic.
- 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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
COULD YOU SHARE SOLUTION? I AM HAVING SAME ISSUE WITH NOT BEING ABLE TO OPEN THE REVIEW NOW IIF....
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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.
- Select Review now on the error message or prompt.
- Search for the error.
- Make corrections to the error.
- Click Save.
- Close the File not imported window.
- 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:
- IIF Overview: import kit, sample files, and headers
- Import IIF Files
- Maximum number of QuickBooks Desktop list
- Improved IIF Import in QuickBooks 2019 and later.
Please stay in touch with me if you have other questions. I'm here to help however I can. Have a great weekend!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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....
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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:
- Tasks you can do with IIF files
- IIF Overview: import kit, sample files, and headers
- Export, import, and edit IIF files
- Export lists from the old company file into a new data file
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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.