Skip links

Home / Articles / Excess and Obsolete Inventory

Manufacturing Inventory Finance

Excess and Obsolete Inventory: How Manufacturers Reserve and Write Down Stock at Year End

Dead and slow-moving stock does more than take up space. Here is how to find it, value it at the lower of cost and net realizable value, book the reserve, and stop it from building up again.

Axolt Editorial Team • 14 min read • Manufacturing Costing

What Counts as Excess, Obsolete, and Slow-Moving Inventory

Every manufacturer carries some stock that is not moving the way the plan expected. The terms are often used together, as E&O, but they describe different problems, and they lead to different accounting.

  • Excess inventory is usable stock held in quantities beyond what you expect to use or sell in a reasonable period, often measured in months of supply.
  • Obsolete inventory has no expected use or sale at its normal price: a discontinued product, a component replaced by an engineering change, or material past its shelf life.
  • Slow-moving inventory still sells or is still consumed, just more slowly than planned. It is a warning sign, not a loss in itself.

The distinction matters because the accounting does not ask whether stock is moving. It asks whether you will recover its cost. Slow-moving items that still sell above cost need no write-down. Obsolete items usually need a large one.

Why the E&O Review Belongs in the Year-End Close

Inventory is often one of the largest assets on a manufacturer's balance sheet, and E&O stock is the part of it most likely to be overstated. Leaving it unreviewed overstates both inventory and the year's profit.

  • It is a valuation requirement. Under IAS 2, and under ASC 330 for inventory measured using FIFO or average cost, inventory is carried at the lower of cost and net realizable value. Stock that will not recover its cost has to be written down.
  • Auditors will test it. Inventory valuation is a common area of audit focus, and auditors will ask how the reserve was calculated and what evidence supports it.
  • The physical count feeds it. Damaged, expired, and obsolete stock tagged during the year-end physical inventory is the starting point for the review.

Done at year end, the review also resets the baseline for the following year. Stock that is reserved now will not distort next year's margins when it is finally sold or scrapped.

How to Find E&O Stock

A good E&O review combines system data with the knowledge of the people who plan, buy, and sell the products. Work through it in this order:

  1. Run an aging and usage reportFor every item, compare quantity on hand with usage or sales over the last 12 months and with forecast demand. Calculate months of supply and the date of the last receipt, issue, and sale.
  2. Flag items above your thresholdsTypical triggers are no movement in 12 months, more than 24 months of supply, or stock of an item marked as discontinued. Set thresholds by product family, because a fastener and a finished machine age differently.
  3. Add what the count foundBring in items tagged as damaged, expired, or obsolete during the physical inventory or cycle counts.
  4. Check engineering changes and product plansComponents superseded by an engineering change order, and products scheduled for discontinuation, often have no future use even if they moved recently.
  5. Review expiry and shelf lifeFor lot-controlled materials, compare remaining shelf life with expected usage. Stock that will expire before it is consumed is effectively obsolete.
  6. Ask sales, planning, and engineeringReview the flagged list with the people who know whether a customer order, a substitute use, or a rework option is realistic.
  7. Document the decision for each itemRecord the evidence, the estimated recoverable value, and who approved it. This is what your auditor will ask to see.

The Valuation Rule: Lower of Cost and Net Realizable Value

Net realizable value (NRV) is the estimated selling price in the ordinary course of business, less the reasonably predictable costs of completion, disposal, and transportation. If NRV is below cost, the difference is a write-down.

Under US GAAP, inventory measured using LIFO or the retail inventory method still follows the older lower of cost or market test. For most manufacturers using standard cost, FIFO, or average cost, the test is cost against NRV, usually item by item or for groups of similar items. The question is what evidence shows that an item will not recover its cost.

Evidence That Supports a Write-Down

  • No sales or usage in 12 months or more, and no orders in the pipeline
  • Product discontinued or replaced by a new model
  • Component superseded by an engineering change, with no other use
  • Material that will expire before it can be used
  • Damage or deterioration found in the count
  • Selling prices that have fallen below cost plus selling costs

Not a Write-Down on Its Own

  • Slow sales of an item that still sells above cost
  • A large purchase made to secure a volume discount
  • Seasonal stock built ahead of peak demand
  • Safety stock held under a documented policy
  • Stock allocated to a confirmed customer order
  • An aging report with no review behind it

The test is about recovery, not speed. Aging thresholds are useful for finding items to review, but the write-down itself should rest on evidence about what the stock will realistically sell for or be used in.

Reserve or Direct Write-Off?

There are two ways to record the loss. A direct write-off reduces the inventory balance of specific items immediately, which suits stock you are about to scrap. An inventory reserve, also called an allowance or provision, records the loss in a contra-inventory account while the stock stays on hand until it is sold, reworked, or scrapped.

