# Excess and Obsolete (E&O) Inventory Reserve Calculator

> Source: https://netray.co/tools/excess-obsolete-inventory-reserve-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Apply reserve percentages to aged inventory buckets and see the total E&O reserve, net inventory and the margin impact of changing the policy.

## Category

cost-finance

## Audience

- Controller
- Cost accountant
- Materials manager

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Inventory with no usage 0 to 6 months

**Key:** b1

**Type:** number

**Default:** 5200000

**Min:** 0

**Step:** 10000

**Unit:** $

**Help:** Cost value of stock with usage inside 6 months.

#### No usage 6 to 12 months

**Key:** b2

**Type:** number

**Default:** 1100000

**Min:** 0

**Step:** 10000

**Unit:** $

#### No usage 12 to 24 months

**Key:** b3

**Type:** number

**Default:** 620000

**Min:** 0

**Step:** 10000

**Unit:** $

#### No usage over 24 months

**Key:** b4

**Type:** number

**Default:** 380000

**Min:** 0

**Step:** 10000

**Unit:** $

#### Reserve % for 0 to 6 months

**Key:** r1

**Type:** number

**Default:** 0

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Reserve % for 6 to 12 months

**Key:** r2

**Type:** number

**Default:** 10

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Reserve % for 12 to 24 months

**Key:** r3

**Type:** number

**Default:** 50

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Reserve % for over 24 months

**Key:** r4

**Type:** slider

**Default:** 100

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Annual revenue

**Key:** revenue

**Type:** number

**Default:** 48000000

**Min:** 0

**Step:** 100000

**Unit:** $

**Help:** Used to express the reserve as a share of sales.

**Outputs:**

#### Total inventory

**Key:** total

**Expr:** b1 + b2 + b3 + b4

**Format:** currency

#### Required E&O reserve

**Key:** reserve

**Expr:** b1 * r1 / 100 + b2 * r2 / 100 + b3 * r3 / 100 + b4 * r4 / 100

**Format:** currency

**Primary:** true

**Description:** Sum of each bucket times its reserve percentage.

#### Net inventory after reserve

**Key:** net

**Expr:** total - reserve

**Format:** currency

#### Reserve as % of inventory

**Key:** reserve_pct

**Expr:** if(gt(total, 0), reserve / total * 100, 0)

**Format:** percent

#### Reserve as % of revenue

**Key:** rev_pct

**Expr:** if(gt(revenue, 0), reserve / revenue * 100, 0)

**Format:** percent

**Primary:** true

**Chart:**

#### Reserve vs reserve % on stock over 24 months

**Type:** line

**X:** r4

**From:** 0

**To:** 100

**Steps:** 20

**Series:**

- reserve

**Disclaimer:** Reserve percentages are a policy and accounting judgement. Confirm the method with your auditors and applicable GAAP or IFRS requirements.

## Content

**Intro:** An E&O reserve is the provision a company books for inventory it does not expect to sell or use at full cost. Most manufacturers use an age-based matrix because it is simple to audit. This calculator applies one and shows what a change in policy does to the balance sheet and P&L.

**Sections:**

#### How to use the calculator

**Body:** Run an inventory aging by last movement or last usage date, and group the cost value into the four buckets. Enter your policy percentages. The default matrix is illustrative, not a recommendation. The chart sweeps the percentage on the oldest bucket, which is usually where the debate with auditors happens.

**Bullets:**

- Age by last demand or last issue, not by receipt date
- Exclude stock with firm future demand or contracts
- Keep service parts on a separate policy if needed

#### The method

**Body:** Reserve = sum over buckets of bucket value x reserve percentage. Net inventory = total - reserve. The increase in reserve from one period to the next is the charge to cost of goods sold. Some companies add a coverage test, comparing on-hand to forecast demand over the next 12 months and reserving any excess; this tool covers the age-matrix method only.

#### Reading the result

**Body:** Compare the reserve to revenue and to the prior quarter. A rising share means the aged buckets are growing faster than sales. Before accepting the charge, review the largest items in the oldest buckets for possible returns, rework, or sale to a broker. Salvage value can reduce a 100 percent reserve to a lower figure if supported.

#### Common mistakes and ERP notes

**Body:** The usual errors are aging by receipt date, double reserving items already written down to standard, and ignoring negative on-hand or inactive bins. In ERPs, the aging report usually needs a last-transaction field per item and warehouse. Check that a transfer between locations is not resetting the age.

**Bullets:**

- Reconcile bucket totals to the inventory ledger
- Document every override with approval
- Review the matrix at least annually

**Cta:** If building the aging takes days of exports, we can show how a read-only ERP agent could list the oldest items with last-usage evidence for your review.

**Faq:**

#### What reserve percentage should I use?

**Answer:** It depends on your industry and product life. Common matrices run from 0 percent for recent stock to 100 percent for stock with no usage in 24 months or more. Set the policy with your auditors and base it on actual historical write-offs.

#### Is an E&O reserve tax deductible?

**Answer:** Not usually until the item is physically scrapped or sold below cost, in many jurisdictions. Rules differ, so confirm with your tax adviser. The book reserve and tax treatment often differ.

#### How is the reserve different from a write-off?

**Answer:** A reserve is a contra-asset estimate that reduces inventory value on the balance sheet while the items remain on hand. A write-off removes the cost of the specific item when it is scrapped or disposed of, usually against the reserve.

#### Should I age by receipt date?

**Answer:** Generally no. Receipt date penalises slow but steady items. Last usage or last demand date better reflects the risk that stock will never be consumed.

## Search terms

excess and obsolete inventory reserve calculator, e&o reserve calculation, inventory obsolescence reserve, slow moving inventory provision, inventory reserve by age, inventory write down calculator, obsolete inventory accounting

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json