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

Importing bills IIF file limit

Is there any limit on how many records I can import in the IIF file? It will not move, no message error. I am breaking it and little by little it transfers. It would help If I knew what is the limit. Or is it another issue? QB Ent Desktop 2023. I upgraded from Ent 2007. There is few IIF changes that I think I managed, but this one is time consuming. 

 

Thank you! 

3 Comments 3
MaryLandT
Moderator

Importing bills IIF file limit

Yes, there's a limit on how many records you can import using the IIF file, Aga aga.

 

I'm glad to share some details about it. You can only import a certain number of records. To see the complete table, you can browse this link: Maximum number of list entries

 

For transactions, like bills, there's no limit. However, we don't recommend importing more than 100 bills at any one time. The system will tell you how many lists are imported successfully.import iif1.PNG

 

Let me walk you through the steps about importing .IIF files.

 

  1. Go to the File menu, hover over Utilities, choose Import, then IIF Files.
  2. Click Import IIF.
    import iif.PNG
  3. Locate the file, then select OK.
  4. Please know that 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.
  5. Once the import is successful, you'll see the number of lists and transactions imported. Press Done.

 

You may also visit this article to download and install the .IIF format: IIF Overview: import kit, sample files, and headers. That way, you can save time and make it easier to enter the information directly into QuickBooks.

 

I'm also adding this article to the lists and transactions you can import and which one you can't export: Export, import, and edit IIF files.

 

I've added some details about the number of bills you can import @Aga aga. If you need anything else, please don't hesitate to leave a comment below. I'm always right here to help you. Thank you and have a great day ahead!

Aga aga
Level 1

Importing bills IIF file limit

Thank you Mary, but your response is not answering my question. I know how to import file. My file is not a list, so that table is not useful. I am reporting over 1000 bill records, and it is not listed. I already looked into this before posting a question. Any other suggestions? 

MaryLandT
Moderator

Importing bills IIF file limit

Thanks for getting back to me, Aga aga.

 

I've added some details above about importing bills using IIF in QuickBooks. If you have additional questions, please keep in touch again by sending a reply below. I'm just right here ready to respond. Thank you and take care always!

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

Need to get in touch?

Contact us