Top 10 Priority Accounts — ranked by risk score
Aging Distribution
Monthly Collections — Full History (from Masterlist TRANSACTION DATE)
PAYMENT amounts negated (stored negative in Masterlist). CREDIT_MEMO amounts negated. Net = Invoiced − Collected. Rate = Collected ÷ Invoiced × 100.
Full Delinquency Rankings — all accounts with outstanding balance > PHP 100
Risk Score = (Balance ÷ 1,000 × 40) + (Months Overdue × 3.5) + (MIN(Days No Payment ÷ 30, 36) × 2.5). Tiers: Critical ≥ 1,200 · High ≥ 800 · Medium ≥ 400 · Low < 400.
Delinquency Aging Summary
Risk Tier Reference
Select a unit owner from the dropdown to generate their Statement of Account.