Inventory Valuation: 10 Controls for Costing, Obsolescence and NRV Reserves

Inventory can look healthy in a warehouse report while its balance-sheet value is already overstated. Slow-moving stock, product redesigns, customer cancellations, rising completion costs and selling-price markdowns can all erode recoverable value before a physical count reveals a problem. For controllers, inventory valuation is therefore not just a costing exercise: it is a recurring estimate, data-quality and control process.

This guide sets out practical controls for US and Canadian finance teams. It distinguishes the measurement rules under US GAAP, IFRS and Canadian ASPE, then connects those requirements to the operational data and close activities that support a defensible reserve.

1. Start with the applicable accounting framework

Under IFRS, IAS 2 Inventories generally requires inventory to be measured at the lower of cost and net realisable value (NRV). NRV is the estimated selling price in the ordinary course of business less estimated completion costs and costs necessary to make the sale. IAS 2 also addresses which costs form part of inventory and the cost formulas used for interchangeable items.

For Canadian private enterprises, ASPE Section 3031 is substantially aligned with IAS 2: inventory is generally measured at the lower of cost and NRV, with specific identification, FIFO or weighted-average cost formulas as applicable. Scope exceptions exist, so entities should confirm whether a specialized inventory category is governed by another section.

US GAAP under ASC 330 is not identical. Following FASB ASU 2015-11, inventory measured using methods other than LIFO or the retail inventory method is generally measured at the lower of cost and NRV. Inventory measured using LIFO or the retail inventory method remains subject to the lower-of-cost-or-market model, with market constrained by an NRV ceiling and an NRV-less-normal-profit floor. This distinction matters for US groups with LIFO pools or retail operations.

Do not apply a single global reserve formula to every ledger. Maintain a documented accounting-policy matrix by reporting framework, inventory class and legal entity. A group may need different adjustments for the same physical stock under different reporting bases.

2. Build a reliable inventory-cost baseline

A write-down analysis is only as sound as the cost balance being tested. Reconcile inventory subledger quantities and values to the general ledger, investigate negative quantities and unusual unit costs, and confirm that the cost build-up includes only eligible purchase, conversion and other costs that bring inventory to its present location and condition.

Review standard-cost updates, purchase-price variances, production variances, freight, duty, overhead absorption and work-in-process calculations. Abnormal waste, avoidable idle-capacity costs and unrelated administrative or selling costs should not be buried in inventory simply because a system configuration capitalizes them.

For example, if a plant operates materially below normal capacity, the controller should assess whether fixed production overhead has been allocated using an appropriate normal-capacity basis rather than allowing unusually low output to inflate the cost per unit.

3. Identify items that may need a write-down

Use multiple indicators rather than relying on a single aging threshold. Relevant evidence can include:

No movement or low movement over defined periods, adjusted for seasonality and planned demand.
Expiry dates, shelf-life constraints, damage, quality holds or failed inspections.
Engineering changes, discontinued products, superseded components or obsolete packaging.
Open sales orders cancelled by customers or forecast demand materially below available stock.
Recent selling prices below carrying cost, planned markdowns or higher costs to complete and sell.
Excess quantities compared with approved production plans, service-part requirements or contractual commitments.

Aging is a screening tool, not an accounting conclusion. A slow-moving spare part may still be fully recoverable if it supports equipment with a long remaining service life. Conversely, a newly received product can be impaired immediately if it has become unsaleable or its expected selling price has fallen.

4. Calculate NRV using supportable evidence

For each material inventory category, document the expected selling price, remaining completion costs and costs necessary to make the sale. Use evidence available at the reporting date: recent transactions, approved price lists, customer contracts, subsequent sales that corroborate conditions at period-end, and current estimates of rework, packaging or disposal costs.

Consider this simplified example. A finished product has a recorded cost of $120 per unit. The expected selling price is $112, and expected selling and completion costs total $8. NRV is $104, so the potential write-down is $16 per unit under a lower-of-cost-and-NRV model. If 2,000 units are affected, the indicated adjustment is $32,000, subject to the applicable framework and unit or grouping requirements.

