TrueStep HR
Browse Tools
Preview of the Referral Program Tracker
One-page dashboardReferrals, hires, conversion, bonus cost, cost per referral hire, and the net savings against other channels, every figure updating from your logsXLSX
HR calculator

Referral Program Tracker

Run an employee referral program end to end in one spreadsheet. Set your bonus rules once, log every referral as it moves from submitted to hired, track each bonus to its payout date, and read a one-page dashboard of your referrals, hires, bonus cost, and the savings against agencies and job boards.

$24USD

One-time purchase, no subscription. Instant download.

Built by expert HR practitioners and leaders

  • A working log for every referral: one row per candidate with a status dropdown from submitted to hired, the referring employee, the role, and the hire date, so nothing slips through the cracks
  • Bonus payouts tracked to the date: each hire’s bonus, the eligibility date set by your retention milestone, the days left, and whether it is pending, approved, or paid, so the right person is paid on time
  • A one-page dashboard: referrals, hires, conversion, bonus cost, cost per referral hire, and the net savings against what those hires would have cost through agencies or sourcing, all updating from your logs
  • Your program rules, set once: bonus amounts by role type, the share paid at hire versus the retention milestone, the recency window for prior applicants, and the eligibility rules in plain English
  • Sourced benchmarks and a leaderboard: typical bonus amounts and program stats to sanity-check your setup, plus an optional points leaderboard to recognize your top referrers, in a file you keep and edit

The workbook calculates from what you log. Your bonus amounts, the payout timing, and the cost per hire through other channels are yours to set.

One-time purchase Instant download Editable files 14-day guarantee

Planning estimates and general business information, not legal or tax advice. Referral bonuses are taxable wages, so run them through payroll and confirm overtime handling for hourly staff before launch, since a bonus can change the regular rate. The savings figure counts direct sourcing cost only, not the added value of faster fills and stronger retention.

Not the right fit? Take the 60-second match.

Last reviewed June 2026

One-time purchaseNo subscription
Instant downloadFiles you keep
Editable filesExcel, Word, PDF
14-day guaranteeMoney back
Secure checkoutSSL encrypted
What you get

One Excel workbook that runs the whole referral program from the first referral to the paid bonus

A working system, not a blank sheet. Set your rules once, log referrals and bonuses as they happen, and the leaderboard and dashboard update from what you enter. It opens on a worked example so the flow is clear before you make it your own.

XLSXExcel + Sheets

Referral Program Tracker

Set your bonus amounts and rules on Program Setup, log each candidate on the Referral Tracker with a status from submitted to hired, and record each hire’s bonus and payout date on the Bonus Payout Tracker. The Leaderboard and Dashboard update from what you enter.

XLSXBuilt in

A one-page dashboard, an optional leaderboard, sourced benchmarks, and the method in plain English

The Dashboard reads referrals, hires, conversion, bonus cost, cost per referral hire, and net savings against other channels. A Benchmark tab holds typical bonus amounts and program stats from SHRM and public recruiting data, a Definitions tab explains every status, and the Notes tab documents how each number is built.

How it works

Three steps to run a referral program without software

Set the rules, log what happens, and read the dashboard. The workbook does the math.

STEP 01

Set your program once

Fill the amber cells on Program Setup: your bonus by role type, how much is paid at hire versus a retention milestone, the recency window for prior applicants, and what a hire costs you through other channels. The worked example runs a small warehouse and office program you can replace with your own.

STEP 02

Log referrals and bonuses

Add one row per referral on the Referral Tracker and move each through the status dropdown as it goes from submitted to hired. When a referral is hired, record its bonus and hire date on the Bonus Payout Tracker, which sets the eligibility date and counts down the days to each payout.

STEP 03

Read the dashboard

The Dashboard pulls it together: your referrals, hires, and conversion, the bonus dollars pending and paid, the cost per referral hire, and the net savings against what those hires would have cost through agencies or sourcing. The Leaderboard ranks your top referrers if you want to recognize them.

The standard

A referral program is cheap hiring if you run it like a program

Referrals are the highest-yield hiring channel most employers have, and the worst run. The math is simple: a referral hire costs mostly the bonus, while the same role through an agency or heavy sourcing costs several times more, and referred hires tend to fill faster and stay longer. The problem is rarely the idea and almost always the operation, with bonuses promised and forgotten, payouts that land after the referring employee has left, and no record of who referred whom. A program that logs every referral, tracks each bonus to its payout date, and shows the savings is what turns a good idea into a channel you can count on.

