Are you looking for a simple and better system for auditing the safety management system of your organization or a supplier?

Basic Safety Auditing Tool is the template you need if you want a concise tool with precise audit questions to audit all the relevant elements of a safety management system and produce a graphical representation of the audit performance. This is basically because you want to audit a low-risk company with a very basic management system.

The tool has 8 features; 

The Audit Scoring Criteria outlines the audit scoring criteria and definitions for what constitutes compliance, major and minor noncompliance, and opportunity for improvements (OFIs)

The Audit Checklist is a series of questions populated in the form of a checklist to address the requirements of a safety management system such as management leadership, worker participation, hazard identification, and risk assessment,  hazard prevention and risk control, training and awareness, evaluation, and improvement and contractor management.

The Audit Summary is the summary of the audit sections, audit findings, and their respective scores which automatically populates from validated reference numbers. This sheet is protected and locked as it is built with sensitive excel formulas to automate the population of reports. There is no need for users to tamper with this sheet due to the automation.

The NC, CAPA & Action Plan is the sheet for logging all NCs, types of nonconformance, root causes, corrective and preventive actions, action status, and action plan. This sheet automatically populates major and minor NCs as users complete their audits. The sheet has a slicer for filtering out the blanks, columns for assigning a responsible person to close action, and providing action priority and action deadlines to automatically estimate days due or overdue. It is also conditionally formatted with color codes for action priority, action open or closed, and days due or overdue.

The Dashboard is dynamic and beautifully made of clattered column chart to represent the various compliance levels of each section of the management system and a stacked column chart representing the number of Compliances, Major and minor nonconformance snd OFIs with a progress chart representing the overall audit score.

The Safety Compliance Sheet shows all the elements of the management system and their levels of compliance and compares against a 100% target to provide an overview of how an organization has performed on various sections.

The Compliance, NC, and OFIs are presented in the unique counts on a table to give an overview of audit performance.

The Audit Findings give the sum of Compliance, NCs, and OFIs in the graphical representation to give an overview of audit performance.

This is a Microsoft excel file hence no installation is required and can run on both Windows and Mac with Microsoft Excel 2013 (+ Later Versions)

This is a FREE add on to the Full Pack