Do not substitute a broad market-price feed for entity-specific NRV. NRV reflects the amount the entity expects to realise in its ordinary course of business; fair value less costs to sell is a different measurement concept.

5. Control the level of assessment and aggregation

IAS 2 generally assesses NRV item by item, although grouping similar or related items may be appropriate in limited circumstances. A broad write-down of an entire product line can conceal profitable items and mask impaired stock. Document why any grouping is appropriate and apply it consistently.

For US GAAP, apply the relevant ASC 330 guidance to the inventory cost method in use, including the separate LIFO and retail-method requirements. For ASPE, follow Section 3031 and document any applicable scope exception. The accounting-policy matrix should specify the level of testing, treatment of raw materials and work in process, and approval requirements.

6. Establish ten practical controller controls

Inventory-to-GL reconciliation: Reconcile quantities and values by plant, warehouse, material type and ledger; age and resolve reconciling items.
Movement and aging analytics: Run a monthly exception report for no-movement, slow-moving, excess, expired and blocked stock.
Demand and supply comparison: Compare on-hand and on-order quantities with approved forecasts, production plans, firm orders and service requirements.
Obsolescence evidence: Obtain documented input from sales, operations, procurement, quality and engineering for discontinued or superseded items.
NRV support: Retain recent sales, price lists, customer commitments and cost-to-complete or disposal assumptions for material reserve calculations.
Cost integrity: Review standard-cost changes, overhead absorption, purchase-price variances and abnormal production costs.
Reserve model governance: Version-control formulas, thresholds, source extracts and manual overlays; restrict who can change them.
Journal approval: Require independent review of reserve calculations, account mapping, materiality and postings before the ledger is closed.
Reversal monitoring: Track prior write-downs and reassess recoveries. IFRS and ASPE permit reversals when the relevant conditions improve, limited to the original write-down; US GAAP generally prohibits reversal of inventory write-downs.
Disclosure and audit trail: Reconcile inventory classes, write-down expense, reversals where permitted, and accounting-policy disclosures to the final reporting package.

7. Use SAP S/4HANA data without confusing system valuation with accounting judgment

SAP S/4HANA can provide useful source data for the process. The Material Ledger collects material valuation data and supports multiple currencies and valuations; actual costing is an optional capability that can calculate periodic actual prices and distribute variances through multilevel production structures. SAP documentation also describes inventory closing activities and stock valuation processes in Materials Management.

These capabilities do not automatically determine whether inventory is recoverable under the reporting framework. A controller should map the relevant material, plant, valuation area, price control, stock category and ledger to the reserve analysis. Ensure blocked, quality-inspection, consignment, in-transit and third-party stock are included or excluded based on ownership and policy—not simply because a report omits them.

Reconcile any reserve upload or journal to the approved calculation. Keep a controlled record of the source extract date, selection criteria, transformation logic, excluded records and posting reference. Changes to material master data, valuation classes or account determination should be subject to change control and testing.

8. Month-end inventory reserve checklist

Confirm inventory subledger-to-GL reconciliation and investigate unusual movements.
Refresh aging, expiry, blocked-stock and excess-inventory reports.
Obtain current demand, sales-price, product-lifecycle and engineering-change evidence.
Validate standard costs, overhead absorption and significant production variances.
Calculate NRV or the applicable US GAAP LIFO/retail-method test by appropriate inventory grouping.
Review assumptions and manual overrides with independent approvers.
Post approved adjustments and reconcile the journal to the reserve schedule.
Assess reversals under IFRS or ASPE and prevent reversals where prohibited under US GAAP.
Update disclosures and retain evidence for audit sampling.

Conclusion

A defensible inventory reserve is built from accurate cost data, timely operational indicators, realistic selling-price evidence and a clearly documented accounting framework. Controllers should treat inventory valuation as a cross-functional close control—not a once-a-year spreadsheet exercise. A disciplined monthly process reduces surprise adjustments, improves gross-margin reporting and gives auditors a traceable explanation for the carrying value of stock.

Informational disclaimer: This article is general educational content, not accounting, audit, tax or legal advice. Apply the authoritative literature relevant to the entity, reporting period and facts, and consult qualified advisers where necessary.