Calculators
One question, one spreadsheet, one number. Most are under $40 and open in Excel or Google Sheets.
Who this is for: Anyone who needs a defensible figure for a meeting today.
30 products, $24.00 to $89.00. Every product lists what is in it before you buy.
Complete TrueStep HR System
Every TrueStep HR kit and analytics pack in one system, organized across the employee lifecycle from the first job posting to the last day.
- You get
- 84 files — 24 Excel workbooks, 21 Word documents, 39 PDF guides
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.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Attendance Point System Tracker
Run a no-fault attendance point system for a whole team in Excel. Set your point values and thresholds once, log occurrences, and see who has reached a step.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Contingent Labor Cost and Conversion Workbook
Price agency labor against payroll with a defensible model: the four-way comparison, a program-level rollup, a burden builder, and scenario compare.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Contingent Workforce Headcount and Spend Tracker
Keep the contingent program visible: headcount by department, agency spend by vendor, FT-vs-temp ratio, tenure flags at the 18-to-24-month line, and a conversion wat…
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Cost Per Hire Calculator (Excel Template)
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 sa…
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Cost of Turnover Calculator
Build the real cost of losing one employee in Excel: separation, the open vacancy, recruiting, and onboarding, plus the cost as a percent of salary and the annual fi…
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Employee Cost Calculator
See the fully loaded cost of an employee. An editable Excel workbook that adds payroll taxes, benefits, workers
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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…
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
HR Staffing Ratio Calculator
See how your HR team compares to the typical ratio for your size, in Excel. Enter headcount and HR staff for your HR-to-employee ratio and cost per employee.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Labor Burden Rate Calculator
Turn a salary into the fully burdened hourly rate and the multiplier on base pay, in Excel. Layer every employer cost and divide it across productive hours.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Merit Increase Matrix
Run merit increases on a two-axis matrix in Excel. Set performance and range position per person and get each raise, the total cost, and a budget check.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
New Hire Ramp Calculator
See what a new hire costs before they reach full output, in Excel. Enter salary, ramp time, and day-one productivity for the cost per hire and the year.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
RIF and Restructuring Savings Planner
Size a reduction before you make it: the severance bill, the full one-time cost, the ongoing savings, and the payback period. Every assumption on the surface.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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 costs.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Recruiting Analytics Pack
What hiring costs, what open roles cost, how many recruiters your reqs need, and agency versus in-house. Four recruiting tools in one workbook.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Referral Program Tracker
Run an employee referral program in one Excel workbook. Log every referral, track each bonus to its payout date, and read a dashboard of cost and savings.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Salary Band Builder
Build salary bands in Excel. Set one market anchor, a midpoint progression, and a range spread; every grade gets a minimum, midpoint, and maximum.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Span of Control Calculator
See how many direct reports each manager carries, in Excel. Enter your headcount and managers for the average span, org layers, and the cost of reshaping it.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Temp-to-Hire and Direct-Placement Decision Workbook
Price direct hire, temp-to-hire, and direct placement for a role, read the declining buyout against the waiver schedule, and compare a whole requisition portfolio.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
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.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Training ROI Calculator
See whether a training program earns back more than it costs, in Excel. Enter cost, hours, and the productivity gain to get the net benefit, ROI, and payback.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Turnover and Absence Cost Pack
Put a number on people leaving and people away: the cost of a departure, absence with the coverage ripple, vacancy, and what retention saves.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Vacancy Cost Calculator
See what open roles cost you in a year, in Excel. Enter headcount, turnover, and time to fill for the annual vacancy cost and what filling faster saves.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides
Workforce Planning Pack
How many people the workload needs, the staff to cover every shift, overtime versus a new hire, and the true cost of an hour. Four tools, one workbook.
- You get
- 4 files — 1 Excel workbook, 3 PDF guides