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

Quickbooks won't open my imported IIF file when using the "Review now" button.

 
Solved
Best answer June 28, 2021

Best Answers
BigRedConsulting
Community Champion

Quickbooks won't open my imported IIF file when using the "Review now" button.

@Maybelle_S 

RE: This error usually occurs when the file association of the IIF file is changed to other applications than MS Excel.

 

Well... the QuickBooks installer sets up IIF files to be associated with QuickBooks, not Excel. It has always done this and it's always been sort of dumb as then when you double-click an IIF file then you get a QB warning that you can't open IIF files in this way.

 

This means that, basically, the button in QuickBooks doesn't work for anyone unless they actually change the file association. And, based on this thread not even that works sometimes.

 

I've no idea why Intuit implemented things this way. It is easy enough to launch Excel and tell it to open the file instead of just launching the file and hoping the computer is set up to open it in Excel.

 

If you're one of the almost-everyone who can't open the error files from within QB, you can open them from within Excel by starting to open a file and then navigating to the folder where you put the original IIF file and then picking "All Files (*.*)" in the file open dialog.  Then you'll see both your IIF file and the one with the ~ "_65465454" extension added to the file name.

 

Also, see BRC QuickBooks 2019+ IIF Import Changes and Recommendations and avoid all this by importing using the alternate method (which Intuit has tried to make sound scary, but works a whole lot better.)

View solution in original post

12 Comments 12
RCV
QuickBooks Team
QuickBooks Team

Quickbooks won't open my imported IIF file when using the "Review now" button.

Let's perform some steps to get the Review now button working in QuickBooks, 18633209.

 

The improved Intuit Interchange Format (.IIF), allows you to see the number of list and transactions that both failed and was successfully imported. QuickBooks automatically creates a new .IIF file for failed records with error info. Before doing some troubleshooting steps, let's make sure QuickBooks Desktop to the latest release and you meet the system requirements

 

Once done, try closing and opening the company file again. Then, access the Select Review now button. Let me show you how:

  1. Go to File on the top menu. Then, select Utilities then Import.
  2. Choose IIF Files then Import IIF.
  3. Locate the file and tap OK.
  4. Select Review now.
  5. Look for ERROR to see what the problem(s) with the file is.
  6. Correct the errors and Save. If asked if you want to keep the file type, select Yes.
  7. Close the File not imported window and import the new, corrected .IIF file.

For more details about this one, see Improved IIF Import in QuickBooks 2019 and later article. If the same thing happens, try opening another company file to check if you're having a problem with only one file and not the program itself. You can also open it from a different location to check if the problem might be coming from a damaged folder. To open a sample file:

  1. From the No Company Open window, select Open a sample file.
  2. Choose any sample file on the list.

If the problem persists, there may be a damaged data in your software. Just follow the steps and details in the Fix data damage on your QuickBooks Desktop company file article. You can also repair QuickBooks Desktop to fix any damaged components in the software.

 

Feel free to visit our Bring in your data page for more insights about importing your data on your software.

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. You have a good one. 

VWin2it
Level 1

Quickbooks won't open my imported IIF file when using the "Review now" button.

I am also having trouble reviewing my failed imports. When I use the "Review Now" button, a window appears asking, "How do you want to open this IIF file? Continue using QuickBooks launcher or Look for an app in Microsoft Store?" I don't know what app to use.

Jen_D
Moderator

Quickbooks won't open my imported IIF file when using the "Review now" button.

Thanks for posting here, @VWin2it,

 

You can use any options suggested. If you're not familiar with the tools, you can work with an IT guy to help you with it.

 

I also found a workaround you can try to resolve the problem. Keep in mind you have to be in Single-User Mode when importing this way. If you’re in Multi-user mode, go to the File menu, then select Switch to Single-user Mode

 

Follow these steps:

  1. Go to the File menu and select Utilities 
  2. Press Import, then IIF Files.
  3. Use the Import it for me. I’ll fix later link at the bottom of the import box.

This will allow you to import the .IIF without QuickBooks doing the usual check for the file. Our IIF Overview, is a great resource as well.

 

Kindly post here again if you have other questions about the import process in QuickBooks Online. I'm here to assist you further. Have a good one!

Fiat Lux - ASIA
Level 15

Quickbooks won't open my imported IIF file when using the "Review now" button.

