Recruiting Tracking for Small Businesses Without a Dedicated HR Team
How small businesses track candidates from application to onboarding. 5 stages, 6 metrics, free template fields, and when to move beyond a spreadsheet.
Recruiting Tracking
How to track candidates from application to productive employee when you have 5-50 employees and no ATS
My first 10 hires were tracked in my head. I remembered who I interviewed, what they said, and where they were in the process. It worked until it did not. The moment I was juggling 3 open roles with 8 candidates each, I started losing people. Not because they were bad candidates, but because I forgot to follow up, double-booked interviews, and let strong applicants sit for two weeks without a response while they accepted offers elsewhere.
The fix was embarrassingly simple: a spreadsheet with 10 columns. Candidate name, role, source, stage, dates, notes. I updated it after every action. Candidates stopped falling through the cracks. Response times dropped from a week to 48 hours. The spreadsheet did not make me a better judge of talent. It made me a reliable hiring process instead of a chaotic one.
This guide covers recruiting tracking for small businesses with 5 to 50 employees: the 5 stages worth tracking, the fields your tracker needs, the 6 metrics that actually matter, when a spreadsheet stops working, and the tracking stage that every guide skips entirely, which is what happens after the candidate becomes an employee.
What Is Recruiting Tracking?
Recruiting tracking is the practice of systematically monitoring where every candidate stands in your hiring process. At its simplest, it is a spreadsheet that tells you: who applied, what stage they are at, what happened last, and what needs to happen next. At its most complex, it is an applicant tracking system (ATS) that automates candidate communication, schedules interviews, parses resumes, and generates reports.
For small businesses, the distinction matters. An ATS is a software category that starts at $29/month and goes up to $300/month or more. Recruiting tracking is the underlying practice that the software automates. You can track recruiting without an ATS. You cannot use an ATS without tracking recruiting. Start with the practice, then add the software when the practice outgrows your manual capacity.
The recruitment process guide covers the full 7-step hiring framework. This guide focuses specifically on how to track candidates through that framework without losing anyone.
The 5 Stages Every Small Business Should Track
Every candidate moves through five stages. Your tracker needs to show which stage each candidate is in, when they entered it, and what the next action is. When a candidate sits in the same stage for more than 5 business days without an update, something is wrong.
Most recruiting trackers end at stage 4. The candidate accepts the offer, the row turns green, and tracking stops. But 20% of new hires leave within the first 45 days (Work Institute). If your tracker does not cover stage 5, you have no visibility into whether your recruiting investment actually produced a productive employee or a 90-day departure that sends you back to stage 1.
What Your Recruiting Tracker Needs (Template Fields)
A recruiting tracker that is too complex does not get updated. A tracker that is too simple misses critical information. These are the fields that balance usefulness with compliance, split into essential (include from day one) and optional (add when your volume justifies them).
| Field | Purpose | Priority |
|---|---|---|
| Candidate name | Identify the person | Essential |
| Role applied for | Track which opening they are connected to | Essential |
| Source | Know which channel produced this candidate (Indeed, referral, LinkedIn) | Essential |
| Application date | Calculate time to fill; identify slow-moving candidates | Essential |
| Current stage | Show where they are: applied, phone screen, interview, offer, hired, rejected | Essential |
| Date of last stage change | Flag candidates sitting too long in one stage (>5 business days = problem) | Essential |
| Next action | What needs to happen next: schedule interview, send rejection, check reference | Essential |
| Next action date | When it needs to happen by | Essential |
| Interviewer | Who evaluated this candidate | Essential |
| Scorecard rating (1-5) | Objective evaluation for comparison across candidates | Essential |
| Notes | Qualitative observations from phone screen and interview | Essential |
| Rejection reason | Document why you passed; EEOC record retention requires this | Essential |
| Compensation expectation | Avoid surprises at offer stage | Optional |
| Availability to start | Plan onboarding timeline | Optional |
| Referral source name | Track who referred successful candidates for bonus payment | Optional |
| Background check status | Track completion for compliance | Optional (essential at 10+ hires/year) |
Keep your tracker under 15 columns. Every column you add is a column that needs updating after every candidate interaction. A 20-column tracker that gets updated weekly is less useful than a 10-column tracker that gets updated within 24 hours. The structured interview guide covers how to build the scorecard that feeds into column 10. The job description guide ensures you have the role requirements that your screening is based on.
6 Recruiting Metrics Worth Tracking (And 4 That Are Not)
Not every metric that enterprise recruiting teams track is relevant for a small business hiring 5 to 15 people per year. These 6 metrics provide actionable insight at SMB scale. Four commonly cited metrics are included as "skip for now" to save you from tracking numbers that do not change your decisions.
| Metric | Formula | SMB Benchmark | Why It Matters |
|---|---|---|---|
| Time to fill | Days from job posting to accepted offer | 25-45 days | Longer than 45 days means you are losing top candidates to faster employers |
| Cost per hire | Total recruiting spend / number of hires | Median $1,633, average $4,700 (SHRM) | Tells you whether your channels are cost-effective |
| Source of hire | % of hires from each channel | Track top 3 sources | Stop spending on channels that produce zero hires |
| Offer acceptance rate | Accepted offers / total offers extended | 80%+ | Below 75% signals slow process, low comp, or poor candidate experience |
| 90-day retention rate | Hires still employed at 90 days / total hires | 85-95% | Below 80% means your screening or onboarding is failing |
| Quality of hire | Manager satisfaction (1-5) + meets performance goals at 6 months | 3.5+ average | The lagging indicator that tells you if everything else worked |
4 Metrics to Skip (For Now)
Enterprise recruiting teams track candidate pipeline velocity, recruiter productivity, hiring manager satisfaction surveys, and applicant-to-interview conversion by source segmentation. These metrics require dedicated TA teams and ATS reporting to calculate. At 10 hires per year, the 6 metrics above tell you everything you need. Add enterprise metrics when you have someone whose job is to analyze them. The recruitment metrics guide covers the full set with formulas. The recruitment KPIs guide covers how to set targets.
The most important metric is 90-day retention. It is the only number that tells you whether your entire recruiting and onboarding process produced the intended result: a productive employee who stays. Every other metric is a leading indicator. Retention is the outcome. The average cost per hire is $4,700 (SHRM), and every early departure means paying that cost again. Research shows that organizations with structured onboarding see 82% better retention (Gallup). The onboarding measurement guide covers post-hire metrics in detail.
When a Spreadsheet Breaks
A spreadsheet is the right tool until it is not. Three signals tell you that manual tracking has hit its ceiling and you need a dedicated tool.
| Signal | What You Notice | What It Means |
|---|---|---|
| Candidates falling through cracks | You discover a strong applicant who has been sitting in 'phone screen' for 12 days with no follow-up | Manual updates are not keeping pace with your pipeline volume |
| Spending 5+ hours/week on tracker maintenance | Friday afternoon is spent updating 30 rows across 3 roles instead of making decisions | The tracker is consuming more time than it saves |
| Candidates complaining about response time | Applicants email asking for updates, or mention slow process in Glassdoor reviews | Your process is slower than your competitors, and candidates are noticing |
| Multiple people updating the same sheet | Two interviewers update the same candidate row with conflicting notes | You need role-based access and audit trails that spreadsheets do not provide |
| No visibility into post-offer status | A new hire starts on Monday and nobody knows if their I-9 is complete | Your tracking stops at 'hired' but your process should not |
The transition point: when you consistently manage 3+ open roles with 15+ candidates each, or when you hire 10+ people per year. Below that, a spreadsheet with the 24-hour update rule handles the workload. Above that, a dedicated tool pays for itself by preventing the lost candidates, slow responses, and compliance gaps that manual tracking creates.
Tool Comparison: Spreadsheet vs ATS vs HRIS
The question is not "do I need an ATS?" The question is "what is the lightest tool that prevents candidates from falling through the cracks at my current hiring volume?" Start with the simplest option and upgrade when you hit the ceiling.
The gap in most tool comparisons: they end at the offer. A standalone ATS tracks candidates from application to accepted offer. It does not track whether the new hire completed their I-9, started training, or had their 30-day check-in. An HRIS with hiring and onboarding built in tracks the full lifecycle in one system. FirstHR handles the post-offer side at $98/month flat: e-signature for compliance documents, AI-generated onboarding plans, training modules, and task workflows that pick up where your ATS or spreadsheet ends. The HR tech stack guide covers when each tool category becomes necessary.
The Missing Link: Recruitment-to-Onboarding Handoff
Every recruiting tracking guide ends at "offer accepted." The candidate row turns green. The tracker declares victory. And then the actual challenge begins: turning that candidate into a productive employee who stays past 90 days.
The handoff from recruiting to onboarding should be a tracked stage, not an afterthought. Here is what to track after the offer is accepted.
| What to Track | Deadline | Why It Matters |
|---|---|---|
| I-9 (Section 1) | Before Day 1 | Federal requirement. Late completion = penalties. |
| I-9 (Section 2) | By end of Day 3 | Federal requirement. No exceptions. |
| W-4 and state withholding | Before first payroll | Employer liable for under-withheld taxes |
| Employee handbook acknowledgment | Day 1 | Documented acknowledgment protects you in disputes |
| 30-60-90 day onboarding plan created | Before Day 1 | No plan = no structure = confused new hire |
| Buddy assigned | Before Day 1 | New hire needs a peer contact, not just a manager |
| Day 7 check-in scheduled | Before Day 1 | Catch problems in week one, not month two |
| Training modules assigned | Day 1 | Role-specific training should start immediately |
| Day 30 review scheduled | Before Day 1 | The first formal milestone. Not optional. |
| Day 90 review scheduled | Before Day 1 | End of onboarding. Transition to regular performance. |
If your current tracker cannot handle this stage, you need a second system for onboarding. Or, better, one system that handles both: candidate tracking through the hiring pipeline and onboarding tracking through the first 90 days. The onboarding checklist maps every post-hire task. The 30-60-90 day plan guide covers how to build the structure. The preboarding guide covers the gap between offer acceptance and Day 1.
Common Recruiting Tracking Mistakes
| Mistake | Why It Happens | The Fix |
|---|---|---|
| Not tracking at all | Hiring is infrequent, feels like overhead | Even 3 hires/year benefit from a 10-column spreadsheet. The first time you forget to follow up costs more than the tracker. |
| Updating weekly instead of daily | Too busy, will catch up later | Apply the 24-hour rule. Update within 24 hours of any candidate action. Weekly updates produce a tracker that reflects last week. |
| Too many columns | Trying to capture everything | Keep it under 15 columns. Every column you add is a column that needs updating. Start with 10 essential fields. |
| Tracking stops at offer accepted | The 'hiring' part is done | Add stage 5: onboarding handoff. Track compliance docs, training, and check-ins through Day 90. |
| No rejection reason documented | Awkward, seems unnecessary | The EEOC recommends retaining hiring records for 1 year. A documented rejection reason is your defense against discrimination claims. |
| Multiple versions of the tracker | Different people use different sheets | One tracker, shared with everyone involved in hiring. One source of truth. |
| No metrics review | Tracking candidates but not outcomes | Review time to fill, offer acceptance rate, and 90-day retention quarterly. These tell you if your process works. |
The pattern: most tracking mistakes are consistency problems, not tool problems. A $300/month ATS used inconsistently produces worse results than a free spreadsheet updated religiously. Choose the simplest tool that handles your volume, then use it for every candidate, every time, with no exceptions. The EEOC recommends retaining all hiring records for at least one year, so your tracker doubles as your compliance documentation. The hiring best practices guide covers the complete set of practices that your tracker should enforce. The candidate experience guide covers how tracking consistency affects how candidates perceive your company.
Frequently Asked Questions
Is recruiting tracking the same as an ATS?
No. Recruiting tracking is the practice of monitoring candidates through your hiring process. An applicant tracking system (ATS) is a specific software category that automates that practice. You can track recruiting in a spreadsheet, a project management tool, or a simple shared document. An ATS adds automation (candidate emails, interview scheduling, resume parsing) on top of tracking. Small businesses hiring fewer than 10 people per year often do not need the automation an ATS provides.
Can I track recruiting in Excel or Google Sheets?
Yes, and for many small businesses it is the right starting point. Create a spreadsheet with columns for candidate name, role, source, application date, stage (applied, phone screen, interview, offer, hired, rejected), interviewer notes, and status date. This works well for 1 to 2 open roles with up to 15 candidates each. Beyond that volume, manual tracking becomes unreliable because status updates fall behind and candidates slip through the cracks.
What is the cheapest way for a small business to track applicants?
A Google Sheets spreadsheet with structured columns costs nothing and handles most small business hiring needs. The minimum fields are: candidate name, role applied for, source (where they found you), current stage, date of last action, and next step. Add a notes column for interview observations. Share the sheet with anyone involved in hiring so everyone sees the same status. This free method works until you hire more than 10 people per year or manage more than 3 open roles simultaneously.
How do I track recruiting without an HR department?
The same way you would with one, but with simpler tools. Use a spreadsheet or lightweight ATS to track candidates through five stages: posting, screening, interviewing, offer, and onboarding handoff. Assign one person (usually the founder or office manager) as the owner of the tracker. Update it within 24 hours of any candidate action. The system does not need to be complex. It needs to be consistent. Every candidate gets tracked, every status gets updated, and nothing falls through the cracks.
What metrics should small businesses track in recruiting?
Six metrics matter for small businesses: time to fill (days from posting to accepted offer, target 25-45 days), cost per hire (total recruiting spend divided by hires, average $4,700 per SHRM), source of hire (which channels produce your best hires), offer acceptance rate (target 80 percent or higher), 90-day retention rate (target 85-95 percent), and quality of hire (manager satisfaction plus performance at 6 months). Start with time to fill and 90-day retention. Add the others as your hiring volume grows.
When should a small business move from a spreadsheet to an ATS?
Consider a dedicated ATS when three conditions converge: you hire more than 10 people per year, you manage 3 or more open roles simultaneously, and candidates are falling through the cracks despite consistent tracker updates. Other signals include spending more than 5 hours per week on manual status updates, receiving complaints from candidates about slow responses, or losing top candidates because your process takes too long. A lightweight ATS at $29-$99 per month pays for itself by reducing time to hire and preventing lost candidates.
What happens to recruiting tracking after the candidate is hired?
This is where most tracking systems stop and where most small businesses lose new hires. The candidate becomes an employee, but nobody tracks whether they completed compliance paperwork, started training, received their 30-day goals, or had their first check-in. Twenty percent of new hires leave within 45 days, and the primary reason is a lack of structured onboarding. The fix: extend your tracking from offer accepted through Day 90, covering preboarding tasks, training completion, and check-in milestones.
What fields should a recruitment tracker include?
Essential fields for a small business tracker: candidate name, role, source (job board, referral, LinkedIn), application date, current stage (applied, phone screen, interview 1, interview 2, offer, hired, rejected), date of last stage change, interviewer name, scorecard rating (1-5), next action, next action date, and notes. Optional fields that add value at higher volume: compensation expectation, availability to start, referral source name, and reason for rejection. Keep it under 15 columns. More fields means less compliance with updates.
How often should I update the recruiting tracker?
Within 24 hours of any candidate action. When a candidate applies, update the tracker. When you complete a phone screen, update the tracker. When you schedule an interview, update the tracker. When you make a decision, update the tracker. The tracker is only useful if it reflects reality. A tracker that is updated weekly instead of daily creates a false picture of your pipeline and guarantees that candidates will be forgotten.
Does recruiting tracking help with compliance?
Yes. A consistent tracker creates documentation that protects you in two ways. First, it demonstrates that you applied the same process to every candidate, which is your defense against discrimination claims. Second, it creates a record of why each hiring decision was made (scorecard ratings, documented criteria), which the EEOC may request if a rejected candidate files a complaint. The EEOC recommends retaining hiring records for at least one year from the date of the hiring decision.