Lead Service Line Inventory: A Living Data System

Every public water system in the country had to hand its state a lead service line inventory by October 16, 2024. Many treated it as a one-time submission, built a spreadsheet, sent it in, and moved on. That is the mistake. Under the EPA’s Lead and Copper Rule Improvements, the inventory is a living record that has to be updated, verified, made public, and turned into a replacement plan by November 1, 2027.

This guide covers what a lead service line inventory has to contain, why it is a data project rather than a plumbing project, and how a utility can maintain it on tools it likely already owns.

What is a lead service line inventory?

A lead service line inventory is a water system’s record of the material of every service line connecting its mains to customers, classifying each as lead, galvanized requiring replacement, non-lead, or lead status unknown, on both the utility-owned and customer-owned portions of the line.

The federal requirements give it a clear shape. Under the EPA’s Lead and Copper Rule, water systems had to:

  • Submit an initial service line inventory by October 16, 2024
  • Classify both the system-side and customer-side portion of each line
  • Make the inventory publicly accessible and notify affected customers
  • Produce a baseline inventory and a replacement plan by November 1, 2027
  • Keep reducing the count of lead and unknown lines over time

It is a data project, not a plumbing project

Replacing a lead service line is plumbing. Knowing which of your tens of thousands of lines are lead, and proving it, is data, and the data is where systems struggle.

The material records are scattered across decades of tap cards, permit files, GIS layers, and the memories of long-serving staff. A large share of lines start life classified as unknown, and every unknown is both a compliance liability and a field investigation waiting to happen. As crews verify materials during other work, the inventory has to absorb those updates. As customers ask about their own line, the utility has to answer from the same record the state sees. A static spreadsheet cannot keep up with any of that.

The systems that handle this well treat the inventory as a maintained database that gets better over time, not a document that was true on one day in 2024. Every verification, every replacement, every new tap updates the same record, and the public view and the state submission both draw from it.

Where a maintained inventory can live

A water utility running Microsoft 365 already has the pieces to run the inventory as a living system rather than a frozen file.

SharePoint or Dataverse can hold the line records with both the system-side and customer-side classification and the evidence behind each. Power Apps can give field crews a mobile form to record a material verification the moment they expose a line during other work, so the inventory improves as a byproduct of normal operations. Power Automate can flag unknowns for follow-up and route customer inquiries. Power BI can produce both the required public-facing view and the internal dashboard that tracks how the unknown and lead counts are falling toward the 2027 milestones.

On licensing: E1, E3 and E5 include seeded rights to build Power Apps and Power Automate over SharePoint, and E5 includes Power BI (Microsoft Power Platform Licensing Guide, August 2026). Field verification, public reporting and progress tracking are within reach of licences most utilities already hold, with the record kept in a tenant they control, which matters when the same data has to be both public and audit-ready.

COMPLIANCE ON MICROSOFT 365

Is your lead inventory a living system or a frozen spreadsheet?

Nexinite builds a maintained lead service line inventory, field verification and public reporting into the Microsoft 365 your utility already runs, so it keeps improving toward the 2027 milestones. In your own tenant, no forever licensing.

Explore the Unified Utility Management Platform

The 2027 milestones the inventory has to serve

The 2024 submission was the start line, not the finish. The Lead and Copper Rule Improvements set a compliance date of November 1, 2027, and the inventory feeds several of its requirements.

Requirement What the inventory must support
Baseline inventory An updated, validated line-by-line record
Replacement plan A prioritized plan to remove lead lines
Lowered action level Supporting data as the level drops to 10 ppb
Reducing unknowns Steady field verification of unknown lines
Public accessibility A current, customer-facing view of the data

The requirement that quietly drives the rest is reducing unknowns. Every line left classified as unknown is treated with caution and complicates the replacement plan, so the utilities in the best position for 2027 are the ones verifying unknowns steadily now, as a routine part of field work, rather than facing a wall of them later.

From inventory to replacement planning

The inventory’s real payoff is the replacement plan it feeds. Once every line has a material and a location, the replacement work becomes a prioritization exercise: which lines, in which order, coordinated with other capital work in the same streets. That is the same discipline as any capital plan, and it connects directly to the capital improvement program. A lead line replacement scheduled alongside a planned road or main project costs far less than one dug up on its own, which only happens if the inventory data and the capital plan share a system.

This is the broader pattern behind our guide to asset management for water and wastewater utilities: good infrastructure data is what turns a compliance obligation into an efficient capital program.

Frequently asked questions

What is a lead service line inventory?

It is a water system’s record of the material of every service line, classifying each as lead, galvanized requiring replacement, non-lead, or unknown, on both the utility-owned and customer-owned portions. The EPA’s Lead and Copper Rule required an initial inventory by October 16, 2024, and a maintained, public version that keeps reducing lead and unknown lines.

When was the lead service line inventory due?

The initial inventory was due to state primacy agencies by October 16, 2024. The Lead and Copper Rule Improvements then set a compliance date of November 1, 2027 for an updated baseline inventory, a replacement plan, and a lowered lead action level of 10 ppb.

Can we manage the inventory on Microsoft 365?

Yes, and treating it as a living system rather than a spreadsheet is the point. SharePoint or Dataverse holds the line records, Power Apps lets crews verify materials in the field, Power Automate flags unknowns, and Power BI produces the public view and progress dashboard. Most of this uses licences a utility already holds (Microsoft Power Platform Licensing Guide, August 2026), with the data in your own tenant.

What do we do about service lines with unknown material?

Unknowns have to be resolved over time through records research and field verification, and until they are, they are generally treated with the same caution as known lead. The efficient approach is to verify unknowns opportunistically whenever a line is exposed for other work, so the count falls steadily rather than all at once before a deadline.

Where to start

Turn the inventory from a submitted file into a maintained system, and start verifying unknown lines as part of routine field work now. The utilities that treat the inventory as living data will reach the 2027 milestones with a plan, while those who filed a spreadsheet and moved on will be rebuilding it under deadline.

Book a call with Nexinite

More from the blog