Insights / The Hidden Cost of Managing Fire Extinguisher Inventory in Excel
The Hidden Cost of Managing Fire Extinguisher Inventory in Excel
28 August 2026 · GRC Teknoloji · 7 min read
In many facilities, the fire-extinguisher inventory is an Excel file containing the building, floor, room, device type and last refill date. The file may look orderly and can be printed before an inspection. Listing devices, however, is not the same as managing their inventory.
A list answers “Which devices do we have?” An auditable inventory must answer a more demanding question for every asset: Who performed which task, when and under what requirement; what did they find; what evidence did they produce; and when is the next action due?
Why is Excel not an inventory by itself?
Excel is not inherently the wrong tool. The problem is that it is commonly used as a current-state table rather than an event record. A cell reading “Last maintenance: 03/2026” does not show the intervening field inspections, when a missing pin was discovered, who received the corrective task or whether it was closed.
Three structural gaps are common:
- History is overwritten. When a cell changes, the previous value and its justification often disappear.
- The author and location of the record are unclear. Field inspection and office data entry become disconnected.
- The schedule is passive. A spreadsheet does not normally assign an approaching task or escalate an overdue one unless someone opens and reviews it.
The main risk is therefore not a typing error. It is the appearance that records exist while the underlying audit trail is incomplete.
Separate the three layers of obligation
In Türkiye, portable extinguishers are affected by building fire-safety rules, occupational requirements for work-equipment controls and rules applying to maintenance and refilling service providers.
| Layer | Principal basis | Inventory implication |
|---|---|---|
| Building fire safety | Regulation on Fire Protection of Buildings, Article 99 | Quantity, location, access, annual general checks and fourth-year actions |
| Occupational safety | Regulation on Health and Safety in the Use of Work Equipment, Annex III | Authorised person, periodic-control process, contract and report |
| Service provision | TS 11827 and the related mandatory-standard communiqué | Service facility, personnel, labels, maintenance and refill records |
All three concern the same asset, but they do not describe the same activity. An inventory based only on a “last refill date” makes those distinctions invisible.
Inspection, maintenance and periodic control are different records
A field check confirming that an extinguisher is present, accessible, sealed and visible is not the same task as maintenance performed by a qualified service provider. Scope and interval must be established from the applicable legislation, standard edition, risk assessment, manufacturer instructions and organisational procedure.
A typical field inspection considers whether:
- The device is in the correct, accessible location,
- Instructions and labels remain legible,
- The safety pin, seal, hose and body are intact,
- Corrosion, impact damage, leakage or discharge is evident,
- The pressure indicator, where fitted, is in the acceptable range,
- New furniture or changes to the layout obstruct access.
An annual service report does not replace those field checks. Likewise, a service label attached to the cylinder is not the complete service report, corrective-action record or chain of responsibility.
A spreadsheet cannot resolve the four-year/ten-year discussion
Article 99 of Türkiye’s building fire regulation provides for annual on-site general checks and, at the end of the fourth year, renewal of the extinguishing agent together with hydrostatic testing. In applications referring to TS ISO 11602-2, different interval statements may also be encountered for hydrostatic testing.
This should not be reduced to deciding whether one spreadsheet cell should contain “4” or “10”. The current legislation applicable to the facility and device, the relevant standard edition, manufacturer instructions and qualified-service assessment should be documented together. The inventory should hold separately:
- The planned action date,
- The legislation, standard, instruction or internal procedure that establishes it.
If a requirement changes, the organisation can then identify the affected device group instead of editing hundreds of dates without retaining their rationale.
Outsourcing service does not remove responsibility
Buying maintenance from an external provider does not automatically remove the facility manager’s or employer’s tracking responsibility. The contractor performs the work; the facility still needs to verify that the right asset was serviced on time, the report was received and any finding was closed.
At least five roles should be distinguishable:
- The operational owner of the device,
- The person performing the field inspection,
- The person or organisation performing maintenance or periodic control,
- The person assigned to close a finding,
- The authorised person reviewing and accepting the evidence.
“The maintenance company handles it” does not, by itself, prove any link in this chain.
What does the 2025 amendment indicate?
Türkiye amended its work-equipment regulation on 23 December 2025. The definitions concerning equipment-inspection organisations and the EKİPNET module were updated. According to the Ministry’s explanation, the requirement for the employer and authorised person to approve an İSG-KATİP contract no later than one day before periodic-control service was reinforced, while isekipmanlari.csgb.gov.tr was established as an official channel for equipment-specific criteria.
This does not mean every routine field inspection is entered into İSG-KATİP. It does show the direction of travel: authority, contracts, criteria and reports are being connected to more traceable digital records. A facility inventory should be capable of linking the official report to the correct asset identity and supporting evidence.
What QR adds: evidence before speed
A QR code neither performs maintenance nor determines compliance. In a properly designed process, it makes three tasks more reliable:
- It opens the correct asset by its unique identity.
- It encourages the record to be created beside the physical device.
- It connects earlier findings, photographs, documents and open tasks to the same asset.
The value lies in the workflow after scanning: a consistent checklist, mandatory fields, visible overdue tasks and a preserved change history.
Snopero brings fire-safety assets into one inventory and connects QR-based field records with location data, maintenance and end-of-life reminders, service documents and task status. Snopero does not provide maintenance or technical inspection; it supports the recording and tracking of work performed by qualified people.
Minimum data model for an auditable inventory
An asset record needs more than a serial number and a date:
- Identity: unique asset ID, manufacturer, model, serial number, agent type and capacity,
- Location: site, building, floor, zone and point, including movement history,
- Lifecycle: manufacture, commissioning, refill, test and end-of-life dates,
- Events: inspection, maintenance, periodic control, fault, use, refill and disposal,
- Evidence: photographs, service labels, reports, certificates and invoices,
- Responsibility: people who performed, approved, received and closed the work,
- Status: compliant, monitor, out of service, at service provider or disposed.
This model still answers “How many devices do we have?” More importantly, it answers “What has happened to this specific device?”
A migration plan that preserves your spreadsheet
The existing file can be used as starting data:
- Give every device a permanent unique identity.
- Separate duplicate rows that share a serial number or location.
- Do not guess missing dates; mark them unknown and create a verification task.
- Standardise the location tree as site–building–floor–zone–point.
- Separate current state from event history; save every inspection as a new event.
- Link service reports to asset records and turn findings into assigned tasks.
- Match QR labels to devices in the field and perform a sample verification.
- Monitor upcoming, overdue and missing-evidence work separately.
After migration, Excel can remain an export and reporting format. The primary record, however, should preserve history and connect field work to the identity of the physical device.
Conclusion
The hidden cost of extinguisher inventory is not the spreadsheet licence. It is the missed date, lost report, ownerless task and history reconstructed on the morning of an inspection.
Good inventory management does not mean collecting more data. It means keeping the right asset, the right person, the work performed at the right time and the resulting evidence in one chain.
Sources
- Regulation on Fire Protection of Buildings — Turkish Legislation Information System
- 23 December 2025 work-equipment regulation amendment — Ministry of Labour
- Regulation on Health and Safety in the Use of Work Equipment
- Communiqué concerning TS 11827, MSG-MS-2018/7
- ISO/TS 11602-2:2010
- Snopero fire-safety asset management software