How to Import Inventory Into QuickBooks

Go to Insert option in the menu bar
Click on Worksheet
Enter Inventory in column A of the excel sheet
Make sure to add this for each item on the spreadsheet
Make column B, enter the item’s name
In column C, add a description for the item
For column D, E, and F, have Sales Income, Cost of Goods Sold, and Inventory Asset as your field names respectively
In column G, enter the quantity or column in which the inventory items are available
Add the cost of each item in column H. Use standard format – 0.00 and not use the dollar sign.
In the Column I, enter the sales price
For column J, add the number of units to be left in stock before being notified to order additional items.
Column K should be left blank. This will be for the total value of the inventory on the basis of its cost per unit. This will be done automatically when you are using QuickBooks
Column L will contain the date when the inventory presently in stock would affect your accounts. The format should be DD/MM/YYYY
In column M, add manufacturer part number. It’s optional
Put all the details under specific columns for each item that you deal with it.

Also Read: How to Produce Physical Inventory in QuickBooks

Go to the File menu
Click Utilities
Choose Import
Choose Excel Files
Go for Advanced Import
Click on Browse to locate the Excel sheet you want to import
Choose to Open
Choose the worksheet containing the required data
Uncheck the This Data File Has Header Rows box
From the drop-down, click on Choose Mapping
Choose Add New
Enter Inventory Report under Mapping Name column
Choose Import Type
Select Item
Choose to Save

Review the items properly and once reviewed, import them