Advanced Recruitment Tracker Template – HR Format & Example

 

Advanced Recruitment Tracker Template – HR Format & Example


Advanced Recruitment Tracker Template – HR Format & Example

Purpose: This recruitment tracker helps HR teams manage job openings, candidate applications, screening, interviews, selection decisions, offers and joining status in one structured format.

1. Recruitment Tracker – Job Requisition Details

Field Details
Requisition ID __________________
Job Title __________________
Department __________________
Hiring Manager __________________
Recruiter Name __________________
Number of Vacancies __________________
Job Location __________________
Employment Type Permanent / Contract / Other
Requisition Date __________________
Target Joining Date __________________
Requisition Status Open / On Hold / Closed

2. Candidate Pipeline Tracker

Use one row for each candidate and assign a unique candidate ID to avoid confusion when multiple candidates apply for the same role.

Candidate ID Candidate Name Job Title Application Date Source Recruiter
C001 Example Candidate HR Executive 01/10/2026 Job Portal Recruiter A
C002 Example Candidate HR Executive 02/10/2026 Referral Recruiter A

Common candidate sources: Job portals, employee referrals, company careers page, LinkedIn, recruitment agencies, campus hiring and direct applications.

3. Screening and Interview Tracker

Candidate ID Screening Status Interview Round Interview Date Interviewer Feedback / Decision
C001 Completed HR Interview ______ ______ Pending
C001 Completed Technical / Functional ______ ______ Pending
C002 Pending Not Scheduled ______ ______ Pending

Suggested screening statuses:

  • Application Received
  • Screening Pending
  • Shortlisted
  • Rejected at Screening
  • Interview Scheduled
  • Interview Completed
  • On Hold
  • Withdrawn

Record job-related feedback using consistent, role-relevant criteria. Limit access to confidential interview notes.

4. Candidate Selection and Offer Tracker

Candidate ID Final Decision Offer Approval Offer Release Date Offer Status Proposed CTC
C001 Pending Pending ______ Not Released ₹______
C002 Pending Pending ______ Not Released ₹______

Offer status options: Not Initiated, Approval Pending, Approved, Released, Accepted, Declined, Expired or Withdrawn.

Only authorised HR personnel should maintain compensation details.

5. Joining and Onboarding Tracker

Candidate ID Offer Accepted Date Planned Joining Date Actual Joining Date Joining Status Remarks
C001 ______ ______ ______ Pending ______
C002 ______ ______ ______ Pending ______

Joining status options: Pending, Joined, Joining Deferred, Candidate Withdrew or Did Not Join.

Update the tracker when the candidate joins or the recruitment case is formally closed.

6. Recruitment Activity Log

Date Requisition ID Candidate ID Activity Owner Next Action Due Date
______ ______ ______ Resume Screening ______ Schedule Interview ______
______ ______ ______ Interview Feedback ______ Follow Up ______

This log helps recruiters track pending actions and reduce delays in candidate communication.

7. Recruitment Metrics and Formulas

A. Time-to-Hire

Formula: Candidate Acceptance Date − Candidate Application Date

This measures the time between a candidate applying and accepting the offer. Define the start and end points consistently before comparing results.

B. Time-to-Fill

Formula: Position Fill Date − Requisition Approval Date

This measures the time taken to fill an approved vacancy. Organisations may use different start and end dates, so document the chosen definition.

C. Offer Acceptance Rate

Formula:

Offer Acceptance Rate = (Offers Accepted ÷ Offers Made) × 100

Example: If 8 offers are accepted out of 10 offers made, the acceptance rate is 80%.

D. Interview-to-Selection Rate

Formula:

Interview-to-Selection Rate = (Candidates Selected ÷ Candidates Interviewed) × 100

Example: If 5 candidates are selected from 20 interviewed candidates, the rate is 25%.

E. Recruitment Source Conversion

Track candidates progressing from each source to interview, offer and joining. Compare sources using consistent time periods and candidate-stage definitions.

Important: Avoid comparing recruitment metrics without accounting for role complexity, hiring volume and differences in how each metric is defined.

8. Monthly Recruitment Summary

Metric Monthly Result
New Requisitions ______
Open Requisitions ______
Closed Requisitions ______
Candidates Sourced ______
Candidates Screened ______
Interviews Completed ______
Offers Released ______
Offers Accepted ______
Candidates Joined ______
Offers Declined ______
Candidates Who Did Not Join ______
Average Time-to-Hire ______ days
Average Time-to-Fill ______ days

