ViewPoints

The conversation about meter data management (MDM) is sometimes focused exclusively on electric utilities. That makes sense — electric utilities were among the earliest adopters of advanced metering infrastructure (AMI), and the challenges of managing millions of interval-reads in a billing and outage context are well documented. But water utilities, and multi-service utilities providing water” are deploying AMI at an accelerating pace, and the data management challenge is just as real.

According to the U.S. EPA’s WaterSense program, AMI provides water utilities with the ability to collect frequent and accurate usage data to improve billing, detect leaks, and manage water resources more effectively. The technology exists. The question is how to put all the data to effective use.

This article explains what MDM does in a water context, how it differs from electric applications, and why the interval data smart water meters generate is only as valuable as the system managing it.

The Water AMI Data Challenge

When a water utility deploys smart meters, it shifts from collecting one monthly reading per account to receiving interval reads typically hourly or every 15 minutes from every meter in the system. For a utility with 10,000 service connections, that is potentially millions of data points per month flowing to legacy systems designed for a single monthly read.

The impact of that volume is easy to underestimate when making the move to AMI: raw interval data is not in itself the same as useful data. Before interval reads can drive billing, identify leaks, or support a conservation program, they need to be collected reliably, validated for accuracy, stored in a structure that allows retrieval, and delivered to the right downstream systems.

This is the same fundamental challenge electric utilities face, and the solution is the same: a meter data management system that sits between the AMI headend and every platform that depends on accurate meter data.

Where Water MDM Shares Ground With Electric

The core MDM functions that electric utilities depend on generally apply to water systems:

Data Collection and Gap Detection

CentralView¹ MDM collects interval reads from water the AMI headend on a defined schedule and automatically flags any gaps in the expected data stream. If a meter fails to report — due to a hardware issue, a communication outage, or a battery problem — MDM identifies the missing reads before they reach billing. Water meters have their own set of failure modes, from frozen endpoints to tampered registers; an MDM system with gap detection logic catches them the same way it catches missed electric reads.

VEE — Validation, Estimation, and Editing

Water meter data validation is the process of confirming that each interval read is within an expected range, consistent with historical consumption patterns, and plausible given what analogous meters are reporting. Reads that fail validation are flagged for review. When reads are missing, estimation fills the gap using historical consumption and a number of industry standard analytical techniques, creating an auditable record that satisfies both billing and regulatory requirements.

For water utilities, accurate VEE is not just a billing issue. Water meter data that has not been validated can mask real problems in the distribution system: a meter reading zero when it should be positive, or a read that is ten times higher than normal, may indicate a hardware failure, a service line issue, or tampering.

Integration with Billing and Customer Information Systems

The meter-to-cash workflow is also like that used by electric utilities. Validated interval reads move from MDM into the billing platform automatically, no manual export, import, or reconciliation between systems. CentralView MDM integrates with CSA’s customer billing and information systems, and with other CIS / billing platforms, to provide the same seamless data flow electric utilities billing rely on.

For multi-service utilities delivering both electric and water services, this integration is particularly valuable. A single MDM platform handling all service types means one validated source of data for each service, rather than separate data management workflows for each.

Where Water MDM Is Different: The Leak Detection Opportunity

While there are many similarities between electric and water AMI solutions, water systems have one use case that with no exact equivalent to electric: the ability to detect leaks at the customer account level, often before the customer knows there is a problem.

This matters because water loss is a significant and persistent operational and financial challenge. According to the American Water Works Association (AWWA), US water utilities lose an average of 16% of the water that is produced, treated, and pumped, but never billed. Some of that loss is physical leakage in the distribution system. Some is apparent loss from meter inaccuracy or billing errors. MDM addresses both.

Account-Level Leak Detection

This is where interval data management for water utilities becomes genuinely different from monthly billing reads. When MDM stores 15-minute or hourly interval data for each service connection, it can identify consumption patterns that indicate a leak — specifically, continuous significant consumption during early morning hours when a property should have zero or near-zero usage.

A running toilet, a slow service line leak, or a failed irrigation valve will register as anomalous consumption in a period when household demand is essentially zero. With only monthly readings, that leak goes undetected until the customer receives a bill several times higher than normal. With MDM flagging such anomalies, the utility can proactively alert the customer before the bill arrives, and before the leak causes further damage or waste.

• Proactive leak alerts — MDM identifies anomalous consumption patterns and triggers alerts to customer service teams.
• Non-revenue water analysis — Interval data lets operations teams compare metered consumption at the district or zone level against production data — isolating where distribution system losses are occurring.
• High-bill dispute resolution — When a customer disputes an unusually high bill, MDM provides the full interval history for that account exactly when consumption spiked, for how long, and at what rate.
• Conservation program support — Usage profiles built from interval data let utilities identify high-consumption accounts, design a targeted conservation outreach, and measure the impact over time.

