QBO Inventory: How QuickBooks Online Tracks Stock, Costs, and Reorders 2026 June

If you sell physical products, QBO inventory is one of the most powerful and most misunderstood features inside QuickBooks Online. The inventory engine does far more than count units on a shelf. It tracks quantity on hand, calculates cost of goods sold on a first-in, first-out basis, posts to your asset and expense accounts automatically, and feeds the profitability reports you rely on at month-end. For anyone studying for the ProAdvisor exam or running a real product business, understanding how QBO inventory behaves is essential to keeping books accurate.

The first thing to know is that inventory tracking is only available in QuickBooks Online Plus and Advanced. The Simple Start and Essentials tiers cannot track quantity on hand at all, which surprises many new subscribers who assumed every plan included stock management. If you are evaluating whether to upgrade, you can explore the feature hands-on through qbo inventory resources before committing budget to a higher subscription tier that you may or may not actually need for your operation.

Once enabled in Account and Settings under the Sales tab, QBO unlocks a new item type called Inventory. This is distinct from Non-inventory and Service items, and the difference matters enormously. An inventory item carries a quantity, a reorder point, an asset account, an income account, and an expense account. When you buy and sell it, QuickBooks moves dollars between these accounts behind the scenes, which is exactly what trips up bookkeepers who never learned the underlying accounting principles involved.

Consider a simple example. You buy 100 widgets at $4 each, spending $400. QBO debits Inventory Asset for $400 and credits Accounts Payable or your bank. Nothing has hit your profit and loss yet because you still own all the inventory. When you later sell 30 widgets, QBO debits Cost of Goods Sold for $120 and credits Inventory Asset for the same amount, recognizing the expense only as units actually leave the building. This matching is the heart of accrual inventory accounting.

QuickBooks Online uses FIFO, or first-in, first-out, as its only costing method. There is no option for LIFO or weighted average in the standard product. FIFO assumes the oldest units you purchased are the first ones sold, so when prices rise over time, your reported cost of goods sold stays lower and your ending inventory value stays higher. This can meaningfully change taxable income, and it is a detail every accountant should explain to clients before they assume QBO matches their old desktop system.

Throughout this guide we will walk through enabling inventory, creating items, recording purchases and sales, running the reports that reveal your true margins, and avoiding the common mistakes that produce negative quantities and broken cost layers. Whether you are a small business owner trying to understand why your books look strange or a ProAdvisor candidate preparing for certification, the goal is the same: confident, accurate, defensible inventory numbers that hold up at year end and survive an accountant's careful review.

The accounting behind QBO inventory becomes much clearer once you understand FIFO costing in detail. First-in, first-out means QuickBooks treats your oldest purchases as the first units sold. Each time you buy stock at a new price, QBO creates a distinct cost layer with a date and a per-unit cost. When you record a sale, the software peels units off the oldest layer first, then moves to the next, ensuring cost of goods sold reflects the actual chronological flow of your purchasing activity.

Here is a worked example. In January you buy 50 units at $10 each. In March prices rise and you buy another 50 units at $14 each. Your inventory asset now holds $1,200 across two layers. In April you sell 60 units. FIFO consumes all 50 of the January units at $10 ($500) and 10 of the March units at $14 ($140), producing $640 of cost of goods sold. Your remaining 40 units are valued at $14, leaving $560 in inventory asset.

This layering matters because it directly shapes your gross margin. If you mistakenly assumed an average cost of $12 per unit, you would expect $720 of COGS on those 60 units. FIFO instead reports $640, an $80 difference that flows straight to net income. Across hundreds of transactions, the gap between what FIFO actually calculates and what an owner guesses can distort a profit and loss statement by thousands of dollars in either direction over a year.

