Inventory Ageing: Identifying Slow-Moving Stock Before Cash Gets Trapped

An inventory-ageing control covering last movement, demand, shelf life, batch, location, ownership, committed orders and liquidation action. The purpose is to turn an operational issue into a measurable exposure, reconciled evidence, an accountable owner and a dated closure.

What management should understand

• Ageing should use relevant demand and movement data, not warehouse transfer alone.
• Raw material, WIP, finished goods, spares, returns and consignment stock need different logic.
• Committed stock differs from speculative stock with no current demand.
• Expiry, technical change, damage, seasonality and customer-specific design accelerate risk.
• Ageing should reconcile physical quantity, ownership, location, GST movement and bank submissions.

Use the Debt Service Coverage Ratio Calculator to work through the related inputs before acting.

The five-point control review

For the connected rule, example or next step, see Debtor Ageing: The 0-30-60-90 Day Dashboard That Protects Cash.

Practical example

For the connected rule, example or next step, see Obsolete Inventory Provision: When Unsold Stock Is Not an Asset.

Implementation workflow

1. Define the transaction and the decision

State precisely what is being measured or approved: a month-end balance, customer order, product cost, purchase, tax credit, payroll run, bank payment, investment or export document. Set the period, legal entity, business owner, reviewer and materiality. A control cannot work when the team is reviewing different transactions or dates.

2. Lock the source evidence

Collect the signed contract, approved master data, invoice, receipt, timesheet, inventory record, payroll file, portal statement, bank transaction or system log. Preserve the original version and document subsequent amendments. Official portals are important external records, but they do not replace the underlying commercial evidence or the books.

3. Reconcile value, quantity, date and identity

Match legal names, PAN or GSTIN where relevant, document numbers, quantity, amount, tax, due date, payment account and approval. Separate timing differences from errors and suspected fraud. An unexplained difference should remain open with an owner; it should not be forced into a suspense or miscellaneous account merely to complete the close.

4. Assess tax, payroll, cyber and contract boundaries

GST registration thresholds are not one universal number: the threshold for suppliers of goods can differ from services, and specified States can have lower limits. Compulsory-registration provisions, e-invoice history, e-way-bill rules, EPF or ESIC coverage and contract terms require separate analysis. Where insurance, guarantees or cyber cover are involved, the actual policy wording or instrument terms control the outcome.

5. Quantify the cash effect

Show the immediate payment or receipt, working-capital days, tax timing, finance cost and downside exposure. A transaction can be profitable in the accounts and still create a cash deficit. Use a base case and at least one stress case before accepting a large order, changing price, buying equipment or releasing a disputed payment.

6. Approve, execute and verify

The preparer should not be the only approver where master data, payment or statutory exposure is involved. Record the decision, exception reason and expiry. After execution, verify the live result in the bank, GST portal, payroll return, vendor master, inventory record or management report. A submitted request is not completion.

Action checklist

• Classify stock types.
• Set last-demand and last-movement dates.
• Review committed demand.
• Assign liquidation or use action.
• Reconcile physical and bank records.

Evidence to keep

• Inventory ledger
• Physical count
• Demand/forecast
• Shelf-life or technical review
• Action and provision register

Warning signs

Finin2min takeaway