Note: Be sure that your inventory function is active in QuickBooks Online. Go to Gear Icon>Account and Settings>Sales tab>Products and services area>Checkmark the following at the minimum:
- Show Product/Service column on sales forms
- Track quantity and price/rate
- Track inventory quantity on hand
Click Save then click Done.
- Go to Gear Icon> Lists menu>Products and services.
- You will notice giant “Low Stock” and “Out of Stock” icons at the very top of your items list; this is an indicator that your inventory function in QuickBooks Online is indeed activated.
- Click New at the top right.
- Choose Inventory
- Note: Inventory Assembly items are not discussed here. This is only for inventory Parts.
- Type in your Item Name or some other identifier for the item name
- Note: Be sure to think about what your vendors and customers will see on your documents you submit to them.
- Note: Be sure to think ahead if you will be creating a lot of different items for your inventory repertoire as you want to have an item naming/identifier structure/system you can build on/add to in the future.
- Click on Category only if you want this item to be within (like a sub-item) a particular category identifier.
- This is useful only if you want to separate out groups of different items to make them easier to see and find in your items list.
- Initial quantity on hand and As of date – I typically skip these fields because this is just in case you ALREADY have booked this inventory item in stock in your warehouse prior to actually creating this item in your bookkeeping platform. I always like to use the typical bookkeeping functions (such as entering in a vendor bill) to receive inventory in my bookkeeping system.
- Reorder Point
- The minimum stock status of this item you want to have on hand (at least) before QuickBooks triggers a warning for you to reorder more.
- Inventory Asset Account
- This account is typically preset by QuickBooks when you activate the inventory function. This is where the accumulated on-hand value of this inventory item will be kept.
- Sales Information
- Description – What you type in here will show on all customer invoices when you use this item.
- Sales Price – What you type in here will show on all customer invoices when you use this item. This is not necessary as you can fill this in during the course of creating a customer invoice.
- Income Account – Choose this account carefully. This is the account that will be affected every time you use this item in a customer invoice.
- Sales tax category
- Be careful here as your items may or may not be taxable depending on where you are located and where you ship to.
- Purchase Information
- Description – What you type in here will show on all purchase orders and vendor bills you create when you use this item.
- Cost – What you type in here will show on all purchase orders and vendor bills you create when you use this item. This is not necessary as you can fill this in during the course of creating a purchase order or vendor bill.
- This is not the same as average Cost of Goods Sold.
- Expense (COGS) Account – Choose this account carefully. This is the account that will be affected every time you use this item in a vendor bill, check payment, etc. (NOT a purchase order as purchase orders do not affect your financials).
- Preferred Vendor – This helps in remembering who you typically order this item from.
- Click Save and close.