Free fire alarm record · Excel

Free Fire Alarm Completion & Acceptance Record

Run the pre-test, prove the acceptance test and hand the owner a clean record: panel and system info, a device inventory that counts itself from the test log, a battery Ah check, monitoring verification and sign-offs.

  • System, panel, firmware, power source and monitoring details
  • Device inventory by type — tested/passed/failed count from the log
  • Battery check: installed Ah vs. designer's calc, with a cross-check
  • Central station alarm, supervisory and trouble verification
  • Test summary that reads READY FOR ACCEPTANCE only when it is
  • 150-row device test log with drop-downs and FAIL highlighting
  • Own layout — not the NFPA 72 form; AHJ may require the official one

Fire Alarm Completion Record

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

1

Completion Record

Property and system info, panel and power, device inventory with automatic counts, secondary power check, monitoring, test summary and sign-offs.

2

Device Test Log

One row per device — address, type, location, model, test method, reading, panel signal, result, tester and date.

3

Instructions

How to use each tab, pre-test field tips, and code references with verify-against-your-AHJ notes.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

Is this the NFPA 72 Record of Completion?

No. It is Field PM's own completion and acceptance layout. It records the same kinds of information — system and panel details, device counts, secondary power, monitoring, test results and sign-offs — but it is not the NFPA 72 form. Many AHJs require the official Record of Completion; use this workbook to run the pre-test and acceptance test, then complete the form your AHJ requires.

How does the device inventory count itself?

You enter the quantity per drawings and the quantity installed for each device type. The Tested, Passed and Failed columns use COUNTIFS against the Device Test Log, so every PASS or FAIL you log is counted automatically. Each type shows COMPLETE, INCOMPLETE or DEFICIENCIES, and the Test Summary only reads READY FOR ACCEPTANCE when every installed device has passed and no failure is open.

How do you check fire alarm battery size?

Required amp-hours = (standby current × standby hours + alarm current × alarm minutes ÷ 60) × a safety or derating factor from the manufacturer. NFPA 72's secondary power requirements (§10.6.7 in recent editions) commonly call for 24 hours of standby followed by 5 minutes of alarm, or 15 minutes for emergency voice systems. The template compares the installed battery against the designer's calc and recalculates a cross-check from the currents — all values are inputs to verify.

What should be on a fire alarm device test log?

At minimum: device address, device type, location, model or rating, test method (smoke aerosol, heat source, manual operation, duct test port, flow test and so on), any reading such as sensitivity, dBA or seconds, whether the correct signal and label appeared at the panel, the result, who tested it and when. Failed devices should stay on the log with a new row for the retest.

Should the contractor pre-test before the AHJ acceptance test?

Yes. Do a 100% pre-test with your own crew and fix every label mismatch, dead device and sequence-of-operations problem first. The acceptance test should be a demonstration for the AHJ, not the first time the devices see smoke. The same log works for both — add a column note for "pre-test" vs. "acceptance".

Turn over a fire alarm system with the proof attached

A fire alarm completion and acceptance record documents what was installed and how it was proven: the control panel and firmware, the count of every device type, battery sizing, the monitoring connection, device-by-device test results, and the signatures of the contractor, owner and AHJ. It is what the next service technician, the owner's insurer and the fire marshal will ask to see.

This free Excel template is Field PM's own layout — it covers the same kinds of information as NFPA 72's Record of Completion, but your AHJ may require the official form. The device inventory counts itself from the test log, and the battery check compares installed amp-hours against the designer's calculation with an independent cross-check.

Use it alongside the sprinkler piping test record for waterflow and tamper tie-ins, and the voltage drop calculator for NAC circuits.

A foreman's guide to fire alarm completion and acceptance testing

Fire alarm acceptance day goes one of two ways. Either the AHJ walks the building with your technician, every device reports the right address and label, the elevator recalls, the air handlers shut down, the central station calls back, and the inspector signs — or you find out at device 14 that the program was loaded from an old revision and you're rescheduling in three weeks. The difference is almost always the pre-test and the paperwork behind it. This guide covers how to use the free Excel fire alarm completion record and device test log above to get the first outcome.

What the completion record is for

The completion record is the one-page summary of what was installed and how it was proven: the panel and its firmware, how many of each device are in the building, how the batteries were sized, how the system talks to the monitoring company, and who signed off. It is the first thing the next service technician reads, and it's what the owner's insurer asks for when something goes wrong.

This template is Field PM's own layout. It records the same kinds of information as NFPA 72's Record of Completion, but it is not that form, and many AHJs require the official one. Use this workbook to organize and prove the test, then fill in the form your AHJ requires from it.

Walking through the Completion Record tab

Property, system and panel

