Collections Performance and Dunning Effectiveness Dashboard
Evaluates collections efficiency and effectiveness of dunning strategies by tracking overdue balances, escalation levels, and resolution performance.
Total AR Balance
Sum of outstanding receivables at the latest snapshot on or before 2025-03-31.
Average Days Past Due (Balance-Weighted)
Calculated across open receivable balances at the latest snapshot on or before 2025-03-31.
AR in Dunning Process
Based on receivable records at the latest snapshot on or before 2025-03-31, with no outstanding balances flagged at dunning_level > 0.
High Escalation Balance (Level 3+)
Computed from receivable records at the latest snapshot on or before 2025-03-31, with no open balances at dunning level 3 or higher.
High-Risk AR (Over 90 Days)
Represents the sum of severely overdue open receivables (days_past_due > 90) at the latest AR snapshot on or before 2025-03-31.
Customers Over Credit Limit
At the 2025-03-31 snapshot cutoff, 1 customer had total outstanding balances above their defined credit limit.
Top 10 Customers by Overdue Balance
King Abdullah Econ City has the highest overdue exposure at 1,055,909, more than three times the second-ranked customer.
The second and third customers (Emirates Steel Works at 332,024 and Jubail Industrial Supply at 306,636) have similar overdue balances, forming a distinct middle tier.
The top customer alone accounts for a disproportionately large share of the top-10 overdue balances, indicating significant concentration risk.
AR by Aging Bucket
The largest portion of AR is 'Not due' at 3,314,596.00, indicating most exposure is still within agreed payment terms.
Late-stage overdue balances (91-180 and Over 180) total 673,500.00, representing significant cash at risk requiring focused collection efforts.
Early overdue balances (0-30) amount to 1,378,375.00, substantially higher than 31-60 (487,408.00) and 61-90 (1,313.00), suggesting recent slippage rather than chronic delinquency.
Outstanding Amount by Dunning Level
All outstanding AR (5,855,192.00) is concentrated at dunning level 0 in the latest snapshot.
No balances appear in higher dunning levels, suggesting escalation processes may not yet be triggered or dunning levels are not actively maintained.