Restoring Billing Accuracy for a Municipal Water Utility After a Catastrophic Storm
- May 27
- 2 min read
How Raybern Consulting diagnosed and resolved a years-long AMI and billing breakdown — and charted a path back to full operational health.
Background & Challenge
A municipal water utility invested in an Advanced Metering Infrastructure (AMI) system for real-time consumption visibility and billing accuracy. In 2018, a Category 5 hurricane wiped out on-premises servers hosting both the AMI platform and billing software. The city migrated to cloud-hosted environments, but a critical link between the two systems was never fully restored. By late 2024, the problems had compounded into a full billing crisis — field crews working reactively, customers receiving inaccurate estimates, and no mechanism to catch failing equipment before bills were missed.
Our Approach: Discovery First, Solutions Second
Raybern conducted three days of on-site Discovery Workshops — structured interviews across field operations, billing, IT, engineering, and city leadership — combined with a live field survey alongside technicians and a forensic review of AMI software, billing configurations, and data files. This allowed us to identify root causes, not just symptoms.
Key Findings: Five Root Causes Behind Years of Missed Reads
Base Station Outage Water-damaged switch took the tower collector offline, reducing read rates city-wide. | Corrupted Data Sync File Billing-to-AMI link pulled active and inactive accounts simultaneously, creating duplicate records that blocked synchronization entirely. |
Widespread Equipment Failures Hundreds of meters and endpoints were non-communicating due to dead batteries, errors, end-of-life hardware, and physical damage. | Meter Swap Collisions Hundreds of meters were not being read because old endpoints weren't deactivated before replacements were installed. |
Recommended Next Steps
Rebuild and validate the data sync file.
Automate billing-to-AMI sync with city IT and the billing vendor to eliminate future data drift.
Prioritize meter replacement: large commercial first (highest revenue risk), then in-warranty, then out-of-warranty units.
Clean AMI data: remove inactive meters and endpoints, resolve data collisions, and clear nearly 10,000 backlogged alerts.
Deliver best-practice guidance on alert monitoring, swap procedures, and bill estimation methodology.
Document improved processes as interactive workflow SOPs — durable playbooks for staff training and long-term sustainability.
Expected Outcomes: From Reactive to Resilient
📡 Restored AMI Coverage All three base stations back online, data flowing reliably to billing for the first time since 2018. | 💧 Accurate Billing Estimated bills eliminated at the source, with corrected methodology as a fallback. | 🔔 Proactive Alerts Staff trained to monitor and resolve AMI alerts before they become billing issues. |
🔧 Fewer Field Errors Standardized swap procedures eliminate data collisions and ensure every replacement is recorded correctly. | 📈 Revenue Protection Commercial meter priority replacements close highest-value billing gaps first. | 📋 Lasting Playbooks Interactive SOPs let staff sustain improvements without ongoing consultant support. |
Facing similar challenges? Raybern Consulting helps water utilities diagnose AMI failures, correct billing data, and build a clear path forward.
Comments