How to Create a Slow-Moving Inventory Reserve Provision
Establishing a prudence-based provision for inventory that has not sold in over 180 days and may require discounting.
| Account Name | Type | Debit ($) | Credit ($) |
|---|---|---|---|
| Inventory Obsolescence Expense | Expense (+) | 4,500.00 | - |
| Allowance for Slow-Moving Inventory | Contra-Asset (+) | - | 4,500.00 |
💡 Accountant's Note
The prudence principle requires recognizing potential inventory losses before they are confirmed. An allowance account is used so the original cost remains visible in the ledger.
Practitioner & Systems Framework
💻 ERP Architecture
Build a slow-moving inventory aging report segmented by last sale date: 0–90 days (active), 91–180 days (watch), 181–365 days (slow-moving), 365+ days (at risk). Apply a tiered provision rate by age band (e.g., 10% for 181–365 days, 30% for 365+ days, 100% for items with zero sales in 24 months). Run this report monthly and adjust the Allowance account to reflect the current provision level, not as a cumulative addition.
⚠️ Audit Flags
Slow-moving provisions are tested for: (1) Consistency of the aging methodology and provision rate from period to period, (2) Whether the provision rates are supported by actual recovery rates on disposed slow-moving stock, (3) Any management overrides reducing the provision without clear justification, (4) Items that have been reclassified as 'active' to avoid provisioning (e.g., a single sale of one unit of a 500-unit holding).
📄 Required Documentation
Inventory aging report by last-sale date, provision methodology memo (aging bands, provision rates, rationale), comparison to prior period provision and explanation of movements, recovery rate analysis from prior-period disposed slow-moving stock, and management sign-off on the provision calculation.
Automate this entry with the JEH Accounting Suite
Stop doing manual entry. Our VBA-powered ERP automatically generates your ledgers, Trial Balance, and Financial Statements.
No Subscriptions. Own your data.
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.