BILL-E

Utility billing enforcement — Outstanding balance management

← Back to Modules
Total Customers847From uploaded file
Total Billed$128.4KThis month
Collected$94.2K73.4% collection rate
Outstanding$34.2K▼ 6% vs last month
Disconnected5Pending payment
Receivables Aging
Current
30-60d
60-90d
90d+
Current: $19,800 (58%) 30-60d: $6,160 (18%) 60-90d: $4,790 (14%) 90d+: $3,420 (10%)
Overdue Accounts
23
of 847 total
Avg Days Overdue
52
for overdue accounts
At-Risk Revenue
$8,210
>60 days outstanding
Collection Rate — 6 Months
Customer Accounts — Overdue & Action Required 23 Overdue
CustomerAccountMeter IDBalance DueLast PaymentDays OverdueStatusActions
Hassan Ali
📍 Block D, Unit 4		 ACC-0041MTR-0041 $1,240 Jan 5, 202694 days ⚠ Critical
Fatima Rasheed
📍 Block A, Unit 12		 ACC-0112MTR-0112 $680 Feb 2, 202672 days ⚠ Critical
Ibrahim Naseer
📍 Block B, Unit 7		 ACC-0087MTR-0087 $320 Feb 28, 202645 days Overdue
Mariam Abdulla
📍 Block C, Unit 2		 ACC-0156MTR-0156 $210 Mar 8, 202631 days Overdue
Aisha Mohamed
📍 Block E, Unit 9		 ACC-0203MTR-0203 $0 (paid) Apr 7, 2026— 🔴 Disconnected
Audit Trail
Today 14:22
Reconnected ACC-0198 (Yusuf Ibrahim) — payment of $540 verified
Admin
Today 09:15
Disconnected ACC-0067 (Ali Hassan) — 102 days overdue, $890 outstanding
Admin
Yesterday
Reminder sent to 8 accounts with 30+ days overdue via SMS
System
Apr 5
File uploaded — April billing data (847 records imported)
Admin
Apr 3
Disconnected ACC-0203 (Aisha Mohamed) — 88 days overdue
Admin
Apr 1
Reconnected ACC-0145 (Omar Farid) — payment confirmed
Admin
Bulk Actions
📨 Send Bulk Reminders
Send SMS/email reminders to all accounts 30+ days overdue (18 accounts).
⚡ Bulk Disconnection
Disconnect all accounts 90+ days overdue with balance >$500 (3 accounts).
📊 Generate Collection Report
Export PDF report of all outstanding balances, aging analysis, and disconnection history.
Recommendations
⚠️
Escalate 3 Critical Accounts (>90 days, >$500)
Hassan Ali ($1,240), Fatima Rasheed ($680), and Ali Hassan ($890) have not responded to reminders. Recommend disconnection to enforce payment discipline.
💰 $2,810 at risk📊 Historical recovery: 85% within 7 days after cut
📱
Implement Prepaid Metering for Repeat Offenders
5 accounts have been disconnected/reconnected more than twice. Switching to prepaid meters eliminates future collection risk and reduces admin overhead.
💰 Save ~$400/month in admin costs📉 Zero future bad debt from these accounts