Referrals punch far above their weight. They are only about 7 percent of applicants but account for 30 to 50 percent of hires, a referred candidate is hired several times more often than a job-board applicant, and referred hires fill in about 29 days against 39 or more and stay markedly longer, near 46 percent one-year retention against about 33 percent. The cost is mostly the bonus, which is why good programs keep the bonus below their cost per hire and split it between the hire date and a retention milestone, so the reward still lands while the referring employee is there to collect it.
Pay for the referral before people leave. The most common mistake is a single large bonus paid only after 90 days, which can land after the referring employee has already gone. Split it, part at hire and part at a retention milestone, and use a smaller, faster bonus for high-turnover hourly roles, so the link between the referral and the reward stays intact.
Keep the bonus below your cost per hire. A referral hire only saves money if the bonus is less than what the role would have cost through an agency or sourcing. In the worked example, three referral hires at a $4,700 total bonus avoid about $12,000 of other-channel cost, a net saving near $7,300, the figure to weigh the program against rather than the bonus spend on its own.
Track conversion, but do not confuse it with the share of hires referrals carry. The dashboard’s conversion rate is hires divided by the referrals you logged, a read on how well your referral pipeline closes. That is a different number from the 30 to 50 percent share of all hires referrals are known for, which compares referral hires to hires from every source. Watch your conversion to see whether the referrals coming in fit the open roles, and treat the savings as a direct-cost estimate, not a full accounting of recruiting cost.
Is this for you

Who this workbook fits and where to go if that is not you

It runs a referral program day to day, from the first referral to the paid bonus, with a dashboard of cost and savings. For the written policy and the launch campaign, the fully loaded cost of a hire, or the cost of a role sitting open, the right tool is next to it.

Built for

  • An HR or talent leader at a small or mid-sized employer who wants to run a referral program in one place, without buying recruiting software, and see what it saves.
  • An operations or office manager already paying referral bonuses on loose spreadsheets and sticky notes, who wants every referral logged and every payout tracked to its date.
  • A founder or owner starting a referral program who wants the rules, the tracking, and the savings read set up before the first referral comes in.

If you are looking for

  • The written policy, the bonus and dispute rules, ready-to-send manager and employee messages, and a 30-day launch campaign around this workbook. The Employee Referral Program Kit packages those with it.
  • The fully loaded cost of one hire, the figure to set your bonus below. The Cost Per Hire Calculator builds it up.
  • The cost of a single open role across a full time to fill, the speed side a referral program helps. The Vacancy Cost Calculator prices it.
Questions

Before you buy

What format is it and can I edit it?
It is one Excel workbook that also works in Google Sheets. Every input, dropdown, and formula is editable, and the file is yours to keep. Set your bonus amounts and rules once, log referrals and bonuses as they happen, and duplicate the file to run more than one program or to keep a clean copy each year.
How accurate is the result?
The tracking is solid arithmetic: referrals counted from your log, hires counted from the rows you mark Hired, bonus cost summed from the payout tracker, and net savings as the cost those hires avoided through other channels minus your bonus cost. Two things to keep in mind. The referral conversion rate is hires divided by the referrals you logged, which is not the same as the 30 to 50 percent share of all hires referrals are known for; that share compares referral hires to hires from every source, which this workbook does not track. And the savings count direct sourcing cost only, not the added value of faster fills and stronger retention. Every figure foots to what you enter, and the Benchmark tab gives typical figures to sanity-check your setup.
How is this different from the free calculator?
The free calculator gives you a quick estimate of what a referral program could save before you run one: you enter a hiring plan, an expected referral share, and a bonus, and it returns the program cost, the cost avoided, and the net savings. That is a planning number. This workbook is what you use to run the program day to day. You log every referral and move it from submitted to hired, track each bonus to its eligibility date and payout, recognize your top referrers, and read a dashboard that computes the same savings from your real logged data rather than an estimate. It is a file you own in Excel and Google Sheets, with the program rules, the benchmarks, and the definitions built in. The free tool tells you whether a program is worth starting; the workbook runs it.
How do I handle the bonus and what counts as a valid referral?
Referral bonuses are taxable wages, so run them through payroll with normal withholding, not a gift card or cash on the side, and confirm overtime handling for hourly staff before launch, since a bonus can change the regular rate used for overtime; the right treatment depends on how your program is written, so check with your payroll provider. For what counts, the workbook follows the common rules: any current employee may refer, the first valid referral wins if two people refer the same candidate, a candidate already in your pipeline within the recency window is not a new referral, and both the referring employee and the hire must still be employed on each payout date. Set these in your written policy, and the Program Setup tab holds the amounts and timing the trackers use.
What is the refund policy?
Digital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms.
What happens after I buy?
Checkout delivers an instant download link, and a receipt with the same link arrives by email. Open the workbook in Excel or Google Sheets, set your rules on Program Setup, and start logging referrals. If a file gives you trouble, email support@truestephr.com.
Can I expense this purchase to my business?

Most customers buy TrueStep HR tools for business use, and a tool you use for work often qualifies as a deductible business expense. Whether it does for you depends on your situation, so confirm with your accountant or tax professional. Your receipt arrives by email at checkout and works as documentation.

Free guide

The 6 red flags to check before you discipline or fire someone

A five-minute screen that catches the most common and most expensive people-decision mistakes before they happen. Free PDF, sent to your inbox. Unsubscribe anytime.

Get the calculator

Run your referral program in one place

Set your rules, log every referral and bonus, and read a dashboard of your hires, cost, and savings, in a file you keep.

$24
One-time purchase, no subscription

Planning estimates and general business information, not legal or tax advice. Last reviewed June 2026.