Employee turnover rate inputs
Use the first date in the HR reporting window, such as the first day of the month or quarter.
Use the final date in the same window; the period must end on or after the start date.
Enter a whole employee count from the first day of the period.
Enter the whole employee count on the last day after hires and exits are reflected.
Use whole exits for resignations, retirements, or other employee-initiated departures.
Use whole exits for terminations, layoffs, or employer-initiated departures in scope.
Enter 0 when every exit is already classified as voluntary or involuntary.
Choose the headcount base your HR report uses; average headcount is the default.
Enter a non-negative headcount base, such as a payroll average or monthly average.
Turn on to show a 365-day equivalent beside the actual period rate.
{{ annualizeEnabled ? 'On' : 'Off' }}
Optional whole count for headcount reconciliation; turnover rates do not use hires.
Use a short export label, e.g. All employees, Sales, or Hourly staff.
Metric Value Formula note Copy
{{ row.metric }} {{ row.value }} {{ row.note }}
Separation type Count Share of separations Turnover rate Copy
{{ row.label }} {{ formatNumber(row.count, 0) }} {{ formatPercent(row.share) }} {{ formatPercent(row.rate) }}
Total {{ formatNumber(totalSeparations, 0) }} {{ formatPercent(totalSeparations > 0 ? 100 : 0) }} {{ formatPercent(metrics.totalTurnoverRate) }}
Enter a positive denominator to render the turnover rate profile.
Enter at least one positive separation count to render the separation mix chart.
Ledger item Detail Copy
{{ row.label }} {{ row.detail }}
Check Status Detail Next step Copy
{{ row.check }} {{ row.status }} {{ row.detail }} {{ row.nextStep }}

                
Customize
Advanced
:

Introduction:

Employee turnover is a workforce flow measure. It counts people leaving a defined population during a defined period, then scales those exits against a headcount base so teams of different sizes can be compared without relying on raw exit counts alone. A five-person loss in a 20-person support team is a very different signal from five exits in a 500-person division.

The measure is most useful when the population and period are clear. Monthly turnover helps managers spot recent churn, quarterly turnover supports people-review and budget discussions, and annual turnover can show whether a department, location, or job family is drifting away from its normal pattern. The same arithmetic can be applied to all employees, hourly employees, a single location, a job family, or another group, but the numerator and denominator must describe the same group.

Separation wording matters because not every exit points to the same follow-up. Voluntary exits usually include employee-initiated departures such as resignations, while involuntary exits cover employer-initiated departures such as layoffs, discharges, or terminations. Many HR reports keep a third category for retirements, transfers, deaths, disability-related exits, uncoded records, or local policy exceptions. Those categories can change the story more than the total percentage.

Employee turnover rate inputs A reporting window gathers separations, a headcount base supplies the denominator, and the result is a turnover percentage that needs population context. Turnover rate anatomy A defensible rate names the period, the exits counted, and the headcount base. Period window start date to end date Separations voluntary involuntary other Rate exits / base x 100 headcount base: average, starting, ending, or approved custom denominator

A common mistake is to compare rates that were built from different definitions. A quarterly all-employee rate, a monthly hourly-worker rate, and an annual voluntary-only rate may all be correct, yet they answer different questions. The rate also becomes unstable in very small groups because one exit can move the percentage sharply.

Turnover should not be read as a complete workforce-health score. A high rate may be expected in seasonal work, internships, short contracts, or planned reductions. A low rate can still hide weak engagement, limited internal movement, or stale skills. The percentage works best as a starting point for asking better questions about hiring pace, vacancy time, tenure, pay, manager changes, absenteeism, and business context.

Common employee turnover reporting choices
Reporting choice Why it changes the rate Check before sharing
Period length Monthly, quarterly, and annual windows scale different slices of exit flow. Do not compare a short-window result with a full-year benchmark without annualization context.
Population All employees, one location, one job family, or one worker type can produce different rates. Make sure exits and headcount come from the same population rule.
Separation type Voluntary, involuntary, and other exits point to different causes and follow-ups. Confirm uncoded or policy-specific exits before comparing categories.
Denominator The headcount base controls the scale of the percentage. Label whether the base is average, starting, ending, or custom.