Because QuickBooks Online offers no setting to switch costing methods, businesses migrating from desktop or another platform that used average cost or LIFO must understand their numbers will shift. There is no workaround inside the standard product. If a client absolutely requires average costing for inventory-heavy operations, the practical answer is usually a dedicated inventory app that syncs with QBO, such as one of the third-party tools available on the QuickBooks App Store, rather than forcing the native engine.

FIFO also interacts with returns and adjustments in ways worth knowing. When a customer returns a unit, QBO adds it back to inventory at the cost it originally left, not the current market price. When you write off damaged stock through an inventory quantity adjustment, the software pulls from existing layers and posts the loss to an adjustment account you select. Getting these mechanics right keeps your inventory asset balance reconciled to the physical reality on your shelves.

For ProAdvisor candidates, expect exam questions that test whether you know FIFO is the only method, how cost layers are consumed, and which accounts move on a purchase versus a sale. For business owners, the takeaway is simpler but just as important: trust the COGS number QuickBooks produces, because it is doing precise layer math you would struggle to replicate by hand. You can pressure-test that understanding with qbo inventory practice scenarios before you rely on the reports for tax filing.

Reports are where QBO inventory proves its value, turning thousands of small transactions into decisions you can act on. The Inventory Valuation Summary is the report you will open most often. It lists every inventory item with its current quantity on hand, its average cost, and its total asset value. The grand total at the bottom should tie exactly to your Inventory Asset account on the balance sheet, and reconciling those two numbers monthly is one of the most important habits a bookkeeper can build.

When the valuation report and the balance sheet disagree, something is wrong, and finding the cause is a core ProAdvisor skill. The usual culprits are journal entries posted directly to the Inventory Asset account, bills coded to an expense account instead of an item, or negative quantities that broke the cost math. QuickBooks even offers a built-in diagnostic, since direct journal entries to inventory bypass the quantity engine entirely and silently push the two figures apart over time.

The Inventory Valuation Detail report drills one level deeper, showing every transaction that touched a given item along with its running quantity and value. This is your audit trail. If a product's cost looks wrong, open the detail report and walk through the purchases and sales chronologically. You will see each FIFO layer being added and consumed, which makes it far easier to spot the one transaction that introduced the error you are currently chasing through the books.

For purchasing decisions, the Stock Status reports and the low-stock view on the dashboard tell you what to reorder. The Products and Services list itself can be sorted by quantity on hand, letting you scan for items below their reorder point at a glance. Pairing this with sales velocity from the Sales by Product/Service Summary report helps you avoid both stockouts on fast movers and dead capital tied up in products that barely sell at all.

Profitability is the report category owners care about most. The Sales by Product/Service Summary shows revenue, cost, and gross margin for each item, revealing which products actually make money once true FIFO cost is subtracted. Many businesses discover that a popular, high-revenue product carries a thin margin while a quieter item is quietly their most profitable line. Without inventory tracking feeding real COGS into these reports, that valuable insight is simply invisible to the owner.

Finally, remember that inventory reports are only as good as the data entry behind them. A pristine valuation report built on bills miscoded to expense accounts is worthless. Before trusting any inventory figure for tax or financing purposes, spend a few minutes confirming that purchases hit items, sales reduced quantities, and adjustments were documented. Clean inputs produce reports you can hand to a lender, an accountant, or the IRS with genuine confidence in their accuracy.

Even experienced users stumble on a handful of recurring QBO inventory mistakes, and recognizing them early saves hours of cleanup. The most common is selling into negative quantity. QuickBooks lets you invoice an item you have not yet recorded buying, but it cannot assign a real FIFO cost to units it never saw arrive. The sale posts with zero or estimated cost, inflating your margin until the missing purchase is entered, at which point QBO retroactively rewrites the cost and your historical reports shift unexpectedly.

A second frequent error is using the wrong item type. Non-inventory and Inventory items look almost identical when you create them, but only Inventory items track quantity and FIFO cost. Choosing Non-inventory because it seemed simpler means QuickBooks never builds cost layers, so your cost of goods sold and inventory asset never update. Many cleanup engagements begin with discovering that an entire product catalog was set up as Non-inventory by mistake, requiring careful conversion and historical correction.

