Can I import inventory with quantity on hand from Excel spreadsheet into the new QuickBooks Online?

Yes, you can import inventory with quantity on hand from Excel.

To do this task, from the homepage screen

  • Select the Company “Gear” (upper-corner)
  • Select “Import Data” under Tools
  • Select “Products and Services” under Import Data
  • They provide a sample file. Download a sample file.
  • Select “Choose File” under Upload you file
  • Follow the instructions.
  • For better accuracy of importing excel file, watch this top-rated instructional video.

And like us for providing this FREE video for help.

Can I import Inventory with Quantity on Hand from Excel Spreadsheet in new QuickBooks Online?

YES, you can import Inventory with Quantity on Hand from Excel Spreadsheet.

Import from Excel spreadsheet (see attached sample spreadsheet format below)

  • GO the Company Gear (located at upper right hand corner)
  • Select “Import Data” under Tools heading
  • Select “Product and Services”
  • Click “Choose File” button to import
  • Follow the instructions

I would recommend importing few inventory items first and review it.

Import Inventory List from Excel
Import Inventory List from Excel