Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
ahenning1911
Level 1

Help with entering Items in Lists

Hello, I'm assisting in the setup of new company and they are using QuickBooks Enterprise for the time being.  Unfortunately they have about 10,000 different Items that need to be created and added.  These entries would be sub items and linked to specific GL codes for COGS.  Does anyone know if there is a way to mass upload or import this data from maybe an Excel sheet, as to not enter all these one by one?  Just curious in the interest of saving days and hours of entering.  Thanks.

1 Comment 1
RheaMaeH
QuickBooks Team

Help with entering Items in Lists

Thank you for reaching out to us, ahenning1911. I'm glad to inform you that you can import multiple items in QuickBooks Desktop. 

 

There are several file formats you can use to import your data, such as MS ExcelCSV, or IIF files, and the data you enter may vary depending on whichever you use.

 

You can also check this article for more information about importing data: Import and export data in QuickBooks Desktop.

 

While it is possible to mass-upload your file, there's a maximum number of entries you can have for the item list in QuickBooks Desktop Enterprise.

 

Alternatively, you can also use a third-party app to import your data. 

 

If you need guidance on modifying your item, I am adding these articles that can help: Add, edit, and delete items in QuickBooks Desktop.

 

Please let me know if you have further questions or concerns about importing your data into QuickBooks Desktop. I'm always here to help. Stay safe.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us