Slow-Moving Inventory Reserve — Allowance for Excess and Obsolete Stock
Establishing and maintaining an allowance for slow-moving, excess, and obsolete finished goods inventory — particularly for discontinued SKUs, packaging changeovers, and failed new product launches.
| Account Name | Type | Debit ($) | Credit ($) |
|---|---|---|---|
| Cost of Sales — Slow-Moving Inventory Reserve (E&O Provision) | Expense (+) | 3,500,000.00 | - |
| Allowance for Excess and Obsolete Inventory | Asset (-) | - | 3,500,000.00 |
💡 Accountant's Note
Slow-moving and obsolete (E&O) inventory is a chronic challenge in FMCG: products are discontinued (when a SKU is delisted by a major retailer), packaging changes create stranded old-design stock (packaging changeovers require the old labels/cartons to be written off), new product launches that underperform leave excess inventory that must be promoted out or written down. The E&O reserve is established using a standard methodology: coverage ratio = weeks of inventory on hand / weeks of average demand. Inventory with coverage > 26 weeks = 25% reserve; > 52 weeks = 50% reserve; > 78 weeks = 100% reserve (effectively fully obsolete). This formula provides a systematic, defensible basis for the reserve.
Practitioner & Systems Framework
💻 ERP Architecture
The E&O reserve calculation is typically run monthly from the ERP's inventory aging report: current inventory quantity by SKU / average weekly sales (13-week rolling average) = weeks of cover. Products with coverage exceeding thresholds are automatically flagged and reserved at the appropriate percentage. SKU rationalization decisions (deliberate discontinuation) and packaging changeovers trigger specific reserve analyses. When reserved inventory is subsequently sold (e.g., at clearance), the allowance is released to COGS — the released allowance is a COGS credit (favorable).
⚠️ Audit Flags
Auditors test E&O reserves against the methodology documentation and verify its consistent application. Red flags: reserves calculated as a percentage of total inventory (not bottom-up by SKU) — a common shortcut that lacks precision. Auditors also look for: discontinued SKUs where full write-off should have occurred but only partial reserve was taken, new product failures where inventory exceeds realistic sell-through projections, and packaging changeover inventory not yet reserved.
📄 Required Documentation
Inventory aging report (weeks of cover by SKU), E&O reserve methodology documentation (threshold percentages by coverage tier), discontinued SKU list with write-off status, packaging changeover schedule and obsolete packaging reserve, new product launch inventory vs. sales projections, E&O allowance rollforward, and subsequent disposals confirming reserve adequacy.
Professional Excel Template
Get the automated version of this entry. Includes built-in IFRS checks, VAT calculators, and SAP-ready upload formats.
Expert Analysis by Qusai Ahmad
General Accountant Supervisor & IFRS Specialist
Specialized in SAP GUI automation and Middle Eastern tax compliance. Building digital tools for the next generation of finance leaders.