How to Keep a Recruitment Tracker Useful
A tracker that leaves
less to guess.
A recruitment tracker is a handover between people. Its most useful fields explain where an application stands, what needs attention and who will act next.
Prepared by Abhay Rohit with AI assistance for Priyanshi Tiwari’s learning portfolio.

Give each row a clear meaning
Start with one row per application to one role. Use an application ID and a role ID. A person applying for two roles needs two application records because the requirements, reviewers and decisions may differ. Avoid counting those records as two unique people.
In the starter workbook, APP-001 and APP-002 are fictional application IDs. The examples demonstrate the structure; replace them before using the workbook for an actual process. Keep contact details and application documents in the organisation’s approved system, with the tracker holding only the reference needed for coordination.
Separate the stage from the next action
Use a short, agreed stage list: Applied, Screening, Interview, Offer, Hired and Closed. A stage describes the current position. The next-action field describes work still needed. “Interview” is a stage; “Confirm the interviewer’s availability” is an action.
Add a named owner and a due date to that action. An open row without either field is difficult to hand over. Keep the outcome and closure reason separate so an application closed by withdrawal is not silently grouped with a hiring-team rejection.
The workbook flags incomplete handovers in the rows provided. This is a check for missing fields, not a candidate-quality score. An application should never receive a hiring decision because a spreadsheet cell changed colour.
Write down evidence and questions separately
For a fictional role requiring spreadsheet reporting, a CV may mention maintaining an event register. Record that example precisely. Ask how the register was checked and summarised. Do not silently upgrade the example to advanced Excel experience or treat an unanswered question as evidence of inability.
The screening sheet pairs the role criterion with available evidence, a clarification question and a reviewer. Agree on job-related criteria with the hiring owner before reviewing applications. Keep notes brief enough for another reviewer to follow and relevant enough to explain the next step. The candidate screening checklist shows how to structure that note.
Review a small set of open actions
At handover, filter to active applications. Check overdue actions, missing owners and rows whose stage has not been updated after a confirmed event. Resolve duplicates by application ID, rather than deleting rows that happen to share a name.
If you need conversion rates, use one defined intake group and count how many applications ever reached each stage. A current-stage tracker alone does not supply cumulative funnel counts. An applicant now at Offer has also passed earlier stages, even though the row displays only Offer.
Use the funnel calculator only after preparing those cumulative counts. That distinction keeps a neat dashboard from telling the wrong story.