Entering Beginning Balances of Inventory in QuickBooks thru Add/Edit Multiple Feature

1. Click the Items and Services icon from the Home Page > Right click anywhere in the items table > choose Add / Edit multiple list from the dropdown.

2. Select a list > Make sure that you choose Inventory Parts in the dropdown list.

3. Fill out the item name > then put in sales and purchase description (if any)

4. Enter quantity on hand, as of date (your own cut off date) then enter the total value of the inventory (or you may right click > Customize to just enter the cost per inventory to automatically get the total value.

5. Enter COGS account which is usually Cost of Goods Sold.

6. Enter the Income Account which is usually Sales, Revenue, Service Income.

7. Asset Account should be Inventory Asset or you can point this to a specified asset account.

8. Enter the Sales Tax code.

9. Once complete, click Save Changes in the lower right.

Important : If you have many inventory to input, you may also use this Add / Edit multiple window to copy / paste from excel. Just make sure that the columns in your excel file are the same with the columns in this window. Just right click then click Customize your columns.