AR Aging Analysis: How to Reduce DSO Effectively

Here's how cash flow crises usually start: not with a bang, but with a slow drift. A growing pile of invoices past 60 days. A handful of accounts quietly sliding past 90. A DSO number that ticks upward quarter after quarter. By the time someone flags it, you're already scrambling.

AR aging analysis is what makes those warning signs visible early, before they turn into a liquidity problem. For Indian finance teams juggling hundreds of invoices across customers with wildly different payment habits, getting aging analysis right is the single highest-impact move for reducing days sales outstanding and freeing up working capital.

What Is AR Aging Analysis?

An AR aging analysis categorises your outstanding accounts receivable by the length of time invoices have been unpaid. The standard aging report groups receivables into time buckets (typically Current (0-30 days), 31-60 days, 61-90 days, and 90+ days) giving finance teams a snapshot of collection health at any point in time.

But a truly useful aging analysis goes beyond simple bucketing. It answers critical questions:

• Which customers are consistently paying late, and by how much?
• Which invoice amounts are most at risk of becoming bad debt?
• Are payment delays concentrated in specific product lines, regions, or customer segments?
• How does your current aging profile compare to the previous quarter?
• What is the probability-weighted value of your receivables (considering historical write-off patterns)?

The Indian Context

AR aging analysis in India carries additional complexity. TDS deductions under Sections 194C, 194J, and 194H mean that the amount received is often lower than the invoice face value, and the difference must be tracked separately as TDS receivable. GST credit notes, debit notes, and return-related adjustments further complicate the picture. An aging report that does not account for these India-specific adjustments gives a distorted view of your true receivables position.

Building an Effective Aging Report

Most Indian businesses rely on a static Excel export grouped into 30-day buckets. That's a starting point, not a solution. What does a report that actually drives DSO reduction look like?

1. Use the Right Aging Basis

You can age invoices from the invoice date or from the payment due date. For DSO reduction purposes, aging from the due date is more actionable because it accounts for varying payment terms across customers. An invoice that is 45 days old but had 60-day terms is not yet overdue. An invoice that is 35 days old with 30-day terms is.

2. Add Granular Buckets for High-Risk Ranges

Instead of the standard 0-30, 31-60, 61-90, 90+ breakdown, consider: Current (not yet due), 1-15 days past due, 16-30 days past due, 31-45 days past due, 46-60 days past due, 61-90 days past due, and 90+ days past due. The first 15 days past due is your highest-leverage window: this is when a polite reminder is most likely to result in payment.

3. Include TDS and Adjustment Context

For each overdue line item, show the original invoice amount, any TDS deducted, credit notes applied, partial payments received, and the net outstanding. Without this, your AR team wastes time chasing amounts that have already been partially settled.

4. Segment by Customer Risk Profile

Group your aging report by customer payment behaviour categories: such as consistently on-time, occasionally late (1-15 days), frequently late (15-30 days), and chronically late (30+ days). This segmentation drives differentiated collection strategies.

5. Add Weighted Risk Scoring

Apply probability-of-collection percentages to each aging bucket based on your historical data. For example, if your data shows that invoices past 90 days have only a 60% collection rate, reflect this in your reporting. This gives leadership a more realistic picture of expected cash inflow and informs provisioning decisions under Ind AS 109 (Expected Credit Loss model).

Most companies generate an aging report. Few actually use it. The difference between a reactive AR team and a high-performing one often comes down to one thing: does someone sit down every week, look at the aging data, and make collection decisions from it?

From Aging Analysis to DSO Reduction: A Practical Framework

Understanding your aging profile is step one. Reducing DSO requires systematic action across five levers:

Lever 1: Tighten Credit Terms Proactively

Use aging data to identify customers who routinely exceed payment terms. For these accounts, consider:

• Renegotiating payment terms (e.g., moving from 60 days to 45 days)
• Requiring advance payment or milestone-based billing for new orders
• Reducing credit limits until payment behaviour improves
• Offering early payment discounts (e.g., 2/10 net 45): particularly effective in India where the cost of capital is high

Lever 2: Accelerate Invoice Delivery

A surprising number of DSO days are lost to invoice delivery delays. If your invoice reaches the customer 5 days after the goods are delivered, you have already lost 5 days. With e-invoicing under the GST framework, invoices generated through the IRP can be delivered to customers in real time, eliminating this gap entirely.

