Inventory Valuation and Excess and Obsolete Reserves

Executive summary

Inventory sits on the balance sheet at cost. When the company will not sell it at a price above that cost, the carrying value has to come down. The mechanism most operators meet is the excess and obsolete (E&O) reserve: a provision against items the business holds in quantities it will not use or sell within a reasonable period, or that can no longer be sold at a normal price. Doing this well is partly accounting and partly operations. The accounting side asks what the inventory is worth. The operations side asks why you bought more than you can sell, and what to do with it.

Three things go wrong in practice. The reserve is a top-down percentage nobody can tie back to items. It is adjusted late, in one lump at year end, and surprises the P&L, the covenants and the borrowing base. And the causes (forecast error, minimum order quantities, engineering changes, cancellations) are never fixed, so the reserve keeps growing.

This guide shows a method: item-level demand tests, a net realizable value (NRV) check, tiered reserve rules written down as policy, a quarterly roll-forward, and the follow-through to the rest of the business. Accounting treatment follows your accounting policy, your auditors and the standards you report under, such as US GAAP or IFRS. We do not state reserve percentages because the right ones are the ones your policy and auditors support from your own history. Nothing in this article is accounting or audit advice.

The first step is to build the item-level excess report from your ERP, so you can see how much inventory exceeds forecast demand before you talk about a reserve.

When to use this

Use this guide when:

• Inventory has grown faster than sales, or turns have slowed.
• The reserve is a single percentage of the balance, or was set once and never revisited.
• An auditor, lender or buyer has asked for support for the reserve.
• A product line is being discontinued, redesigned or replaced.
• You are preparing a quality of earnings review, a refinancing or a sale.
• Physical counts, cycle counts and the ledger regularly disagree.

If the inventory ledger is unreliable (bad costs, unmatched receipts, uncounted locations), fix the data first. The inventory optimization guide covers the operational side: turns, safety stock and how excess is created.

Diagnostic questions

Answer from the ERP, the policy manual and the last audit file.

1. What inventory costing method is used (for example FIFO, weighted average, standard cost with variances), and has it been applied consistently?
2. Is there a written policy for excess, slow-moving and obsolete inventory? Who approved it and when?
3. Does the policy define a demand horizon (how many months of forecast usage or sales the company is willing to carry) and how is it set?
4. What is the demand basis: historical usage, a forward forecast, open orders, or a mix? How often is it refreshed?
5. How are the quantities above the demand horizon identified, at item level, and who reviews the list?
6. Is there a separate test comparing carrying cost to NRV (expected selling price less costs to complete and sell)? How are selling prices estimated?
7. How does the reserve change from quarter to quarter, and can you produce a roll-forward from the last four period-ends?
8. What happens physically to reserved items: are they scrapped, sold at a discount, returned, reworked or held? Who decides?
9. Do standard costs reflect current purchase prices?
10. Which items carry a purchase commitment, customer-specific content or a minimum order that makes them likely to become excess?
11. Are consigned, third-party and in-transit inventories in the same analysis?
12. Does the lender, the borrowing base or a covenant definition depend on inventory value or on the reserve?

How to read the answers. If question 2 or 3 is "no", you have a judgment without a method. If question 6 is "no", you may be missing items that are selling below cost rather than not selling. If question 12 is "yes", reserve changes need to be shared with Treasury before they hit the ledger, not after.

The framework: valuation, demand tests and reserve tiers

Two separate questions

Most reserve confusion comes from mixing two tests that answer different questions.

An item can pass one test and fail the other. A fast-moving item can be sold below cost after a price war. A slow item can still be worth full cost if there is a firm order for it. Run both and record each result separately.

The measurement basis (for example, lower of cost and NRV, or lower of cost and market for some methods) depends on the standard and the costing method you use. Confirm with your accounting policy and auditors which applies. The mechanics below work either way, but the label and the rules do not.

Five-step reserve logic

1. Quantity. Take on-hand quantity from the perpetual ledger after reconciling to the latest count.
2. Demand. Estimate usage or sales over the horizon in your policy, using forward information (open orders, forecast, bill of materials) before history.
3. Excess. Excess quantity is on-hand minus demand over the horizon, floored at zero. Excess value is excess quantity times unit cost.
4. Tier. Place excess value into tiers by age or by last-movement date, as your policy defines. Each tier has a reserve rate of [policy rate]. Items that are discontinued, obsolete or unsaleable may be fully reserved under your policy.
5. Override with evidence. An item can be moved to a different tier only with a documented reason, such as a signed order, a return agreement, or a quote from a liquidator. The override is logged with name and date.

The reserve is the sum of tiered excess value, plus any NRV write-downs. The rates are inputs from your own policy, set by looking at what you actually recovered when you disposed of similar items in prior periods. Do not import a rate from a benchmark.

Why the reserve moves other numbers

