✓ Device transmitting normally. Last 5 reads received on schedule.
📄 Billing History · click a row for details
Period
Consumption
Amount
Status
May 2026
18 m³
₱842.00
Paid
Apr 2026
15 m³
₱796.00
Paid
Mar 2026
20 m³
₱904.00
Paid
💰 Current Balance · current cycle
₱0.00
Paid Jun 1, 2026 · OR #20260601-4421
Last Payment₱842.00
Payment DateJun 1, 2026
Received ByAna Reyes
📋 Open Tickets · click to view
🔧
SR-2026-0042 — Meter faulty
🔧 Maintenance
▸
⚖️
DISP-2026-0041 — May bill dispute
📋 Billing Dept
▸
New Account
Same structure as the Agua de Oro application form
1 · Applicant Information
2 · Household Members
Name
Gender
Birthday
Relationship
3 · Connection Details
🔗 The LoRaWAN device is not assigned here. It is bound to the account after installation, at the Bind Device step.
4 · Requirements Checklist
5 · Terms & Agreement
New Application
Encode a walk-in / phone application · routes to Service → Applications
📋 On submit, a new APP-2026-#### record is created and appears in the New lane of Applications, then follows the standard Flowable workflow.
1 · Applicant Information
2 · Connection Details
3 · Requirements Checklist
Bill Generation
Monthly billing · NWM LoRaWAN API
✓ June 2026 billing complete — 1,280 bills generated.
📅 Billing Cycle
Current PeriodJun 20 – Jul 20, 2026
Read Cutoff DateJul 20, 2026
Last NWM PullJun 21 8:00 AM
Bills Generated1,280 / 1,284
Data Gap Accounts4 (needs action)
⚠️ Data Gap Accounts (4) · no read this cycle
ℹ️ Last-good-read rule: if a meter transmitted earlier in the cycle but missed the cutoff, that last read is used as the basis — and the account is still flagged for review. Accounts below had no transmission at all this cycle.
Account
Name
Last Read
Action
2023-00445
Alfonso Cruz
May 6 ⚑ gap
2022-00112
Nita Domingo
Apr 29 ⚑ gap
🟡 Flagged — billed on last good read (6)
Transmitted earlier in the cycle but missed the cutoff date. Billed using last read; flagged so field can verify.
Account
Name
Last Good Read
Basis
2024-00733
Elena Marquez
Jul 16
16 m³ ⚑
2023-00701
Ramon Yu
Jul 15
22 m³ ⚑
📋 Previous Cycles · click to view
✅
June 2026 — 1,280 bills
Jun 21 · 4 data gaps resolved
▸
✅
May 2026 — 1,276 bills
May 21 · 2 data gaps
▸
✅
April 2026 — 1,274 bills
Apr 21 · 5 data gaps
▸
Rate Management
NWRB-approved schedule · Effective May 1, 2026
ℹ️ Rate changes require NWRB approval with 30-day advance notice. Saving creates a new pending version.
💹 Current Rates (RES-A)
Item
Rate
Effective
Basic Charge (0–10 m³)
₱280.00/month
May 1, 2026
Excess Consumption
₱38.00 per m³
May 1, 2026
Sewerage
₱178.00/month
May 1, 2026
Environmental Fee
₱55.00/month
Jan 1, 2026
Meter Service Fee
₱25.00/month
Jan 1, 2026
Late Penalty
10% of total due
Jan 1, 2026
Reconnection Fee
₱500.00
Jan 1, 2026
Sr. Citizen Discount
20% of basic charge
Jan 1, 2026
🕓 Previous Rate Versions · click to view
💹
v3 · Effective Apr 1, 2026
Basic ₱265→₱280 · Excess ₱35→₱38
▸
💹
v2 · Effective Jan 1, 2025
Sewerage charge introduced
▸
💹
v1 · Effective Jan 1, 2024
Initial approved schedule
▸
⚙️ Bill Simulator
Edit Rates (RES-A)
Creates a new version pending NWRB approval
Disconnection Notices
NWRB 60-day timeline
⏱ NWRB: Disconnection only after Day 60. 5-day notice at Day 55. 48-hr final at Day 58.
Account
Name
DMA
Balance
Days Overdue
Stage
Disconnect Date
Action
2023-00089
Cynthia Reyes
DMA-03
₱3,368
62
Disconnected
Jun 24 ✓
2022-00441
Bernardo Cruz
DMA-02
₱4,210
61
Eligible
Jul 1
2023-00124
Roberto Lim
DMA-04
₱2,526
56
Notice Sent
Jul 4
2024-00512
Lorena Valdez
DMA-01
₱1,684
55
5-Day Due
Jul 4
Roberto Lim Notice Sent
Account No. 2023-00124 · DMA-04 Kalabugao
💰 Balance Breakdown
Bill in arrears₱2,300.00
Penalty (10%)₱226.00
Total Outstanding₱2,526.00
Last PaymentApr 28, 2026 · ₱700
📞 Contact
Mobile+63 9XX XXX 2231
Service AddressBrgy. Kalabugao
⏱ Disconnection Timeline
Due Date passed
May 9, 2026
Day 55 · 5-Day Notice sent
Jun 27, 2026 · Maria Santos
Day 56 · Notice acknowledged
Current
Day 58 · 48-hr Final Notice
Jul 1, 2026
Day 60 · Eligible for disconnection
Jul 4, 2026
📣 Notice History
📣
5-Day Disconnection Warning (SMS)
Jun 27 · Maria Santos
📄
Statement of Account = Notice
Bill Jun 21
Payments & Collections NEW
Real-time from POS · Jun 29, 2026
₱48,200
Today's Collections
₱2,100,400
Month-to-Date (Jun)
24
Transactions Today
Time
OR Number
Account No.
Customer
DMA
Channel
Amount
Cashier
10:32 AM
OR-20260629-0051
2024-00845
Juan dela Cruz
DMA-02
Cash
₱842.00
Ana Reyes
10:18 AM
OR-20260629-0050
2024-01012
Eduardo Pascual
DMA-01
GCash
₱842.00
Ana Reyes
9:55 AM
OR-20260629-0049
2025-00201
Leonora Beltran
DMA-03
Cash
₱761.00
Boy Santos
Applications
Flowable workflow routing
📋 Applications route through departments via Flowable. Each department has its own portal access and is notified in-portal when a step is assigned to them. Customers see their current step in the member portal.
📥 New (3)
APP-2026-0124
Pedro Santos
New Connection · Jun 29
⏳ Unassigned
APP-2026-0123
Cecilia Lim
New Connection · Jun 28
⏳ Unassigned
APP-2026-0119
Ramon Dela Peña
Reconnection · Jun 25
⏳ Unassigned
🔍 In Review (2)
APP-2026-0115
Analiza Torres
New Connection · Jun 22
📋 Technical
🔧 Field Survey (1)
APP-2026-0108
Carmen Ocampo
New Connection · Jun 15
🔧 Technical Field
💳 Payment (1)
APP-2026-0104
Diego Ramos
Awaiting application fee
💳 Finance
✅ Approved (2)
APP-2026-0101
Renato Cruz
New Connection · Jun 10
✅ Finance
🎉 Completed
APP-2026-0088
Salvador Flores
Completed Jun 18
APP-2026-0124 New
New Connection · Jun 29, 2026
👤 Applicant
Name
Pedro Santos
Mobile
+63 917 234 5678
Address
Lot 12 Blk 4, Brgy. Malipayon, Manolo Fortich, Bukidnon
DMA
DMA-03 Malipayon
Connection
New · Residential · 1/2"
Location Pin
📍 8.3742° N, 124.9812° E
Geofence
✅ Within service area
📍 Location
🗺️
DMA-03 Malipayon, Manolo Fortich
📍
✓ Within service area
🔄 Workflow
Application Submitted
Jun 29, 2026 · Applicant
Awaiting Assignment
Current step
Technical Review
Field Survey
💳 Payment (Application Fee)
₱350 application + ₱1,500 deposit
Install reported (serial captured)
🔗 Bind Device & Activate
Hard gate · account goes Active on confirmed read
Disputes
NWRB SLA: Ack 5 biz days · Resolve 15 biz days
🚨 2 disputes approaching the 5-day acknowledgment deadline.
Reference
Account
Customer
Type
Filed
Dept
Ack. By
Resolve By
Status
DISP-2026-0047
2024-00321
Maria Gomez
Bill
Jun 29
⏳ Unassigned
Jul 4 ⚠
Jul 14
Open
DISP-2026-0041
2024-00845
Juan dela Cruz
Meter
Jun 4
📋 Billing
Jun 7 ✓
Jun 19
Under Review
DISP-2026-0039
2023-00701
Ramon Yu
Meter
Jun 2
🏗️ Infrastructure
Jun 5 ✓
Jun 17
Under Review
DISP-2026-0041 Under Review
Meter dispute · Filed Jun 4, 2026
⚖️ Dispute Details
Account
2024-00845
Customer
Juan dela Cruz
Type
Meter reading
Assigned Dept
📋 Billing Dept
Complaint
"My May bill shows 18 m³ but I was away the whole month. Please verify the meter reading."
📅 SLA Tracking
FiledJun 4, 2026
Acknowledge byJun 7 ✓
Resolve byJun 19
🔄 Resolution Stepper
Filed
Jun 4 · Customer
Submitted via member portal
Acknowledged
Jun 7 · Carlo Diaz (CS)
"Received. Forwarding to Billing for meter audit."
Under Review
Current · Billing Dept
"Pulling LoRaWAN read history for May."
Resolved
Service Requests
Department-routed tickets
Reference
Account
Customer
Type
Filed
Department
Status
SR-2026-0035
2022-00445
Julio Santos
Street Leakage
May 28
🏗️ Infrastructure
In Progress
SR-2026-0048
2023-00701
Ramon Yu
Mainline pressure
Jun 5
🏗️ Infrastructure
Open
SR-2026-0044
2024-00990
Lita Cruz
Leak after meter
Jun 4
🔧 Maintenance👁 read-only
In Progress
SR-2026-0042
2024-00845
Juan dela Cruz
Meter Faulty
Jun 3
🔧 Maintenance
In Progress
SR-2026-0039
2024-00612
Arturo Valdez
No Water
Jun 1
🔧 Maintenance
In Progress
SR-2026-0051
2025-00322
Nora Lim
Reconnection
Jun 7
🛠️ Installation
Open
SR-2026-0053
2022-00118
Delia Cruz
Street Leakage
Jun 8
⏳ Unassigned
Open
SR-2026-0042 In Progress
Meter Faulty · Filed Jun 3, 2026
🔒 This ticket is assigned to 🔧 Maintenance. Only Admin, Customer Service, or the assigned department can move it. Every move requires a comment.
🔧 Request Details
Account
2024-00845
Customer
Juan dela Cruz
Type
Meter Faulty
Assigned Dept
🔧 Maintenance
Description
"Meter glass is foggy and dial not visible. Requesting inspection."
What this role can access (see full matrix under Users & Roles → Permission Matrix).
Customer AccountsView / Edit
Billing & RatesNo access
Service ticketsAssigned dept only
Move ticketsOwn dept + comment
Users & RolesNo access
Permission Matrix
Who can access / act on what
Module
Admin
Billing
Cust. Service
Cashier
Department
Customer Accounts
✏️ Full
✏️ Edit
✏️ Edit
👁 View
—
New Application
✅
—
✅
—
—
Bill Generation
✅
✅
—
—
—
Rate Management
✅
✅
—
—
—
Disconnection
✅
✅
—
—
—
Collections
✅
✅
—
👁 Own shift
—
Applications
✅
—
✅
—
🎯 Assigned
Disputes
✅
👁
✅
—
🎯 Assigned
Service Requests
✅
—
✅
—
🎯 Assigned
Move / advance ticket
✅ Any
—
✅ Any
—
✅ Own dept
Infrastructure / Map
✅
—
—
—
🎯 Infra only
Bulk Notices
✅
✅
—
—
—
Users & Roles
✅
—
—
—
—
Audit Log
✅
—
—
—
—
🔒 Ticket movement rule: once assigned to a department, only Admin, Customer Service, or that assigned department can advance the ticket — and every transition requires a comment, stored on the ticket's audit trail.
Audit Log
Immutable system log
💰
Payment Posted — 2024-00845
₱842.00 · OR #20260629-0051 · Ana Reyes
Jun 29 10:32 AM
👤
Account Viewed — 2024-00845
Maria Santos (Billing Officer)
Jun 29 9:48 AM
🔧
Ticket Moved — SR-2026-0042 → In Progress
Tonio Bautista (Maintenance) · "Scheduled site visit Jun 30 AM."
Jun 29 9:10 AM
🔔
Disconnection Notice — 2023-00124
Day 56 · Maria Santos
Jun 28 4:12 PM
💹
Rate Schedule Updated
Basic ₱265→₱280, Excess ₱35→₱38 · Jessa Ramos
Apr 1 9:00 AM
Device Inventory
LoRaWAN devices synced from NWM · Manolo Fortich
📡 NWM owns device provisioning and connectivity. This registry mirrors device status and enforces 1:1 binding — only Available devices can be bound to an account.
1,291
Total Devices
14
Available
5
Signal Lost
3
Faulty / Retired
DevEUI / Serial
Status
Bound Account
DMA
Last Transmission
LRW-8842-A019
Bound
2024-00845 Juan dela Cruz
DMA-02
Jun 28 · 6:02 AM ✓
LRW-2231-C004
Signal Lost
2023-00445 Alfonso Cruz
DMA-04
May 6 · 5:48 AM ⚑
LRW-9001-F210
Available
—
—
—
LRW-9002-F211
Available
—
—
—
LRW-3320-E118
Faulty
— (RMA)
—
—
LRW-1190-B077
Retired
—
—
—
Showing 6 of 1,291 devices
Bind Device & Activate
Account 2024-00845 · Juan dela Cruz
🔗 Binding links the account to its LoRaWAN device so NWM reads feed billing. Every account requires one bound device — activation is gated on a confirmed read.