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

IIF import fails

Hi,

We are trying to import an IIF file, which imports properly on QB desktop 2020 but not on QB desktop 2017.

The file is attached.  I need to attach the screenshot of the file, since we can't attach iif here.

 

Can anyone suggest? We don't have the file which is created for the errors from the client. Any guesses for the changes between 2020 and 2017.

 

Thanks in advance.

Awanish

13 Comments 13
Angelyn_T
QuickBooks Team

IIF import fails

Hello, @Awanish.

 

 

At this time, QuickBooks still supports importing IIF file to QuickBooks Desktop (QBDT) 2017. Thus, you should be able to import the file to the 2017 version seamlessly.

 

For now, may I know the specific error you're getting when trying to import the file to QBDT 2017? This way, I can check and gather information about the error/message.

 

If you've received an error message "File not imported", QuickBooks gives you the option to review and resolve the errors found in the .IIF file.

 

  1. Choose Review now.
  2. Look for ERROR to see what the problem(s) with the file is.
  3. Correct the errors and Save.Important: If asked if you want to keep the file type, select Yes.
  4. Close the File not imported window.
  5. Import the new, corrected .IIF file.

Save the IIF file on the computer. Then, import it. Here's how:

  1. Go to the File menu, select Utilities then Import then IIF Files.
  2. Select Import IIF.
  3. Locate the file, then select OK. We don't recommend the option Import it for me. I'll fix it later. Since this option bypasses data review, some of the info may not be correct or complete for your books. It also requires that you switch to a single user.
  4. Once the import is successful, you'll see the numbers of lists and transactions imported. Press Done.

 

For additional reference about importing IIF file in QBDT, check out this article: Export, import, and edit IIF files.

 

Also, for the improved IIF import in the later versions of QuickBooks, read this article.

 

Get back to me if you have any other questions. I'm a few clicks away to help. Have a great weekend!

Awanish
Level 1

IIF import fails

Hi @Angelyn_T 

 
Thanks for your response and apologies for the delay from my side.
 
 
 
 
 
 
 We had been trying to get the error iif file from the client but that for some reason cannot happen.
 
 It's decided that we'll experiment with QB Desktop 2017 at our end. Caveat with that is that there is no trial version available for the same apparently. Can you help me with that. The reason is that we need to support from QBD 2017 to QBD 2020, and it is too costly to have licenses for all the versions.
 
Fiat Lux - ASIA
Level 15

IIF import fails

@Awanish 

Company made an enhancement to IIF feature since QuickBooks 2019. You may have 2 options to assist your clients:

1. Purchase a license of Pro 2017 or Pro 2018. You may purchase QB 2018 Pro for 1 user for less than $300

 

2. Utilize another approach to import data into QB Desktop. Consider using one of these 3rd party tools. 

https://transactionpro.grsm.io/qbd

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

They provide as a one-time license and support QB Desktop 2007-2020.

 

Hope it helps.

Awanish
Level 1

IIF import fails

Hi,

 

We talked here with product owner and we can't have the option #2 (third party tools) as a solution.

For Option #1, issue is that we may have customers with different version of QBD. So we can't buy licences from QBD2007 onwards.

 

Another suggestion is if we can have some consultant who can help us test all this, can you point us to some consulting services.

 

ReyJohn_D
Moderator

IIF import fails

Thanks for getting back here in the Community, @Awanish.

 

You can get professional pieces of advice with this from our Pro-Advisors. They are QuickBooks-certified independent accounting pro who can provide vital insights on how to manage your books, adding payroll, and paying taxes, etc. to drive your business success. 

 

I'll guide you on how to reach them:

 

  1. Visit the website: Find-a-ProAdvisor.
  2. Choose one of the specialties listed to narrow the search results.
  3. Enter your ZIP code, town, city, or area in the search field then click Search once done.

A39.PNG

You may also visit this website to learn more about pro-advisors: Who are pro-Advisors?

 