• EBITDA and gross margin. A reserve charge reduces earnings in the period it is booked. A late, large charge distorts the trend. Some lender definitions of EBITDA treat non-cash charges in particular ways. Read yours.
• Covenants. A reserve increase lowers inventory and earnings, which can cut covenant headroom. Test the effect before booking. The covenant headroom calculator can model it.
• Borrowing base. If your credit agreement values eligible inventory net of reserves, a reserve change reduces availability. See revolver borrowing base management.
• Working capital in a deal. A buyer's quality of earnings review tests inventory and reserves.

Step-by-step process

1. Reconcile the data. Tie the perpetual inventory to the general ledger and the latest physical or cycle count. Owner: Controller. Output: reconciled inventory file with quantity, cost and location by item.
2. Pull demand. For each item, extract usage or sales for the trailing periods, open sales orders, open work orders, and forecast. Owner: Supply chain or planning. Output: demand table by item.
3. Compute excess. Apply the horizon in your policy, compute excess quantity and value. Owner: FP&A. Output: excess report sorted by value.
4. Run the NRV test. For items sold below cost, items with falling prices, and items needing rework, compute expected selling price less costs to complete and sell. Owner: Finance with Sales. Output: NRV exceptions list.
5. Review the top of the list. Look at the largest excess items and any with no recent activity. Ask operations why we have it and who will buy it. Owner: Operations lead. Output: disposition notes per item.
6. Apply policy tiers and overrides. Compute the reserve with the tiered rates in the policy. Log each override with evidence. Owner: Controller. Output: reserve schedule.
7. Review with the auditors' lens. Test whether the schedule can be traced from ledger quantities to the reserve, and that the method matches last year's or that the change is documented. Owner: Controller, with the CFO. Output: audit-ready file.
8. Pre-clear the impact. Run the effect on EBITDA, covenants and borrowing base before booking. Owner: CFO with Treasury. Output: impact memo.
9. Book and roll forward. Post the entry. Update the roll-forward of beginning reserve, provision, disposals and ending reserve. Owner: Controller. Output: reconciled roll-forward.
10. Act on the causes. For the top ten excess items, trace the root cause (forecast error, minimum order quantity, engineering change, canceled order) and assign a fix. Owner: Operations with Purchasing. Output: action list with dates.
11. Repeat quarterly. The same method, the same horizon, the same approvers. Owner: Controller. Output: quarterly reserve file.

Worked example

Illustrative. The numbers below are made up to show the method. They are not benchmarks. The 12-month demand horizon is an assumption of the example; your policy sets yours.

Excess by item

Checks: A100 is 4,000 x 12.50 = 50,000. B220 is 1,800 x 40 = 72,000, and 1,800 − 900 = 900 excess units x 40 = 36,000. C310 has no forecast usage, so all 2,500 units x 8 = 20,000 are excess. D440 is 600 x 95 = 57,000. E550 is 3,200 x 22 = 70,400, and 3,200 − 1,200 = 2,000 x 22 = 44,000. Inventory totals 269,400 and excess totals 36,000 + 20,000 + 44,000 = 100,000, which is about 37% of the item set shown.

Months of supply is on-hand divided by annual usage times 12: A100 is 8 months, D440 4.8, B220 24 and E550 32. C310 has no usage, so it is undefined.

From excess to reserve

The reserve is the excess value in each tier multiplied by that tier's [policy rate]. Suppose your policy puts C310 (no movement) in a "no demand" tier and B220 and E550 in an "excess demand" tier. The formula is:

Reserve = (20,000 x [no-demand rate]) + ((36,000 + 44,000) x [excess-demand rate])

Use the rates your policy and auditors support. The point of the schedule is that every dollar of reserve traces to an item and a rule.

NRV check on a different item

Item F660 has 500 units at a cost of $60.00. The company expects to sell them at $52.00, with $5.00 of selling cost per unit.

NRV per unit = 52 − 5 = $47.00. Cost per unit is $60.00, so the write-down per unit is 60 − 47 = $13.00. For 500 units, the write-down is $6,500.

F660 would not show up in an excess test because it sells. Only the NRV test finds it.

Reserve roll-forward

Check: 80,000 + 35,000 − 18,000 = 97,000.

What this tells the operator

• A reserve schedule with item-level support can be audited. A percentage of the balance cannot.
• Over a third of the value in this item set is above the demand horizon. That is an operations finding before it is an accounting one.
• The two largest excess values, E550 and B220, are items to investigate first: why were 3,200 units bought against 1,200 of demand?

Templates

E&O analysis sheet (copy into a spreadsheet)

NRV test

Reserve roll-forward

Policy outline (for your accounting policy manual)

1. Scope: which inventories are covered.
2. Demand basis and horizon, and who sets and reviews it.
3. Tier definitions and the reserve rate for each, with the approval date.
4. NRV test: triggers, price evidence, and review frequency.
5. Overrides: who can approve and what evidence is required.
6. Disposal: authority levels for scrap, discount sale and return.
7. Review cycle and sign-off.

Metrics and KPIs

Setting targets without invented benchmarks. Use three anchors. First, your own disposal history: what you actually recovered on similar items in prior periods supports your tier rates. Second, your own best trailing turns and aged inventory mix. Third, named public peers' filings, where you can read their policies and disclosures. Do not quote a target reserve percentage or an industry turn figure from a general source.

