| Recruitment pipeline tracker |
|---|
| Template by Layers (layers.md) · CC BY 4.0 |
| 1. «Jobs»: one row per open role — client, consultant, fee %, expected salary. The expected fee is calculated. |
| 2. «Pipeline»: one row per candidate per job. Choose the stage from the list and update the stage date when it changes. |
| The sheet shows days in stage, overdue next actions, the expected fee and the fee weighted by the stage probability. |
| 3. «Stages»: the list of stages and the probability that a candidate at that stage is placed. Adjust to your own history. |
| 4. «Summary»: candidates and weighted fee by stage and by consultant. |
| Blue cells = your input. White cells = formulas (do not delete). Days are counted to today’s date. |
| Template — review before use. Not legal advice. |
| Stages and placement probability | |
|---|---|
| Stage | Probability of placement |
| Sourced | 2% |
| Screened | 5% |
| Submitted to client | 10% |
| Client interview 1 | 20% |
| Client interview 2 | 35% |
| Final interview | 50% |
| Offer made | 75% |
| Offer accepted | 90% |
| Placed | 100% |
| Rejected | 0% |
| Withdrawn | 0% |
| Jobs | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Job ID | Client | Role | Consultant | Opened | Fee % | Expected salary | Expected fee | Status | Days open |
| JOB-014 | Harbor Analytics | Senior Data Analyst | Alex | 28/09/2026 | 20% | 68,000 | 13,600 | Open | 33 |
| JOB-015 | Bluefin Logistics | Operations Manager | Sam | 04/09/2026 | 18% | 75,000 | 13,500 | Open | 57 |
| JOB-016 | Cedar Health | Finance Business Partner | Alex | 20/08/2026 | 20% | 62,000 | 12,400 | Filled | |
| Pipeline — candidates by job and stage | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Candidate ref. | Job ID | Client | Role | Stage | Stage date | Days in stage | Next action | Next action date | Owner | Source | Expected fee | Probability | Weighted fee | Alert |
| CAND-0101 | JOB-014 | Harbor Analytics | Senior Data Analyst | Client interview 2 | 16/10/2026 | 15 | Collect feedback | 20/10/2026 | Alex | 13,600 | 35% | 4,760 | Overdue | |
| CAND-0102 | JOB-014 | Harbor Analytics | Senior Data Analyst | Submitted to client | 13/10/2026 | 18 | Chase client for feedback | 18/10/2026 | Alex | Database | 13,600 | 10% | 1,360 | Overdue |
| CAND-0103 | JOB-014 | Harbor Analytics | Senior Data Analyst | Offer made | 17/10/2026 | 14 | Call candidate about offer | 19/10/2026 | Alex | Referral | 13,600 | 75% | 10,200 | Overdue |
| CAND-0201 | JOB-015 | Bluefin Logistics | Operations Manager | Screened | 10/10/2026 | 21 | Submit to client | 16/10/2026 | Sam | Job board | 13,500 | 5% | 675 | Overdue |
| CAND-0202 | JOB-015 | Bluefin Logistics | Operations Manager | Client interview 1 | 15/10/2026 | 16 | Prepare candidate | 21/10/2026 | Sam | 13,500 | 20% | 2,700 | Overdue | |
| CAND-0301 | JOB-016 | Cedar Health | Finance Business Partner | Placed | 29/09/2026 | 32 | Check-in after 4 weeks | 27/10/2026 | Alex | Database | 12,400 | 100% | 12,400 | Overdue |
| CAND-0302 | JOB-016 | Cedar Health | Finance Business Partner | Rejected | 24/09/2026 | 37 | Alex | Job board | 12,400 | 0% | 0 | |||
| Summary | ||
|---|---|---|
| Stage | Candidates | Weighted fee |
| Sourced | 0 | 0 |
| Screened | 1 | 675 |
| Submitted to client | 1 | 1,360 |
| Client interview 1 | 1 | 2,700 |
| Client interview 2 | 1 | 4,760 |
| Final interview | 0 | 0 |
| Offer made | 1 | 10,200 |
| Offer accepted | 0 | 0 |
| Placed | 1 | 12,400 |
| Rejected | 1 | 0 |
| Withdrawn | 0 | 0 |
| Total | 7 | 32,095 |
| Placed — fees earned | 12,400 | |
| Open jobs | 2 | |
| Overdue next actions | 6 | |
| Consultant | Active candidates | Weighted fee (open stages) |
| Alex | 3 | 16,320 |
| Sam | 2 | 3,375 |