Aging Report

Definition

An aging report is a financial management tool that sorts outstanding accounts receivable into time-based categories (or 'buckets') based on how long invoices have remained unpaid. Standard buckets include Current (0-30 days), 31-60 days, 61-90 days, and over 90 days. The report provides a snapshot of receivables health, highlighting which invoices are at increasing risk of non-collection as they age.

For Indian businesses, aging reports carry particular significance because of regulatory requirements around provisioning and write-offs. Under Ind AS 109, companies must apply the Expected Credit Loss (ECL) model, which uses aging data to calculate provisions for doubtful debts. Additionally, aging reports are essential for monitoring compliance with MSME payment timelines, the MSMED Act, 2006 mandates payment within 45 days (or 15 days without a written agreement) to micro and small enterprises, and Section 43B(h) of the Income Tax Act now disallows expense deductions for payments delayed beyond these limits.

An effective aging report in India must also account for TDS deductions, partial payments, GST credit and debit notes, and advance receipts. Without these adjustments, the report overstates the true outstanding amount and leads to inaccurate collection actions. Modern AR platforms generate real-time aging reports that automatically reflect all adjustments, eliminating the lag inherent in manual spreadsheet-based reporting.

Key Points

• Groups receivables into time buckets: Current, 31-60 days, 61-90 days, and 90+ days overdue
• Critical input for provisioning under the Expected Credit Loss (ECL) model of Ind AS 109
• Helps monitor compliance with MSME payment timelines under the MSMED Act, 2006
• Must account for TDS deductions, partial payments, and credit notes for accuracy in Indian context
• Should be reviewed weekly for effective collections management, not just at month-end
• Drives credit policy decisions: customers consistently in older buckets may need revised terms
• Value-weighted aging (prioritising large overdue amounts) is more actionable than age-only sorting