QuickBooks Online Moving Average Cost: How Inventory Valuation Is Calculated
QuickBooks Online users can choose Moving Average Cost for inventory. Here's how starting value and new purchases update the average and COGS.
QuickBooks Online users who sell homogeneous, interchangeable products are asking how Moving Average Cost (MAC) is applied when they record beginning inventory and later purchases. The confusion usually shows up in two places: entering a starting value for an inventory item, and understanding why the reported cost per unit shifts after every purchase. The accepted answer in the community walks through both, and the mechanics are worth laying out plainly.
The Issue
Many QuickBooks Online customers set up inventory items expecting the cost per unit to stay fixed once entered. Instead, they see the average cost change after each purchase, and the Cost of Goods Sold (COGS) on their reports does not match what they calculated by hand. The root cause is that QuickBooks Online uses a moving average cost model, not a first-in, first-out model, for inventory valuation. Under MAC, every new purchase at a different price recalculates the average cost of all units on hand.
How Moving Average Cost Works
The system tracks total inventory cost and total units. After each purchase, it divides the combined cost by the combined units to get a new per-unit average. That new average is then used for the next sale until another purchase changes it again.
For example, start with 10 units valued at $2,000. The average cost is $200 per unit. Buy 15 more units at $210 each, adding $3,150 to inventory. The new totals are 25 units and $5,150, producing an average cost of $206 per unit. Sell 8 units at that point, and COGS is 8 times $206, or $1,648. Remaining inventory is 17 units at $3,502, still $206 per unit.
Buy 12 units at $205 each after that, and the totals become 29 units and $5,962. The average drops to $205.59 after rounding. Selling 10 units then records COGS of $2,055.90, leaving 19 units valued at $3,906.10, or $205.58 per unit after rounding. Small rounding differences are normal because QuickBooks Online carries more decimal places than the two shown on screen.
Setting the Starting Value
A common stumbling block is the starting value screen. In QuickBooks Online, go to the All apps area, then Sales & Get Paid, and open Products & services. From the Action column, select Edit on the item, choose Starting value, and confirm with Got it. Enter the correct quantity and cost, then save. QuickBooks Online uses those numbers as the opening inventory balance for the item and begins calculating the moving average from there.
If the starting values are wrong, the entire COGS calculation chain is wrong, because every later average is built on that first number. This is why the community answer emphasizes entering the correct quantity and total cost rather than just a per-unit price. For users adopting an existing inventory count mid-year, that step is the foundation for everything afterward.
When Moving Average Cost Makes Sense
The accepted answer lists several situations where MAC is the better fit. It works well for sales of undifferentiated products such as sand, grain, liquids, or mass-produced goods where individual units are not unique. It also helps when purchase prices fluctuate, because it smooths out the highs and lows instead of letting a single invoice spike COGS.
Companies that do not need to trace the exact physical flow of units, and that prefer a financial statement position between FIFO and LIFO during rising prices, commonly choose MAC. It also pairs naturally with a perpetual inventory system, since the average is recomputed after every transaction. For those selling unique items, batch-tracked products, or anything where unit-level cost identity matters, MAC can feel misleading, and that is when users often search for help.
What This Means for Your Reports
The key takeaway is that QuickBooks Online is not mis-calculating COGS. It is applying the moving average method consistently. Users who expected FIFO-style results will see different numbers, and the difference grows when purchase prices move significantly. Reviewing the average cost after each purchase, and checking the total cost and unit count on the starting value screen, will explain most discrepancies. For broader guidance on working with inventory in QuickBooks Online, see our QuickBooks Online help and general inventory discussions.