Recruiting for a specific position is very hectic process, when you imagine the activities and sub-process involved. Recruitment of an incompetent resource is a business risk. Such risk is can be reduced with optimization in process of recruitment.
Normally, in any company the holistic recruitment process involves;
- Vacancy Posting/ Announcement
- Application receiving
- Filtering and Screening applications
- Shortlisting candidates
- Phone/ Call Screening
- Technical Interview scheduling
- Final Shortlisting
- Offer Intent Sharing
- Onboarding
Now, each component of the recruitment process listed above will have multiple task and sub-task to do and when it comes to multiple candidates, you will have to ensure that all the candidates, recruitment team and their calendar dates are adequately aligned. Thus, recruitment process tracking becomes very crucial. This excel template helps you track each of the process listed above along with the reason for decline (if someone declines at the end) .
Contents of this template
This tracking template comes with three excel sheets, namely,
- Settings
- Applications
- Dashboard
Settings – This contains the stages of process, Application sources and Decline reasons. It is designed and pre-filled with five reasons which pretty much covers the possible reasons and areas. However, you can modify as per your need.
Applications – It covers information of the job title for which the tracker is being prepared, name of the principal recruiter, job announcement date and all the journey details of each candidates. As per the process, each application of the candidate shortlisted will be registered here for the complete journey.
Dashboard – This is the summary of all the actions and activities happening behind the scenes. This is non-editable sheet and is locked for integrity. Source of this dashboard is from the two sheets aforesaid. Hence, you don’t have to worry about the design and alignment. You can use this dashboard for your Management Information System (MIS) for HR Recruitment process.
