Columns that matter
Keep it practical. A spreadsheet shared with the agency works for most employers; a dedicated system helps at larger volumes.
| Column | Owner |
|---|---|
| Candidate ID and trade | Agency |
| Interview and test result | Employer |
| Offer sent and accepted | Employer and agency |
| Medical result | Agency |
| Visa or permit status | Employer |
| Emigration clearance | Agency |
| Ticket and flight date | Employer or agency |
| Arrival and induction | Site |
Status rules
Define each status in one line so that “medical done” means the same to everyone: examined, or result received, or result valid? Ambiguity is where delays hide. Record the date of each change, not just the current state, so you can measure how long each step takes.
The weekly view
Each week, sort by the oldest unchanged status. Those rows are your problems. Ask the owner what is needed and by when. A ten-minute call on these rows usually does more than a long meeting about the whole batch.
- Rows with no change for more than a set number of days.
- Candidates whose passport or medical will expire before arrival.
- Selected candidates who have stopped responding.
- Steps waiting on an employer document.
Keep it secure
A tracker with names and passport numbers is personal data. Use candidate IDs where possible, limit who can edit it and avoid copying it into email attachments that circulate widely.
Use the data afterwards
After a few batches, the dates show where time really goes. If visa issue is always the slowest step, start it earlier in the next plan. If drop-outs cluster after a long wait, keep candidates informed during that wait or shorten it.
An example weekly summary
A short summary at the top of the tracker helps managers who do not want to scroll through rows. For a batch of forty, it might read: thirty-eight selected, thirty-five medically fit, two medicals pending, thirty visas issued, five pending, twenty emigration clearances completed, eighteen tickets booked, twelve arrived. Below it, list the five oldest problems with an owner and the next action.
Sending this summary every week to the hiring manager, the site and the agency keeps everyone aligned and reduces ad hoc status calls.
Linking to the site plan
Connect the tracker to the site’s mobilisation plan. When arrivals slip, the site needs to know so it can adjust housing, transport and work sequencing. A tracker that only HR sees leaves the site guessing.
Common mistakes
The usual failures are trackers that only the agency can see, statuses updated once a month, and columns nobody owns. Fix ownership first. A simple sheet updated twice a week beats a sophisticated system that nobody maintains.
Questions employers ask
Should candidates see the tracker?
No, but they should be told their own status regularly by the agency.
How often should it be updated?
At least twice a week during active processing, and on the day any status changes for urgent cases.
Do we need special software?
Not at first. Move to a system when volume or the number of sites makes a spreadsheet hard to control.
What should happen when a candidate drops out?
Mark the reason, move in a reserve from the shortlist and record the date so you can measure replacement time.
Can the agency keep its own tracker instead?
It can for internal use, but the employer should see a shared version with the same rows and dates so that both sides discuss the same facts.
General information, reviewed 2026-11-21. Rules change and differ by country, so confirm the current position with the authority concerned or your legal adviser before acting.
Keep reading
Planning to hire from India?
Send the roles, numbers, destination and start date. We reply with a written scope, timeline and cost.
Send your requirement