TrueStep HR
Get matched
HR Tools

HR Calculators

Editable spreadsheet calculators that turn your own numbers into the figure you need: cost per hire, turnover cost, the fully loaded cost of an employee, severance, staffing ratios, and more. Each one is a one-time purchase you download and keep, and it runs in Excel or Google Sheets.

All HR toolsFree calculators

Not sure? Get matched in 60 seconds →

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

In this collection

Calculator

Agency vs Internal Recruiter ROI Calculator

Compare an in-house recruiter against agency fees in Excel: total cost each way, cost per hire, and the break-even in hires per year, with overflow handled.

from $39View ›
Calculator

Overtime vs New Hire Planner

Weigh recurring overtime against an added hire in Excel: the cost each way per year, the break-even in weekly overtime hours, and a three-year view.

from $39View ›
Calculator

Pay Structure and Internal Equity Review

A directional pay-equity self-assessment in Excel: compare two groups, see the raw pay gap, then the gap that remains after accounting for time in role.

from $39View ›
Calculator

Salary Band Builder

Build salary bands in Excel: set one market anchor, a midpoint progression, and a range spread, and every grade gets a minimum, midpoint, and maximum.

from $39View ›
Calculator

Absenteeism Cost Calculator

Price unplanned absence in Excel: the cost by department, the coverage ripple, the cost per employee vs the CDC benchmark, and what cutting absence days saves.

from $29View ›
Calculator

Attendance Point System Tracker

Run a no-fault attendance point system for a whole team in Excel.

from $29View ›
Calculator

Cost of Turnover Calculator

Build the real cost of losing one employee in Excel: separation, the open vacancy, recruiting, and onboarding, plus the percent of salary and the annual cost.

from $29View ›
Calculator

Cost Per Hire Calculator

Build your cost per hire in Excel on the SHRM and ANSI standard: external spend plus the recruiter and manager time most teams miss, the split, and the percent of first-year salary.

from $29View ›
Calculator

Employee Cost Calculator

See the true cost of an employee, not just salary.

from $29View ›
Calculator

FTE Headcount Planner

Plan headcount in Excel: turn each team’s workload into required FTE, set it against current staff, and get a hiring plan that separates the gap from attrition.

from $29View ›
Calculator

Merit Increase Matrix

Run merit increases on a two-axis matrix in Excel.

from $29View ›
Calculator

Promotion and Internal Equity Calculator

Price one promotion in Excel: the raise in dollars and percent, where it lands in the new range, how it compares to peers, and the loaded first-year cost.

from $29View ›
Calculator

Recruiter Capacity Planner

Size your recruiting team in Excel: open reqs weighted by complexity show the recruiters you need, who on the roster is over capacity, and what right-sizing adds or saves each year.

from $29View ›
Calculator

Severance Planning Calculator

Model a whole reduction in Excel: list every affected employee under one severance policy and total the cost with accrued time off, benefits, and outplacement.

from $29View ›
Calculator

Shift Staffing Planner

Turn coverage into headcount in Excel: set time off once, list each post, and the workbook returns the relief factor and the people you need to staff it.

from $29View ›
Calculator

Time-to-Fill Cost Calculator

Price your open roles in Excel: each vacancy’s value lost net of the pay you save, the net cost of every open role, and what cutting time to fill would save.

from $29View ›
Calculator

Training ROI Calculator

See whether a training program earns back more than it costs, in Excel.

from $29View ›
Calculator

New Hire Ramp Calculator

See what a new hire costs before they reach full output, in Excel.

from $24View ›
Calculator

Referral Program Tracker

Run an employee referral program in one Excel workbook.

from $24View ›
Calculator

Span of Control Calculator

See how many direct reports each manager carries, in Excel.

from $24View ›
Calculator

Vacancy Cost Calculator

See what open roles cost you in a year, in Excel.

from $24View ›

Other shelves: Analytics Packs ›   Compliance and Audit Kits ›   Employee Relations and Leave ›   Hiring and Onboarding ›   Retention and Restructuring ›   EU and Global Pay Transparency ›

With a practitioner

Get a read on the setup behind the numbers

A calculator answers what something costs. It does not tell you whether the setup producing that cost is sound. The free scorecard does, and a senior HR practitioner can read the result with you.

Free scorecard

HR Readiness Scorecard

A six-area scorecard that shows where your HR setup is strong today and the two areas that will give you the most lift next. The Report Review of that result is free, about 20 minutes with a senior HR practitioner.

FreeOpen ›
Kit setup

HR Setup Session

One hour on a screen share once you own the kit. We load your real numbers, walk the outputs together and flag the judgment calls the tool cannot make for you. You leave with it set up and running, not just a plan.

$149See the session ›
For your team

Team Session

The same senior read brought to a manager group or a whole department. Team work is scoped to your group, so it starts with a short conversation. The first priced step is a facilitated 90 minute session.

$499See the options ›
Free guide

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

A five-minute screen to run before you act. Free PDF, sent to your inbox. Unsubscribe anytime.

Keep going

Browse the full TrueStep HR toolkit

Every calculator, pack, and kit in one place, organized by the employee lifecycle.

Browse all tools