Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Import items into your company data file from an Excel spreadsheet


  1. If  you are importing existing inventory items, you cannot update their Quantity On Hand (QOH), value on hand (VOH) or average cost.
  2. For new inventory items you are importing, you can set up a Quantity On Hand (QOH) and a Value on Hand (VOH) and establish an average cost. QuickBooks enters an Adjust Quantity/Value on Hand debiting the item's asset account and crediting Opening Balance Equity
  3. If you want to import item quantities or values and you have Advanced Inventory and Multiple Inventory Sites enabled, you must disable Multiple Inventory SItes before importing.
  4. Before importing any data or any kind into your company data file, backup your data file without overwriting any previous backups.

To import items into your QuickBooks company data file. You will need to:

  1. Create a spreadsheet in Microsoft Excel listing the items and their properties.
  2. Utilize the Advanced Import feature.
  3. Create a mapping to translate your spreadsheet into QuickBooks format.
  4. Import the items.
Detailed instructions


If these steps do not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free or you can contact a technical support agent for additional guidance. Fees may apply.

KB ID# HOW13228
9/1/2015 7:08:22 AM
QYPPRDQBKSWS05 9125 Pro 2015 8c7cd4