Skip to main content
A
ahenning1911
February 27, 2024
Question

Help with entering Items in Lists

  • February 27, 2024
  • 1 reply
  • 0 views

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 reply

R
RheaMaeH
February 27, 2024

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 Excel, CSV, 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.

Terms & ConditionsAccessibility statement