employee corrective action plan template excel

Employee Performance Improvement and Corrective Action Tracker

This system serves as a centralized registry for managing formal disciplinary documentation, tracking progress toward performance goals, and ensuring compliance with HR policies. It is designed for HR Managers and Department Leads to maintain a historical audit trail. Update this document weekly to reflect status changes or completion of milestones.

Column Definitions

• Date of Incident: [Date] - The calendar date the issue was identified or documented.
• Employee Name: [Text] - The full legal name of the individual under review.
• Category: [Dropdown] - Choose from: Attendance, Performance, Conduct, Policy Violation, or Other.
• Issue Description: [Text] - A concise summary of the observed behavior or performance gap.
• Status: [Dropdown] - Choose from: Pending Review, In Progress, Resolved, or Terminated.
• Target Completion: [Date] - The deadline established for the corrective behavior to be demonstrated.

Essential Formulas

Calculating Days Elapsed Since Incident: Place this in a column titled "Days Active" to track how long an issue has remained open:

=IF(E2="Resolved", "Closed", DATEDIF(A2, TODAY(), "d"))

Status Count Summary: Use this to create a dashboard summary of active cases:

=COUNTIF(E2:E100, "In Progress")

Data Validation and Formatting

1. Status Dropdown: Select the Status column, go to Data > Data Validation, and select "List." Enter: Pending Review, In Progress, Resolved, Terminated.
2. Overdue Alert (Conditional Formatting): Select the "Target Completion" column. Use a formula rule: =AND(F2<TODAY(), E2<>"Resolved"). Set the cell fill color to light red to highlight overdue action items.
3. Resolved Strikethrough: Select the entire row. Use a formula rule: =$E2="Resolved". Set the font style to strikethrough to visually deprioritize completed items.