QuickBooks can handle inventory tracking, but the setup determines whether it actually works. Done right, you get accurate cost of goods sold and real-time stock levels. Done poorly, your reports are wrong and you spend hours fixing discrepancies.

First, enable inventory tracking in your settings. In QuickBooks Online, go to Settings, then Sales, and turn on inventory tracking. In QuickBooks Desktop, this lives under Preferences and then Items & Inventory. Until you flip this switch, QuickBooks treats everything as a direct expense instead of tracking quantities on hand.

Create each product as an inventory item with accurate information. You need the item name, SKU if you use them, sales price, and most importantly the cost. QuickBooks uses either FIFO (first in, first out) in Online or average cost in Desktop to calculate your cost of goods sold. If you enter the wrong starting cost or quantity, every report after that point is wrong.

When you receive inventory, record it through a purchase order or bill that references the inventory item. This increases your quantity on hand and your asset value. When you sell, record the sale against that inventory item. QuickBooks automatically reduces quantity and moves the cost from your asset account to cost of goods sold. The automation only works if you use the correct items on every transaction.

Physical counts matter more than most people realize. QuickBooks tracks what should be there based on recorded transactions. Reality is different. Product gets damaged, lost, or miscounted. Run inventory adjustment transactions at least quarterly to match your books to what’s actually on the shelves. Many businesses do this monthly. The longer you wait between counts, the harder it is to figure out what went wrong.

Not every business needs full inventory tracking. If you buy materials for specific jobs and use them immediately, tracking as expenses or cost of goods sold without quantity management might be simpler. Retail shops and e-commerce businesses with products sitting on shelves benefit most from inventory tracking. Service businesses that buy supplies as needed usually don’t.

The problems show up when processes break down. Someone creates a sale without using the inventory item. Someone receives product without recording it. Someone does a physical count and enters the adjustment wrong. Your inventory accounting only stays accurate when everyone follows the same process every time.

QuickBooks also struggles with complex inventory situations. If you have multiple warehouses, lot tracking requirements, or products with serial numbers, the built-in inventory features may not be enough. Third-party apps like Fishbowl or inFlow can extend QuickBooks for more advanced needs, though they add cost and complexity.

For bookkeeping services in MetroWest, we often see businesses that enabled inventory tracking years ago but stopped maintaining it. The numbers in QuickBooks don’t match reality, cost of goods sold is wrong, and the balance sheet shows inventory that doesn’t exist. Fixing this requires a full physical count and adjustment to reset the baseline, then building processes to keep it accurate going forward.

Start simple. Enable tracking, set up your items correctly, record purchases and sales against those items, and do regular counts. If you’re not willing to maintain it consistently, you’re better off not using inventory tracking at all than having numbers you can’t trust.