employee offboarding checklist template excel

Employee Separation and Asset Recovery Workflow

This system provides a structured framework for HR and IT departments to track the transition of departing personnel. It ensures compliance, security, and knowledge transfer. This document should be reviewed and updated by the [HR Department] on a [Quarterly/Bi-annual] basis to reflect changes in security protocols or company policy.

Column Definitions

• Task ID: [Alphanumeric] Unique identifier for tracking; format: OFF-XXX.
• Category: [Dropdown List] Select from: IT, HR, Finance, Operations, Legal.
• Task Description: [Text] Detailed action required for the separation process.
• Assigned To: [Dropdown/Text] Name or role responsible for the task.
• Status: [Dropdown List] Options: Not Started, In Progress, Pending, Completed, N/A.
• Due Date: [Date] Deadline for task completion.
• Completion Date: [Date] Actual date the task was finalized.

Essential Formulas

Days Remaining until Deadline: Place this in a column to track urgency (assuming Due Date is in Column F):

=IF(E2="Completed", "Done", F2-TODAY())

Completion Percentage: Place this at the top of your sheet to track progress (assuming Status column is E):

=COUNTIF(E:E, "Completed") / COUNTA(E:E)

Data Validation and Formatting

Data Validation (Status Column):

1. Select the Status column.
2. Go to Data > Data Validation.
3. Select "List" and enter: Not Started, In Progress, Pending, Completed, N/A.

Conditional Formatting (Urgency):

1. Select the Due Date column.
2. Go to Conditional Formatting > New Rule > Use a formula.
3. Enter =AND(F2<TODAY(), E2<>"Completed") and set the fill color to light red to highlight overdue tasks.

Conditional Formatting (Completion):

1. Select the entire row.
2. Go to Conditional Formatting > New Rule > Use a formula.
3. Enter =$E2="Completed" and set the text to strikethrough/grey to visually dim finished items.