Most manufacturers use a reserve for the year-end review, because the stock is still physically there and disposal decisions take time. The reserve keeps item quantities and costs intact in the inventory records, while the balance sheet shows the reduced value. How it behaves afterward depends on your accounting framework:

  • US GAAP: a write-down creates a new cost basis. It is not reversed because the outlook improves; the reserve is released only when the stock is sold, scrapped, or otherwise disposed of.
  • IFRS: IAS 2 requires a write-down to be reversed, up to the original amount, when the circumstances that caused it no longer exist, for example when selling prices recover.
  • Tax: tax rules for inventory reserves often differ from the book treatment, so confirm the treatment with your tax adviser.

A Worked Example: $510,000 Flagged, $262,000 Reserved

A manufacturer of industrial equipment carries $6.2 million of inventory at year end. Its aging report, count findings, and engineering change log flag five groups of items, with a combined carrying cost of $510,000. Each group is reviewed for what it can realistically recover.

Item group Carrying cost What the review found Recoverable value Reserve
Discontinued finished goods $120,000 Replaced by a new model. Best liquidator offer is $24,000, less $6,000 of freight and handling. $18,000 $102,000
Components superseded by an ECO $64,000 No other use and no scrap value. $0 $64,000
Excess resin, 30 months of supply $210,000 18 months of shelf life left, so 12 months of supply will expire before it can be used. $126,000 $84,000
Damaged finished goods from the count $20,000 Can be sold as seconds for $10,000 after $2,000 of rework. $8,000 $12,000
Slow-moving spare parts $96,000 Sales down 40%, but still sold above cost. $96,000 $0
Total flagged $510,000 — $248,000 $262,000

Recoverable value is net realizable value: the expected selling price, less the costs to complete, sell, and ship. The 18 months of resin that will be used in production is valued at cost, because it will be consumed at full value.

What the Example Shows

An aging report alone would have treated all $510,000 the same way. A flat 50% reserve on the flagged list would have produced $255,000, close to the right total for the wrong reasons: too little for the obsolete components and discontinued products, and a reserve on spare parts that are still profitable.

The item-by-item review also tells the business what to fix. The resin points to a purchasing decision, the superseded components to an engineering change that did not plan for existing stock, and the discontinued products to a phase-out that started too late.

Slow-moving is a warning, not a write-down. Reserve what the evidence says will not recover its cost.

Booking the Reserve and Releasing It

Inventory write-downs are usually recorded in cost of goods sold, so they reduce gross margin in the year the loss is recognized. The reserve then follows the stock until it leaves the business.

Event Debit Credit P&L impact
Record the year-end reserve Cost of goods sold Inventory reserve Expense of $262,000
Scrap the reserved components Inventory reserve Inventory None, already expensed
Sell reserved stock: release its reserve Inventory reserve Cost of goods sold Offsets the cost of the sale
Write off stock with no reserve Cost of goods sold Inventory Expense when booked
Reverse a write-down (IFRS only) Inventory reserve Cost of goods sold Income, up to the original write-down

The reserve is calculated on carrying cost, whatever costing method you use. Under standard costing that is the item's standard cost, adjusted for any capitalized variances. Under FIFO or weighted average it is the recorded cost. Our guide to inventory valuation methods for manufacturers explains how each method sets carrying cost.

Keep the calculation at item level, even if the reserve is booked as one journal entry. When an item is sold or scrapped, you need to know exactly how much reserve to release against it, and your auditor will want to trace the total back to the items. Reviewing the reserve in every month-end close, not only at year end, keeps the year-end adjustment small and expected.

What to Do with E&O Stock

A reserve fixes the balance sheet. It does not free up warehouse space or recover cash. Once the reserve is booked, work through the options for each group:

  • Use it. Find substitute uses in other products, or rework it to a current revision.
  • Sell it. Offer it to existing customers at a discount, sell it as spares or seconds, or sell it to a liquidator.
  • Return it. Ask suppliers about returns for credit, even with a restocking fee.
  • Scrap it. Scrap what has no other use, and record the disposal so the stock and its reserve leave the books together.

Obsolete stock has a carrying cost of its own: warehouse space, insurance, handling, and the time spent counting it every year. Holding it in the hope of a future sale is usually more expensive than it looks.

Preventing E&O from Building Up

