Defaulter position — Depot 113
Loading…
① Collectable vs uncollectable
how much of the outstanding is money that can actually be pursued
The split
click a slice to scope the page
Reasons for uncollectable
Ageing against classification
1 term = current · >1 arrear · metered >6 · click any cell
② Collection
what came in since the last upload, and against what it is measured
Where the money went since the last upload
opening balance → collections → fresh demand → closing balance
Movement since the last upload
Collection by amount range
where the money is coming from
Trend across uploads
bars: total dues outstanding · line: collected against that upload
Biggest collections since the last upload
| Bill no. | Name | Street | Dues before |
Dues now | Collected | Status |
③ Action taken
the recovery ladder — who has been served, and what it brought in
Coverage by step
bars: dues covered · dot: consumers
Action against classification
is the effort going where the money is?
Recent decisions
who classified or acted, latest first
④ Range-wise position
up to ₹5,000 · ₹5,000–25,000 · ₹25,000–50,000 · ₹50,000–1 lakh · ₹1–5 lakh · above ₹5 lakh
Consumers and dues in each range
click a row or a cell to scope the whole page to it
⑤ Top 100 defaulters
the collectable list, largest first — where one decision moves the number
Top 100 collectable defaulters
| # | Bill no. | Name & address | Street | Class |
Terms | Dues | Share | Cumulative |
Classification | Last action |
More breakdowns
concentration, recency, class, street, depots
Current vs arrear
1 term = current · metered up to 6
How concentrated the dues are
Pareto curve
When each consumer last paid
Depot comparison
latest snapshot of each depot
All consumers
everything the filters above leave standing
Defaulters
|
Bill no. |
Name & address |
Street |
Class |
Terms |
Total dues |
Movement |
Classification |
Last action |