QuickBooks Online Values Inventory With FIFO, and You Cannot Switch
QuickBooks Online applies FIFO to stock items, the Mac desktop edition uses a moving average, and the method cannot be changed after purchases exist.
A familiar question keeps surfacing wherever QuickBooks Online users track stock: does the software average its inventory costs, and can the method be changed once the books are underway? The answer on both counts is no. The online product costs every stock sale with FIFO, and it offers no switch to an average.
The method follows the product, not a setting
Across the products users most often compare, inventory costing splits down two paths, and mixing them up is where the trouble starts. QuickBooks Online applies first in, first out, known as FIFO, to every inventory item it tracks. The Mac desktop edition instead works out a moving average as purchases arrive. Neither product exposes a preference you can flip.
Some retellings of this get the direction backwards, which only deepens the confusion. It is the desktop side, not the web app, that works from an average. Assume otherwise and you will misread your margins every time a supplier changes prices.
The symptoms are easy to spot once you know the cause. Margins drift even though selling prices hold steady. The cost booked on a sale fails to match the last price you paid. Stock on the balance sheet looks stale after a price rise. All of it is FIFO behaving normally, not a fault in your file.
When prices rise, FIFO pulls older, cheaper units into cost of goods sold first, so reported profit runs higher than an average would show. When prices fall, the effect reverses. That single difference is why the method question matters well beyond tidy bookkeeping.
How does a sale get valued under FIFO?
A generic example shows the mechanics. Suppose you buy 20 widgets at $6 each. They sit on the books as an asset worth $120, and your widget cost of goods sold sits at zero because nothing has sold yet.
Demand picks up, so you order 30 more, but your supplier now charges $7 each. The new layer adds $210 of asset value. Your stock now holds two layers: 20 units at $6 and 30 units at $7, worth $330 in total.
One customer then buys 15 widgets. FIFO draws those units from the oldest layer, so each one is costed at $6. The asset drops by $90 and cost of goods sold rises by $90. Five $6 units remain, alongside the untouched 30 at $7.
A second sale of 20 widgets drains the last five $6 units first, then takes 15 from the $7 layer. That sale carries $135 of cost, split as $30 from the cheap units and $105 from the dearer ones. You are left holding 15 widgets, all valued at $7.
Can you switch methods later?
No. The basis hardens as soon as inventory transactions exist. That lock is deliberate, because a costing swap would restate the cost behind every past sale, and with it every gross margin already reported.
Consistency also matters outside the software. Your costing basis feeds the cost of goods sold that reaches your tax return, so a midstream change would raise questions no report can answer. Expect the two editions to disagree whenever prices move, since each measures cost differently.
Threads on this topic end the same way every time: confirmation that no hidden switch exists, followed by advice to plan around the method instead.
Practical steps before you commit
Decide before your first inventory purchase, not after your first surprise. If average cost is the basis your reporting needs, the Mac desktop edition is the average-cost path in this lineup, and the choice deserves attention before data piles up.
Enter real unit costs on every purchase bill. The cost stored on an item card is only a starting default; FIFO layers are built from what you actually paid, so a careless bill distorts every later sale.
Date sales after the purchases that supply them. A sale recorded ahead of any owning purchase leaves the software nothing to draw cost from, and the odd figures that follow fuel forum threads.
When you want to see your layers, open the inventory valuation detail report. It lists each purchase as its own cost line, which makes FIFO visible instead of abstract.
If the method still feels wrong for your business, raise it with your own accountant rather than hunting for a setting. There is no setting. The costing basis is a property of the product you chose, and the software treats it exactly that way.
The bottom line
We will keep it plain. In QuickBooks Online, FIFO is not a preference you set; it is the ground the inventory module stands on. Pick your edition with that fact in mind, keep your purchase bills honest, and the costing will take care of itself.