How to Use This Tool:

Enter one consistent workforce population from start to finish. Results appear when the date window, counts, and selected denominator are valid.

  1. Set Period start and Period end. The period end must be on or after the start date, and the day count is inclusive.
  2. Enter Starting headcount and Ending headcount from the same employee population. Use whole employee counts that match the separation scope.
  3. Enter Voluntary separations, Involuntary separations, and Other separations. Use 0 for a category with no exits.
  4. Choose Calculation basis. Average headcount is the default; use Starting headcount, Ending headcount, or Custom denominator when your HR report requires that base.
  5. Turn Annualized rate on only when a 365-day equivalent helps comparison. Treat short-period annualization as directional because a few days of churn can expand into a large yearly number.
  6. Open Advanced when you need Hires during period for the reconciliation check or a Population label for tables and exports.
  7. Read Turnover Metrics first, then use Separation Mix, Turnover Rate Profile, Separation Mix Chart, Formula Ledger, and Review Flags to verify the result before copying or downloading evidence.

Interpreting Results:

Total turnover rate is the headline percentage: total separations divided by the selected headcount base. It should be read beside Voluntary turnover rate, Involuntary turnover rate, and Other turnover rate so the category mix does not get hidden inside one number.

Retention estimate is 100% - total turnover rate. It is a useful complement, but it is not the same as a formal cohort retention rate because it does not track a fixed starting group and exclude later hires in the same way.

  • Annualized turnover rate multiplies the actual period rate by 365 / inclusive days. Use the actual period rate as the primary result for short windows.
  • Formula Ledger shows the selected denominator, turnover formulas, annualization math, and headcount reconciliation path.
  • Review Flags call out a non-average denominator, a short annualized period, other or unknown separations, turnover above 100%, and headcount reconciliation gaps.
  • A valid rate still needs a written population, period, separation definition, and denominator label before it can be compared with another report.

Technical Details:

Turnover is a rate built from a flow count and a stock-like workforce base. Separations happen over time, while headcount describes the size of the population used to scale that flow. Average headcount is a common denominator because it uses both the opening and closing workforce size, but a starting, ending, or custom base can be valid when a written reporting policy calls for it.

Public labor-market sources often classify separations as quits, layoffs and discharges, and other separations. Internal HR systems may map those categories into voluntary, involuntary, and other or unknown exits. The calculation is still the same once categories are chosen: the selected exit count becomes the numerator and the selected headcount base becomes the denominator.

Formula Core:

The calculation adds the three separation categories, divides by the active denominator, and formats displayed percentage values to two decimal places. CSV exports keep four decimal places for rate values, and JSON keeps numeric rate values rounded to six decimal places.

S = Sv+Si+So Davg = Hstart+Hend2 T = SD×100 A = T×365P R = 100T

Here S is total separations, Sv is voluntary separations, Si is involuntary separations, So is other separations, D is the selected denominator, T is total turnover rate, A is annualized turnover rate, P is inclusive calendar days, and R is the retention estimate.

With 4 voluntary exits, 1 involuntary exit, 0 other exits, 100 starting employees, and 104 ending employees, average headcount is (100 + 104) / 2 = 102. Total turnover is 5 / 102 x 100 = 4.90%. Across 90 inclusive days, annualization gives 4.90% x 365 / 90 = 19.88%.

Employee turnover denominator options
Headcount base Denominator rule Best use
Average headcount (starting headcount + ending headcount) / 2 General period reporting when both opening and closing workforce size should matter.
Starting headcount starting headcount Policies that measure exits against the population present at the start of the window.
Ending headcount ending headcount Policies that intentionally scale exits against the closing workforce size.
Custom denominator Positive numeric headcount base Payroll averages, monthly averages, full-time-equivalent bases, or approved local reporting bases.

