Recruitment Dashboard, Onboarding Checklist, Offboarding Checklist

This Excel template allows you to track recruitment process KPIs, candidate sourcing quality, hire needs vs. hires, recruitment process speed and costs, candidate conversion rate, and employee retention.
It automatically generates the onboarding workflow schedule for new employees, and the offboarding workflow schedule for those who depart from the company.
It will help you assess the whole recruitment process, and improve your ability to attract and retain talented candidates.

This HR dashboard template includes four reports:

Recruitment Funnel Report

Tracks the effectiveness of your sourcing strategies:

• Recruitment Funnel KPIs: number of open positions, sourced candidates, rejected candidates, in progress candidates, number of declined job offers, number of hires, started working employees, number of departures, and remaining job vacancies
• Percentage of filled positions, conversion rate, job interview progress, declined offers rate, and company ability to retain employees
• Speed of recruitment process: time to Hire, time to Fill and time to Start
• Average cost per hire
• Hiring rate by recruitment source, reasons why candidates are not hired, and reasons why candidates refuse the company job offers

Recruitment KPIs Report

Evaluates the quality of your recruitment process by:

• Job Title
• Job Experience level
• Job Department
• Work Mode: remote, on-site, hybrid
• It also displays the schedule for job interviews, and the score of candidates

Onboarding Checklist Report:

Shows key metrics for employee onboarding process:

• Onboarding workflow progress for each new employee
• Onboarding schedule: due date, task, and who the task is assigned to

Offboarding Checklist Report

Shows key metrics for employee offboarding process:

• Offboarding workflow progress for employees departing from the company
• Offboarding schedule: due date, task, and who the task is assigned to

Using this template is quite easy, you just need to:

• Define your settings
• Enter open jobs descriptions
• Enter candidate data
• Regularly enter onboarding completed tasks for new employees
• Regularly enter offboarding completed tasks for leaving employees

Video:

Template Requirements and How to Use:

• Works on PC with Windows.
• Does not work on MAC.
• Requires Microsoft Excel 2019 or higher
• Memory (RAM) 4 GB or more recommended.
• Allow Macros to run (enable content when opening file).
• Ready-to-use template, just enter or import your data.
• Dashboard ready to be printed.
• Instructions on the Excel file”User Guide”.

Customizable template:

Colors, fonts, and all style attributes can be changed to suit your needs. If you want to make changes on your own, just enter the password included with the file to unlock the template.

Included in the download:

• A template with sample data
• An empty template, ready to receive your data
• A user guide

Download link:

• Downloads are available from your account once your payment is confirmed.

Warning:

We have put a lot of effort into providing you with a quality work tool at a reasonable price. We kindly ask you to respect the copyright so that we can continue to exist, develop and improve our services. Thank you.

Once purchased, it is prohibited to resell, redistribute, sublicense, assign or transfer this file to anyone in any form. Please read our terms and conditions before purchasing this product.