Inventory Obsolescence Reserve Calculator

Where do these reserve percentages come from?

The tiers used here (2%, 15%, 50%, 90%) are common industry starting points for general merchandise, reflecting that inventory idle 0-6 months is probably fine while inventory idle over 24 months usually recovers only pennies on the dollar in liquidation. Refine these percentages using your own historical recovery data from actual liquidation, clearance, or write-off events — categories differ a lot, and electronics or fashion should skew more aggressive than durable industrial parts.

How often should this reserve be recalculated?

Quarterly at minimum, aligned with financial close, and monthly if your inventory has fast-changing velocity like seasonal or fashion goods. Auditors typically want to see a documented, consistently applied methodology rather than an ad hoc adjustment each period, so lock in your aging buckets and percentages and apply them consistently.

Does building a reserve mean I should write off the inventory?

Not necessarily — the reserve is a balance sheet provision, not a decision to physically dispose of the stock. Many operations use the aging analysis that feeds this reserve to trigger action: a clearance sale, a return to vendor, a liquidation channel sale, or a formal write-off, rather than just letting the reserve grow indefinitely against inventory going nowhere.

What's the warehouse operations angle on obsolescence?

Obsolete inventory isn't just a finance problem — it occupies pallet positions and pick locations, degrades cubic utilization, and adds noise to cycle counts. Tying obsolescence review to a slotting or space utilization audit often surfaces inventory that should have been cleared out long before it hit the 24-month bucket.