Accounts Receivable Aging and Credit Risk Dashboard
Comprehensive view of customer receivables, aging exposure, and credit utilization to support collections prioritization and credit control decisions.
Overdue Percentage
Calculated at the latest snapshot_date with 90.02% of the total outstanding AR balance classified as overdue based on positive days_past_due.
Customers with Outstanding Balance
Counted 46 distinct customers with SUM(outstanding_amount) > 0 at the latest accounts_receivable snapshot.
Customers Over Credit Limit
Based on customer-level aggregation of outstanding balances at the latest AR snapshot, where 3 customers exceed their defined credit limits.
Balance-Weighted Average Days Past Due
Unable to compute because the database rejected the SELECT query execution.
AR Exposure by Region
Saudi Arabia holds the largest AR exposure at 1,072,116, significantly higher than any other region.
UAE is the second-largest exposure at 667,184, but is still about 405,000 lower than Saudi Arabia.
Saudi Arabia and UAE together account for the majority of total receivables, indicating a strong geographic concentration of credit risk.
AR Balance Trend by Snapshot Date
Total AR declined significantly from 5,855,192.00 on 2025-03-31 to 2,278,708.00 on 2026-03-31, indicating a sustained reduction in outstanding exposure.
A sharp drop occurred between 2025-03-31 (5,855,192.00) and 2025-06-30 (3,279,252.00), a reduction of over 2.5M, suggesting a major collection cycle or portfolio cleanup.
After a temporary increase from 3,279,252.00 in June 2025 to 3,420,762.00 in September 2025, AR resumed its downward trajectory through year-end and into Q1 2026.