@VWin2it 

If you are not familiar with IIF feature, you may explore these migration tools as another option.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

kristenklipe
Level 1

Quickbooks won't open my imported IIF file when using the "Review now" button.

I have a client that imports checks from a third party software.  They had to upgrade from QBDT 2018 to 2021 because of payroll and their IIF files would not import as they used to.  I used the "Import it for me. I'll fix it later." option instead of the blue "Import IIF" button, and it worked just like it did in the previous versions.  This particular client owns an antique mall and rents booth space to almost 100 vendors.  They collect the sales for all of them and then pay out their portion of the sales at the end of each month.  They were worried they would have to go back and manually enter those checks which would have been so time consuming.  I was so relieved when I could help them "fix" the problem and save them so much time.  

d1csp3r
Level 2

Quickbooks won't open my imported IIF file when using the "Review now" button.

What if the "Review Now" button does not work? The IIF file failed, so when I selected the "Review Now" button, it gave me this pop-up. I have downloaded IIF files hundreds of times, from the same place, this file is nothing out of the ordinary. Any suggestions?

Doc1.png

Maybelle_S
QuickBooks Team

Quickbooks won't open my imported IIF file when using the "Review now" button.

Thanks for joining the thread, @d1csp3r.

 

This error usually occurs when the file association of the IIF file is changed to other applications 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.

 

If needed, you'll 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 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 know you can continue to reach me here with any additional questions. Thanks for coming to the Community, wishing you continued success.

d1csp3r
Level 2

Quickbooks won't open my imported IIF file when using the "Review now" button.

Thank you for your reply. That is the problem I'm running into, I had followed those steps and it is an Excel file. Please see below:

 

d1csp3r
Level 2

Quickbooks won't open my imported IIF file when using the "Review now" button.

I'm trying to open the IIF file using QB Launcher, isn't that what I'm supposed to use?

Ryan_M
QuickBooks Team

Quickbooks won't open my imported IIF file when using the "Review now" button.

Thank you for the prompt reply @d1csp3r. Allow me to join the thread and provide further insight into your situation about IIF files in QuickBooks Desktop (QBDT).

 

You can use the QB Launcher to open the IIF file with errors. An option I can suggest for your IIF file import to go through without the usual checks is the workaround provided by my peer @Jen_D above. 

 

In case you missed it, here's how:

 

  1. Click the File menu. 
  2. Highlight Utilities, then select Import.
  3. Tap the Import it for me. I’ll fix later link at the bottom of the popup window.

I suggest you view this article as well: Import and export data in QuickBooks Desktop. It lists different ways you can import and export information in QBDT, along with their respective links for additional details. 

 

Please don't hesitate the leave a comment below if you have other questions about IIF files in QBDT. I'll be sure to get back to you. Enjoy your weekend!

BigRedConsulting
Community Champion

Quickbooks won't open my imported IIF file when using the "Review now" button.

@Maybelle_S 

RE: This error usually occurs when the file association of the IIF file is changed to other applications than MS Excel.

 

Well... the QuickBooks installer sets up IIF files to be associated with QuickBooks, not Excel. It has always done this and it's always been sort of dumb as then when you double-click an IIF file then you get a QB warning that you can't open IIF files in this way.

 

This means that, basically, the button in QuickBooks doesn't work for anyone unless they actually change the file association. And, based on this thread not even that works sometimes.

 

I've no idea why Intuit implemented things this way. It is easy enough to launch Excel and tell it to open the file instead of just launching the file and hoping the computer is set up to open it in Excel.

 

If you're one of the almost-everyone who can't open the error files from within QB, you can open them from within Excel by starting to open a file and then navigating to the folder where you put the original IIF file and then picking "All Files (*.*)" in the file open dialog.  Then you'll see both your IIF file and the one with the ~ "_65465454" extension added to the file name.

 

Also, see BRC QuickBooks 2019+ IIF Import Changes and Recommendations and avoid all this by importing using the alternate method (which Intuit has tried to make sound scary, but works a whole lot better.)

View solution in original post

CherylL
Level 1

Quickbooks won't open my imported IIF file when using the "Review now" button.

Thanks for the feedback.  My file was finally able to import.  But it didn't ask me what I wanted to tie it to (Commercial Credit Card).  Can you post the link that tells me what to do next?  

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us