Coding purchases to an expense account instead of to the inventory item is the third classic problem. When you buy stock and code the bill to a generic Supplies or Cost of Goods Sold expense line, QuickBooks expenses the full purchase immediately and never increases quantity on hand. Your profit and loss looks lumpy, your inventory asset stays flat, and the valuation report no longer reflects what is physically in your warehouse. Always select the item, not an account, when receiving new stock.

Direct journal entries to the Inventory Asset account, mentioned in the alert above, deserve repeating because they are so damaging and so common among accountants migrating habits from other systems. A journal entry can move the dollar balance but never touches the quantity engine, so the two figures drift apart silently. Once they diverge, every future FIFO calculation is built on a broken foundation, and untangling it can require recreating transactions one by one.

Skipping physical counts is a quieter but equally serious mistake. Books drift from reality through shrinkage, breakage, and miscounts, and only a real count and a documented adjustment bring them back in line. Businesses that never count are often shocked at year end to find their on-paper inventory worth thousands more than what actually sits on the shelves, which can mean overpaying tax on phantom assets they no longer actually own.

Finally, many owners ignore reorder points and reporting entirely, treating inventory as a number they glance at rather than a system they manage. The fix is routine: reconcile the valuation report to the balance sheet monthly, review stock status before purchasing, and check product margins quarterly. If you want a low-stakes way to internalize these workflows before applying them to live client books, working through qbo inventory practice questions builds the muscle memory that prevents these errors in the first place.

With the mechanics and the pitfalls covered, here is the practical playbook for keeping QBO inventory clean over the long run. Start every engagement or new setup by confirming the subscription tier, because no amount of expertise overcomes a Simple Start plan that lacks the feature entirely. Once you are on Plus or Advanced, enable tracking, verify the Inventory Asset and Cost of Goods Sold accounts exist, and resist the temptation to rush opening balances. The starting layer you create on day one anchors every FIFO calculation that follows it.

Build a consistent purchasing routine. Whether you use purchase orders or enter bills directly, always code to the inventory item and double-check that the received quantity matches the supplier's packing slip before saving. A two-minute habit of comparing the bill to the physical delivery prevents the quantity drift that creates negative inventory weeks later. If you receive partial shipments, record only what actually arrived, and leave the remaining units open on the purchase order for later.

On the sales side, train everyone who creates invoices to select items rather than typing free-form amounts. This single discipline preserves the link between revenue and cost that makes your margin reports trustworthy. If your team works across multiple channels, such as a point-of-sale system or an e-commerce platform, confirm the integration maps each product to the correct QBO inventory item so quantities sync instead of silently diverging across separate systems.

Schedule a monthly reconciliation between the Inventory Valuation Summary and the Inventory Asset balance on the balance sheet. Put it on the calendar the same way you reconcile bank accounts. When the two numbers match, you have strong evidence your inventory accounting is sound. When they do not, investigate immediately while the offending transaction is recent and easy to find, rather than waiting until year end when months of activity obscure the underlying cause.

Plan physical counts at a cadence that fits your business: quarterly for most, monthly for high-shrinkage or high-value goods. After each count, record an inventory quantity adjustment to a clearly named shrinkage or COGS account, and keep notes explaining significant variances. Over time these notes reveal patterns, such as a particular SKU that consistently goes missing, that point you toward process or security fixes rather than just accepting the loss as a cost of doing business.

For ProAdvisor candidates, weave practice into your routine rather than cramming. Inventory questions on the certification exam reward people who have actually clicked through item setup, recorded a purchase and a sale, and read a valuation report. Spend time in a test company, make deliberate mistakes, and watch how the accounts respond. The combination of hands-on reps and targeted practice questions builds the durable understanding that lets you both pass the exam and confidently manage real client inventory afterward.