Run your site safety program like a real control system — not scattered sheets.
This premium Excel workbook is a complete Site Safety Management & Compliance Tracker built for construction projects that need consistent inspections, stronger follow-up discipline, and executive-ready reporting.
Everything is organized into a connected workflow: inspect → log findings → raise corrective actions → track close-out → verify → report trends — with clean formatting, automated calculations, and a professional dashboard that updates from your logs.
What’s Included in This Workbook (16 Sheets)
✅ Instructions (quick start + how to use)
✅ Site Safety Dashboard (executive overview + charts)
✅ Daily Site Safety Inspection Checklist (shift-based inspections with pass/fail, priority, risk level, photo reference, sign-off)
✅ Weekly Safety Audit Report (category scoring, compliance status, action references, due dates & responsibility)
✅ Monthly Safety Performance Review (monthly rollups for inspections, incidents, near misses, LTIs, open/closed CAs, safety score vs target)
✅ Incident / Accident Log (OSHA recordable flag, root cause, immediate actions, investigation findings, lessons learned, status)
✅ Corrective Actions & Non-Conformance Tracker (priority, due dates, days open, completion %, verification & closure)
✅ Risk Assessment Matrix & Risk Register (5×5 matrix + register with risk score + residual risk scoring + actions & owners)
✅ PPE Compliance & Issuance Tracker (issue dates, expiry, condition, compliance flag, replacement need)
✅ Equipment & Tool Inspection Log (inspection dates, due tracking, certification validity, inspector, notes, status)
✅ Permit to Work Register (permit types, risk level, status, approvals, emergency contact, conditions/notes)
✅ Safety Training Records & Certification Tracker (expiry automation + expiring soon status)
✅ Toolbox Talk / Safety Briefing Log (attendance, key points, actions, sign-off, verified)
✅ Emergency Contacts & Response Directory (services + project team + subcontractors + quick response procedures)
✅ Dropdowns (standardized lists for clean data entry)
✅ Chart Data (feeds the dashboard visuals)
Dashboard Reporting (Auto-Updated Visuals)
The Site Safety Dashboard is designed for PMs, Safety Officers, and leadership reviews. It presents:
✅ Safety Score (overall indicator)
✅ Total Inspections (reporting period)
✅ Open Actions (requires follow-up)
✅ Incidents (MTD)
✅ Monthly Safety Score Trend (line chart)
✅ Inspection Status Breakdown (donut)
✅ Incidents by Type (bar chart)
✅ Corrective Actions Status (donut)
✅ Weekly Incident Trend (line chart)
✅ PPE Compliance Rate (bar chart)
✅ “Top Priority Action Items” table for leadership focus
Built-In Automation (What Updates for You)
This file is built around live formulas + conditional formatting, so your reporting stays accurate as you add records.
✅ Corrective Actions
- Auto-calculates Days Open based on status (Open/In Progress vs Completed/Verified)
- Tracks % Complete, completion date, verified by, and closure date
- Status colors (Open / In Progress / Completed / Verified / Overdue)
✅ Training & PPE
- Auto-calculates Days to Expiry
- Auto-flags Valid / Expiring Soon / Expired
- Highlights items needing replacement or compliance action
✅ Risk Register
- Auto-calculates Risk Score = Likelihood × Consequence
- Auto-labels Risk Level (Low/Medium/High/Extreme)
- Includes Residual Risk scoring after controls
✅ Weekly Audits
- Auto-calculates % Score per category
- Auto-labels Compliant / Partially Compliant / Non-Compliant
- Links corrective action references and assigns due dates & owners
✅ Permits + Equipment
- Auto-calculates Days Remaining / Days Until Due
- Tracks permit status, approvals, and special conditions
- Supports certification validity tracking for equipment/tooling
✅ Incident Management
- Captures immediate action + investigation findings
- Flags OSHA Recordable
- Links incident-driven actions via Corrective Action Ref
Who This Template Is For
✅ Site Safety Officers / HSE Engineers
✅ Construction Project Managers & Site Managers
✅ Superintendents, Foremen, and Field Leaders
✅ PMOs & Quality/Safety Coordinators
✅ Contractors managing multi-trade worksites
✅ Teams preparing for audits, inspections, and compliance reporting
Professional Design + Print-Ready Layouts
✅ Clean, presentation-ready formatting with clear section headers
✅ Conditional formatting that makes risks, overdue actions, and compliance gaps visible instantly
✅ Suitable for weekly safety meetings, client reporting, and audit evidence packs
✅ Uses standardized dropdown lists to reduce data-entry errors
Technical Verification From the Excel File (Quick Check)
✅ 16 sheets found (matches your screenshots)
✅ Dashboard includes 6 charts (trend + breakdown charts as shown)
✅ 500+ formula cells across the workbook powering automation (days open, expiry logic, risk scoring, audit scoring, totals)
✅ No #REF / #DIV/0 / formula error values found in the workbook during scan
✅ No macros / no VBA (corporate-friendly)
How To Use (Simple Workflow)
✅ Fill inspection results in Daily Inspection
✅ Log events in Incident Log if needed
✅ Raise follow-up items in Corrective Actions (and track them to verification)
✅ Track ongoing controls via Risk Register, PPE, Training, Equipment, and Permit to Work
✅ Use Weekly Audit + Monthly Review for structured rollups
✅ Present the Dashboard in weekly safety and management reviews
