SpireStock
SpireStock
Finance & ComplianceAlso known as: Debtor Ageing, AR Ageing

Ageing Report

A report that buckets outstanding receivables by days-past-due, 0-30, 31-60, 61-90, 90+, to highlight collection risk.

Full definition

An ageing report (or debtor ageing) buckets every open invoice by how long it has been outstanding, typically 0-30 days, 31-60, 61-90, and 90+. It is the single most important report for collections and working-capital management in a distribution business. Money stuck in the 90+ bucket is approaching write-off territory and deserves urgent escalation.

In Indian FMCG, healthy distributor ageing shows 80%+ of outstanding in the 0-30 bucket and less than 2% in 90+. When the 60+ bucket swells, it usually signals channel stress: stock has stopped moving, the distributor is squeezed, and the brand must act quickly with scheme support, credit restructuring, or stop-supply.

Good sales analytics in an invoice-billing system refresh the ageing view in real time and let collections teams drill into individual invoices and dispute history.

Real-world example

A distributor's ageing report shows Rs 12 lakh in 0-30 days, Rs 2 lakh in 31-60, Rs 40,000 in 61-90, and Rs 20,000 in 90+, a healthy profile.

See Ageing Report in action

Start a free trial and watch how SpireStock turns ageing report from a concept into a measurable, auditable workflow.