Start by turning on inventory tracking in your QBO settings. Go to Settings, then Sales, and enable the option to track quantity and price/rate. Once this is on, you can create products as inventory-type items instead of just non-inventory or service items. For each inventory item, enter the product name, SKU if you have one, the cost you pay, and the price you sell it for. QBO will create a corresponding inventory asset account on your balance sheet automatically.

When you purchase inventory, record it through a bill or expense tied to the vendor. Select the inventory item so QBO knows to increase your quantity on hand and add the cost to your inventory asset. If you use purchase orders, create those first and then convert them to bills when the product arrives. This keeps your committed purchases visible and your received inventory accurate.

QBO uses the weighted average cost method. It takes the total cost of all units you have on hand and divides by the quantity to get an average cost per unit. When you sell an item on an invoice or sales receipt, QBO automatically moves that average cost from your inventory asset account to cost of goods sold. You don’t have to calculate COGS manually. This works well for most small businesses, but if your costs fluctuate significantly between purchases, be aware that the average can smooth out those differences in ways that don’t perfectly reflect what you actually paid for a specific batch.

Run inventory adjustments when physical counts don’t match what QBO shows. Shrinkage, damage, and miscounts happen. Go to the inventory adjustment screen, enter the actual quantity on hand, and QBO will book the difference. Do physical counts regularly, whether that’s monthly, quarterly, or weekly depending on your volume. Waiting until year-end to count means you’ve been making decisions based on numbers that may have drifted from reality months ago.

Use the Inventory Valuation Summary and Inventory Valuation Detail reports to see what you have on hand and what it’s worth. These reports show quantity, average cost, and total asset value by item. Review them alongside your sales data to understand which products move quickly and which are sitting on shelves tying up cash.

One important limitation to know is that QBO does not support FIFO or LIFO costing. If your business or your accountant needs those methods for tax or reporting purposes, you’ll need to track costs outside of QBO or use an inventory accounting add-on that handles it. For businesses with a large number of SKUs or complex inventory needs like kitting, bundling, or multiple warehouse locations, tools like SOS Inventory or Dear Inventory integrate with QBO and fill those gaps.

The biggest mistakes people make with inventory in QBO are inconsistency and shortcuts. Entering purchases as general expenses instead of inventory items means your COGS is wrong and your balance sheet understates your assets. Skipping physical counts means your reports show quantities that don’t exist. Not recording damaged or returned goods means your margins look different from what’s actually happening.

If setting all of this up feels like a lot, working with a QuickBooks ProAdvisor in Long Beach can save you time and prevent errors that compound over months. Getting the chart of accounts, item list, and workflows configured correctly from the start means the data you pull from QBO is actually reliable enough to make business decisions with.