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

IIF Import Error QB Desktop Pro 2020

We just updated from 2017 to 2020 QB Desktop Pro. My first IIF upload was unsuccessful. This is the error: QB Error 15101 QNTY is not a valid column for record CHECK.

 

How do I fix it? The QNTY column has never been an issue before.

Solved
Best answer April 28, 2020

Best Answers
MaulikH
QuickBooks Team

IIF Import Error QB Desktop Pro 2020

Afternoon, Deb24442!

 

Glad to have you as a member of the QuickBooks Community. You've come to the right place for help. With QuickBooks Pro 2020, importing lists and transactions is convenient and accurate with the Import IIF Tool. Sounds like you may have a minor error in the correct IIF format of your document.

 

We have a great guide you can view here: IIF Overview

 

We even have a kit with a formatted document you can input the data on and upload after. To upload an IIF file follow the steps below.

  1. Switch to Single- User Mode
  2. Go the File menu and select Utilities.
  3. Select Import then click Import IIF Files.
  4. Locate the file.
  5. Click Import it for me. I'll fix it later.
  6. Select OK

Once the file is imported you'll see the number of lists and transactions imported. If you have any questions about importing in QuickBooks or have any questions at all. You can reach me at any time by replying below. I look forward to hearing how these steps worked for you. Have a great day!

View solution in original post

12 Comments 12
MaulikH
QuickBooks Team

IIF Import Error QB Desktop Pro 2020

Afternoon, Deb24442!

 

Glad to have you as a member of the QuickBooks Community. You've come to the right place for help. With QuickBooks Pro 2020, importing lists and transactions is convenient and accurate with the Import IIF Tool. Sounds like you may have a minor error in the correct IIF format of your document.

 

We have a great guide you can view here: IIF Overview

 

We even have a kit with a formatted document you can input the data on and upload after. To upload an IIF file follow the steps below.

  1. Switch to Single- User Mode
  2. Go the File menu and select Utilities.
  3. Select Import then click Import IIF Files.
  4. Locate the file.
  5. Click Import it for me. I'll fix it later.
  6. Select OK

Once the file is imported you'll see the number of lists and transactions imported. If you have any questions about importing in QuickBooks or have any questions at all. You can reach me at any time by replying below. I look forward to hearing how these steps worked for you. Have a great day!

View solution in original post

jacobsn66
Level 1

IIF Import Error QB Desktop Pro 2020

Hello I just upgraded to QB desktop 2020. I used to be able to create journal entries in excel and save as csc. I used to change the extension to iif and I could upload. I can no longer do this. How do I get my excel entries into QB desktop 2020?

Jovychris_A
QuickBooks Team

IIF Import Error QB Desktop Pro 2020

Welcome to the Community, @jacobsn66.

 

I'd be delighted to share with you a link that was already given by MaulikH about IIF Overview: import kit, sample files, and headers. Please review the article before using this guide: journal.iif.

 

This way, you can upload your excel entries to QuickBooks Desktop 2020 seamlessly by following the steps above.

 

For more details in importing and exporting IIF files, you can refer to this article: Export, import, and edit IIF files.

 

Additionally, reference this article if you need guidance in importing and exporting data in QuickBooks Desktop: Import and export data in QuickBooks Desktop.

 

You can always leave a message if you have more questions. I'll keep my notifications. Cheers!

DN76
Level 1

IIF Import Error QB Desktop Pro 2020

I have followed all of these steps when trying to import my .iif files into QB 2020..

I do not get a prompt to fix items later. when I click on review them now...I get a box that pops up that says to use the QB launcher app. I get the error attached. If I select open in folder..I get the same error. The file with all the error reports keep duplicating in my downloads file. They are all .iif files. Not sure how to proceed and I need help!

Nick_M
QuickBooks Team

IIF Import Error QB Desktop Pro 2020

Hello, DN76.

 

I'm happy to assist you this afternoon. To successfully import your .IIF files, you;ll want to download the sample .IIF file in the article I'm including below and check to make sure your format is correct as the file name corresponds with the transaction type you're importing. 

If you're still running into trouble, I'd recommend reaching out to our support team. They will be able to dive into your account with you and see exactly where the hitch is. 

 

If you have any other questions, feel free to post below. Thank you and have a nice afternoon. 

kemjdm
Level 3

IIF Import Error QB Desktop Pro 2020

I am having a similar problem. Just updated Quickbooks Desktop from 2018 to 2021. Now I can't import IIF files that worked fine before installing the new version.

 

I opened the files in Excel and don't see anything amiss. 

jamespaul
QuickBooks Team

IIF Import Error QB Desktop Pro 2020

Hello, kemjdm. 

 

Reviewing the Excel file's format is one way to check for any issues. I'll lay down other fixes to help you import your IIF file. 

 

Have you tried doing the steps above? If not, they're a good way to resolve the IIF import issues. 

 

The first thing you'll want to do is to check to see if this is caused by a damaged component within the installation. The QuickBooks Tool Hub can be a great help to resolve the QNTY issue.

 

Follow the steps from this article to get started: Fix common problems and errors with the QuickBooks Desktop Tool Hub

 

