Invoice-Level Payment Discipline and Terms Compliance Dashboard
Analyze payment discipline by comparing invoice due dates, payment terms, and overdue behavior to identify structural issues in billing and collections strategy.
Average Days Past Due
Calculated as a balance-weighted average across all open receivables (outstanding_amount > 0) at the 2025-03-31 cutoff snapshot.
Term Discipline Gap (Days)
Computed from open receivable balances at the latest snapshot on or before 2025-03-31 using balance-weighted days past due and payment terms.
Overdue Ratio (%)
Calculated from all open receivable balances at the latest snapshot on or before 2025-03-31, isolating the portion with positive days_past_due.
Overdue Rate by Sales Channel
Online channel shows an overdue rate of 1.0000 (100%), meaning all outstanding receivables in this channel are past due.
Direct sales have an overdue rate of 0.3870 (38.70%), significantly higher than Distributor at 0.2612 (26.12%), indicating weaker payment discipline in Direct.
Distributor channel exhibits the lowest overdue rate at 26.12%, suggesting comparatively stronger collections performance.
Invoice Aging vs Contracted Terms (Scatter)
Invoices with 15-day terms show a balance-weighted average of 65.40 days past due, significantly worse than 30-day terms at 13.63 days.
Shorter 15-day terms are associated with materially higher overdue behavior, suggesting structural enforcement or customer-risk issues.
Only two distinct payment terms categories (15 and 30 days) are present in the latest snapshot, indicating limited contractual term diversity.