How Do I Identify and Write Down Obsolete Ecommerce Inventory?

Who needs this review, and what decision should it complete?

This method is for an ecommerce founder, inventory manager, or finance operator holding seasonal, discontinued, damaged, restricted, superseded, or persistently slow-moving SKUs. The decision is not simply “is this old?” It is whether the recorded unit cost remains recoverable, what write-down is supportable, and what operational disposition should happen next.

Search results frequently define obsolete stock or give a journal entry. They rarely connect demand uncertainty, sell-through scenarios, completion and selling costs, evidence quality, and final disposal ownership. Another gap is the tendency to apply a single age percentage to every SKU. This workflow uses age as one signal and makes the recoverability conclusion explicit.

What evidence should flag a SKU for review?

Build a SKU risk profile from independent signals. Demand signals include trailing unit sales, forecast changes, cancelled listings, and replacement-product launches. Age signals include last receipt, last sale, and remaining shelf or fashion season. Condition signals include damage, expiration, packaging defects, and incomplete bundles. Restriction signals include platform delisting, safety concerns, import restrictions, and missing documentation. Economics signals include current achievable price, promotions required, storage, refurbishment, fulfilment, commissions, and disposal cost.

Do not use revenue forecasts without a quantity bridge. Verify on-hand, in-transit, reserved, quarantined, and third-party warehouse units first. An apparent overstock can be a duplicate feed, and a genuine obsolete balance can remain invisible when units sit in a return or quarantine location.

How does the evidence-to-action decision tree work?

This decision tree is the first original-value component.

1. Do quantities exist and reconcile? If no, stop valuation and resolve the unit ledger.
2. Can the item legally and physically be sold? If no, obtain disposal, return-to-vendor, or salvage evidence; ordinary retail recovery may be zero.
3. Is there credible ordinary-course demand within the relevant horizon? If yes, estimate units and price without assuming impossible sell-through.
4. What costs are necessary to complete and sell? Include repair, repackaging, marketplace commissions, fulfilment, and other incremental costs required for recovery.
5. Is estimated recovery below carrying cost? If yes, calculate the shortfall under the approved accounting framework.
6. What action realizes or limits the loss? Assign markdown, bundle, alternate channel, supplier claim, donation, recycling, or destruction with an owner and date.

Accounting should not become a substitute for disposition. A write-down corrects the carrying amount; it does not free warehouse space or stop continuing storage fees.

How should I calculate a supportable write-down?

Under IAS 2, inventories are measured at the lower of cost and net realisable value (NRV). IAS 2 defines NRV as estimated selling price in the ordinary course of business less estimated costs of completion and costs necessary to make the sale. A simple SKU calculation is:

NRV per unit = supportable selling price - completion cost - necessary selling cost.

Write-down = quantity owned × max(0, carrying cost per unit - supportable NRV per unit).

Apply the calculation at the level required by the reporting framework and policy. Avoid offsetting a weak SKU with an unrelated profitable SKU merely to erase the shortfall. Also document whether later recovery can reverse a prior write-down; IFRS and other frameworks can differ in detailed treatment, so obtain professional approval.

Which recovery scenario is credible?

Use the following evidence hierarchy and scenario matrix, the second original-value component.

A management hope to “sell it eventually” is not price evidence. Likewise, a public list price is weak when the business has no recent conversions at that price. Prefer realized transactions, current approved campaigns, binding quotes, or other observable evidence and preserve the date checked.

Worked hypothetical example: a discontinued accessory

Hypothetical example—not a customer result. Assume an electronics seller owns 800 discontinued phone cases at a carrying cost of $11 each, or $8,800 total. A count confirms all 800 units. The original $29 selling price is no longer realistic after a new phone generation launches. A tested clearance price is $9.50. Marketplace and payment fees expected for the sale are $1.35 per unit, fulfilment is $2.10, and repackaging is $0.55. Management expects the clearance channel can sell 500 units. A recycler offers $0.40 per unit net for the remaining 300.

