ABCDEOPQRSTUVWXYZ
1
2
3
Service Line Inventory Template
4
Date last updated: July 27, 2022
5
6
What is the purpose of this template?
The purpose of this draft template is to help water systems and states comply with the service line inventory requirements of the January 15, 2021 Lead and Copper Rule Revisions (LCRR). This template supplements the draft EPA document, Guidance for Developing and Maintaining a Service Line Inventory (2022) by providing fillable forms and tables that water systems can use to document their methods, organize their inventory, submit the initial inventory and inventory updates to the state, and document how they are making the inventory publicly available. This template also provides a checklist for state review. Note that EPA does NOT require systems use this template for their inventory. Refer to EPA's 2022 Inventory Guidance for minimum LCRR inventory requirements, recommendations, and disclaimers.
7
8
How is the template organized?
9
The worksheets in this template are color coded:
Yellow sheets are instructions and background.
Dark blue sheets are templates for systems.
The dark green sheet is a template for states.

See the table below for a description of each worksheet.
The cells in this template are also color coded:
Gray cells are background or instructions.
Light blue cells are fillable cells for systems.
Aqua cells are the required fields in the Detailed Inventory worksheet.
Light green cells are fillable cells for states.
10
11
Template Organization
12
Worksheet TypeWorksheet NameDescription
13
BackgroundTemplate Instructions_SystemContains detailed instructions for systems.
14
Template Instructions_StatesContains detailed instructions for states.
15
Classifying SLsSummarizes requirements for classifying the entire service line when ownership is split (i.e., when the system owns a portion and the customer owns a portion).
16
Templates for Water SystemsPWS InformationFor systems to document basic system information.
17
Inventory MethodsFor systems to document the methods and resources they used to develop and update their inventory.
18
Inventory SummaryFor systems to provide a summary of their service line inventory, including information on ownership, inventory format, and the number of service lines for each of the four required materials classifications. Systems can enter the totals into this worksheet or automatically generate totals based on information in the Detailed Inventory worksheet.
19
Detailed InventoryProvides a customizable format water systems can use to track materials for each service line in their distribution system. Each row equals one service line connecting the water main to the customer's plumbing. Separate columns track location information, the system-owned portion, the customer-owned portion, other possible sources of lead, information for assigning a tap sample tiering classification, and information for lead service line replacement (LSLR). Systems can customize the worksheet by adding or deleting columns.
20
Public Accessibility Doc.For systems to provide documentation to states on how they met the public accessibility requirements of the LCRR.
21
Templates for StatesState ChecklistProvides a checklist that states can use to determine and document if water systems met all of the January 15, 2021 LCRR requirements for their Initial Inventory including timely submission, required elements, use of information sources, public accessibility, and public notification of service line materials.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100