Check a service line inventory

Everything happens in this browser tab. Nothing is uploaded: once the page has loaded you can switch off your network and it still works.

Free check · no license

1. Your inventory

EPA's Service Line Inventory Template (.xlsx) or any CSV or Excel file with one row per service line.

Drop your inventory file here

.xlsx or .csv

Choose a file

Last year's inventory (optional, for the annual update)Add last year's file

2. Columns and your water system

Water system name

PWSID

Service connections

Used for the 39-per-1,000 deferred deadline test.

Who owns the service line

Lead ban year (State or local)

Lines installed after this year can be ruled out by date where your State accepts it.

Phone for customers

Email for customers

Website

Replacement plan link (if online)

Health department and phone

Rule out lead on unknown portions installed after the ban year (only if your State accepts installation date as evidence) Rule out lead on unknown portions wider than 2 inches (only if your State accepts diameter as evidence)

Add your inventory file first.

3. Results

Fix before you submit

Replacement pool and pace

Letters to mail

Row

Location

System side

Customer side

Classification

Connector

Found

Downloads

License

The check is free. The files for your own data need a license: Single system $990, Multi-system $1,990 (up to 10), Consultant $3,900 (unlimited), for 12 months. Founding offer: $594, $1,194 or $2,340 with FOUNDING40 until 30 Nov, applied automatically at checkout.

Have a license key?

Keep a copy of your key: paste it on any computer your team uses. Lost it? Reply to your Paddle receipt and we resend it.

Check a service line inventory

1. Your inventory

2. Columns and your water system

3. Results

Fix before you submit

Replacement pool and pace

Letters to mail

Annual update against last year's file

Downloads

License

Have a license key?