A mid-sized consumer goods company in northern India had a distributor doing ₹80 lakhs in monthly purchases. Their payment terms were 30 days. On paper, their outstanding balance hovered between ₹75 lakhs and ₹85 lakhs. To the credit committee, it looked stable. The outstanding was within the credit limit. The relationship was healthy.
Then, within forty-five days, the distributor went silent. The outstanding balance jumped to ₹1.2 crore, no payments came in, and the territory went dry.
When the credit head audited the account, they found the problem had not developed in forty-five days. It had been developing for seven months. The total outstanding balance had indeed remained stable at around ₹80 lakhs, but the age of that outstanding had changed completely.
Six months prior, 90% of the outstanding was under 30 days old. Two months prior, only 40% was under 30 days, while ₹35 lakhs had migrated into the 60–90 day bucket. The distributor was paying, but they were paying later and later. They were using the supplier’s credit to fund a cash flow gap elsewhere in their business.
This is the classic B2B credit blind spot in India: monitoring the outstanding amount instead of the payment behaviour.
Why the Total Outstanding Number Misleads You
Most credit managers monitor distributor credit risk using two primary metrics: total outstanding balance and credit limit utilisation. If a distributor has a credit limit of ₹1 crore and their outstanding is ₹80 lakhs, they are green-flagged.
This is a dangerous simplification. The total outstanding balance is a static snapshot. It tells you how much is owed today, but it tells you nothing about how the distributor is paying.
A distributor can maintain a perfectly stable outstanding balance of ₹80 lakhs while their payment behaviour deteriorates. They do this by matching their payment speed to their order speed. If they order ₹10 lakhs worth of goods and pay ₹10 lakhs in the same week, their outstanding stays the same. But if that ₹10 lakh payment is clearing an invoice from 90 days ago instead of 30 days ago, their risk profile is completely different.
The Rupee amount is a lagging indicator. The DPD (Days Past Due) trend is a leading indicator. By the time the absolute outstanding balance starts growing uncontrollably, the distributor has usually been in financial stress for 3–6 months.
When you focus only on the total outstanding, you are watching the scoreboard instead of the play. The signal that gives you lead time is the movement of invoices across aging buckets - also known as aging migration.
The Lead-Time Signal: Aging Bucket Migration
Aging migration is the movement of outstanding rupees from newer buckets (like 0–30 days) to older buckets (like 31–60, 61–90, and 91–180 days).
In a healthy distribution network, 80% or more of your outstanding balance should sit in the current (0–30 days) bucket. As a distributor’s cash flow tightens, they begin to delay payments to clear more urgent liabilities (like bank interest or retail rent). Consequently, your invoices start aging.
Let’s look at two scenarios for a distributor with the same ₹80 lakhs outstanding:
Illustrative Example - Aging Profile: Healthy Distributor vs. Deteriorating Distributor
HEALTHY DISTRIBUTOR - Outstanding well-concentrated in current bucket
DETERIORATING DISTRIBUTOR - Migration into late buckets is the warning
On paper, both accounts show ₹80 lakhs outstanding. But Scenario 2 represents a distributor on the verge of default. Over 50% of their outstanding is overdue, and ₹6.4 lakhs has crossed 180 days - a bucket from which recovery in India drops to under 15%.
If your credit monitoring system only alerts you when outstanding crosses the credit limit, you will miss Scenario 2 entirely until it is too late.
“The distributor who is about to default does not usually stop paying overnight. They slow down first - a few days at a time, over several months. That slowdown is the signal.”
Why Days Past Due (DPD) Trend is the Best Lead-Time Metric
To catch deterioration early, you must track Days Past Due (DPD). DPD measures the number of days an invoice remains unpaid past its due date.
Specifically, you should monitor the Average DPD Trend over a rolling 3-month window. An increase in average DPD is the clearest indicator of dealer stress.
For example, if a distributor’s average DPD has been 4 days for the last year, and it rises to 8 days in Month 1, 12 days in Month 2, and 18 days in Month 3 - this is a clear trend. The absolute numbers are small, but the direction is consistent. The distributor is taking longer to clear their dues every single month.
This trend gives you 2 to 3 months of lead time to intervene before a default occurs. You can use this time to reduce supply, secure additional collateral, or renegotiate terms before the exposure gets out of hand.
How to Categorise DPD and Aging Signals
To make these signals actionable for your sales and credit teams, you need to map them to specific risk tiers and response protocols. Here is a recommended framework:
DPD stable or improving vs. 3-month baseline
No action needed. Distributor is paying consistently. Monitor as usual.
Average DPD up +3 days vs. 3-month baseline
Slowing down slightly. Review payment pattern. Watch for continued increase next month.
Average DPD up +8 days vs. baseline
Consistent slowdown. Require advance payment on new orders. Start a payment plan conversation.
Average DPD up +15 days vs. baseline
The distributor is in financial stress. No new credit. Escalate to recovery. Assess outstanding exposure.
By categorising signals this way, your team does not need to debate what action to take when a distributor starts slowing down. The response protocol is defined in advance.
The Practical Early-Warning Trigger Matrix
Here is how you can set up automated triggers in your ERP or credit system based on aging bucket migration and DPD trends:
Note: All examples above are illustrative thresholds. Apply these proportionally based on the distributor's credit limit, relationship tenure, and sector context.
A 5-Step Framework to Implement DPD Tracking
If your company currently monitors risk using absolute outstanding, here is how to transition to behavior-based monitoring:
Transitioning to Behavior-Based Credit Monitoring
Extract historical invoice data. Pull the last 12 months of invoices and collections at the distributor level to establish a baseline DPD for each dealer.
Define DPD baselines. Calculate the average DPD over a rolling 90-day window for each distributor. This is their normal payment speed.
Build aging migration reports. Create a weekly report showing the share of outstanding across 0-30, 31-90, 91-180, and 181+ day buckets.
Set automated alerts. Configure your ERP to flag accounts where average DPD rises by more than 5 days or the 31-90 day bucket share grows by 10 percentage points.
Align sales and credit teams. Ensure the sales team is incentivised on collections rather than just sales. A sale is not complete until the cash is in the bank.
Conclusion: Overdue is a Behaviour, Not a Number
Distributor defaults in India’s pharma and FMCG networks rarely happen overnight. The signs are present in the data months in advance. The difference between a minor collections follow-up and a multi-lakh write-off is the speed at which you read those signals.
By moving your focus from the absolute outstanding balance to DPD trends and aging migration, you gain the lead time needed to protect your business.
Automate Your Days Past Due (DPD) and Aging Monitoring
Privue's Distributor Risk Management platform continuously tracks DPD trends, aging bucket migration, and outstanding growth across your entire network - automatically generating early warning alerts before defaults occur.
Request a Demo