Record the property, occupancy, AHJ and permit number, installing contractor and license, the designer and NICET certification, the approved drawing revision, the system type (addressable horn/strobe, voice evacuation, conventional) and scope. For the panel: manufacturer, model, serial, firmware version, location, annunciators, SLC loops and NAC circuits, NAC power extenders, and the primary power source — panel and circuit number, with the breaker locked and marked. Save the program file to the owner; it's the fastest way to restore a panel after a lightning hit.

Device inventory — counts itself

For each device type — smoke, heat, manual pull, duct smoke, beam, waterflow, supervisory, horn/strobe, strobe, speaker/strobe, control/relay module and monitor module — enter the quantity per drawings and the quantity installed. Tested, Passed and Failed are counted from the Device Test Log automatically. When drawings and installed quantities don't match, the total row flags it — document the change with an RFI or field change before the AHJ counts devices for you.

Secondary power (battery) check

Enter total standby current, standby period, total alarm current, alarm period, and the manufacturer's safety or derating factor. The sheet calculates a cross-check:

  • Ah = (standby A × standby hr + alarm A × alarm min ÷ 60) × factor

With 0.842 A standby for 24 hours, 3.65 A alarm for 5 minutes and a 1.2 factor, that's about 24.6 Ah — so a pair of 26 Ah batteries passes. NFPA 72's secondary power section (§10.6.7 in recent editions) commonly requires 24 hours standby followed by 5 minutes of alarm, or 15 minutes for emergency voice/alarm communication — verify against the edition your AHJ adopted. The most common battery failure on acceptance day isn't a bad battery; it's a battery calc that was never updated after a change order added thirty strobes.

Monitoring

Record the monitoring company, account number, communicator type (DACT, cellular, IP, radio) and whether both communication paths were verified. Send an alarm, a supervisory and a trouble signal and confirm with the central station operator that each came through with the correct zone or point description. Write down the operator's name and time.

Test summary and sign-offs

The summary rolls up devices installed, tested, passed and failed and reports DEFICIENCIES OPEN, TESTING INCOMPLETE or READY FOR ACCEPTANCE. Confirm the sequence of operations matrix was verified and that audibility or intelligibility readings are attached. Sign-off rows cover the installing contractor or lead technician, the designer, the owner, the AHJ and the monitoring company.

The Device Test Log

One row per device, 150 rows ready to go: address, device type (drop-down), location, model or rating, test method (drop-down), reading, whether the panel showed the correct signal and label, result, tester and date. Conditional formatting turns FAIL red and "No" at the panel red, so problems jump out on a printout.

A few rules that keep the log honest:

  • Never overwrite a FAIL. Fix the device, retest, and add a new row with the same address. The history is the proof.
  • Test with two people. One at the device, one at the panel reading back the address and custom label. Most acceptance failures are programming or label mismatches, not bad hardware.
  • Use the right test method. Listed aerosol for smoke detectors, a listed heat source for restorable heat detectors, and electrical or mechanical testing for non-restorable heat detectors per the manufacturer and the NFPA 72 test methods table.
  • Record readings. Sensitivity values, dBA with ambient noted, waterflow time in seconds. Numbers beat "OK" when someone questions the test later.

Don't forget the interfaces

The devices are the easy part. Acceptance tests fall apart at the interfaces with other trades, so walk the sequence of operations matrix line by line:

  • Elevator recall — primary and alternate floors, and the machine-room/hoistway heat detector shunt trip
  • HVAC shutdown on duct detector activation, and fire/smoke damper operation
  • Door holder release and access-control unlock where required
  • Sprinkler waterflow (within the required time) and valve supervisory switches — see the sprinkler piping test record
  • Kitchen hood suppression and other special-hazard systems monitored by the panel

Get those trades' foremen on site for the pre-test, not just the acceptance test.

Before you call for the AHJ

  1. 100% pre-test complete, every FAIL retested and closed on the log
  2. Battery calc current and matching the installed batteries
  3. Central station has the correct point list and confirmed all three signal types
  4. NAC circuits checked for voltage drop at the end of line under full alarm load (see the voltage drop calculator)
  5. As-builts, program file, battery calc and this record ready in the documentation cabinet if required

From spreadsheet to live test records

On a large building the device log runs to thousands of rows, and the pre-test is spread across several technicians and days. Field PM's QA/QC module lets each technician log tests from a phone, attach photos, and roll results into one record the PM can see in real time — with hold-point workflows so ceilings don't close before devices are verified. Start a free 30-day trial — no credit card required.

Related templates and tools

Code values in this template are inputs; section numbers vary by edition. Verify against the edition adopted by your AHJ, local amendments and the approved drawings. Not engineering advice.

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice