Inventory Valuation Methods: FIFO, Moving Average and How Inventory Costing Works

Inventory quantity tells a business how many units it has.

Inventory valuation answers a different question:

How much are those units worth?

The distinction matters because the same physical inventory can produce different ending inventory values and different cost of goods sold depending on the costing method applied.

That affects inventory reporting, gross profit, margin analysis, purchasing decisions and the accounting evidence that connects warehouse activity to finance.

Common inventory valuation approaches include FIFO, moving average cost, periodic weighted average and specific identification.

They do not all treat inventory cost in the same way.

This guide explains how the main methods work, compares FIFO and moving average using the same transaction history, and shows why an ERP system needs more than a quantity balance to produce reliable inventory valuation.

What is inventory valuation?

Inventory valuation is the process of assigning a monetary value to inventory held by a business.

A warehouse may know that 100 units of an item are physically available, but that quantity alone does not explain the financial value of the stock.

If the same item was purchased at different prices, the business needs a consistent costing method to determine:

• the value of inventory still on hand
• the value of inventory consumed or sold
• the cost transferred to cost of goods sold or another destination
• the financial effect of receipts, issues, returns and adjustments

Inventory valuation therefore sits between physical inventory movement and financial reporting.

A reliable system must preserve both.

Why inventory valuation matters

Inventory valuation affects several important business measures.

It influences:

• ending inventory on the balance sheet
• cost of goods sold
• gross profit
• product margin analysis
• inventory write-offs
• stock adjustments
• month-end reconciliation
• purchasing and replenishment analysis

Two businesses can hold exactly the same physical quantity of an item but report different inventory values if their permitted costing methods and cost histories differ.

The method therefore needs to be applied consistently and supported by traceable transaction evidence.

The main inventory valuation methods

Four approaches appear most often in inventory accounting and ERP configuration.

These methods answer the same basic question — what cost should be assigned to inventory movement and ending stock — but they preserve and consume cost history differently.

FIFO inventory valuation

FIFO means First In, First Out.

Under FIFO costing, the oldest available inventory cost is normally consumed first for valuation purposes.

This does not necessarily mean that every physical warehouse movement must literally pick the oldest individual unit.

The important accounting concept is the cost-flow assumption.

For example, 10 units are available at €10.

Another 10 units are received at €15.

The inventory now contains:

• 10 units × €10 = €100
• 10 units × €15 = €150

Total: 20 units, €250.

If 12 units are issued under FIFO, the issue consumes:

The remaining inventory consists of:

8 units × €15 = €120

The oldest €10 layer is exhausted first, and the remaining stock is carried at the newer €15 cost.

Cost layers are the mechanism that makes this possible. Our detailed FIFO method guide covers layer creation, partial consumption across several layers and the cost-ledger evidence behind the calculation in more depth.

Moving Average Cost

Moving Average Cost takes a different approach.

Instead of preserving each receipt cost as a separate layer for later consumption, the system maintains a current average unit cost.

Using the same inventory:

• Opening inventory: 10 units × €10 = €100
• Receipt: 10 units × €15 = €150
• Total: 20 units, €250

The new moving average is:

If 12 units are then issued:

12 × €12.50 = €150

Remaining inventory:

8 × €12.50 = €100

The issue normally uses the current moving average and does not itself recalculate that average.

A later valued receipt at a different cost can change it again.

Our Moving Average Cost guide follows one item through six receipts and issues to show exactly when the average changes and when it stays the same.

FIFO vs Moving Average: the same inventory, different result

Both methods above started from an identical transaction history and issued the same 12 units.

FIFO leaves the newer, higher-cost €15 units in stock in this example.

Moving Average spreads the combined €250 cost across all 20 units before the issue.

Because purchase prices increased from €10 to €15, FIFO produces lower issue cost and higher ending inventory in this example.

Moving Average produces a smoother blended result.

If purchase prices were falling instead, the relationship could reverse. Neither method is universally better than the other.

How inventory valuation affects COGS

When inventory is sold, consumed in production or otherwise transferred out of stock, its cost normally needs to move somewhere.

For merchandise sold, that destination is commonly cost of goods sold.

For the debits and credits behind that movement, from receipt and freight to invoice, COGS and the later stock corrections, see the inventory journal entries guide.

For manufacturing, inventory value may move through raw materials, work in process and finished goods before eventually reaching cost of goods sold.

The valuation method determines which cost is assigned to that movement.

In the comparison above:

• FIFO issue value = €130
• Moving Average issue value = €150

That €20 difference also creates a corresponding €20 difference in ending inventory:

• FIFO ending inventory = €120
• Moving Average ending inventory = €100

The total value remains €250.

The timing of cost recognition changes.

How inventory valuation affects gross profit

If both businesses sell the same goods at the same sales price, different COGS can temporarily produce different gross profit.

For example, assume the 12 issued units are sold for €20 each. Revenue is 12 × €20 = €240 in both cases.

This does not mean one method has created additional economic value.

The difference comes from when historical inventory cost is recognized in COGS versus retained in ending inventory.

Over time, subsequent inventory consumption continues to move those costs through the accounting records.

Periodic Weighted Average

Moving Average and Periodic Weighted Average are related concepts, but their timing is different.

Moving Average is normally associated with a perpetual inventory environment where the average can be recalculated after relevant valued receipts.

Periodic Weighted Average calculates one average for a defined period.

Conceptually:

That period average is then used to value the units issued or sold and the inventory remaining at the end of the period.

The difference is therefore not merely the formula.

It is also when the calculation is performed.

That timing distinction mirrors the broader difference between perpetual and periodic inventory systems.

Specific Identification

Specific Identification follows the actual cost of an individually identifiable inventory item or unit.

This approach may be appropriate where inventory items are distinct and their individual cost can be reliably identified.

Examples can include certain:

• vehicles
• high-value equipment
• unique machinery
• individually serialized products
• project-specific assets held for sale

Under this approach, a business does not need to assume that the oldest or average cost was consumed if the exact item and its cost are known.

The method requires strong item-level traceability.

It is not automatically appropriate for every serialized item. Accounting framework and business circumstances matter.

What about LIFO?

LIFO means Last In, First Out.

Under LIFO, newer inventory costs are assumed to be consumed before older costs.

However, LIFO requires special care in an international article because its acceptability depends on the accounting framework.

Because Gruvero serves an international audience, this guide focuses mainly on FIFO and weighted-average approaches.

Perpetual vs periodic inventory costing

Inventory valuation method and inventory recordkeeping method are related, but they are not the same concept.

A perpetual inventory system updates inventory records as transactions occur.

A periodic system determines inventory quantities and valuation using period-end procedures.

Moving Average is normally associated with ongoing recalculation in a perpetual system.

Periodic Weighted Average calculates an average for a defined period.

FIFO can also be implemented within different inventory-recording environments, although system mechanics and timing differ.

What happens when purchase prices rise?

The example in this guide uses rising prices: inventory was purchased first at €10 and then at €15.

When purchase prices are rising:

• FIFO can leave newer, higher-cost inventory in ending stock while older, lower-cost layers are consumed first.
• Moving Average blends the older and newer costs.

In the example:

• FIFO ending inventory = €120
• Moving Average ending inventory = €100
• FIFO COGS = €130
• Moving Average COGS = €150

What happens when purchase prices fall?

If newer inventory enters at a lower price than older inventory, FIFO may consume older higher-cost layers first while Moving Average blends the newer lower cost into the current average.

The direction of the difference can therefore reverse.

The costing method should not be selected simply because one short-term price environment produces a more attractive accounting result.

Consistency, accounting requirements, business model and reliable system support matter.

Goods receipts are a key costing event

Inventory costing depends heavily on reliable receipt data.

A valued goods receipt can establish:

• quantity received
• unit cost
• total inventory value
• cost-layer information
• a new moving average
• source-document references

The exact effect depends on the valuation method and system configuration.

Incorrect receipt quantities or costs can therefore affect later inventory issues, stock valuation and accounting reconciliation.

Our guide to goods receipt accounting explains how a valued receipt affects inventory quantity, value and accounting before a supplier invoice is even posted.

Returns and inventory adjustments

Inventory valuation becomes more complex when the transaction history contains:

• supplier returns
• customer returns
• inventory adjustments
• damaged stock
• write-offs
• reversals
• retroactive price changes

The correct cost treatment depends on why inventory is moving and which original transaction the movement relates to.

A return linked to an original receipt may need different costing treatment from an unexplained positive inventory adjustment.

The important ERP control is that valuation consequences remain traceable to the underlying business event. Our guide to inventory adjustments explains why valued corrections should stay tied to a documented reason rather than an unexplained balance change.

Zero inventory and cost resets

Zero inventory can be an important boundary condition in average costing.

When both inventory quantity and inventory value reach zero, the next valued receipt will normally establish a new cost basis.

The exact system behavior depends on ERP configuration and accounting rules.

Why negative inventory makes costing difficult

Negative inventory creates a control problem because the system may be asked to value an issue before the receipt that economically supports it has been recorded.

Depending on system design, later receipts may require:

• revaluation
• retroactive correction
• cost variance treatment
• recalculation

Different ERP systems handle negative inventory differently.

Backdated transactions and retroactive cost changes

Later freight or customs evidence can introduce additional acquisition cost. Our landed cost guide explains eligibility, allocation and why late costs need controlled treatment.

A transaction entered today with an earlier effective date can change the historical sequence used for costing.

Examples include:

• late goods receipts
• backdated supplier invoices
• corrected receipt values
• missed inventory movements
• retroactive landed cost

Whether earlier issues are revalued depends on the costing engine and ERP configuration.

