cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

5 Comments
Highlighted
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

Highlighted
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?

Highlighted
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!

Highlighted
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!

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

Need to get in touch?

Contact us