Most E&O stock is created by decisions made months or years before the write-down. The year-end review is the right moment to trace those decisions:

  • Buying more than you use. Minimum order quantities and volume discounts look cheaper per unit, but not if part of the order expires or becomes obsolete.
  • Engineering changes without a stock plan. Decide how existing stock will be used up before an engineering change takes effect, not after. Our article on BOM and ECO control covers this in more detail.
  • Late product phase-outs. Stop buying components for a product as soon as its end-of-life date is set, and build only to confirmed demand.
  • Outdated planning parameters. Reorder points, safety stock, and lead times set years ago keep buying for demand that has moved on.
  • Inaccurate stock records. If the system shows less than is really on the shelf, planning buys more. Inventory accuracy is part of E&O prevention.

Common E&O Mistakes

  • Reserving by age alone. Aging finds candidates; it does not prove a loss. Slow stock that still sells above cost does not need a write-down.
  • Waiting until year end. A full year of E&O reviewed at once produces a large, surprising charge. Review it every quarter, or every month.
  • Booking a top-down number. A reserve that cannot be traced to items is hard to release correctly and hard to defend in an audit.
  • Forgetting work in process. Open work orders for discontinued products can hold obsolete material and labor too.
  • Releasing the reserve too early. Under US GAAP, the reserve stays until the stock is sold or scrapped, even if the outlook improves.
  • Reserving and forgetting. Fully reserved stock still takes up space and still gets counted every year. Dispose of it.

A Year-End E&O Review Timeline

Adjust the timing to your size and close calendar. The sequence matters more than the exact dates.

  1. Six weeks before year endAgree thresholds, the reserve method, and review owners with finance, planning, and your auditor.
  2. Four weeks beforeRun the aging and usage report, and pull the engineering change and discontinued-product lists.
  3. Three weeks beforeReview the flagged list with sales, planning, and engineering, and record a decision for each item.
  4. Count dayTag damaged, expired, and obsolete items found during the physical inventory, and add them to the list.
  5. First week after year endEstimate recoverable values, calculate the reserve by item, and get it approved.
  6. CloseBook the reserve, reconcile it to the item-level calculation, and file the support for the audit.
  7. First quarterStart disposals, release the reserve as stock leaves, and fix the purchasing and planning causes.

How an ERP Should Support the E&O Review

The hardest part of an E&O review is rarely the accounting. It is getting reliable data on what is on hand, how it has moved, and what it is still needed for. An ERP should make that data available without a spreadsheet project:

  • Usage, sales, and last-movement dates are available by item, location, and lot
  • Lot and expiry data shows which material will expire before it can be used
  • Stock adjustments and count variances are approved before stock levels change
  • Every stock movement posts to finance, so inventory value and the reserve stay aligned
  • Reorder rules reflect current demand, so the system does not keep buying excess

Axolt runs inventory, warehouse, production, and finance on one data model inside Salesforce. Stock is tracked by batch, lot, or serial number, with expiry dates captured at receipt, and inventory KPIs can be built in native Salesforce reports and dashboards. Stock adjustments and count variances are reviewed and approved in Salesforce, and every stock movement posts financial entries in real time, so the inventory value finance reviews is the one the warehouse recorded. Automated reorder triggers help keep purchasing in line with current demand.

Frequently Asked Questions

What is excess and obsolete inventory?

Excess inventory is usable stock held beyond expected demand for a reasonable period. Obsolete inventory has no expected use or sale at its normal price, for example a discontinued product or a superseded component. Together they are often called E&O.

How do you calculate an inventory reserve?

Compare each item's carrying cost with its net realizable value: the expected selling price, less the costs to complete, sell, and ship it. The reserve is the shortfall. Aging and months-of-supply thresholds help find items to review, but the reserve should be based on evidence about what each item can recover.

Where is an inventory write-down recorded?

Usually in cost of goods sold, with the credit going to a contra-inventory reserve account or directly to inventory. Significant write-downs may also need to be disclosed separately in the financial statements.

Can an inventory write-down be reversed?

Under IFRS, yes: IAS 2 requires a reversal, limited to the original write-down, when the circumstances that caused it no longer exist. Under US GAAP, no: the write-down creates a new cost basis, and the reserve is released only when the stock is sold or disposed of.

How often should excess and obsolete inventory be reviewed?

At least at every year end, and preferably every quarter or month. Regular reviews keep the reserve current, recognize losses in the periods they occur, and make the year-end adjustment much smaller.

The Bottom Line

Excess and obsolete inventory is a valuation question: will this stock recover its cost? Answer it item by item, with evidence, and book the shortfall as a reserve before the year is closed.

Then use the review to fix the causes. Every reserved item points to a buying, planning, or engineering decision, and fixing those is what keeps next year's reserve smaller.

See E&O Before It Becomes a Write-Down

Axolt connects inventory, warehouse, production, and finance on Salesforce, so stock movements, lot and expiry data, and inventory value come from the same records your teams use every day.

Book a Demo