Inventory can look healthy in an ERP report while its financial value is quietly becoming less recoverable. Slow-moving components, discontinued product lines, damaged goods, excess purchases, and rising completion or selling costs can all create pressure on inventory valuation. If the review happens only after the year-end count—or relies on a single aging report—the controller may discover the issue too late to investigate it properly.
A robust inventory valuation process combines operational signals with accounting judgement, clear ownership, and evidence. This guide gives US and Canadian financial controllers a practical approach to identifying risk, estimating write-downs, and documenting the close. Apply the requirements of the entity’s reporting framework and approved accounting policy; US GAAP, IFRS, and Canadian ASPE should not be treated as interchangeable.
1. Start with the applicable accounting framework
For IFRS reporters, 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 costs of completion and the costs necessary to make the sale. IAS 2 also addresses what inventory cost includes and the cost formulas used to assign costs.
For US GAAP reporters, inventory guidance is in Topic 330 of the FASB Accounting Standards Codification, the authoritative source of nongovernmental US GAAP. Measurement can depend on the inventory method and the applicable provisions, so do not simply copy an IFRS NRV calculation into a US GAAP workpaper. Canadian private enterprises should assess the applicable Canadian accounting standards, including Section 3031, Inventories, where relevant, and the entity’s accounting policies.
The first control is therefore a documented framework decision: identify the reporting basis, the inventory classes in scope, the measurement policy, and who approves technical accounting conclusions. For groups with multiple reporting bases, maintain a clear bridge between local books and consolidation adjustments.
2. Build a complete population before reviewing risk
An aging report is useful, but it is not a complete inventory valuation control by itself. A slow-moving item may still be fully recoverable, while a recently received item may already be obsolete because a product design changed. Combine quantitative data with business knowledge.
At minimum, reconcile the inventory subledger to the general ledger and identify the population by SKU or item, location, quantity, cost, lot or batch where applicable, and last movement or demand date. Include inventory held at third-party locations and goods in transit when they belong in the reporting population. Investigate negative quantities, duplicate item records, unusual unit costs, and items with missing or stale master data.
Then add operational indicators: forecast demand, recent sales, open customer orders, product lifecycle status, quality holds, engineering change notices, returns, shelf-life limits, and planned product discontinuations. Assign data owners and document when each extract was taken so reviewers know which period and population they are assessing.
3. Use risk-based indicators, not a single age threshold
Days since last movement can help prioritize review, but it should not determine a write-down automatically. Spare parts for long-lived equipment may move infrequently and still be needed; fast-moving seasonal products can lose value quickly after the selling window closes.
Useful risk flags include:
- Slow or no movement: no consumption or sales for a defined period, adjusted for product lifecycle and normal demand patterns.
- Excess quantity: on-hand stock plus open purchase orders materially exceeds credible demand or approved safety-stock policy.
- Declining selling prices: market prices, customer pricing, or expected discounts no longer support the carrying cost.
- Damage or quality concerns: goods on hold, returned, expired, or requiring rework.
- Product changes: discontinued models, superseded components, or engineering changes that limit future use.
- Cost pressure: higher costs to complete or sell, or production variances suggesting that recorded cost may not be recoverable.
Set review thresholds based on materiality, business characteristics, and risk appetite. Thresholds should identify items for investigation—not replace a reasoned valuation conclusion.
4. Estimate recoverable value and retain the assumptions
For each material flagged item or appropriate group of similar items, document the carrying cost, expected disposition, and supporting evidence for the estimated recovery. Depending on the facts, evidence may include recent sales, current customer orders, approved price lists, subsequent sales, market quotations, expected completion costs, disposal costs, or a supported plan to use the inventory in production.
Under IAS 2, the NRV estimate reflects the estimated selling price in the ordinary course of business less estimated costs of completion and the costs necessary to make the sale. The IFRS Interpretations Committee has explained that the assessment of costs necessary to make the sale requires judgement based on the facts and circumstances; it should not automatically be restricted to incremental costs only. See the official June 2021 IFRIC Update.
A useful workpaper separates the calculation from the judgement. Show the data source, assumptions, calculation, preparer, reviewer, and conclusion. If management expects to sell an item below cost, document the expected price and the relevant selling or completion costs. If it expects to consume the item in production, explain how the finished product economics support recoverability under the applicable framework.
5. Make the ERP and spreadsheet controls traceable
In SAP S/4HANA or another ERP, inventory valuation depends on master data, quantities, costing, movements, and reporting extracts. The exact setup varies by implementation, so validate the configuration and reports in the company’s environment rather than relying on generic system assumptions.
- Restrict changes to material master data, valuation settings, and inventory status to authorized roles.
- Reconcile quantities and values between inventory reports, subledger records, and the general ledger.
- Keep evidence of the report parameters, extraction date, filters, and population totals.
- Investigate stale standard costs, unusual negative stock, blocked inventory, and large manual adjustments.
- Control any spreadsheet used to calculate write-downs: lock formulas, protect source data, track versions, and independently review material assumptions.
- Ensure the person who prepares the estimate is not the sole approver of a material adjustment, or document a compensating review where staffing limits segregation of duties.
When an adjustment is posted, link the journal entry to the supporting item-level analysis. Record whether the change is a write-down, reversal of a prior write-down, reclassification, or another type of adjustment, consistent with the applicable accounting policy.
6. Connect the estimate to operational owners
Finance should not determine obsolescence in isolation. Procurement understands supplier commitments and cancellation options; sales understands customer demand and discounting; operations understands product changes, rework, and scrap; and engineering may know that a component is no longer compatible with the current design.
Establish a recurring review with clear accountability. Finance owns the accounting conclusion and reporting control. Operational owners validate the underlying facts and provide evidence. Disagreements should be escalated, especially when a forecast assumes sales or production that are not supported by approved plans.
Track exceptions to closure. A statement such as “the business expects to sell it” is not sufficient evidence on its own. Ask what demand supports the expectation, when the sale is expected, at what price, and whether completion or selling costs have been included where required.
7. Controller’s inventory valuation checklist
- Confirm the reporting framework, inventory policy, and relevant measurement requirements.
- Reconcile the inventory population to the general ledger and explain differences.
- Validate item-level quantities, costs, locations, and report extraction parameters.
- Identify slow-moving, excess, damaged, expired, discontinued, and price-sensitive items.
- Obtain sales, demand, product-lifecycle, and operations evidence for material exceptions.
- Document the recovery estimate and relevant completion or selling costs under the applicable framework.
- Review calculations, assumptions, subsequent sales evidence, and management overrides independently.
- Post supported adjustments with traceable references to the workpaper.
- Assign owners and due dates to unresolved items, and report material exposure to finance leadership.
- Retain the final reconciliation, exception log, approval, and evidence of resolution.
Conclusion
Effective inventory valuation is not just an accounting calculation at period-end. It is a cross-functional control that connects reliable ERP data, operational knowledge, supportable recovery estimates, and independent review. A repeatable process helps controllers identify risk earlier, reduce surprise adjustments, and explain inventory balances with evidence rather than optimism.
Informational only: this article is not accounting, audit, tax, or legal advice. Confirm the current requirements of the applicable reporting framework and your organisation’s approved accounting policies before recording an adjustment.
