How do I track inventory costs in QuickBooks Online?
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.
Long Beach's Trusted Bookkeeping Partner
The Next Step:
A Quick Discovery Call
Tell us where things stand with your books. We'll listen, ask a few questions, and give you a clear quote to get it handled.
More Questions
How often should a small business reconcile its books?
At minimum, reconcile monthly. But weekly is better for most small businesses because it keeps errors small, makes bank feeds easier to review, and gives you financial information you can actually act on.
Read answerHow do I stop running out of cash at the end of every month?
Cash shortages at month-end usually come from a timing mismatch between income and expenses or a lack of visibility into your numbers. Tightening your invoicing, reviewing books weekly, and building a small buffer can turn monthly cash crunches into something you plan around.
Read answerCan my bookkeeper work directly with my tax preparer?
Yes, and they should. A good bookkeeper will coordinate directly with your tax preparer so financials are accurate, the year-end handoff is smooth, and you don't have to play middleman between the two.
Read answerShould I let QuickBooks automatically categorize my transactions?
Auto-categorization in QuickBooks saves time but makes frequent mistakes. Use it as a starting point, not a final answer. Every transaction should still be reviewed before it hits your books.
Read answerWhat business licenses does a Long Beach small business need to track?
At minimum, you'll need a Long Beach business license and likely a California seller's permit if you sell goods. Beyond that, industry-specific permits and state licenses vary, and tracking renewal dates and costs in your books keeps you from missing deadlines.
Read answerHow should a business with both products and services handle cost of goods sold?
Separate them. Create distinct COGS accounts for your product costs and your service costs so your profit and loss statement shows accurate gross margins for each revenue stream.
Read answer
