Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
Deb24442
April 28, 2020
Solved

IIF Import Error QB Desktop Pro 2020

  • April 28, 2020
  • 12 replies
  • 74 views

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.

    Best answer by kjszjasjs

    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!

    12 replies

    kjszjasjsAnswer
    April 28, 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!

    MDD2021
    May 31, 2021

    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

    GaryAC
    June 11, 2021

    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.


    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.

    jacobsn66
    June 13, 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?

      mv32
      Level 8
      June 13, 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!

      kemjdm
      May 21, 2021

      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
        Level 8
        May 21, 2021

        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. 

         

         

        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. 

        Need QuickBooks guidance?
        Log in to access expert advice and community support instantly.
        Terms & ConditionsAccessibility statement