See what hiring costs. The cost per hire, what open roles cost, how many recruiters your reqs need, and whether to use an agency or build in-house.
Four recruiting tools in one workbook
Eight tabs in one Excel file. A Start Here page sets the order to work in, four tools price and plan the hiring, a benchmarks tab keeps the inputs honest, a one-page summary pulls the headlines together, and a Notes tab holds the assumptions you chose and why.
-
Cost Per Hire. Enter the hires and the external and internal recruiting costs for one period: ads, agency fees, background checks, recruiter and hiring-manager time, and tools. Cost per hire calculates on the SHRM and ANSI standard, with the external and internal split.
-
Time to Fill. Set the working days and benefits load, then list each open role with its salary, value multiplier, and days open. The net cost of each vacancy and the total calculate, valuing both the output lost and the pay saved.
-
Recruiter Capacity. Set the reqs one recruiter can carry by complexity, then enter your open reqs as high-volume, professional, and hard-to-fill. The recruiters needed and a recommended team size calculate, with utilization and the gap.
-
Agency vs In-House. Set your in-house cost and capacity, then list the roles you hire by group with agency fee rates. The all-agency cost, the in-house scenario, and the annual saving calculate.
-
Benchmarks. Public figures to sanity check each result: cost per hire from SHRM 2025, time to fill, value multipliers, recruiter capacity, and agency fee ranges, with the source noted per section.
-
Summary. Your recruiting picture on one page. Cost per hire, the net cost of open roles, the recommended recruiters, and the agency-versus-in-house saving, every figure pulled live from the four tools.
From recruiting spend to a number you can plan against
Each tool answers one hiring question, and every result flows to the summary, so the picture stays current as you work.
-
Price a hire. Enter the external and internal costs for one period. Cost per hire calculates on the SHRM and ANSI standard, with the share that is external versus internal.
-
Cost the open roles. List your open roles with salary, a value multiplier, and days open. The net cost of each vacancy nets the output lost against the pay you save while it sits open.
-
Size the recruiting team. Enter your open reqs by complexity. The weighted recruiters needed and a recommended team size show whether you are over or under capacity.
-
Settle agency versus in-house. List the roles you hire and the agency fees. The annual saving from building in-house, at your volume, makes the call visible.
Recruiting numbers that hold up with finance
A recruiting number is only as strong as the assumptions under it, so the pack keeps every assumption on the surface and sources its benchmark figures.
-
Assumptions on the surface. The cost lines, value multipliers, capacity limits, and agency fees are visible, editable cells, not buried constants.
-
Benchmarks from public sources. Cost per hire from the SHRM 2025 report, time to fill and value-of-vacancy ranges from public research, and agency fee norms, with the source next to each figure.
-
Built on a recognized standard. Cost per hire follows the SHRM and ANSI definition, total recruiting cost over the number of hires, so the number is comparable to published benchmarks.
-
A worked example in every tool. The file opens on realistic roles, reqs, and hiring volumes, not a blank sheet you have to decode.
Who it is built for
Built for
- A talent or HR leader who has to show what recruiting costs and whether the team is sized right.
- An HR team of one deciding between an agency and a first in-house recruiter.
- A consultant or fractional HR lead building a recruiting cost case for a client.
If you are looking for
- A staffing plan, not the cost of hiring it. The Workforce Planning Pack covers FTE and headcount, shift coverage, overtime versus hiring, and labor burden.
- The cost of people leaving, not the cost of hiring. The Turnover and Absence Cost Pack covers cost per departure, absence, vacancy, and retention savings.
Before you buy
What format is it and can I edit it?
One Excel workbook, eight tabs. It works in Excel or Google Sheets, every cell is editable, and the file is yours to keep.
Is this legal or tax advice?
No. It is cost math with estimates and general business information. Pay, fees, and recruiting practices vary by company and market, so calibrate the assumptions to your own data before decisions that depend on them.
How is this different from a free cost-per-hire template?
Free templates usually compute one cost-per-hire number and stop. This pack connects four: cost per hire on the SHRM and ANSI standard, the net cost of open roles, the recruiters your reqs need, and the agency-versus-in-house call. Sourced benchmarks and a one-page summary hold it together.
Where do the figures come from?
From your inputs. You enter the recruiting costs, the value multipliers, your reqs, and the agency fees, and each tool calculates from those. Each tool opens with its own worked example, so the example figures differ from tab to tab; the Summary reflects your own numbers once you fill them in. The Benchmarks tab shows public figures next to each result so you can see where your figure lands.
Is it a subscription?
No. One-time purchase, instant download, no recurring fee. You keep the file.
Will it stay current as rates change?
The workbook carries a last-reviewed date, the benchmark figures show their sources next to the results they support, and meaningful updates are released as the numbers change.
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 Start Here tab first; it tells you the order to work in. If the file gives you trouble, email support@truestephr.com.
Planning estimates and general business information, not legal or tax advice. The costs rest on the assumptions you set, so calibrate them to your own data. Last reviewed June 2026.
