Water District Demo
Billing & Collections — as of Nov 10, 2026, 4:28 PM
10
Active accounts
₱3,264.51
Outstanding balance
7
Accounts in arrears · 70.0%
₱1,018.98
Collected this month
Billed vs. collected
Billed Collected
Monthly totals billed versus what was actually collected, based on billing and payment records.
How much of what's billed gets collected, and what share of accounts are behind on payments.
Accounts with balance, by highest arrears
7 shown
Consumer Account No. Mo. Balance Status
Juan Dela Cruz DEMO-1002 0 ₱641.58 Active
Pedro Garcia DEMO-1004 1 ₱603.84 Active
Jose Ramirez DEMO-1008 0 ₱566.10 Active
Luz Fernandez DEMO-1005 0 ₱471.75 Active
Manuel Bautista DEMO-1010 1 ₱415.14 Active
Maria Santos DEMO-1001 1 ₱358.53 Active
Rosa Villanueva DEMO-1007 1 ₱207.57 Active
Arrears balance by months overdue
Total outstanding balance grouped by how many months overdue, showing where collection risk is concentrated.
0 months
₱1,679.43
1 month
₱1,585.08
Recent payments
Elena Torres
OR-10009 · November 2026 · Nov 10, 2026
₱283.05
Carlos Mendoza
OR-10006 · November 2026 · Nov 10, 2026
₱547.23
Ana Reyes
OR-10003 · November 2026 · Nov 10, 2026
₱188.70
Active accounts by zone
10 total
Zone Active
Zone 1 3
Zone 2 3
Zone 3 2
Zone 4 2
Disconnected accounts by zone
0 total
Zone Disconnected
Zone 1 0
Zone 2 0
Zone 3 0
Zone 4 0
Figures are sourced live from tblConsumerInfo, tblBilling, and tblPayment.