A field guide to sprinkler acceptance testing and the test record
Sprinkler systems don't get turned over on a handshake. Before the AHJ signs off, the installing contractor has to prove the piping is tight, the underground is clean, the alarms work, and the water supply can actually deliver the design demand. The paperwork that proves it — the test record — is what the fire marshal, the owner's insurer and, years later, the ITM contractor will all go back to. This guide walks through each section of the free Excel sprinkler piping test record above, with the kind of detail that saves a re-test.
Why the test record matters as much as the test
A system that held 200 psi for two hours but has no signed record might as well not have been tested. Inspectors change, superintendents move to the next job, and gauges get borrowed. When there's a leak at a coupling eighteen months later, the first question from the owner's carrier is "show me the hydro." A complete record — test segment, required and actual pressure, start and end times, gauge readings, and who witnessed it — ends that conversation.
The template is Field PM's own layout. It captures the same kinds of information as NFPA 13's Contractor's Material & Test Certificate for aboveground and underground piping, but it is not that form. Many AHJs require the official certificate; use this workbook to run and document the tests in the field, then transcribe or attach the form your AHJ requires.
Section by section
Project, system and materials
Record the riser, the area and floors served, the system type (wet, dry, preaction, deluge, antifreeze), the design basis (hydraulic calc or pipe schedule), the hazard classification and the number of sprinklers. The materials table lists pipe, fittings and joining method, sprinklers (K-factor and temperature), hangers and seismic bracing, valves, underground pipe, the backflow assembly and the FDC — with a Listed / Approved column. If you substituted a product during construction, this is where it shows up on paper.
Hydrostatic tests
Each row is one test segment: aboveground by riser or zone, the underground lead-in, the FDC piping. Enter the required test pressure and duration, the actual start and end date/time, and gauge readings at start and end. The sheet calculates actual duration and pressure drop and returns PASS only when the gauge met the required pressure, the duration was met, and the drop is within the allowable you entered (zero for aboveground in most cases).
The common requirement in NFPA 13 is 200 psi for 2 hours, or 50 psi above maximum static pressure where static exceeds 150 psi (§25.2.1 in the 2016/2019 editions — the section number moves between editions). Treat that as a starting point and verify against the edition your AHJ adopted and the project specification.
- Gauge at the low point. The reading the AHJ cares about is at the lowest elevation of the section being tested.
- Vent the high points. Trapped air goes into solution and looks like a leak.
- Watch the temperature. Cold water in a warm building gains pressure; the reverse loses it. Note conditions when the gauge moves without a visible leak.
- Protect what can't take the pressure. Isolate or remove internals on devices not rated for test pressure, per the manufacturer.
Underground leakage
Underground mains are tested by measuring the make-up water needed to hold test pressure. The template applies the allowable-leakage formula used in NFPA 24: L = S × D × √P ÷ 148,000 (gallons per hour), with S = length tested in feet, D = nominal diameter in inches and P = average test pressure. A 420-foot run of 6-inch main at 200 psi allows about 0.24 gph; measured make-up of 0.3 gallons over two hours (0.15 gph) passes. Some editions and AHJs add allowances for valves or hydrants — check yours.
Flushing
Flushing the underground before it is tied to the riser keeps rocks, gaskets and pipe shavings out of the sprinklers. Minimum flushing flow rates are tabulated by pipe size in NFPA 24; enter the required rate for your pipe size and the flow you actually achieved (by pitot or meter), and confirm the water ran clear. If the supply can't produce the table flow, document the maximum available and get the AHJ's acceptance in writing.
Dry-pipe and preaction trip tests
For dry systems, record air pressure before the trip, water supply pressure, trip-point air pressure, time to trip, and time for water to reach the inspector's test connection. NFPA 13 caps the water delivery time on larger dry systems (commonly 60 seconds, depending on system volume and hazard) — that limit is an input. The 24-hour pneumatic test (commonly 40 psi with no more than 1.5 psi loss) is also in the template, with both values editable.
Alarms, backflow and FDC
Flow the inspector's test and time the waterflow alarm at the panel (commonly required within 90 seconds). Verify exterior bells, valve supervisory switches, the backflow forward-flow test at system demand with the certified tester's name, and the fire department connection: location, hydrostatic test, thread type matched to the local fire department, signage, caps and check valve.
Main drain baseline
Record static and residual pressure with the main drain full open. This number is gold for the owner's ITM contractor: a future annual main drain test that reads more than about 10% below this baseline usually points to a partially closed valve or an obstruction in the supply.
The hydraulic calc summary tab
The hydraulic calculation of record is the designer's job, but the field team still needs to know whether the system works with the supply that exists today. The Hydraulic Calc Summary tab takes the design area, density, calculated sprinkler flow and hose allowance, and the required pressure at the base of the riser. It then builds the water supply curve from your flow test:
- Supply pressure at demand = Ps − (Ps − Pr) × (Q ÷ Qf)^1.85
- Available at base of riser = supply pressure − 0.433 × elevation − losses (backflow, meter, underground friction)
- Safety margin = available − required, in psi and as a percent
NFPA 13 doesn't set a universal cushion, but many specs, insurers and AHJs want at least 10 psi or 10%. If the margin is thin, check the age of the flow test, seasonal demand on the water system, and whether a backflow preventer was added after the calc was run — that's a common way to lose 5–10 psi without anyone noticing. The tab is a check and a record, not a substitute for the designer's calc.
The ITM checklist tab — hand it to the owner
Once the system is accepted, the owner is responsible for inspection, testing and maintenance under NFPA 25. The ITM Inspection Checklist lists the common items — gauges, control valves (sealed and supervised), waterflow and supervisory devices, the main drain test, the FDC, sprinklers and spares, backflow, dry valves, internal pipe assessment, hangers and signage. You enter the interval from the NFPA 25 edition and the owner's program; the sheet calculates the next due date and flags anything OVERDUE or due within 30 days. Example intervals are included for illustration only — frequencies differ by edition, device type and insurer, so replace them with yours.
Common reasons sprinkler tests fail on the day
- No calibrated gauge. Inspectors increasingly ask for the calibration date. Keep a dedicated test gauge with a current sticker.
- Air in the system. Slow pressure decay that stops after an hour is usually air, not a leak. Vent before starting the clock.
- Unflushed underground. An AHJ that shows up for the riser hydro and finds no flushing record will stop there.
- Alarm timing. A vane switch with the retard set too long, or a panel program that treats waterflow as supervisory, fails the alarm test.
- Missing witnesses. If the AHJ or owner's rep had to leave, get their signature on the record the same day or plan to repeat the test.
From paper test record to a searchable QA/QC history
On a multi-riser or multi-building job, test records multiply fast — and the one you need is always in someone else's truck. Field PM's QA/QC module lets the foreman fill test records and inspection forms from a phone, attach gauge photos, collect signatures from witnesses, and file the PDF straight into the project's Job Book. QA/QC workflows add hold points so the ceiling doesn't close before the hydro is signed. Start a free 30-day trial — no credit card required.
Related templates and tools
- Fire alarm completion & acceptance record — waterflow and tamper devices tie in here
- Inspection request log — track the AHJ hydro and final inspections
- Hot work permit — for welded outlets and cut-ins on existing systems
- Steel pipe schedule chart — wall thickness and ID by schedule
- Project closeout checklist — test records are part of turnover
- Browse all free construction templates
Code values in this template are inputs; section numbers vary by edition. Verify against the edition adopted by your AHJ and the project specification. Not engineering advice.
