Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementRecruitment & HiringCost-per-Hire Calculator

SpreadsheetRecruitment & HiringFree

Cost-per-Hire Calculator

Add up internal and external recruiting costs, allocate shared costs and calculate cost per hire by role family.

Shown with sample data

Colour

Cost-per-Hire Calculator

Add up internal and external recruiting costs, allocate shared costs and calculate cost per hire by role family.

Internal costs
$72,300
External costs
$59,050
Total hires
25
Cost per hire
$5,254
(Internal + external) ÷ hires
Recruiting cost ratio
7.4%
Cost ÷ first-year salaries
Cost per hire by role family
  • Engineering$10,025
  • Sales$5,018
  • Customer service$3,491
  • Operations$3,146
Recruiting spend by category
  • Recruiter salaries$46,00035%
  • Agency fees$31,00024%
  • Interviewer time$12,80010%
  • Job advertising$11,6009%
  • Referral bonuses$9,0007%
  • Travel and relocation$8,5006%
  • Other$12,4509%

How to use it

  1. 1Log each cost for the period on the Costs sheet, choosing Internal or External and the role family (or All roles for shared costs).
  2. 2Enter the number of hires and average starting salary for each role family on the Hires sheet.
  3. 3Read cost per hire and the recruiting cost ratio by role family; shared costs are split by hires.
  4. 4Compare periods and channels to decide where to spend next year’s budget.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Know what each hire really costs. Log every recruiting cost as internal (recruiter time, referral bonuses, interviewer time) or external (agencies, job boards, assessments, background checks), tagged to a role family or shared across all roles. The calculator applies the standard formula (internal + external costs ÷ total hires), allocates shared costs by number of hires, and shows cost per hire and the recruiting cost ratio for each role family.

Who it’s for

  • Quarterly or annual recruiting reports
  • Comparing agency and direct hiring costs
  • Building the recruitment budget for next year

What’s included

  • Costs sheet: One row per recruiting cost in the period.
  • Hires sheet: Hires and cost per hire for each role family. Shared costs are split by number of hires.
  • By category sheet: Amount and the number of entries for each category.

How to use it

  1. 1Log each cost for the period on the Costs sheet, choosing Internal or External and the role family (or All roles for shared costs).
  2. 2Enter the number of hires and average starting salary for each role family on the Hires sheet.
  3. 3Read cost per hire and the recruiting cost ratio by role family; shared costs are split by hires.
  4. 4Compare periods and channels to decide where to spend next year’s budget.

Tips

  • Include internal costs: recruiter salaries and interviewer time often exceed external spend but are usually left out.
  • Use the same period for costs and hires (for example costs incurred and hires made in the same quarter).
  • Look at cost per hire alongside quality and retention; the cheapest hires are not always the best.

Questions

What is the cost-per-hire formula?

The SHRM/ANSI standard is (total internal recruiting costs + total external recruiting costs) ÷ total number of hires in the period.

What counts as an internal recruiting cost?

Costs of your own recruiting effort: recruiter and coordinator salaries and benefits, referral bonuses, interviewer time, recruiting technology you own, and internal events.

What is the average cost per hire?

Benchmarks often cite roughly $4,000–$5,000 for US employers overall, with much higher figures for executive and specialist roles. Track your own trend over time.

What is the recruiting cost ratio?

Total recruiting cost ÷ total first-year salaries of the people hired. It makes cost comparable across roles with very different pay.

Related searchescost per hire calculatorcost per hire formularecruiting cost spreadsheetrecruitment budgethiring cost analysistalent acquisition metrics

Details

Format
Spreadsheet
Category
Recruitment & Hiring
Sheets
3
Setup
20 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetRecruitment & HiringFree

Cost-per-Hire Calculator

Add up internal and external recruiting costs, allocate shared costs and calculate cost per hire by role family.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Recruitment & Hiring
Sheets
3
Setup
20 min
Level
Intermediate
Price
Free

Your copy is private to you.

More recruitment & hiring templates

View all
Applicant Tracking Sheet4 sheets

Active candidates

8

Stalled or overdue

8

Hires

1

Hiring funnel
13
11
7
3
1
AppliedScreenInterviewFinalOffer
SpreadsheetRecruitment & Hiring

Applicant Tracking Sheet

Candidates for every open role with stage, scores, next steps and stalled flags, plus a hiring funnel, time to hire and source quality.

10 min setupPreview
Interview Scorecard2 sheets

Interviews scored

6

Top score

90

Average score

75

Average score by candidate
88
77
61
Nadia OkaforLeo FischerInes Duarte
SpreadsheetRecruitment & Hiring

Interview Scorecard

Rate every candidate on the same competencies, weight what matters and compare them side by side.

10 min setupPreview

Job Title

Location: City / Remote · Type: Full-time · Team: Team · Salary: $X–$Y + benefits

About us

Two or three sentences about your mission, customers and culture.

The role

Why this role exists and the impact it will have.

What you'll do

  • •Responsibility with outcome
  • •Responsibility with outcome
  • •Responsibility with outcome
DocumentRecruitment & Hiring

Job Description

An inclusive, structured job description that attracts the right candidates.

30 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