free employee recruitment database template

Job ID for which the application was sent.

Don’t interfere with these cells and start filling after row 5. Most of the table is required to fill in manually, while cells which will show automatic calculations are colored green. It will show all the information related to the applications received. Makes sure You “do not enter any values in Green Color”Īpplications Statistics & Monitoring Sheetįor smooth results, you are required to enter all the new applications received for the position in this spreadsheet.

Calculated fields include, completed, number hired, to hire, days in the market, the number of applications and total cost.

It must be filled manually, while some fields are filled in automatically and they are colored green.

This spreadsheet of the tracker provides jobs information. Jobs Sheet in Excel- Hiring Manager Basic Info Decline reasons may include, technical, culture, salary, experience or other.Enter a list of decline reasons up to 15.Application sources may include, LinkedIn, website, indeed, agency and more.Īdd decline reasons for the application here.Enter the list of application sources (up to 15).

It shows where most of the applications are received. Stages include application, phone screen, MGR interview, onsite interview, offer and hire.Leave blank, for the stages not required.This is the first sheet of the template, actually requiring your working and it must be filled carefully as it can be followed for whole of the template. Settings Sheet of Recruitment Tracker Template Instructions and simple data entry processes are also added up in this spreadsheet, therefore you can understand how to get the best results from this template. Tips to avoid mistakes are beneficial as you are dedicating your time and effort while using this template, therefore any mistake may result in losing the data or affecting the whole calculation process, therefore go through the tips and utilize them. Whether a one is a pro in excel or if he is a beginner, he is able to perform efficiently on this template through understanding this spreadsheet. This sheet is actually designed to help you get started with and get the overview of the template. View the performance of recruitment process.Look out for the change, after each new selection.Enter the cost of filling the Job in the Cost field.Enter the Decline Reason if the candidate was not hired.Enter ‘ HIRED’ or ‘ NOT HIRED’ in the Application Status column.Can be used for vacant positions, or replacing an employee.Here is some basic set of the template, make sure you put values, to perform result in the further sheet. Microsoft Excel 2010-2013 and above for Windows.

Free employee recruitment database template