Financial
Unit: currency
Lower is better
About This Metric
Represents the portion of total balance that has exceeded payment terms. High overdue amounts may indicate collection issues, customer dissatisfaction, or billing problems.
Formula
SUM(customer.balance) where balance is past dueCode Expression
customers.filter(c => c.balanceAge > 0).reduce((sum, c) => sum + c.balance, 0)Data Sources
- diamond-customers
balancebalanceAgestatusText
Caveats & Limitations
- •Aging buckets determined by balanceAge field
- •Does not include customers on payment plans unless past due
Tags
#collections
#aging
#risk
Calculation Source
Real-time (Cosmos DB)