Common mistakes

1. Reserving by percentage of the balance. It cannot be traced to items and does not respond to what is happening in the warehouse.
2. Using history only. Demand that has ended, such as a canceled program or a discontinued product, will not show in trailing usage. Use open orders and the forecast.
3. Ignoring NRV. The excess test misses items that sell below cost.
4. Booking everything at year end. A quarterly roll-forward avoids a shock to earnings and covenants.
5. No disposal discipline. Reserved inventory that stays in the warehouse gets reserved again and clogs space, counts and the borrowing base.
6. Reversing reserves without evidence. Releasing a reserve because the quarter needs help is a policy and audit problem. Reversals need documented sales or usage.
7. Not telling Treasury. A reserve change can reduce borrowing base availability and covenant headroom.
8. Treating E&O as only a finance topic. The causes are buying decisions, forecast quality, minimum order quantities and engineering changes. Fix them or the reserve returns.

AI prompt assistance

AI can help you build the analysis and draft the policy and communications. It does not decide the accounting treatment. Provide your own data and policy, check outputs against the ledger, and ask your auditors about judgment calls.

1. Build the excess report.

I will paste an item table with on-hand quantity, unit cost, trailing 12-month usage, open sales orders and forecast for the next 12 months. Using a demand horizon of [N months], compute demand over the horizon, excess quantity, excess value, and months of supply for each item. Show formulas and flag items with no demand. Do not assume reserve rates.

Check: recompute five items by hand and tie total inventory value to the ledger.

2. Classify root causes of excess.

Here are the top 25 excess items with purchasing notes. Tag each with one cause from this list: forecast error, minimum order quantity, engineering change, canceled or reduced order, supplier lead time, quality hold, other. Return a count by cause and flag notes you could not classify.

Check: confirm tags with purchasing and planning before assigning actions.

3. Draft the policy outline.

Draft a one-page inventory excess and obsolete policy for a manufacturer, with sections for scope, demand horizon, tiers with [policy rate] placeholders, NRV test, overrides, disposal authority and review. Do not propose numeric rates.

Check: have the Controller and auditors review the draft and set the values from your own history.

Implementation guide

Governance: the CFO owns the policy, the Controller owns the schedule, Operations owns disposition and root-cause fixes, Purchasing owns buying rules, and the auditors review the method. Report excess value, reserve coverage and disposal recovery quarterly alongside turns. See the working capital playbook for how inventory sits in the cash cycle.

Do not announce a reserve target before the item-level analysis exists.

Downloadable assets

The E&O analysis sheet, NRV test, roll-forward and policy outline above are designed to be copied into a spreadsheet or document. To test the earnings and covenant effect of a reserve change, use the covenant headroom calculator. To place reserve and disposal cash in the forecast, use the 13-week cash flow builder.

Related resources

• Working capital hub: where inventory sits next to receivables and payables.
• Inventory optimization: turns, safety stock and excess: preventing excess in the first place.
• Working capital playbook: the full program for the cash cycle.
• Cash management hub: liquidity, lenders and forecasting.
• Revolver borrowing base management: how reserves can change availability.
• Covenant compliance headroom tracking: testing the effect of a reserve before booking.

Frequently asked questions

What is an excess and obsolete inventory reserve?

An excess and obsolete reserve is a provision that reduces the carrying value of inventory the company holds in quantities it will not use or sell within its policy horizon, or that can no longer be sold normally. It is built from item-level demand tests and tiered rules in your accounting policy. Your auditors and the standards you report under govern the treatment.

How do you calculate excess inventory?

Excess quantity is on-hand quantity minus expected demand over the horizon in your policy, floored at zero, and excess value is excess quantity times unit cost. Use open orders, the forecast and bills of material before trailing history. Apply the reserve rates your policy sets from your own disposal experience, rather than a generic percentage.

What is the difference between an E&O reserve and a net realizable value write-down?

An E&O reserve addresses quantities you will not use or sell in a reasonable period. A net realizable value test addresses items that can be sold, but for less than their carrying cost after costs to complete and sell. An item can fail one test and pass the other, so run both and record the results separately.

How does an inventory reserve affect covenants and the borrowing base?

A reserve increase reduces earnings and inventory value in the period it is booked, which can reduce covenant headroom and, if your credit agreement values eligible inventory net of reserves, borrowing base availability. Test both before booking and tell Treasury and your lender contact as your agreement requires.

How often should you review the reserve?

Review it at least quarterly, using the same method, the same demand horizon and the same approvers each time, and roll forward the balance from beginning to ending. A single year-end adjustment tends to surprise earnings and covenants. Whether you also perform monthly checks depends on volume, volatility and your auditors' expectations.

How this works in a System of Performance

An E&O reserve is an accounting number, but it is made by decisions about buying, forecasting and disposal that live in different systems and different heads. A Performis routine can take on a recurring job like this, with the scope and fit agreed with you: it works from the records your team supplies, prepares the work for your named reviewer, and keeps each approval on record. To see how much of your inventory sits above demand, bring it to us as a launch partner.