Hires do not enter the turnover numerator, but they are useful for checking whether the headcount movement is coherent. The reconciliation path compares actual ending headcount with starting headcount plus hires minus separations. A mismatch may be legitimate when transfers, acquisitions, leave rules, reclassifications, or source-system timing affect the population, but the gap should be explained before the percentage is treated as final.

Employee turnover validation and review conditions
Condition Boundary Review cue
Date window Period end must be on or after Period start. Correct the dates before reading the rate.
Numeric counts Headcounts, separation counts, hires, and custom denominator must be 0 or greater. Replace blanks, negative values, or nonnumeric values with valid counts.
Selected denominator The active denominator must be greater than 0. Use a positive base before interpreting any percentage.
Rate magnitude Total turnover above 100% or separations above starting headcount plus hires. Add small-team, seasonal, or high-churn context and recheck the population.
Annualization window Annualized rate is on and the period is shorter than 30 days. Treat the 365-day equivalent as directional only.
Other or unknown exits Other separations is greater than 0. Confirm whether those exits should be recoded before comparing categories.

Worked Examples:

Quarterly all-employee report

A company reports 2026-01-01 through 2026-03-31, starts with 100 employees, ends with 104, records 4 voluntary separations, 1 involuntary separation, 0 other separations, and enters 9 hires. Average headcount is 102, total separations are 5, and Turnover Metrics shows Total turnover rate of 4.90%. The reconciliation ties because 100 + 9 - 5 = 104.

Starting-headcount policy

The same separations produce a different rate when Calculation basis is Starting headcount. The denominator becomes 100, so Total turnover rate becomes 5.00%. Review Flags marks the denominator choice so the report does not get compared with an average-headcount result by mistake.

Seasonal short-window churn

A seasonal group runs a 14-day report, starts with 8 employees, ends with 4, adds 3 hires, and records 7 separations. Average headcount is 6, so Total turnover rate is 116.67%. With Annualized rate on, the review flags should call out both the rate above 100% and the short annualization window.

Custom denominator validation

An analyst chooses Custom denominator for a payroll-average base but leaves the value at 0. The validation message says the selected denominator must be greater than 0. Entering the approved payroll average restores the metrics and shows the custom base in Formula Ledger.

FAQ:

Which denominator should I use first?

Use Average headcount first for most period reports because it reflects both opening and closing workforce counts. Use another base only when the reporting policy or source report requires it.

Why can turnover be over 100%?

Turnover can exceed 100% when total separations are greater than the selected headcount base. This can happen in small, seasonal, or high-churn populations, but the rate needs written context.

Is retention estimate the same as retention rate?

No. Retention estimate is 100% minus Total turnover rate. A formal retention rate usually follows a starting cohort and treats new hires differently.

Why is the separation chart empty?

Separation Mix Chart appears only when at least one separation category has a positive count. If all separation fields are 0, the chart area asks for a positive separation count.

What should I do with a reconciliation delta?

Compare Ending headcount with Starting headcount + Hires during period - total separations. If the delta is real, explain transfers, population rules, acquisitions, leave rules, or source-system timing before using the rate.

Does the calculator upload employee counts?

The calculation runs in the browser. Avoid entering personally identifying employee data anyway; the calculator only needs aggregate headcounts, separation counts, dates, and an optional population label.

Glossary:

Separation
An employee exit counted inside the selected reporting period.
Voluntary separation
An employee-initiated exit, such as a resignation, when that category matches the reporting policy.
Involuntary separation
An employer-initiated exit, such as a layoff, discharge, termination, or completed assignment in scope.
Other separations
Exit records that are unknown, uncategorized, policy-specific, or not cleanly voluntary or involuntary.
Denominator
The headcount base used to scale separations into a turnover percentage.
Annualized turnover rate
The period turnover rate multiplied by 365 / inclusive calendar days.
Reconciliation delta
The difference between actual ending headcount and expected ending headcount after hires and separations.

References: