How to Add Inventory in QuickBooks

Adding inventory to QuickBooks is a task that trips up new and experienced users alike. Tested on QuickBooks Desktop Pro 2022 and 2023, and QuickBooks Online (2024) on Windows 10 and Windows 11, this guide walks through every step for both platforms, explains how item records work, and covers the most common mistakes that lead to incorrect stock counts or missing COGS entries.

What Is Inventory Tracking in QuickBooks?

Inventory tracking in QuickBooks is a feature that records the quantity and value of physical goods you buy and sell. When you enable it, QuickBooks automatically updates your stock count every time you record a purchase or sale, posts the cost to your Cost of Goods Sold (COGS) account, and keeps a running asset value on your balance sheet.

Without inventory tracking, you can still create items and use them on invoices, but QuickBooks treats them as non-inventory parts. The system will not reduce a quantity on hand, will not flag when stock runs low, and will not calculate COGS automatically. The difference matters at tax time and whenever you need an accurate picture of what you have in stock.

QuickBooks Desktop and QuickBooks Online handle inventory differently in several key ways:

Understanding these differences before you begin prevents surprises when your reports look different between platforms.

Enable Inventory in QuickBooks Desktop

Before you can add a single inventory item in QuickBooks Desktop, you must turn on the inventory feature in company preferences. This step is skipped most often by users who assume the feature is active by default.

1. Open QuickBooks Desktop and go to Edit > Preferences
2. In the left panel, click Items and Inventory
3. Click the Company Preferences tab
4. Check the box labeled Inventory and purchase orders are active
5. Click OK

QuickBooks will close all open windows to apply the change. That is expected behavior. Once the preference is saved, the Item List will show the Inventory Part option in the Type drop-down, and the home screen will display the inventory workflow icons.

If you are on QuickBooks Enterprise and need advanced features like multiple warehouse locations or bin tracking, go to Edit > Preferences > Items and Inventory > Company Preferences, then click Advanced Inventory Settings. You may need to sync your license online first by going to Help > Manage My License > Sync License Data Online.

Add an Inventory Item in QuickBooks Desktop

With the inventory preference enabled, follow these steps to create your first inventory item.

1. Go to Lists > Item List (or press Ctrl+I)
2. Click the Item button at the bottom left of the Item List window, then select New
3. In the Type drop-down at the top, select Inventory Part
4. Fill in the fields:

- Item Name/Number: Enter a short, unique identifier (e.g., "WIDGET-100"). This appears on invoices and purchase orders.

- Purchase Description: Text that appears on purchase orders when you buy this item

- Cost: Your default purchase price from the vendor

- COGS Account: QuickBooks defaults to your Cost of Goods Sold account. Confirm this is correct.

- Preferred Vendor: Optional but useful for generating purchase orders automatically

- Sales Description: Text that appears on customer invoices

- Sales Price: Your default selling price

- Income Account: The revenue account that records income when you sell this item

- Asset Account: The inventory asset account that holds the value of stock on hand (QuickBooks defaults to Inventory Asset)

- Reorder Point: The quantity at which QuickBooks should remind you to reorder

- On Hand / Total Value / As of Date: Enter your current stock quantity and value if you are setting up an existing item

1. Click OK to save the item

The COGS Account, Income Account, and Asset Account fields are the ones most commonly left wrong. If the income account is mapped to an expense account by mistake, your profit and loss report will show incorrect numbers from day one.

Enable Inventory in QuickBooks Online

QuickBooks Online requires a Plus or Advanced subscription to use inventory tracking. If you are on Simple Start or Essentials, you will need to upgrade before the option appears.

1. Click the Gear icon in the upper right corner
2. Select Account and Settings
3. Click Sales in the left menu
4. Scroll to the Products and services section
5. Toggle on Track inventory quantity on hand
6. Click Save, then Done

Once enabled, you will see a new Quantity on hand column when you add or edit products in your product list.

Add an Inventory Item in QuickBooks Online

1. Go to Sales > Products and Services (or click the Gear icon and select Products and Services)
2. Click New in the upper right
3. Select Inventory as the product type
4. Complete the form:

- Name: A unique product name visible on transactions

- SKU: Optional stock-keeping unit for internal tracking

- Initial quantity on hand: Enter how many units you currently have

- As of date: The date your opening stock count is accurate as of

