Aging

Aging — Meaning, Definition & Full Explanation

Aging is an accounting method that categorizes a company's accounts receivable by the number of days invoices remain unpaid, helping businesses identify overdue payments and assess credit risk. Also called accounts receivable aging or an aging schedule, this tool groups unpaid customer invoices into time-based buckets (typically 30, 60, 90+ days) to reveal collection problems and estimate bad debt reserves. Banks, lenders, and investors use aging reports to evaluate a company's operational health and cash flow reliability.

What is Aging?

Aging is a systematic way to track and classify outstanding customer invoices based on how long they have been unpaid. Every time a company makes a credit sale, that amount becomes an account receivable—a current asset representing money customers owe. Over time, some invoices become overdue. Aging organizes these receivables into age brackets to show which payments are current, which are slightly late, and which are seriously delinquent.

The aging process creates a detailed report, usually prepared monthly or quarterly, that lists each unpaid invoice alongside the customer's name, invoice number, original due date, and current status. Accountants use this data to calculate how much of the total receivables portfolio may turn into bad debt—money the company will never collect. By grouping invoices into date ranges, aging helps finance teams spot trends, prioritize collection efforts, and make realistic provisions for loan loss on the balance sheet.

How Aging Works

Aging follows a straightforward classification process:

1. Extract unpaid invoices: The accounting system pulls all customer invoices that have not been fully paid as of the reporting date.

2. Calculate days outstanding: For each invoice, the system calculates the number of days between the due date and the report date.

3. Group into age buckets: Invoices are sorted into standard time categories: 0–30 days, 31–60 days, 61–90 days, and 90+ days (sometimes extended to 120+ days for older debts).

4. Calculate totals by bucket: The finance team sums the outstanding balance in each age category, creating subtotals.

5. Apply historical loss rates: Using past experience, accountants multiply each age bucket by an estimated bad debt percentage. Older invoices carry higher loss rates (e.g., 1% for 0–30 days, 10% for 61–90 days, 40% for 90+ days).

6. Calculate bad debt reserve: The weighted total across all buckets becomes the allowance for doubtful accounts, recorded as an expense on the income statement.

7. Generate aging report: The final document shows customer names, invoice amounts, age brackets, and total receivables by age. This report guides collection strategy and informs lenders and auditors about credit quality.

Aging in Indian Banking

In India, the Reserve Bank of India (RBI) mandates that banks maintain aging schedules for advances and non-performing assets (NPAs) as part of prudential norms. Under the RBI's SARFAESI Act and Master Directions on Classification and Valuation of Assets, banks must categorize advances into age-based buckets to identify stress early.

For banks, aging is critical under the NPA classification framework. A standard advance becomes a non-performing asset when principal or interest remains unpaid for 90 days. Banks must track advances aging at 30 days, 60 days, and 90+ days to forecast slippages. The RBI requires banks to maintain specific provisions for NPAs based on age: 10% for standard assets (less than 90 days overdue), and higher percentages for sub-standard, doubtful, and loss assets.

NBFC (non-banking finance companies) regulated by RBI also use aging extensively. For JAIIB candidates, aging appears in the Asset-Liability Management and Credit Risk modules. CAIIB aspirants study aging as part of Advanced Bank Management and Risk Management.

Major Indian banks like ICICI Bank, HDFC Bank, and SBI publish aging schedules in their quarterly financial statements, disclosing advances in various age brackets. The RBI's Prompt Corrective Action (PCA) framework also monitors NPA aging trends to assess systemic risk. For retail lending, credit bureaus (CIBIL, Equifax) track payment aging for credit scoring.

Practical Example

Scenario: Akshay Industries, a Mumbai-based manufacturing company, prepares an aging schedule as of 31 March 2024. Its accounting records show ₹50 lakhs in outstanding invoices:

• 0–30 days: ₹20 lakhs (mostly current invoices from March)
• 31–60 days: ₹18 lakhs (invoices from February not yet settled)
• 61–90 days: ₹8 lakhs (invoices from January; one customer is negotiating a payment plan)
• 90+ days: ₹4 lakhs (an invoice from October; customer has defaulted twice; recovery unlikely)

Based on historical data, Akshay estimates bad debt rates: 0% for 0–30 days, 2% for 31–60 days, 8% for 61–90 days, and 50% for 90+ days.

Bad debt calculation:

• 0–30 days: ₹20 lakhs × 0% = ₹0
• 31–60 days: ₹18 lakhs × 2% = ₹36,000
• 61–90 days: ₹8 lakhs × 8% = ₹64,000
• 90+ days: ₹4 lakhs × 50% = ₹2 lakhs

Total provision: ₹3 lakhs

The aging report alerts Akshay's management that ₹4 lakhs is likely uncollectible and that the 31–60 day bucket needs focused collection attention. The auditors rely on this aging schedule to validate the bad debt expense on the financial statements.

Aging vs. Accounts Receivable

Aspect	Aging	Accounts Receivable
Definition	A classification tool that groups unpaid invoices by age	The total amount owed to a company by customers
Purpose	Identifies overdue payments and estimates bad debt	Shows total credit sales not yet collected
Output	Detailed aging schedule with time buckets	Single balance sheet line item
Frequency	Monthly or quarterly; detailed analysis	Reported periodically; summary figure
Use case	Credit analysis, collection strategy, loan loss provisioning	Financial position and liquidity assessment

Accounts receivable is the broader balance sheet category; aging is the analytical tool used to examine and manage it. A company's accounts receivable of ₹100 lakhs might be broken down by an aging schedule to reveal that ₹30 lakhs is dangerously overdue. Aging is actionable; accounts receivable is descriptive.

Key Takeaways

• Aging groups unpaid invoices into standard time brackets (typically 0–30, 31–60, 61–90, and 90+ days) to classify receivables by collection risk.

• The RBI requires banks to use aging schedules to track advances and classify non-performing assets under the 90-day NPA definition.

• Older invoices carry higher bad debt percentages in the aging formula; debts over 90 days may have 25–50% loss rates compared to 1–2% for current invoices.

• Aging informs loan loss provisioning on bank balance sheets and is a key input for audit procedures and regulatory compliance.

• JAIIB and CAIIB exams test aging as part of credit risk management, asset-liability management, and financial analysis modules.

• The aging report guides collection teams, helping prioritize follow-ups on invoices nearing the 90-day threshold to prevent NPA classification.

• NBFC lending and retail credit bureaus use aging to track payment performance and assess creditworthiness for credit scoring.

• Aging is essential for lenders assessing a borrower's working capital management and ability to convert sales into cash.

Frequently Asked Questions

Q: How often should a company prepare an aging schedule? A: Most companies prepare an aging schedule monthly as part of the monthly close process, and quarterly for external reporting. Banks and financial institutions often generate daily or weekly aging reports for advances and NPAs.

Q: What is considered a "good" accounts receivable aging profile? A: A healthy profile has most receivables in the 0–30 day bucket, minimal amounts in the 31–60 day range, and very little in the 60+ day categories. Industry norms vary; a Days Sales Outstanding (DSO) of 30–45 days is typical for manufacturing, while retail may target under