Regulatory Compliance and Audit Requirements

Water utilities operate in a distinct regulatory environment with specific data retention and reporting obligations. The Safe Drinking Water Act (SDWA) and state-level regulatory frameworks require water systems to maintain accurate records of consumption, billing adjustments, and service history. MDM’s definitive audit trail, documenting every data change, every estimate, and every manual edit, provides the documented record that regulatory reviews and customer dispute processes require.

For water system operators accustomed to paper logs and manual billing reconciliation, the shift to a structured, searchable audit trail represents a meaningful improvement in both compliance posture and operational efficiency.

A Note for Multi-Service Utilities

Many utilities deliver more than one type of service. A municipal utility may provide electric and water service to the same customer base. Managing separate data workflows for each service type adds complexity, increases the risk of billing errors.

The CentralView MDM, from Central Service Association, handles electric and water service data from a single platform. System operators can view daily, monthly, and yearly use and demand across both service types using one system. When VEE flags an exception, the review workflow is the same regardless of service type. When billing runs, all service types draw from the same validated data source.

For multi-service utilities accustomed to managing each service type separately, this is a critical capability.

What Water System Operators Should Evaluate in an MDM Platform

Many of the evaluation questions that apply to electric MDM apply equally to water. AMI headend compatibility, VEE depth, audit trail quality, and billing integration are universal requirements. But water system operators have a few additional considerations:

• Does the platform support your specific water AMI headend? Meter vendors such as Badger Meter, Sensus, Neptune, Itron, and others each have their own headend system and communication protocols. Confirm that the MDM platform you are evaluating is certified with your headend vendor, not just generally compatible. An AMI-agnostic MDM platform that connects to multiple AMI headend systems provides flexibility as metering technology continues to evolve.
• What leak detection and anomaly alerting capabilities does it offer? Ask vendors to demonstrate how their platform identifies continuous-flow anomalies and alerts your billing and customer service teams. A platform that stores interval data without acting on it is a missed opportunity.
• If you deliver more than water, how does it handle multi-service billing? If your utility bills for both electric and water, ask how the MDM platform manages validated data across service types and how billing exceptions in one service type might affect the other.
• What does the audit trail look like for water-specific adjustments? Water utilities make billing adjustments for leak allowances, service interruptions, and meter exchanges. Ask to see how those adjustments are documented in the audit trail and whether the documentation satisfies your state’s regulatory requirements.
• Has it been implemented at water systems of similar size? MDM experience with large electric IOUs does not automatically translate to smaller water utilities. Ask for references from water utilities of comparable size and service structure.

How CentralView MDM Serves Water Utilities

CentralView MDM from Central Service Association (CSA) was built for the operating environment small to medium size utilities that often deliver multiple service types to member communities and need a single platform that handles all of them reliably.

CentralView MDM provides:

• Interval data collection from water AMI headend systems, with automated gap detection and flagging of missed or late reads.
• Full-platform VEE with configurable validation rules for water consumption data, catching reads that fall outside expected ranges, deviate from historical patterns, or conflict with zone-level usage expectations.
• Account-level data storage that supports leak detection, high-bill dispute resolution, and usage analysis for conservation programs.
• A complete and definitive audit trail for every data change, estimate, and manual edit to support both internal billing review and regulatory compliance documentation.
• Native integration with CSA’s customer billing and information systems, so validated water reads move directly into the billing cycle without manual intervention.
• Multi-service support from a single platform — electric, and water managed together, with separate views for each service type.

For utilities currently managing billing data with spreadsheets, manual exports from the AMI headend, or a cumbersome middleware layer, the shift to a purpose-built MDM platform typically recovers significant staff time every billing cycle and reduces the rate of billing exceptions that require manual resolution.

Is MDM the Right Investment for Your Water System Now?

Not every water utility is at the same point in their AMI journey. Some are still reading meters manually or with AMR. Some have recently deployed AMI and are managing data with the headend vendor’s bundled tools. Some are mid-deployment.

The right time to evaluate MDM is before the data management pain becomes acute — not after billing exceptions are backing up and your team is spending three days per billing cycle on manual reconciliation. If your utility is planning an AMI deployment, has recently completed one, or is starting to outgrow your current data handling capabilities, an MDM evaluation is worth your time.

The questions in this article apply equally whether you are managing electric service, water service, or both. The fundamentals of data collection, validation, storage, and integration are the same. Where water service is concerned, the real opportunity is in leak detection and non-revenue water loss, which impacts both operational costs and customer satisfaction.

---

Questions about MDM for your water or multi-service utility?

CSA’s CentralView MDM supports electric, water, and gas from a single platform. Talk to our team about what it looks like for your utility’s specific configuration.

Contact CSA →

---