Furthermore, you can check out this article to know more on how to manage the export and import of IIF files in QuickBooks Desktop: How Do I manage the export and import of IIF files in QuickBooks Desktop?

 

Please let me know if I can be of any help by leaving a comment below. Take care and have a nice day!

Fiat Lux - ASIA
Level 15

IIF import fails

@Awanish 

We may share the installer file of 30-day Quickbooks Enterprise 18.0 Trial. Send a private message to us.

blackbeltmom
Level 1

IIF import fails

Starting with the payroll for the week of Thanksgiving,  the iif file import is not working correctly. I am getting no error messages and it actually tells me that it is imported. However,  there is no data imported.  I can open the iif file in Excel and the data is there. I need this fixed because right now our checkbook is off by about $120,000. The last journal entry file that imported is dated 11/27/2020.

MorganB
Content Leader

IIF import fails

Hi there, blackbeltmom.

 

Thanks for following up on this thread. I want to make sure you're able to successfully enter payroll info into your Desktop account.

 

You may want to check to see if the system created a new IIF file, due to potential damage in the old one. If you see the option Open in Folder, you can click that and be redirected to where the new file is located, and continue from there. I recommend the following articles for even more info on this process:

Feel free to reach back out if you have any other questions. I'll be here to help.

blackbeltmom
Level 1

IIF import fails

BTW. I am using 2018. I have downloaded the file multiple times and it doesn't fix the problem. Paychex says that it is not the iif file. Could something have gotten corrupted in QuickBooks, possibly after the last update.

blackbeltmom
Level 1

IIF import fails

We are using Quickbooks 2018. I have downloaded the iif file multiple times and it does not work. Unless it is continually getting damaged. Paychex says it is not the iif file. When the file is opened in Excel the data is there.

Kristine Mae
Moderator

IIF import fails

We can check if it's because of a corrupted file, Blackbeltmom. I'm here to guide you.

 

Let's run the Verify/Rebuild utility to detect the data damage. Here's how:

  1. Click File.
  2. Go to Utilities, then choose Verify Data.
  3. If QuickBooks detected no problems, there's no further action needed. If you receive a message, "Your data has lost integrity," the file is damaged. Just continue to Rebuild Data to correct the problem.
  4. When you Rebuild Data, you'll receive a message to back up your company file, just click OK. The utility starts as soon as the backup is finished.
  5. Click OK when you get the message "Rebuild has completed."
  6. Run Verify Data again to check for remaining data damage.

Once done, let's ensure the IIF file is mapped correctly, then import it again.

 

If it didn't make any difference, let's use the QuickBooks File Doctor to fix the company file.

 

You can get back to this thread if you need more help. We'll respond as soon as we can. Keep safe!

 

blackbeltmom
Level 1

IIF import fails

The iif files are not damaged. I have opened an older backup on another computer with 2018 on it (that has not be updated) and the files import and install correctly. Also that Quickbooks gave me the prompt about the GL files. When I try to import on the main computer with updated QB2018, it does not give me that prompt it only tells me that the file has been imported. I have to believe that the issue is in Quickbooks itself.

JonpriL
Moderator

IIF import fails

Hello @blackbeltmom,

 

Let's repair QuickBooks to get rid of the error prompt so you can get back to business in no time.

  1. Go to Start.
  2. Select Control Panel.
  3. Under Programs and Features, select Uninstall a Program.
  4. Click QuickBooks, and select Uninstall/Change.
  5. Select Repair.
  6. Click Finish.

In addition, here's an article you can read to learn more about how you can repair QuickBooks: Repair your QuickBooks Desktop for Windows.

 

Lastly, I've got you this helpful article for guidance in preparation for the 2020 tax season: QuickBooks Desktop Year-end Checklist.

 

If there's anything else that I can help you with, please let me know by leaving any comments below. I'll be here to lend a hand.

Need to get in touch?

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