Age each part from its last movement, apply a rate set by policy to each bucket, roll the reserve forward, and release it only when the part is sold or scrapped.
Obsolescence and excess quantities are signs that inventory cost may not be recovered. For a population of thousands of slow-moving parts, preparers usually measure the loss with a reserve: the parts are aged, each age bucket gets a rate set by policy and supported by a back-test, and the reserve is rolled forward from one close to the next. In the worked case, service parts with a gross cost of $1,350,000 carry a reserve of $232,500 at the end of 2026.
Worked in full in The Inventory Accounting Handbook by Julian R. Sterling.Get the DRM-free PDF, $19.99 →or the paperback
Free: the inventory valuation and reserve model in Excel, with FIFO, weighted average and LIFO side by side, the LIFO reserve, a net realizable value test and an aging reserve, all checked.
1. Age from the last movement: the latest receipt, issue or sale of the part number, not the purchase date of the oldest unit.
2. Rates set by policy: proposed by the controller from a back-test of what was actually scrapped or sold below cost, approved above the preparer, dated and filed.
3. Provision by difference: closing reserve from the aging, minus opening reserve, plus parts scrapped against the reserve in the year.
4. No release on recovery: a reserved part keeps its reduced cost; the reserve comes off only when the part is sold or scrapped.
A fictional tool manufacturer keeps service parts for repairs and sells them to dealers, on FIFO. Its policy ages them in four buckets.
| Months since last movement | Gross cost | Rate | Reserve |
|---|---|---|---|
| 0 to 12 months | $840,000 | 0 percent | $0 |
| 13 to 24 months | $270,000 | 25 percent | $67,500 |
| 25 to 36 months | $150,000 | 50 percent | $75,000 |
| over 36 months | $90,000 | 100 percent | $90,000 |
| Total | $1,350,000 | $232,500 |
Net of the reserve, the parts are carried at $1,117,500. The reserve is an estimate built bucket by bucket, so each rate needs evidence; the aging alone proves only that the arithmetic was done.
| Line | $ |
|---|---|
| Opening reserve, 31 December 2025 | $180,000 |
| Provision charged to cost of sales | $107,500 |
| Parts scrapped against the reserve | ($55,000) |
| Closing reserve, 31 December 2026 | $232,500 |
The provision is not typed: it is what makes the opening reserve, less what was used, equal to the closing reserve from the aging. Every use must match a scrap ticket or a sale; a release posted without one is an exception to chase.
For the effect of an understated reserve on EBITDA and on a purchase price, see how much an obsolescence shortfall cuts EBITDA and the price. For a discontinued finished product, the measure is the net realizable value test.
Rules read on 18 November 2026, paraphrased, not quoted. The company is the fictional case of the book; its figures are teaching assumptions, not market data. Not accounting, tax or legal advice.
Not under US GAAP. The reserve reduced the cost basis of the parts; it comes off only when the parts are sold or scrapped. IAS 2 instead reverses a write-down when net realizable value increases.
Not the preparer who applies them. The rates are an accounting estimate: the controller proposes them from a back-test and operations input, and a more senior officer approves them.
It is usually part of cost of sales. What matters for the reader is the disclosure of the estimate when a change in the near term is reasonably possible and would be material.
This article is one calculation from The Inventory Accounting Handbook, a practitioner’s guide to inventory under ASC 330 with IAS 2 side by side: capitalizable costs and normal capacity, standard cost variances, FIFO, average cost and LIFO, net realizable value, excess and obsolete reserves, counts and cut-off, on one company followed for two years.
DRM-free PDF, $19.99 · Paperback, shipped worldwide · Free Excel model