This is one reason inventory valuation requires controlled transaction chronology rather than a spreadsheet containing only the final quantity and value.

Inventory valuation in ERP systems

An ERP costing engine needs more than a formula.

It needs reliable transaction evidence.

A controlled inventory valuation process should be able to answer:

• What transaction created this quantity?
• What cost was assigned to it?
• Which valuation method was applicable?
• What cost was used when inventory left stock?
• Which transaction changed the average or cost layer?
• Can finance trace the valuation back to the source document?
• Can corrections be made without destroying the original history?

Inventory costing should therefore connect:

A controlled ERP design should preserve every link in that chain. When a link is missing, the valuation number may still be mathematically correct while remaining impossible to explain.

Our guide to inventory reconciliation explains how to investigate a difference between system and physical stock before deciding how inventory value should be corrected.

Common inventory valuation mistakes

1. Treating quantity and value as the same problem. A stock count can be correct while inventory valuation is wrong.
2. Changing purchase cost without preserving history. Historical inventory should not silently adopt a new purchase price unless the costing method specifically requires that result.
3. Allowing issues without reliable valuation evidence. A quantity movement needs an explainable financial cost where valuation is required.
4. Treating Moving Average as Periodic Weighted Average. The formulas are related, but calculation timing is different.
5. Ignoring negative inventory. Negative stock can create downstream valuation corrections.
6. Using manual journal entries to hide operational errors. Accounting adjustments should not replace investigation of the warehouse or procurement transaction that caused the problem.
7. Losing source-document traceability. Finance should be able to explain how a material inventory value originated.

Inventory valuation method comparison

Which inventory valuation method should a business use?

There is no universally correct method for every business.

The choice can depend on:

• applicable accounting standards
• inventory characteristics
• transaction volume
• price volatility
• traceability requirements
• ERP capability
• reporting requirements
• consistency with established accounting policy

The method should be selected as part of the organization's accounting and inventory-control design rather than as an isolated software preference.

For accounting-policy decisions, businesses should apply the requirements of their applicable accounting framework and professional accounting advice.

Summary

Inventory valuation determines how the cost of inventory is allocated between stock that remains on hand and stock that has been consumed or sold.

• FIFO preserves historical cost layers and normally consumes the oldest available layer first.
• Moving Average blends existing and newly received inventory value into a current average.
• Periodic Weighted Average performs a related calculation at period level.
• Specific Identification follows the cost of individually identifiable inventory.

Using the same transaction history can therefore produce different COGS and ending inventory values even though total inventory value before consumption is identical.

The accounting method matters.

But the ERP control behind the method matters just as much.

Reliable inventory valuation requires traceable receipts, controlled issues, clear cost evidence and a transaction history that finance can reconcile back to the underlying business event.

Test your understanding

FAQ

What are the main inventory valuation methods?

Common approaches include FIFO, weighted-average methods and specific identification. The appropriate method depends on inventory characteristics, the applicable accounting framework and the organization's accounting policy.

What is the difference between FIFO and Moving Average?

FIFO normally assigns older available inventory costs to issues first, while Moving Average uses a blended current average cost. When purchase prices change, the methods can therefore produce different COGS and ending inventory values.

Does inventory valuation change physical inventory quantity?

No. Inventory valuation determines monetary cost, while inventory quantity represents the physical units on hand. The two records are connected but are not the same measure.

Does Moving Average change after every inventory issue?

Normally, an inventory issue consumes stock using the current moving average without changing the average itself. Relevant valued receipts can recalculate the average. Exact behavior depends on the ERP and costing configuration.

Is weighted average the same as Moving Average?

Not always. Moving Average normally recalculates cost during a perpetual transaction flow, while Periodic Weighted Average calculates one average for a defined period.

Which method produces the highest profit?

There is no universal answer. The result depends on purchase-cost history, transaction timing and quantities. Accounting methods should not be selected simply to maximize a short-term profit result.

Is LIFO allowed?

LIFO is not permitted under IFRS. It may be used under U.S. GAAP when the applicable requirements are met. Businesses should apply the requirements of their accounting framework and established accounting policy.

Why is inventory valuation difficult in ERP systems?

The calculation itself may be straightforward, but real transaction histories contain partial receipts, returns, adjustments, negative inventory, backdated entries and price changes. The system must preserve both the calculation and the source-document evidence behind it.

Conclusion

Inventory costing is not simply a formula attached to an item master.

It is the financial interpretation of a sequence of real inventory transactions.

FIFO, Moving Average, Periodic Weighted Average and Specific Identification can assign cost differently, but each method still depends on reliable quantities, reliable transaction timing and reliable source data.

The strongest inventory-control environment is therefore one in which warehouse and finance can answer the same question:

Where did this inventory value come from?

When the answer can be traced from the financial balance back through the inventory movement to the original business document, valuation becomes much more than a period-end calculation.

It becomes part of the transaction audit trail.