How to Track Inventory in QuickBooks

Accurate inventory tracking keeps your stock counts reliable, your sales records organized, and your financial reports aligned with your actual stock levels. QuickBooks Online and QuickBooks Desktop both include built-in inventory tools. These features track stock levels, monitor quantities, and generate inventory valuation reports automatically.

Before you begin, confirm your QuickBooks Online plan is Plus or Advanced, since inventory tracking is not available on Simple Start or Essentials. For Desktop, confirm the inventory feature is active in Preferences. This guide explains how QuickBooks Track Inventory works, how to enable inventory tracking, add products, track stock manually, review inventory reports, and maintain accurate inventory records in both QuickBooks Online and Desktop.

Why Inventory Tracking Matters in QuickBooks

Tracking inventory in QuickBooks helps you maintain accurate stock records and improve purchasing decisions across your business.

• Accurate stock visibility helps you see the exact quantity available for every product.
• Inventory management keeps your sales records aligned with available stock and prevents overselling.
• Sales tracking helps identify top-selling products and customer buying trends.
• Purchase tracking through purchase orders helps maintain organized inventory records.
• Low-stock alerts help you reorder products before inventory reaches zero.
• Inventory reports show quantity on hand, average cost, and inventory value for each product. These reports support better purchasing and restocking decisions.
• Cost tracking helps QuickBooks calculate cost of goods sold accurately and maintain reliable profit margins.

Important Checks Before Enabling Inventory Tracking

Complete these checks before turning on inventory tracking in either version of QuickBooks:

• Verify that your QuickBooks Online subscription uses the Plus or Advanced plan because inventory tracking is unavailable on Simple Start or Essentials.
• For Desktop, confirm that the Inventory and Purchase Orders feature exists in your QuickBooks version before making changes.
• Review your products and services list and remove duplicate or outdated entries before setup begins.
• Count your existing stock carefully and prepare accurate opening quantities for every inventory item.
• Gather the cost price, sales price, and inventory account details for every product before setup begins.
• Review your sales tax settings and confirm each inventory item uses the correct tax code.
• Back up your company file before changing inventory settings, especially in QuickBooks Desktop.

How QuickBooks Track Inventory Works?

QuickBooks tracks inventory quantities automatically after you enable the feature and set up inventory products correctly.

Feature	QuickBooks Online	QuickBooks Desktop
Inventory Setup	Account and Settings > Sales	Preferences > Items & Inventory
Quantity Tracking	Updates with each sale and purchase	Updates with invoices and purchase orders
COGS Calculation	Automatic on each sale	Automatic on each invoice
Reorder Alerts	Set per product	Set per item in Item List
Inventory Reports	Valuation Summary and Detail	Valuation Summary and Detail
Stock Adjustments	Manual adjustment entries	Manual adjustment entries

When you record a sale, the system reduces the quantity on hand and calculates the cost of goods sold automatically. Recording a purchase increases the quantity on hand. This keeps your stock records aligned with your financial data automatically.

How to Enable Inventory Tracking in QuickBooks Online?

Turn on inventory tracking before adding products or recording stock transactions.

1. Log in to your QuickBooks Online account.
2. Select the Settings gear icon.
3. Click Account and Settings.
4. Open the Sales tab.
5. Go to the Products and Services section.
6. Turn on Show Product/Service column on sales forms.
7. Turn on Track quantity and price/rate.
8. Turn on Track inventory quantity on hand.
9. Click Save and then Done.

How to Enable Inventory Tracking in QuickBooks Desktop?

QuickBooks Desktop requires you to activate inventory tracking through Preferences before adding inventory items.

1. Open QuickBooks Desktop and go to the Edit menu.
2. Select Preferences.
3. Click Items & Inventory from the left panel.
4. Open the Company Preferences tab.
5. Check the box for Inventory and purchase orders are active.
6. Click OK to save the setting.

The software now allows inventory item tracking through the Item List.

How to Add Inventory Products in QuickBooks Online?

After enabling inventory tracking, add products so the Online version can monitor stock quantities automatically.

1. Go to the Sales menu and select Products and Services.
2. Click New.
3. Select Inventory as the product type.
4. Enter the product name in the Name field.
5. Enter the SKU if you use one.
6. Enter the Initial quantity on hand as of today’s date.
7. Set a Reorder point for low-stock alerts.
8. Enter the Cost price for the product.
9. Enter the Sales price you charge customers.
10. Assign the correct Income account and Inventory asset account.
11. Assign the COGS account where the system records product costs after sales.
12. Click Save and close.

How to Add Inventory Items in QuickBooks Desktop?

QuickBooks Desktop stores inventory products inside the Item List. Once you add items correctly, the software tracks quantities automatically.

