QuickBooks Desktop Inventory Management: Complete Setup and Tracking Guide
QuickBooks Desktop Inventory Management: Complete Setup and Tracking Guide
A full walkthrough of QuickBooks Desktop’s inventory features — setting up inventory items, tracking stock levels, entering purchases and sales, running valuation reports, and understanding what each edition offers.
QuickBooks Desktop has been a go-to inventory management tool for small and mid-size product businesses for decades. Unlike QuickBooks Online’s limited inventory capabilities, Desktop Pro, Premier, and Enterprise offer genuine inventory tracking with average cost valuation, assembly management, and detailed stock reporting that can run an entire product-based business.
This guide covers the complete inventory workflow in QuickBooks Desktop — from initial setup to daily operations to reporting.
📋 Table of Contents
- Inventory Features by Edition: Pro vs Premier vs Enterprise
- Step 1: Enable Inventory Tracking
- Step 2: Set Up Inventory Items
- Tracking Inventory Purchases
- Tracking Inventory Sales
- Inventory Adjustments
- Inventory Assemblies (Premier/Enterprise)
- Inventory Reports and Valuation
- Inventory Limits and What to Do When You Hit Them
- Frequently Asked Questions
1. Inventory Features by Edition: Pro vs Premier vs Enterprise
| Feature | Pro | Premier | Enterprise Silver | Enterprise Platinum |
|---|---|---|---|---|
| Basic inventory tracking | ✅ | ✅ | ✅ | ✅ |
| Average cost valuation | ✅ | ✅ | ✅ | ✅ |
| Inventory assemblies | ❌ | ✅ | ✅ | ✅ |
| Sales orders | ❌ | ✅ | ✅ | ✅ |
| FIFO cost tracking | ❌ | ❌ | ❌ | ✅ |
| Lot/serial number tracking | ❌ | ❌ | ❌ | ✅ |
| Barcode scanning | ❌ | ❌ | ❌ | ✅ |
| Bin location tracking | ❌ | ❌ | ❌ | ✅ |
| Max inventory items | 14,500 | 14,500 | 1,000,000+ | 1,000,000+ |
| Inventory reports | Standard | Advanced | Advanced | Full suite |
💡 Which edition for inventory? Pro handles basic stock tracking well for businesses with simple inventory needs. If you manufacture or assemble products from components, Premier is required for the assembly feature. Enterprise Platinum is only necessary if you need FIFO costing, lot tracking, or barcode scanning — these are specialized requirements common in food distribution, pharmaceuticals, and high-volume retail.
2. Step 1: Enable Inventory Tracking
Open Preferences
Go to Edit → Preferences → Items & Inventory → Company Preferences.
Enable inventory
Check the box for Inventory and purchase orders are active. This enables all inventory-related features in the software.
Set COGS account
Confirm your Cost of Goods Sold account is set up in your chart of accounts. QuickBooks uses this account to record the cost of inventory items when they are sold. If it doesn’t exist, create it as a Cost of Goods Sold account type.
Configure warnings
Optionally enable Warn if not enough quantity on hand to sell — this prevents creating invoices for quantities you don’t have in stock.
3. Step 2: Set Up Inventory Items
Each physical product you sell needs an inventory item in QuickBooks. Here’s how to set them up correctly:
Open the New Item window
Go to Lists → Item List → Item → New (or Ctrl+N in the Item List).
Select Inventory Part as the item type
From the Type dropdown, select Inventory Part. This is what tells QuickBooks to track quantity on hand for this item.
Complete the item details
Enter: Item Name/Number (your SKU or product code), Description on Purchase Transactions, Cost (your purchase cost — this sets your starting average cost), COGS Account (Cost of Goods Sold), Description on Sales Transactions, Sales Price, Income Account (your revenue account for this product), Asset Account (Inventory Asset — where the value of unsold stock is tracked), and Reorder Point (optional minimum quantity trigger).
Enter opening quantity if you have existing stock
In the On Hand field, enter your current stock quantity. In the Total Value field, enter the total value at cost. QuickBooks calculates your average cost per unit automatically.
Save the item
Click OK to save. Repeat for each inventory item.
⚠️ Opening balance accuracy: Getting your opening quantities and values right at setup is critical for accurate cost of goods sold going forward. If possible, do a physical count before entering your inventory in QuickBooks, and enter the actual quantities and costs as of a specific date (ideally the start of a fiscal period).
4. Tracking Inventory Purchases
There are two methods for recording inventory purchases in QuickBooks Desktop:
Method A: Purchase Orders (Recommended)
Create a purchase order before the goods arrive: Vendors → Create Purchase Orders. Enter the vendor, items, and quantities ordered. The PO does not affect inventory levels — it’s a non-posting document that tracks what you’ve ordered.
When the goods arrive, receive them against the PO: Vendors → Receive Items and Enter Bill (or Receive Items if the bill comes later). This updates your inventory quantities and values immediately.
Method B: Enter Bills Directly
If you don’t use purchase orders, go to Vendors → Enter Bills, select the vendor, and enter each inventory item in the Items tab (not the Expenses tab). Using the Items tab updates inventory quantities automatically.
🚫 Common mistake: Recording inventory purchases through the Expenses tab of a bill does not update inventory quantities. Always use the Items tab when purchasing inventory items. This is one of the most frequent setup errors in QuickBooks Desktop.
5. Tracking Inventory Sales
Inventory is depleted automatically when you record a sale — either through an invoice or a sales receipt:
- Invoice (payment later): Customers → Create Invoices. Select the customer and enter the inventory item and quantity. QuickBooks records the revenue to your income account and simultaneously decreases the inventory quantity on hand, recording the cost to COGS.
- Sales Receipt (payment immediate): Customers → Enter Sales Receipts. Same process as invoices but records payment immediately.
QuickBooks uses average cost accounting for inventory valuation. When you sell an item, QuickBooks calculates the cost using the running average cost of all units of that item currently in stock — not the specific cost of the units being sold.
6. Inventory Adjustments
Physical counts will occasionally reveal discrepancies between your QuickBooks inventory and your actual stock. Adjust these using:
Vendors → Inventory Activities → Adjust Quantity/Value on Hand
In the adjustment window: enter the Adjustment Date, select your Inventory Adjustment Account (typically a shrinkage or loss account in COGS), and for each item enter the new quantity (not the adjustment amount — QuickBooks calculates the difference). QuickBooks records the value of the adjustment to your chosen account.
Best practice: perform a complete physical inventory count at least once per year (ideally twice), and make adjustments immediately after the count to keep your books accurate.
7. Inventory Assemblies (Premier and Enterprise Only)
If you manufacture or assemble finished products from component parts, Premier and Enterprise’s Inventory Assembly feature tracks the full build process:
Create the assembly item
Go to Lists → Item List → New → Inventory Assembly. Name the finished product.
Add component items
In the Bill of Materials section, list every component item that goes into the assembly, with quantities per finished unit.
Enter a build transaction
When you assemble products, go to Vendors → Inventory Activities → Build Assemblies. Enter the quantity you’re building. QuickBooks automatically decreases the component quantities and increases the finished goods quantity.
The assembly feature calculates the cost of the finished product based on the average costs of all components, keeping your COGS accurate for manufactured goods.
8. Inventory Reports and Valuation
QuickBooks Desktop provides a comprehensive set of inventory reports under Reports → Inventory:
| Report | What It Shows | Best Used For |
|---|---|---|
| Inventory Valuation Summary | Current quantity and value of each item at average cost | Month-end closing, balance sheet verification |
| Inventory Valuation Detail | Every transaction that affected each item’s value | Investigating cost discrepancies |
| Inventory Stock Status by Item | Quantity on hand, on order, and reorder point | Daily stock management |
| Sales by Item Summary | Revenue and quantity sold per item | Best-seller analysis, pricing review |
| Purchases by Item Summary | Total purchases per item | Vendor spend analysis |
| Pending Builds | Assemblies initiated but not completed | Work-in-progress tracking (Premier/Enterprise) |
| Physical Inventory Worksheet | Blank list for counting — print and take to warehouse | Physical inventory counts |
9. Inventory Limits and What to Do When You Hit Them
QuickBooks Desktop Pro and Premier have a practical limit of approximately 14,500 combined list items (customers + vendors + items + employees). For product-heavy businesses, this can become a constraint. Signs you’re approaching the limit: QuickBooks slows down significantly, list searches become slow, and you receive a warning when adding new items.
Your options when approaching the limit:
- Merge or make inactive old items: Items you no longer sell can be made inactive — they won’t count against the active list but historical transactions are preserved
- Archive old customers: Customers with no activity in several years can be made inactive
- Upgrade to Enterprise: Enterprise supports 1,000,000+ list items, removing this constraint permanently. ParagonSoftwares offers Enterprise 2024 from $449 as a perpetual license.
Frequently Asked Questions
Need QuickBooks Desktop for Your Product Business?
Full inventory management included with every license — Pro from $199, Premier from $299. No subscription, no recurring fees.