Articles

How do you calculate an excess and obsolete inventory reserve?

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.

The method in four rules

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.

Example: service parts at the end of 2026

A fictional tool manufacturer keeps service parts for repairs and sells them to dealers, on FIFO. Its policy ages them in four buckets.

Aging and reserve, 31 December 2026.
Months since last movementGross costRateReserve
0 to 12 months$840,0000 percent$0
13 to 24 months$270,00025 percent$67,500
25 to 36 months$150,00050 percent$75,000
over 36 months$90,000100 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.

The roll-forward

Reserve roll-forward, 2026.
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.

Checks before the reserve is signed

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.

Sources

  1. Deloitte DART, ASC 330-10, Inventory: overall
  2. IFRS Foundation, IAS 2 Inventories

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.

Questions readers ask

Can the reserve be released if demand for a part comes back?

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.

Who should set the reserve rates?

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.

Is the provision a separate line in the income statement?

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.

Read the whole book

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.

Also on this site