1. Go to the Lists menu and select Item List.
2. Click the Item button and select New.
3. In the Type field, select Inventory Part.
4. Enter the item name in the Item Name/Number field.
5. Add purchase and sales descriptions in the relevant fields.
6. Enter the Cost price per unit.
7. Select the correct COGS Account.
8. Enter the Sales Price for the product.
9. Assign the correct Income Account.
10. Select the correct Asset Account for inventory value tracking.
11. Enter the Reorder Point for low-stock notifications.
12. Enter the On Hand quantity and Total Value as of the setup date.
13. Click OK to save the item.

How to Track Sales and Purchases in QuickBooks Desktop?

Recording every inventory transaction correctly keeps stock quantities accurate inside QuickBooks Desktop.

1. Create an Invoice for each customer sale and assign the correct inventory items. The system automatically reduces the quantity on hand after saving the invoice.
2. Add Sales Receipts for transactions where customers pay immediately at the time of sale.
3. Create Purchase Orders for inventory orders placed with suppliers. This helps maintain accurate purchase records.
4. Record an Item Receipt or use Enter Bills Against Inventory after stock arrives. This updates the quantity on hand automatically.
5. Verify quantities regularly through the Item List or the Inventory Valuation Summary report.

How to Track Inventory Manually in QuickBooks Online?

Manual tracking works for businesses using a QuickBooks Online plan without built-in inventory tracking.

1. Go to Sales and select Products and Services.
2. Click New and select Non-inventory as the product type.
3. Enter the product name, description, price, and income account details.
4. Click Save and close.
5. Maintain a separate spreadsheet for stock quantities, purchases, and sales activity.
6. Update the spreadsheet whenever you receive stock or record a sale.
7. Record purchases under Expenses or Purchase Orders in QuickBooks.
8. Record sales through invoices or sales receipts as usual.
9. Review the spreadsheet regularly. Compare the numbers against your QuickBooks sales and purchase records to confirm accuracy.

How to Review Inventory Reports in QuickBooks?

Both versions of QuickBooks include inventory reports that help monitor stock levels, costs, and inventory value.

In QuickBooks Online

1. Open the Reports menu.
2. Search for Inventory Valuation Summary to review quantity on hand, average cost, and inventory value.
3. Search for Inventory Valuation Detail to review every inventory transaction affecting stock quantities and costs.

In QuickBooks Desktop

1. Open the Reports menu.
2. Select Inventory.
3. Choose Inventory Valuation Summary or Inventory Valuation Detail.
4. Set the correct date range and run the report.

Review these reports regularly to identify discrepancies before they affect your accounting records.

Common Inventory Tracking Problems in QuickBooks

These issues commonly create inaccurate inventory records:

• Incorrect stock quantities appear when purchases or sales are entered with the wrong quantity or recorded late.
• Missing inventory products occur when products are deleted or never added before inventory tracking starts.
• Duplicate inventory entries happen when businesses create the same item under different names or SKUs.
• Inventory adjustment errors create inaccurate reports when users adjust the wrong product or quantity.
• Outdated inventory counts build up when physical stock counts are skipped regularly.
• Product setup mistakes such as incorrect accounts or opening quantities create inaccurate inventory values from the beginning.

Tips to Maintain Accurate Inventory Tracking

Follow these practices to keep inventory records accurate and organized:

• Review inventory records regularly and compare them against physical stock counts.
• Update stock quantities immediately after receiving products or processing returns.
• Verify every purchase entry and confirm products and quantities match supplier records.
• Monitor reorder points and create purchase orders before stock reaches zero.
• Remove inactive inventory items to keep your product list organized.
• Run inventory valuation reports frequently to monitor inventory value and stock activity.
• Maintain consistent SKUs across sales channels and QuickBooks records to prevent mismatches.

When to Contact QuickBooks Support

Contact QuickBooks Support after completing the setup and troubleshooting steps above.

• You cannot access inventory tracking despite using a supported plan or Desktop version.
• Stock quantities continue calculating incorrectly after corrections and adjustments.
• Inventory data fails to sync correctly with connected sales channels or third-party applications.
• Inventory products or records disappear from the products list unexpectedly.
• An inventory setup error prevents you from saving products or enabling inventory settings.

Conclusion

QuickBooks Track Inventory features give businesses accurate visibility into stock quantities, inventory costs, and product performance across both Online and Desktop versions. Setting up inventory tracking requires only a few configuration steps in both versions. Once active, QuickBooks updates inventory quantities automatically with every recorded sale and purchase. Review inventory reports regularly, maintain organized product records, and resolve discrepancies quickly to keep your inventory management accurate and reliable.

Frequently Asked Questions