Corrective and Preventive Action Tracker
Originally published: 25/03/2020 21:21
Last version published: 15/07/2021 10:00
Publication number: ELQ-64217-5
View all versions & Certificate

Corrective and Preventive Action Tracker

Template for logging nonconformance (NCs) and Corrective and Preventive Actions (CAPAs) for effective tracking purposes

To ensure continuous improvement of the health and safety management system, identifying nonconformance and analyzing their root causes for corrective and preventive actions (CAPA) play pivotal role. Nonconformance are usually identified through Safety Monitoring or Assurance Activities such safety audits, workplace inspections and the like.

SHEQXEL Corrective and Preventive Action Tracker provides the best template for logging all Nonconformance and Corrective and Preventive Actions (CAPAs) for effective tracking purposes.

The tool has 4 main features;

The Approved List is the setting section where Safety Assurance activities and Corrective Action Rate targets usually 100%, are set. A list of safety assurance activities such as internal audits, external audits, workplace inspections, environmental inspections, chemical inspections, safety walkthroughs, hazard hunts etc. have been provided for users to use or update with their own to reflect in source data sheet.

The Source Data features all safety assurance activities, details, location or equipment, nonconformance, roots causes, corrective/preventive actions, responsible person, progress updates, deadlines, deadline status which is dynamically set to show “Not Yet Due”, “Deadline Due Soon”, “Overdue” or “Deadline Met”. The source data dynamically tracks due days, duration used to close action once the user updates action status as closed and provided the closing date.

The Dashboard is dynamically designed with stacked bar charts, clattered column charts and a speedometer chart to visualize all open and closed actions, and progress towards the Overall Corrective Action Rate target.

The rest of the sheets are pivot tables and graphs to show total nonconformance, CAPA (Action) status from Safety Assurance Activities, days CAPA is Due or Overdue; duration Used to Close CAPA and finally the CAPA Register showing all closed vs Open actions & Persons Responsible.

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 Best Practice includes
1 excel file, 3 pdfs

Acquire business license for $19.97

Add to cart

Add to bookmarks


Further information

This designed for logging nonconformance (NCs) and Corrective and Preventive Actions (CAPAs) from Safety Assurance Activities for effective tracking purposes


  • Be the first to review this Downloadable Best Practice

    Write a review

More Best Practices from SHEQXEL

See all

Discussion feed for Corrective And Preventive Action Tracker

The user community and author are here to help. Go ahead!

  • Murtada Al-Luwaimi
    I purchased the dashboard before few days ago and I can't modify it to fit internal audit purposes... I would like to ask if there is any way to make changes to the dashboard
    arrow_drop_uparrow_drop_downReply reply
      Hello Murtada, find the password at the bottom of the welcome page, thus if you wish to customize it. However, you wouldn't need to, as the template is pre-built to work as intended. You only have to work from the source data sheet. After any changes to your data, go to the data tab on the menu and click on "Refresh all" to update the entire workbook. That will update the dashboard and other report.
      arrow_drop_uparrow_drop_downReply reply

    0.0 / 5 (0 votes)

    please wait...