Lever 3: Implement Structured Dunning

Replace ad-hoc payment follow-ups with a structured dunning process. A typical effective sequence for Indian B2B transactions:

1. Day -3 (before due date): Courtesy reminder with invoice copy and payment details
2. Day +1 (past due): Payment confirmation request
3. Day +7: Formal reminder citing payment terms
4. Day +15: Escalation to senior contact at customer organisation
5. Day +30: Formal notice, credit hold consideration
6. Day +60: Legal notice under the MSME Samadhaan portal (if customer is a buyer under MSMED Act)

Lever 4: Resolve Disputes Faster

Disputes are the silent DSO killer. When a customer raises a query about pricing, quantities, or tax calculations, the clock keeps ticking on your aging report while the dispute sits unresolved. Centralise dispute tracking, set SLAs for resolution (target: 5 business days), and give your AR team the authority to resolve common disputes without lengthy approval chains.

Lever 5: Use Aging Data for Cash Flow Forecasting

Use your aging trends to build rolling cash flow forecasts. If your aging analysis shows that 70% of current receivables convert to cash within the bucket period, 20% slip by one bucket, and 10% slip by two or more, you can project cash inflows with reasonable accuracy: critical for treasury planning and working capital decisions.

What This Looks Like in Practice

Take a mid-sized auto components manufacturer processing roughly 800 invoices per month with an average DSO of 72 days. When they actually dug into their aging data, here's what they found:

• 40% of overdue amounts were concentrated in just 12 customers (out of 200+)
• Average invoice delivery delay was 4 days due to manual dispatch of physical invoices
• 35% of past-due invoices had unresolved disputes, with average resolution time of 22 days
• No structured dunning process: follow-ups were at the discretion of individual AR executives

After putting in weekly aging reviews, automated e-invoicing, a standardised dunning workflow, and dispute SLAs, they brought DSO down from 72 to 51 days in two quarters. The result? Roughly Rs. 4.2 crore freed up in working capital.

How OneFinOps Makes Aging Analysis Actionable

Most AR tools give you aging reports. OneFinOps gives you aging reports you can actually act on. The platform generates real-time aging views segmented by customer, region, and product line, with TDS deductions and partial payments already factored in. DSO tracking works at the company, business unit, and individual customer level, with trend analysis so you can spot problems early.

Where it gets practical: the dunning engine triggers collection workflows automatically when invoices cross aging bucket thresholds. No invoice slips through the cracks because someone forgot to check a spreadsheet. Bank feed integration keeps your aging report current with the latest payments, and the connection to GST reconciliation and TDS tracking means your data is compliance-verified, not just directionally correct.

Common Aging Analysis Mistakes

Even companies that run aging reports regularly often make these errors:

1. Running the report monthly instead of weekly: In a fast-moving receivables environment, monthly reports mean you are always reacting to problems that are already 2-4 weeks old. Weekly or real-time aging analysis is the standard for high-performing AR teams.
2. Ignoring partial payments and advances: If a customer has paid Rs. 8 lakh against a Rs. 10 lakh invoice, chasing them for Rs. 10 lakh damages trust. Ensure your aging report reflects the net outstanding after all adjustments.
3. Not connecting aging data to credit decisions: Your aging analysis should directly inform credit limit reviews, payment term negotiations, and order release decisions. If these processes are disconnected, you are collecting data without using it.
4. Treating all overdue invoices equally: A Rs. 50,000 invoice at 45 days and a Rs. 50 lakh invoice at 45 days require very different collection strategies. Prioritise by value-weighted aging, not just age alone.
5. Failing to account for seasonality: Many Indian industries have seasonal payment patterns (e.g., textiles before Diwali, construction during Q4). Compare aging trends year-over-year, not just quarter-over-quarter.

Aging analysis isn't a report you generate and file away. It's an operational tool: one that should drive daily collection priorities, weekly management reviews, and quarterly credit policy decisions.

Indian businesses that treat aging analysis as a core discipline consistently achieve lower DSO, healthier cash flow, and fewer bad debt write-offs. Start by building a solid aging report, layer in structured dunning and dispute resolution, and use the data to make better credit decisions. Your working capital position will show the difference. See how OneFinOps can help with intelligent aging analysis and automated collections.