Recruitment Tracker Excel Template | Hiring Dashboard Spreadsheet

Are you looking for an effective applicant tracking system (ATS)? Here’s our Recruitment Tracker in Excel to to help human resources professionals in making the hiring process easier and more efficient.

This candidate tracking tool can help channel all energies, efforts, and costs in a time and place where we will get the right people and will become a real talent hunter.

What is a Recruitment Tracker?

A recruitment tracker is any software or tool to prepare your applicant list and to organize, monitor and finalize your hiring processes, interview stages and job applications.

What does a recruitment tracker include?

The recruit track dashboard might include a candidate database, a vacancies list, a job application monitoring sheet and a dashboard. Also, a settings section might be useful to make the necessary adjustments to customize the template according to your particular needs. This employee sourcing and management tool will also help you monitor your hiring costs and budget.

With a clear recruitment timeline, you’ll improve your applicant assessment, employee engagement, requisition process.

In summary, a recruitment tracker will include trackers for all talent acquisition process as Preparing > Sourcing > Screening > Shortlisting > Selecting > Hiring > Onboarding.

Recruitment Tracker Excel Template Features:

This spreadsheet lets you monitor the whole hiring and staffing process flowchart to organize your manpower.

This Excel template has four main sections with a clear employee recruitment funnel:

Dashboard:

The recruitment dashboard will give you clear and useful insights into what is the overall situation in the company. Here you can see the number of candidates from the first consideration until hiring, the hiring costs, the active job openings, the percentage of the source distribution of the candidates, and the monthly distribution of job applications.

To show the results and analysis more clearly, the dashboard is divided into two separate parts which are candidates and vacancies statistics.

In order to make everything as user-friendly and efficient as possible, there are some filters for custom reporting. You can display stats based on your monthly selections, based on months & years, years only, job IDs, departments, or based on recruiters. You can also apply multiple or all filters at once, and the charts will update accordingly in real-time.

Please keep in mind that the date filters on top of the dashboard only affect the recruitment pipeline, sources of applications, and final decision charts of candidate statistics.

Note! The year selections will be specified according to the data you have entered on the vacancies and candidates sheets. So, please fill in the data first to be able to select a year from the dropdown buttons.

There is a separate date filter selection for the number of applications by month. If you leave the year selection empty, the chart will show all of the results. Otherwise, you can filter the chart according to the year selection.

Vacancies:

The Vacancies section is where you can add job openings with all the necessary details. Recruitment Tracker Template supports up to 1000 vacancies which are dynamically connected to the rest of the template.

On this page, you can write the opening date, recruiter name, vacancy status, start date, hiring cost, etc for the relevant position. Here it is very important to input dates and costs for the dashboard to give you accurate stats.

Additionally, he error check column will help you while you are filling in the data. Also, please do not forget to check that column to avoid any confusion or duplication in the data.

In summary, this is an open position tracking sheet of the recruitment tracker template.

Candidates:

After configuring the vacancies, you can then add all job applications to the candidate’s pipeline tracker page. In this candidate tracker, you should first select the job ID for which the candidate has applied, and then you can enter all other details. Recruitment Tracker Template supports up to 3000 candidates.

According to the job id you selected, the department, job applied for and recruiter column will be filled automatically. Please do not try to change the grey-colored columns manually.

In addition to the selection phase and decision information, there are 3 informational decision columns: HR View, Hiring Manager View, and Decision Maker View. It is totally up to you whether or not to fill these areas as they’re only for informative purposes. To fill them, just enlarge the grouping for manager views (First “+” sign). Their decision will not be displayed on the dashboard.

**We also added panel decisions in case more than 1 person is involved in the hiring process. You can also keep notes on each step and phase the candidates are in.

Settings for Recruitment Tracker

Finally,the settings section will accommodate unique business needs on your recruitment flowchart. Also, we recommend starting from this part before moving on to other sections.

So, you can change/add/remove the recruiters, departments, application sources, vacancy status, selection phases, and currency. In addition, here you can also change the final decision and hire decision labels in a way that suits you the best.

Here, the selection phases is very important. Here, you will build your recruitment funnel which will be used throughout the recruitment tracker template.

Recruitment Tracker Excel Template Features Summary:

• Recruitment Tracker Dashboard in Excel Template
• Easy-to-use Applicant Tracking System (ATS)
• Track your hiring, screening and vetting processes
• Works both on Mac and Windows
• No installation, ready to use.
• Professional design and suitable for presentations
• On Sheet Instructions
• Print-Ready
• Compatible with Excel 2010 and later versions

Recruitment Tracker is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

Download Now!