HR Staffing Ratio Calculator

See how your HR team stacks up against the typical ratio for your size, and what reshaping it would do to cost. Enter your headcount and your HR staff, and the workbook returns your HR-to-employee ratio, how it compares to the typical range for your size, the gap to a target, and what your HR function costs per employee now and at that target.

One Excel workbook that turns a headcount and an HR count into a benchmarked ratio and a cost

A Start Here tab orients you, and the workbook opens on a worked example so the logic is clear before you change anything.

• HR Ratio Calculator and Cost. Enter your total employees, your HR staff in full-time equivalents, and a target ratio, and the workbook returns your HR-per-100 ratio, employees per HR FTE, the typical low and high for your size, the FTE a target would call for, and the gap to your count today. The Cost tab turns an average loaded HR salary into your HR cost per employee now and at your target.
• Benchmark, Summary, and Notes. A Benchmark tab holds typical HR-per-100 ratios by organization size, with sources from SHRM, Bloomberg Law, ADP, and Indeed and a note on what moves the ratio. A one-page Summary carries the headline numbers, and the Notes tab documents how each figure is built and what to count as HR FTE.

Three steps from a headcount to a benchmarked ratio and its cost

Enter the organization, read your ratio against your size, then cost the gap to a target.

• Enter your headcount and HR staff. Fill the amber cells: total employees including HR, your HR staff in full-time equivalents, and a target ratio if you have one in mind.
• Read your ratio against your size. The workbook returns your HR-per-100 ratio, employees per HR FTE, and the typical low and high for your size band, with the gap to a target alongside.
• Cost the gap. On the Cost tab, enter an average fully loaded HR salary and read your HR cost per employee now and at your target, then read the Summary for the headline numbers.

What the right ratio depends on

A single benchmark hides more than it shows. The ratio that fits you depends on the work your HR team does and the tools it has, which is why this reads your ratio against a range, not a target.

• Benchmarks are a starting point, not a rule. Regulated and people-intensive sectors such as healthcare, finance, and consulting tend to run higher, and HR technology and self-service stretch a team further, so the typical range is context to weigh, not a number to hit.
• The ratio falls as you scale. Under 100 employees HR covers everything with little scale to spread it, while at a thousand and above shared services and automation stretch the team, so compare yourself to your size band rather than to the overall average.
• What you count as HR FTE drives the number. Count generalists and benefits, compensation, and labor relations, and decide consistently whether payroll belongs in or out, because that choice moves your ratio more than anything else.

Who it is built for and where to go if that is not you

Built for

• An HR leader benchmarking the size of the team against organizations of the same size, with a figure for a budget conversation.
• A finance or operations partner sizing the cost of the HR function now and at a target ratio.
• A founder or owner checking whether HR is under-resourced or carrying more than the work needs.

If you are looking for

• The number of people a team needs based on its workload, rather than the HR-to-employee ratio. The FTE Headcount Planner sizes that.
• How many direct reports each manager carries and your org layers, rather than the HR ratio. The Span of Control Calculator covers that.

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 compare divisions or model a target.

There is a free version of this calculator. Why pay for this one?

The free tool gives a quick browser read of your ratio against the typical range and resets when you close the tab. This workbook is the file you keep: it adds the cost side the free tool does not touch, turning an average loaded HR salary into your HR cost per employee now and at a target, with a sourced benchmark tab, a one-page summary built for a budget conversation, and every formula open so you can set what counts as HR FTE to your own operation.

How accurate are the benchmarks?

The benchmark ranges are general estimates from public sources, and the surveys differ: the most-cited figure, from SHRM, is near 1.7 HR staff per 100 employees, while Bloomberg Law lands near 1.5 and broad surveys average near 1.4. Read them as a range to weigh, not a standard, and your own result foots to the headcount and HR count you enter.

What should I count as an HR FTE?

Count generalists plus benefits, compensation, and labor relations, and decide consistently whether to include payroll. How you draw that line is the single biggest influence on your ratio, so the Notes tab has a place to record it.

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 workbook in Excel or Google Sheets, enter your total employees and your HR staff, and read your ratio against the typical range for your size. If a file gives you trouble, email support@truestephr.com.

Planning estimates and general business information, not legal or tax advice. The right ratio depends on your industry, your HR technology, and how strategic HR needs to be, so treat the benchmarks as a starting point, not a rule, and confirm your figures before you act on them. Last reviewed June 2026.