Interpretation: a single $9.50 list price for all 800 units would overstate recovery because the tested channel has capacity for only 500. The write-down is $5,930 under these assumptions, while the disposition plan separately assigns clearance and recycling. Limits: the scenario ignores tax, possible return rates, storage during sell-through, and framework-specific reversal rules. Actual evidence must support both channel capacity and costs.

Which anomaly should I investigate first?

First resolve quantity or ownership uncertainty: duplicate warehouse feeds, consigned stock, customer returns, and goods owned by another entity can invalidate every later calculation. Second investigate items that cannot lawfully or safely be sold. Third review SKUs with no current price evidence but a high carrying value. Fourth test forecasted sell-through against historical channel capacity. Fifth inspect necessary selling costs omitted from NRV. Finally, compare approved dispositions with subsequent execution.

Rank cases by financial exposure, evidence weakness, and urgency. A high-value restricted product with no disposal plan is red. A seasonal item with recent sales and a documented markdown test may be amber. A small balance supported by a current recycler quote can be green once approval and custody evidence are complete.

What steps produce a reviewable write-down file?

1. Freeze an inventory snapshot and reconcile quantities by SKU, location, owner, and condition.
2. Generate risk signals without automatically assigning values from age alone.
3. Collect current price, demand, cost-to-complete, cost-to-sell, and salvage evidence.
4. Segment each SKU into supportable recovery populations.
5. Calculate cost versus recoverable value and run sensitivity for material assumptions.
6. Obtain operational, finance, and where needed tax or legal approval.
7. Post the journal with SKU or category support and retain the calculation version.
8. Assign and monitor disposition; compare later proceeds and units with assumptions.

Definition of done: quantities tie to the inventory ledger; each material SKU has a documented risk conclusion; the valuation is reproducible from dated evidence; the journal ties to the approved schedule; and disposition owners report outcomes rather than leaving written-down stock unmanaged.

What failure modes create an unsupported number?

A flat “50% after 180 days” rule may be a screening device, but without recovery evidence it is not a complete valuation. Using list price instead of achievable price ignores actual demand. Omitting commissions, fulfilment, repairs, or disposal costs inflates NRV. Writing every slow mover to zero can understate assets, while refusing any write-down until physical destruction can overstate them. Combining legal entities or currencies can also mask where the exposure belongs.

Do not treat a write-down as a tax deduction automatically. Tax treatment, documentation, VAT/GST consequences, donation rules, and destruction evidence vary by jurisdiction. Financial reporting and tax returns may need separate adjustments.

When does this need professional review?

Use a qualified accountant or valuation specialist for material balances, audited statements, lender covenants, acquisition diligence, complex manufacturing or bundles, uncertain ownership, significant tax consequences, or a change in accounting policy. Involve legal or compliance specialists when sale or disposal is restricted.

Caigeek can use SKU ledger, warehouse counts, sales history, price tests, platform fees, fulfilment costs, supplier claims, and disposition quotes to produce an aging diagnostic, evidence matrix, NRV schedule, journal support, and action register. Management and its qualified advisers remain responsible for assumptions and accounting conclusions.

Self-check before sign-off

• Quantities, ownership, entity, location, and condition reconcile.
• Age is a signal, not the only valuation assumption.
• Prices and selling costs are current and dated.
• Channel capacity supports the units assigned to each scenario.
• The journal equals the approved SKU schedule.
• Disposition actions have owners, dates, and outcome tracking.

Sources and last updated

Last checked: 17 August 2026.

• IFRS Foundation, IAS 2 Inventories
• AccountingTools, Inventory Accounting Guide
• Beancount, lower of cost or NRV documentation guide

FAQ

Is slow-moving inventory automatically obsolete?

No. Age is a diagnostic signal; recoverability, condition, demand, restrictions, and policy determine the conclusion.

What is net realizable value for ecommerce inventory?

Under IAS 2 it is estimated ordinary-course selling price less estimated completion and necessary selling costs.

Should obsolete inventory be written down to zero?

Only when supportable recovery is zero. Sale, liquidation, salvage, or repurposing may support a positive amount.

What evidence supports an inventory write-down?

Retain age and demand data, quantities, condition, current selling evidence, necessary costs, approved disposition, calculations, reviewer approval, and outcomes.