Use a consistent reporting period and avoid counting the same candidate more than once in a metric unless the metric specifically measures applications or interview events.

9. Recruiter-Wise Hiring Summary

Recruiter Name Open Requisitions Interviews Coordinated Offers Accepted Candidates Joined Pending Actions
Recruiter A ______ ______ ______ ______ ______
Recruiter B ______ ______ ______ ______ ______
Recruiter C ______ ______ ______ ______ ______

Use this summary for workload planning and process monitoring, not as a standalone measure of recruiter performance. Role difficulty and hiring requirements can vary.

10. Recruitment Tracker Review Checklist

  • [ ] All active vacancies have a requisition ID.
  • [ ] Hiring approvals have been recorded.
  • [ ] Candidate stages are updated.
  • [ ] Interview feedback and decisions are documented.
  • [ ] Offer approvals and outcomes are recorded.
  • [ ] Joining dates and actual joining status are updated.
  • [ ] Pending candidate follow-ups have an owner and due date.
  • [ ] Recruitment metrics use consistent definitions.
  • [ ] Candidate information is accessible only to authorised personnel.
  • [ ] Closed requisitions and withdrawn applications are clearly marked.

11. HR Best Practices

  1. Maintain one source of truth for each vacancy and candidate.
  2. Use standardised candidate-stage labels across the recruitment team.
  3. Record reasons for rejection using job-related criteria and follow applicable hiring policies.
  4. Review delayed requisitions and pending feedback regularly.
  5. Protect candidate contact details, CVs, interview notes and compensation information.
  6. Retain or delete candidate data according to the organisation’s retention policy and applicable law.

Related HR Resource

HR Policies: Meaning, Types, Examples and Best Practices
https://hrlearninghub.blogspot.com/2026/08/hr-policies-meaning-types-examples-best.html

Disclaimer

This template is provided for general HR documentation and educational purposes. Customise it to your organisation’s recruitment workflow, reporting requirements, data protection practices and applicable laws before use.

Comments

Post a Comment

Popular posts from this blog

HR Analytics: Meaning, Types, Metrics, Benefits, Tools & Career Guide (2026)

Image
Introduction In today's workplace, HR teams collect large amounts of employee data, including headcount, attendance, hiring, turnover, compensation, performance, and training data. But data alone does not help HR make better decisions. HR Analytics turns workforce data into meaningful insights that can support better HR and business decisions. For example, if employee turnover increases from 12% to 18%, HR Analytics can help identify where the increase is happening, which employee groups are most affected, and what factors may need further investigation. HR can then use these insights to evaluate appropriate actions and measure whether those actions improve the outcome. This guide explains HR Analytics in a practical way, including its meaning, objectives, types, key metrics, real-world example, common mistakes, limitations, tools, required skills, and career opportunities. Learn more about HR :  HR Generalists Table of Contents Introduction HR Analytics Definition ...
Read more

HR Recruiter vs Talent Acquisition: What's the Difference? (With Real-Life Example)

Image
     Many people use the terms HR Recruiter and Talent Acquisition (TA) interchangeably. Although both roles are involved in hiring employees, their responsibilities and focus can differ. An HR Recruiter typically focuses on sourcing, screening, and hiring candidates for open positions. Talent Acquisition takes a broader approach that may include workforce planning, talent pipelines, employer branding, candidate experience, and long-term hiring strategy. In this guide, you'll learn the key differences between HR Recruiters and Talent Acquisition professionals, their responsibilities, required skills, salary considerations, career paths, and when companies may need each function. Table of Contents HR Recruiter vs Talent Acquisition: Quick Comparison What Is an HR Recruiter? HR Recruiter Responsibilities What Is Talent Acquisition? Talent Acquisition Responsibilities HR Recruiter vs Talent Acquisition: Key Differences Skill...
Read more

Employee Onboarding Process: Steps, Checklist, Benefits & Best Practices

Image
Introduction   An effective employee onboarding process is essential for helping new employees settle into their roles and become productive members of the organization. A well-planned onboarding program goes beyond completing paperwork—it introduces employees to the company's culture, values, policies, and job responsibilities while providing the support they need to succeed. A structured onboarding process helps new hires feel welcomed, improves employee engagement, reduces turnover, and shortens the time it takes for employees to perform at their best. Whether you're an HR professional, business owner, or aspiring HR executive, understanding the onboarding process is key to building a positive employee experience. In this comprehensive guide, you'll learn the step-by-step employee onboarding process, discover a practical onboarding checklist, explore its key benefits, and understand the best practices that can help organizations create a successful onboarding experience....
Read more