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

17 Comments 17
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
Moderator

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.)

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?  

Sjones94
Level 3

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

Hi - I am having the same problem. I've always gone to single user mode, import iif file and never had a problem. But today it is not letting me import or review the errors. It is asking me what app to use to open but I thought it always was the QB launcher which it shows but it's not working. So I can't the errors, don't know why it's not importing all of a sudden. Any insight? I am hesitant to use the work around you suggested as another post said don't do it. 

Jen_D
Moderator

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

Thanks for posting here, @Sjones94.

 

I appreciate you taking the time to let us know the updates of your import process.

 

Since you already tried the suggested troubleshooting here, I'd always recommend contacting our Support Team to assist you with your account concerns and questions. They can help further identify what's causing the import hurdle. 

 

To contact us: 

 

  1. Open QuickBooks and click the Help menu.
  2. Select QuickBooks Desktop Help.
  3. On the pop-up screen select Contact us.
  4. Click the Search for Something else button then type your concern in the Ask us anything box.
  5. Hit Search then scroll down to get your contact options.

 

Refer to this article to learn more about our contact options and support availability: Contact QuickBooks Desktop support

 

Thanks for reaching out to us today. This forum is always open for your QuickBooks importing concerns and I am always here to help. Have a nice week ahead!

Sjones94
Level 3

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

Thank you for your reply - I have had zero luck with support. I literally was kicked back and forth between payroll and desktop help as each would say it wasn't their department. No one can seem to figure this out. I literally ran payroll again today and IIF files still won't import. I was disconnect twice on the phone after being on hold for over 20 minutes and after a 43 minute call that they finally said they didn't know how to fix the issue. (a little frustrating to say the least) so am hoping to get the help I need here instead. So now I am going on a few weeks of this and it really needs to get fixed. Can you please help?

MadelynC
Moderator

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

This isn’t the experience we want to leave to you, @Sjones94.


To resolve your situation, you may consider contacting an IT expert. They can check everything up to ensure you can successfully import your files.


I’ve added this reference to learn more about importing and exporting Intuit Interchange Format (IIF) files to and from QuickBooks Desktop: Export, import, and edit IIF files.


You can also visit the QuickBooks Support page for more tips, resources, and tutorials. It helps ensure records are accurate and organized.


If you have any other questions or concerns besides importing IIF files, don’t hold back to drop a comment below. We’ll be here!

MthisLthat
Level 1

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

You assume small businesses have an "IT guy," never mind miniscule business like mine. How about Quickbooks makes Desktop changes so that small businesses don't need an "IT guy" to fix every little thing that goes wrong? I've spent unbillable hours and hours trying to import iif data, trying to interpret "fixes" and vaguely explained solutions that say follow the steps and there are no steps. Quickbooks is going to put me out of business. And Qbooks tech support doesn't support this iif import issue, that, from what I've read, a huge number of users experience. It's unconscionable, especially since Qbooks has gone subscription for Desktop (no argument from me - I totally understand), but for that price, I should have access to knowledgeable support who can actually help fix the problem. It's year end, and I can't import my client's data - you're going to give me a heart attach from the stress of it. Rant over.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us