- Reorder point: The quantity that triggers a low-stock reminder

- Inventory asset account: Defaults to Inventory Asset

- Description: Appears on sales forms

- Sales price/rate: Your selling price

- Income account: The account that records revenue from sales

- Purchasing information: Description and cost that appear on purchase orders

- Expense account: Your COGS account

1. Click Save and close

QuickBooks Online uses FIFO costing. This means when you sell an item, the system assumes you are selling the oldest units first and values COGS at the cost of those units. You cannot change this costing method in QuickBooks Online.

Set Up Inventory for QuickBooks Enterprise

QuickBooks Enterprise includes all the steps above plus additional configuration for businesses managing multiple locations or large volumes of products.

Serial and Lot Number Tracking:

1. Go to Edit > Preferences > Items and Inventory > Company Preferences
2. Click Advanced Inventory Settings
3. On the Serial/Lot Numbers tab, enable tracking for serial numbers, lot numbers, or both
4. When you receive items on a purchase order or bill, you will be prompted to assign serial or lot numbers

Multiple Location Inventory:

1. In Advanced Inventory Settings, click the Multiple Inventory Sites tab
2. Check Enable Inventory Site Tracking
3. Go to Lists > Inventory Site List to add your warehouse or bin locations
4. Assign a site when receiving inventory and when fulfilling sales orders

Bin Tracking (Enterprise Platinum and higher):

Bin tracking lets you specify exact shelf locations within a warehouse. Enable it in Advanced Inventory Settings > Bin Tracking tab after enabling Multiple Inventory Sites.

Receive Inventory Against a Purchase Order

Once your items are set up, the standard process for receiving new stock in QuickBooks Desktop is:

1. Create a purchase order: Vendors > Create Purchase Orders
2. When goods arrive, go to Vendors > Receive Items (with or without a bill)
3. Select the vendor and click Yes when QuickBooks asks if you want to receive against an open purchase order
4. Select the purchase order, verify quantities received, and click OK
5. QuickBooks increases the quantity on hand and debits the Inventory Asset account automatically

In QuickBooks Online:

1. Go to + New > Purchase Order to create a PO
2. When you receive goods, go to + New > Bill or Expense
3. Link it to the open purchase order
4. QuickBooks updates inventory quantity on hand when you save the bill

Adjust Inventory Quantities

Physical counts rarely match what QuickBooks shows. Use an inventory adjustment to correct discrepancies.

QuickBooks Desktop:

1. Go to Vendors > Inventory Activities > Adjust Quantity/Value on Hand
2. Select an Adjustment Account (typically an expense account like Inventory Adjustments)
3. Enter the correct quantity for each item that needs updating
4. Add a memo explaining the reason for the adjustment
5. Click Save and Close

QuickBooks Online:

1. Go to + New > Inventory Quantity Adjustment
2. Enter the new quantity on hand for each affected product
3. Select an adjustment account
4. Click Save and close

Common Inventory Setup Mistakes

Mistake 1: Using a non-inventory part type for physical goods. Non-inventory parts do not track quantity and do not post to an asset account. If you have been using this type and want to switch, you cannot change an existing item's type. You must create a new inventory item and update your open transactions.

Mistake 2: Not setting an opening balance quantity. If you skip the "quantity on hand as of date" field when creating items, QuickBooks starts all counts at zero. This means your first sales will show negative inventory, which creates negative asset values on your balance sheet.

Mistake 3: Mapping COGS to a revenue account. This understates expenses and overstates gross profit. Check your item setup by going to Lists > Item List, double-clicking each inventory item, and verifying the COGS Account field.

Mistake 4: Using inventory adjustments for normal purchases. Adjustments are for correcting discrepancies, not for recording incoming stock. Always use purchase orders and receive items (or bills) to add stock so the audit trail is correct.

When to Call Support

Contact QuickBooks support if:

• Inventory quantities go negative after recording sales that should have sufficient stock
• The inventory asset account balance does not match the sum of your items' on-hand values
• You receive a "There is insufficient quantity" error when creating sales orders against available stock
• Assembly build errors prevent you from creating finished goods from components
• Inventory settings are grayed out or missing in Preferences despite having the correct QuickBooks edition

You can reach support through the QuickBooks support phone number or through the Help menu inside QuickBooks Desktop or Online.