Cost of Turnover Calculator

Build the real cost of losing one employee from the ground up. Enter the salaries of the people involved and your time and cost assumptions, and the workbook prices the exit, the open vacancy, recruiting a replacement, and the ramp to full speed, then returns the total per departure, the cost as a percent of salary, and the annual cost at your turnover volume.

A working model, not a blank grid

Enter the salaries of the role that left, the manager, a coworker, and HR, set your working days, then work down four stages: separation, the open vacancy, recruiting, and onboarding. The workbook prices each person’s time from their pay, adds the output lost while the role is open and while a new hire ramps, and returns the total per departure, the share from each stage, the percent of salary, and the annual cost at your turnover volume. A one-page Summary pulls the four stage subtotals and the total into a snapshot for a budget conversation, a Benchmark tab holds turnover-cost ranges by role type from Gallup, SHRM, and public research, and it opens on a worked example so the logic is clear before you change anything.

The cost is mostly lost output, not invoices

The cash you write a check for, job ads and an agency fee, is the small part. The larger cost is the output lost while the seat is empty and while a new hire climbs to full speed, which is why this workbook prices time, not just spend. Each person’s hours are valued from their own salary, so separation, recruiting, and onboarding time carries a real dollar figure. Coverage loss while the role is open and lost output while a new hire ramps are usually the two largest pieces and the ones people skip, so the coverage and ramp percentages move the result most. The workbook then multiplies the per-departure cost by the exits you expect for the role, so a high-turnover seat shows its full annual cost.

Built for

• An HR or finance partner who needs the real cost of a departure to weigh against the cost of retaining people.
• A manager building the case for a counteroffer, a retention program, or a faster backfill, with a number instead of a guess.
• An HR leader who wants a board-ready figure for what turnover in a given role costs per exit and per year.

If you are looking for the yearly cost of seats sitting open from your turnover and time to fill, the Vacancy Cost Calculator prices that. For the all-in cost of filling a role on the ANSI/SHRM formula, see the Cost Per Hire Calculator.

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 cost a second role, since one average hides where the cost concentrates. Checkout delivers an instant download link, with the same link emailed on your receipt.

What does the paid workbook do that a free calculator does not?

This workbook builds the cost from the ground up across four stages, prices each person’s time from their own salary, and separates the output lost while the role is open from the output lost while a new hire ramps. You set your assumptions once, duplicate the file per role, and read every formula behind the number. A free calculator gives you one number from three inputs; this workbook keeps your assumptions on the surface where finance can audit them, and is a file you keep and re-run each year as your pay and turnover change.

What does the cost include?

Four stages, each with its own subtotal. Separation is the time to process the exit, accrued PTO, and any severance. Vacancy is the output lost while the seat is empty. Recruiting is job ads, any agency fee, and the hours HR and the manager spend. Onboarding is training, equipment, and the output lost while the new hire ramps to full speed.

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.

These are planning estimates, only as good as the salaries and time assumptions you enter. The figures are most sensitive to the coverage and ramp percentages, so set those to your situation and use your own numbers rather than the example figures.

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.