HR Staffing Ratio Calculator

See how your HR team compares to the organizations it supports. Enter your total HR headcount and your employee count, and the workbook returns your HR-to-employee ratio and where it sits against benchmarks by company size and industry, with a board-ready summary and a cost-per-employee figure.

A working model, not a blank grid

Enter your total HR FTE, split between HR generalists and specialists and HR operations and admin, and your total employee count. The workbook returns your overall HR-to-employee ratio, the ratio for each sub-function, the employees per HR person, and a cost-per-employee figure when you add the total HR payroll. A comparison table shows where your ratio sits against SHRM and Gartner benchmarks by company size, a one-page Summary carries the ratio, the range, and the cost-per-employee into a budget or headcount conversation, and it opens on a worked example so the logic is clear before you change anything.

A ratio is a starting point, not a verdict

Most finance partners have a benchmark in their head: one HR person per 100 employees, or a ratio from a prior employer. This workbook gives you the published ranges to replace that single number with context. SHRM puts the median HR-to-employee ratio near 1.4 per 100 for companies under 100 employees and close to 0.5 for larger ones, but the range within each band is wide, and a high ratio often reflects payroll or benefits administration in-house while a low one reflects heavy automation or outsourcing. The split between HR operations and HR business partners matters as much as the total, and the cost-per-employee figure connects the team to the budget a finance partner will ask about alongside the ratio.

Built for

• An HR leader defending the current team size or making the case for the next HR hire, who needs a published benchmark to frame the conversation.
• A finance or HR partner reviewing HR headcount costs who wants the ratio and the cost-per-employee in one place.
• An owner or COO who asked what an HR team this size should look like, and wants a real answer rather than a guess.

If you are looking for the number of HR people a workload requires, sized from volume and productive hours rather than a ratio, the FTE Headcount Planner converts demand into headcount.

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 and formula is editable, and the file is yours to keep; duplicate it to model a future team size or track the ratio over time. Checkout delivers an instant download link, with the same link emailed on your receipt.

How current are the benchmarks?

The Benchmark tab notes the source and date of each figure. SHRM and Gartner update their HR benchmarking data annually, and the workbook carries the most recently available figures. The ratios shift slowly, so even a benchmark two or three years old gives a useful frame.

How accurate is the result?

The math is exact for what you enter: the ratio, the sub-function split, the employees per HR person, and the cost-per-employee all foot to your headcount and payroll. The benchmark comparison is only a frame, since the right ratio depends on how much payroll, benefits, and administration your team runs in-house versus outsources, so read the gap as context, not a target.

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.

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.