Another thing to do is to use the alternative import process. This can be accessed the same way when you import the file. Here's how to do it: 

 

  1. Go to File, then hover on Utilities.
  2. Select Imports.
  3. Choose IIF file
  4. On the pop-up, click the Import it for me I'll fix it later link. 

 

import1.PNG

 

If you still encounter the same error message, you'll want to contact our QuickBooks Desktop support. They'll check on your file and installation and resolve the issue for you. Here's how to reach them: 

 

  1. On QuickBooks Desktop, press the F1 key to open the Help menu. 
  2. Click the Contact Us button.
  3. Enter something like "QB Error 15101 QNTY" or any other error messages you encountered.
  4. Proceed with Let's talk.
  5. Select either Start a chat or Get a call

 

After resolving the issue, you can start working on the imported data. If you need help, feel free to check our guides here: QuickBooks Desktop articles list page

 

You're more than welcome to ask any other questions about importing your data into QuickBooks Desktop. Do you have other concerns? Let me know and I'll help you out. 

MDD2021
Level 1

IIF Import Error QB Desktop Pro 2020

I'd be immensely grateful for any suggestions to my import issue. I'm upgrading from ver  QB Pro 2018 to Enterprise 2021. Trying to export my customer file which was successful but the import left more than 2/3 of the files unsuccessful. I've been reading every solution that I can find. I used the "import for me I'll review later" utility. When I click to open the file in folder it tells me it will open with QBLauncher. Fine. I click that and an error says only company files can be opened with QBLauncher. 

 

This is so immensely frustrating - I wonder if it is worth it at all. 

 

In gratitude,

 

R Mouer

JasroV
QuickBooks Team

IIF Import Error QB Desktop Pro 2020

Great job in exporting your customer list, R Mouer.

 

I'm here to guide you on how to import your data to your QuickBooks Desktop (QBDT) 2021.

 

Only company files can be imported when using QBLauncher. To seamlessly import your customer list, you'll want to go to the File menu and upload the file from there. Let me show you how.

 

If you've exported your customer list via MS Excel, you can follow these steps in importing it:
 

  1. Go to the File menu.
  2. Select Utilities then Import.
  3. Then select Excel Files.
  4. If you get the Add/Edit Multiple List Entries window, click No.
  5. Follow the wizard in importing files.

 

You can also check this link for more details: Import or export MS Excel files.

 

However, if you've exported it as IIF file and received an error, you can refer to the troubleshooting steps provided in this link: Improved IIF Import in QuickBooks 2019 and later.

 

You can also read this article for more insights about importing and exporting data in QBDT: Import and export data in QuickBooks Desktop.

 

Let me also add this resource that you can utilize in case you need to merge your accounts and customers: Merge list entries in QuickBooks Desktop.

 

I'll be around if you have other concerns about importing data in QBDT. Have a great week ahead!

MDD2021
Level 1

IIF Import Error QB Desktop Pro 2020

Thank you for your response. I did export data as iif file.

 

Most of the other files ie vendors & such I was able to export & import successfully. My largest data sources are the problem.

 

               Exporting from 2018 as .iff file

               Import file>utilities>import iff

               Result – files not successfully imported

 

From there I cannot open the file to correct the errors. Make sense? If I click “review” it launches QB Launcher automatically. If I click open in folder, I see the folder but I cannot open it.

 

I appreciate your time.

DivinaMercy_N
QuickBooks Team

IIF Import Error QB Desktop Pro 2020

Hi there, @MDD2021.

 

Thanks for getting back here. I've got steps to further help you fix the error when importing your IIF files. Here's how:

  1. Select the Review now button.
  2. Find the ERROR to see what the problem(s) with the file is.
  3. Correct the errors and then, Save.
  4. Click Yes, if there's a prompt that says you want to keep the file type. 
  5. Close the File not imported window.
  6. Import the corrected .IIF file again. 

 

For more info about this process, please see this article: Improved IIF Import in QuickBooks 2019 and later.

 

However, if the issue persists, I highly recommend reaching out to our Technical Support team. This way they can have a formal investigation to determine what's preventing you to import the IIF file. You can also request a screen sharing session so they can check your setup. To do so, please follow these steps:

  1. Click the Help menu and select QuickBooks Desktop Help.
  2. Click Contact Us.
  3. Enter your brief description of your concern. Example: Cannot import customer file using IIF files in QuickBooks Desktop. 
  4. Select Continue.
  5. Choose either Start messaging or Get a callback.

 

Then, to find articles you can bookmark for future use, check out our QuickBooks Desktop help articles site. Simply, enter a keyword of your concern on the search box or select any of the categories displayed.

 

Should you need any assistance with importing your IIF files in QuickBooks, please leave a reply below. I'm available here to help at any time. Take care always.

GaryAC
Level 1

IIF Import Error QB Desktop Pro 2020

We encountered this problem today, which was the first import after upgrading from 2018 to 2021. We figured out that the format of the IIF file must now be tab-separated as opposed to comma-separated. It's an easy fix you can do in notepad, or you can do it when you select the file type to save from Excel.

 

Worked for us.

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