A recruitment tracker keeps every job applicant in one list, from the day their CV arrives to the final decision. This free Excel template holds up to 20 candidates, with dropdowns for channel, stage and decision. The band at the top counts total applications, interviews held, offers made and hires, so you can see how a hiring round is going.
How the tracker counts progress
The four figures in the band come from what you enter, not from guesswork:
- TOTAL APPLICATIONS counts every row with a Candidate Name
- INTERVIEWS counts candidates with an Interview Date entered
- OFFERS MADE counts candidates with an Offer Date entered
- HIRED counts candidates whose Decision is Hired
Because interviews and offers are counted from dates, a candidate who reached interview but was later rejected still counts as interviewed.
Seeing which channels work
The Channel column records where each application came from. After a round, filter by channel and compare it with the Decision column. If most of your hires came from referrals and the job board brought nothing usable, that tells you where to spend next time.
Steps to take before a new starter begins
Before anyone starts work, you must check they have the right to work in the UK. Once they join, they become part of your payroll and records, so set up a proper employee file. The employee record template is a good next step.
