Moving Average Cost

How the moving average cost is calculated

The basic formula is simple: the new average price is the total value of the stock after a receipt divided by the total quantity after the receipt. Formally: (value of existing stock + value of receipt) ÷ (quantity of existing stock + quantity of receipt). The value of the existing stock is quantity × previous average price, and the value of the receipt is the received quantity × actual cost price of the new delivery.

The timing of the recalculation is decisive: the price is updated exclusively on receipts. Goods issues – sales, consumption, transfers – reduce the quantity but do not change the valid average price. They are posted out at the current average price. Only the next goods receipt with a differing purchase price shifts the value again.

Why the moving average cost matters

The stock value is a central figure: it feeds into the balance sheet, determines the level of current assets and is the basis for calculating cost of goods sold, contribution margin and cost estimation. A method that realistically updates this value with every delivery ensures current and traceable figures – without having to laboriously settle individual price layers at the end of the period.

Especially with volatile purchase prices, averaging smooths out short-term outliers. If the procurement price rises, this only affects the stock value proportionally, rather than hitting immediately at full force. For trade and manufacturing this provides a stable basis for price calculation, because the cost of goods sold does not jump abruptly with every purchase.

At the same time, the method is audit-friendly: because every receipt and every price calculation is logged in the system, an item's value development can be traced without gaps – an advantage during stocktaking and audits.

Moving average cost in the ERP system

In ERP and inventory management systems, the moving average cost is usually configured as a valuation method per item or valuation area. On every posted goods receipt, the system automatically calculates the new average price and updates it in the item master; every goods issue is valued at this figure and generates the appropriate posting records for cost of goods sold. The inventory valuation thus runs permanently and without manual rework.

The prerequisite for correct values is clean data maintenance: receipt quantities, cost prices and incidental costs must be posted promptly and correctly. Subsequent invoice corrections, returns or incorrectly recorded quantities can distort the average. Many systems therefore offer correction and revaluation runs to clean up the value retroactively.

Distinction: moving average cost vs. FIFO and periodic average

FIFO ("first in, first out") assumes that the goods stored first are consumed first, and values issues at the prices of the oldest layers. The moving average cost dispenses with this layer logic and instead maintains a single blended value. In times of rising prices, FIFO tends to show a higher closing stock, whereas the average shows a mid-range value.

The moving method differs from the periodic average price (average at the end of the period across all receipts) in its timing: the moving average is continuously reformed after every receipt and is therefore up to date at all times, while the periodic one is only fixed at the reporting date. LIFO ("last in, first out"), finally, values issues at the most recent prices and is only permitted to a limited extent under German commercial law.

Which method fits depends on the industry and the objective. Those who need stable, easily calculable cost-of-goods-sold values and work with frequently fluctuating purchase prices are often better off with the moving average cost. Those who, on the other hand, want to strictly reflect physical consumption sequences for perishable goods or batches will rather reach for FIFO. In practice, average-cost valuation is the standard case in many ERP installations because of its simplicity and permanent up-to-dateness.

DACH specifics and valuation law

German commercial law (HGB § 240 (4) and § 256) expressly permits the valuation of similar inventories at a weighted average – the moving average cost is thus a legally recognised method under commercial law. The lowest-value principle must additionally be observed: if the value to be attributed on the reporting date is below the average price, a write-down to the lower value is required.

In Austria and Switzerland, comparable principles apply; average-cost valuation is also customary and permitted there. Important for all DACH countries is consistency: a valuation method once chosen should be retained so that stock values remain comparable over the years. A change of method requires justification and documentation.