Turnover Rate Calculator

How to use the employee turnover rate calculator

What this calculator does

This calculator estimates employee turnover rate for one month, quarter, year, or custom reporting period. It divides the number of employees who permanently left by the average employee population for that same period, then expresses the result as a percentage. It is useful for consistent internal reporting, trend review, workforce planning, and checking whether hiring capacity is keeping pace with separations. It does not diagnose why people left, determine whether a rate is “good,” or replace a segmented analysis by department, job family, location, tenure, or voluntary versus involuntary separation.

When to use it

Use the calculator when preparing a monthly HR dashboard, comparing quarterly workforce stability, building an annual staffing plan, or checking a turnover figure before presenting it to management. It is also useful when reconciling a reported percentage to the underlying headcount records. The U.S. Bureau of Labor Statistics explains the broader concepts of hires, separations, quits, layoffs, and other labor turnover in its Job Openings and Labor Turnover Survey definitions.

How to calculate

1. The calculator opens with a complete demonstration: 95 employees at the beginning of the year, 87 at the end, and 9 employees who left. Results and a validated Excel workbook are available immediately.
2. Choose Average headcount method. Select “Calculate from beginning and end” when you have snapshot counts, or “Enter known average” when payroll or HR reporting already provides a period average.
3. Replace the sample counts with your own data. Use whole people or a documented full-time-equivalent convention consistently; do not mix the two.
4. Read Turnover rate first, then review the average, ending headcount, leavers per 100 employees, net headcount change, and the calculation audit.
5. Select the correct Reporting period label so the interpretation and workbook describe the same time window.
6. Choose Download Excel to export the current typed inputs and results. Reset clears the demonstration and calculated content; Excel download remains unavailable until a complete valid state is entered again.

Input guide

Average headcount method is required and controls which denominator inputs are active. “Calculate from beginning and end” uses two nonnegative counts and computes their arithmetic mean. “Enter known average” expects one positive average count. A common mistake is switching methods while relying on a stale number from the other method; this calculator only uses the fields visible for the selected method.

Employees at beginning and Employees at end are required in the start/end method. Enter nonnegative plain numbers using a dot as the decimal separator, such as 95 and 87. Grouping commas, percent signs, currency symbols, and scientific notation are rejected. Higher beginning or ending counts usually increase the denominator and reduce the rate when leavers are unchanged. Both counts cannot average to zero.

Average number of employees is required only in the known-average method. Enter a positive plain number, such as 91. Use an average calculated under one consistent policy – daily, pay-period, monthly snapshot, or another documented method. Do not enter the ending headcount as a shortcut unless it genuinely represents the period average.

Number of employees who left is required. Enter a nonnegative count, such as 9, for permanent separations in the same population and time window. The rate rises directly as this value increases. Internal transfers and temporary leaves are commonly excluded because the employee has not left the organization, while resignations, retirements, layoffs, and terminations are normally included under a broad total-turnover definition.

Reporting period is required as an interpretation label. Month, Quarter, Year, and Custom period do not annualize or otherwise transform the number. A 9.89% monthly rate and a 9.89% annual rate are numerically equal but describe very different workforce patterns, so never compare them without matching periods.

Output guide

Turnover rate is the primary percentage: employees who left divided by average employees. Zero means no recorded leavers; a higher result means more separations relative to the workforce base. It is an exact result for the entered counts, not a forecast or recommendation. Average employees is the denominator used. Employees retained at period end displays the ending snapshot when the start/end method is used; in known-average mode it is unavailable because an average alone cannot reconstruct ending headcount.

Leavers per 100 average employees is the same rate written as a count per 100, which can be easier to communicate. Net headcount change equals ending minus beginning and is only available in start/end mode. It is not the same as turnover: a company can have high turnover and still grow if hiring exceeds separations. The Calculation audit table shows each input, the denominator calculation, and the final formula so the result can be checked or copied into a review file.

Worked example

With 95 employees at the beginning and 87 at the end, average headcount is (95 + 87) ÷ 2 = 91. If 9 employees left during the year, turnover rate is 9 ÷ 91 × 100 = 9.8901%, displayed as 9.89%. The ending headcount is 87, leavers per 100 average employees is 9.89, and net headcount change is 87 – 95 = – 8. The negative net change does not mean only eight people left; it means the final workforce was eight smaller after both separations and any hiring activity.