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.
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 gave me a reliable hiring process instead of a chaotic one.
This guide covers recruiting tracking for small businesses: 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 most guides skip, which is what happens after the candidate becomes an employee.
- Sign the offer letter
- Sign the employee handbook
- Workplace Safety course
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.
An ATS is a software category that runs from free plans with tight limits to $300/month or more. Recruiting tracking is the underlying practice that the software automates. You can track recruiting without an ATS, but you cannot use an ATS without tracking recruiting. Start with the practice, then add the software when it outgrows your manual capacity.
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. That leaves the early weeks unwatched, and research reported by SHRM (2017) puts as much as 20% of all employee turnover inside a new hire's first 45 days.
Stage 5 is what closes that blind spot. If your tracker does not cover it, you have no visibility into whether your recruiting investment produced a productive employee or a 90-day departure that sends you back to stage 1.
Nick Anisimov, FirstHR founder
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 (job board, referral, careers page) | 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; the Equal Employment Opportunity Commission (EEOC) requires employers with 15 or more employees to keep hiring records for one year | 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, which means adding the optional fields one at a time and only when you need them. 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.
Here are those fields already laid out as a sheet you can start filling today. The first tab is one row per candidate. The second is one row per opening, which is what turns a list of names into the numbers you need for time to fill and source of hire without recounting anything by hand.
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Candidate | Role | Source | Applied on | Current stage | Stage changed on | Next action | Next action by | Interviewer | Score (1-5) | Reason if passed over | Notes |
| 2 | ||||||||||||
| 3 | ||||||||||||
| 4 | ||||||||||||
| 5 | ||||||||||||
| 6 | ||||||||||||
| 7 | ||||||||||||
| 8 | ||||||||||||
| 9 | ||||||||||||
| 10 | Note | Sort by the stage changed column before every hiring conversation. Anything that has not moved in five business days is the agenda. | ||||||||||
| 11 | Note | Fill the reason column for every candidate you pass over, including the ones you never spoke to. | ||||||||||
| 12 | Note | Stage values, in order: applied, phone screen, interview 1, interview 2, offer, hired, and rejected. Use the same seven on every role so the Open Roles counts mean the same thing across openings. |
Read the second tab as a funnel once two or three roles are closed out. Comparing applications to phone screens tells you whether the posting reaches the right people. Comparing phone screens to offers tells you whether your screen is calibrated. The recruiting funnel guide covers benchmark ratios for each step.
6 Recruiting Metrics Worth Tracking (And 4 That Are Not)
These 6 metrics provide actionable insight at small-business scale. Enterprise recruiting teams track more, so four commonly cited metrics are listed further down 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 | Beyond 45 days you are slower than the market median for any type of role, and candidates close elsewhere |
| Cost per hire | Total recruiting spend / number of hires | $4,700 average (SHRM, 2022) | 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 |
Apart from the SHRM cost figure, the benchmarks in that table are targets to steer by, not published averages. Time to fill is the one other number with an outside anchor. SHRM's 2026 recruiting benchmarking of more than 4,600 organizations puts the median, from requisition to accepted offer, at 39 calendar days for nonexecutive positions and 45 for executive ones.
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. These metrics need a dedicated talent acquisition team and ATS reporting to calculate. At 10 hires per year, the 6 metrics above tell you everything you need. Add enterprise metrics when someone's job is to analyze them.
Of the six metrics you do track, the most important is 90-day retention. It is the first number that tells you whether your entire recruiting and onboarding process produced the intended result: a productive employee who stays. The four metrics before it in the table measure the process. Retention measures the outcome.
According to SHRM benchmarking (2022), the average cost per hire runs close to $4,700, and every early departure means paying it again. Gallup (2018) finds that only 12% of employees strongly agree that their organization does a great job onboarding new employees, which is why structured onboarding is the cheapest place to intervene.
When a Spreadsheet Breaks
A spreadsheet is the right tool until it is not. Five 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 the slow process in employer reviews online | 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 finer access control and audit trails than a shared spreadsheet offers |
| 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, when a single role draws 15+ candidates, or when you hire 10+ people per year. Below those levels, a spreadsheet with the 24-hour update rule handles the workload. Above them, 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 its ceiling. The last card covers an HRIS (human resources information system), which is software that keeps employee records, here in a version that also handles hiring and onboarding.
The gap in most tool comparisons is that 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 a flat $98 a month for up to 10 people or $198 for 11 to 50: e-signature for offer letters and policy acknowledgments, AI-generated onboarding plans, training modules, and task workflows that pick up where your ATS or spreadsheet ends.
The Missing Link: Recruitment-to-Onboarding Handoff
Most recruiting tracking guides end at "offer accepted." 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) | No later than Day 1 | Federal requirement under 8 CFR 274a.2. Late completion draws penalties. |
| I-9 (Section 2) | Within 3 business days of Day 1 | Federal requirement. Day 1 if the job lasts under 3 business days. |
| 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. |
The two I-9 rows carry the hardest deadlines in that table, and both are written into federal regulation. Under 8 CFR 274a.2, the employee completes Section 1 at the time of hire and the employer completes Section 2 within 3 business days of the hire. For a job lasting fewer than 3 business days, both happen at the time of hire.
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.
Nick Anisimov, FirstHR founderCommon Recruiting Tracking Mistakes
Seven mistakes are worth avoiding when you set up and run a recruiting tracker. The table pairs each one with its cause and its fix.
| 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 the essential fields from the template above. |
| 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 | EEOC regulations require employers with 15 or more employees to keep personnel and employment records for one 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.
Consistency also happens to be what the law rewards. EEOC regulations require employers with 15 or more employees to keep every personnel and employment record for one year. When an employee is involuntarily terminated, the one-year clock runs from the termination date. A tracker you actually maintain doubles as your record retention documentation.
Your next step is small: copy the template fields into a sheet today, add the onboarding handoff as stage 5, and update it within 24 hours of every candidate action.
Frequently Asked Questions
Is recruiting tracking the same as an ATS?
No. Recruiting tracking is the habit of knowing which stage each candidate is in and what happens next, and you can keep it in a spreadsheet, a project management tool, or a shared document. An applicant tracking system (ATS) is software that automates that habit with candidate emails, interview scheduling, and resume parsing. Small businesses that hire fewer than 10 people per year often get by without that automation, as long as the tracker is updated consistently.
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 10 or more people per year or manage 3 or more open roles at once.
How do I track recruiting without an HR department?
The same way a company with an HR team would, only with simpler tools. A spreadsheet or lightweight ATS can follow candidates through five stages: posting, screening, interviewing, the offer, and the handoff to onboarding. Make one person, usually the founder or office manager, the owner of the tracker, and have them record each candidate action in it within 24 hours. Complexity is not the goal. Consistency is: every candidate gets a row, every status stays current, and nobody gets forgotten.
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, close to $4,700 on average in the 2022 SHRM benchmark), 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 the spreadsheet stops keeping up. The usual triggers are hiring 10 or more people per year, running 3 or more open roles at once, or seeing 15 or more candidates for a single role. Other warning signs include candidates falling through the cracks despite consistent updates, more than 5 hours a week spent on manual status updates, candidate complaints about slow responses, and top candidates lost because your process takes too long. A lightweight ATS, often under $100 a month, pays for itself by cutting 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. Research reported by SHRM in 2017 puts as much as 20 percent of all employee turnover inside the first 45 days on the job, which is exactly the window your tracker goes dark on. The fix: extend your tracking from offer accepted through Day 90. Carry the compliance documents, the training assignments, and the scheduled check-ins as tracker rows with an owner and a due date, the same way you carried interview stages.
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, notes, and reason for rejection. Optional fields that add value at higher volume: compensation expectation, availability to start, referral source name, and background check status. 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 tracker you update consistently gives you a paper trail in two ways. It shows that every candidate went through the same process, which is your defense against a discrimination claim. It also records why each hiring decision was made, through scorecard ratings and documented criteria, which the Equal Employment Opportunity Commission (EEOC) may ask to see if a rejected candidate files a complaint. For employers with 15 or more employees, EEOC rules say each personnel and employment record must be kept for one year from the date it was made or the personnel action was taken, whichever is later, so the tracker you already keep can serve as that record.
Make HR the easy part of running your business
Onboarding, e-signatures, training and core HR in one place. Up and running in 5 minutes.
- 7-day free trial
- No credit card required
- Cancel anytime