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 referrals, hires, bonus cost, and the savings against agencies and job boards.

A working system, not a blank sheet

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, which sets the eligibility date and counts down to each payout. The Leaderboard and Dashboard update from what you enter and read 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 it opens on a worked example so the flow is clear before you make it your own.

Run it like a program and referrals become your cheapest channel

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. Two rules keep that advantage: split the bonus, part at hire and part at a retention milestone, so it pays before people leave; and keep the bonus below your cost per hire, since a referral only saves money when the bonus is less than the agency or sourcing cost it replaces.

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, bonus and dispute rules, ready-to-send manager and employee messages, and a launch campaign, the Employee Referral Program Kit packages those with this workbook. For the fully loaded cost of one hire to set your bonus below, see the Cost Per Hire Calculator.

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; duplicate it to run more than one program or keep a clean copy each year. Checkout delivers an instant download link, with the same link emailed on your receipt.

How is this different from the free calculator?

This workbook runs the program day to day: you log every referral, track each bonus to its payout, recognize top referrers, and read a dashboard that computes savings from your real logged data, not an estimate. A free calculator estimates what a program could save before you run one, from a hiring plan, an expected referral share, and a bonus; this one runs the program and reports from real logged data.

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 and confirm overtime handling for hourly staff, since a bonus can change the regular rate; check with your payroll provider. The workbook follows the common rules: any current employee may refer, the first valid referral wins on a tie, a candidate already in your pipeline within the recency window is not new, and both the referrer and the hire must still be employed on each payout date.

What is the refund policy?

Digital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms. Questions? Email support@truestephr.com.

These are practical HR tools, not legal or tax advice. Referral bonuses are taxable wages that run through payroll and can affect the overtime regular rate, so confirm the handling with your payroll provider and qualified help before you rely on it.

How the download works

Your files arrive as a single ZIP download, best opened on a computer: save it, extract it (right-click and Extract All on Windows, double-click on a Mac), and open the Start Here file first. PDFs open in any reader, and the editable files work in Microsoft Word and Excel or their free equivalents, including LibreOffice and Google Docs and Sheets. No other software is needed. Step-by-step help for every device is at truestephr.com/pages/download-help.

Scope

This tool is a planning and analysis model. Its outputs depend entirely on the inputs and assumptions you enter, and they are estimates for decision support, not accounting, tax, or legal conclusions. It is not legal, tax, or financial advice, and it is not a substitute for qualified counsel on your specific situation. Check the assumptions against your own data and have any decision with pay, headcount, or separation consequences reviewed against applicable law before you act on it.