How to Calculate Employee Turnover Rate: Formula, Example, and Dashboard

Employee turnover rate is calculated by dividing the number of employees who left during a defined period by the average number of employees during that period, then multiplying by 100. Organizations should calculate total, voluntary, involuntary, and regrettable turnover separately and document which employees and departures each rate includes.

The division is easy. Producing a useful number requires consistent definitions, source data, time periods, and access controls.

What Is the Employee Turnover Rate Formula?

The employee turnover rate shows separations as a percentage of the average workforce during the same period.

Employee turnover rate (%) = Employee separations during the period ÷ Average number of employees during the period × 100

For a simple calculation:

Average headcount = (Opening headcount + Closing headcount) ÷ 2

SHRM’s turnover guidance uses separations during the measurement period divided by average employees, multiplied by 100. Organizations should also define the employee population, time frame, and separation types.

Turnover Measure	Numerator	Denominator	Question It Answers
Total turnover	All included separations	Average eligible headcount	How much of the workforce left?
Voluntary turnover	Employee-initiated separations	Average eligible headcount	How many employees chose to leave?
Involuntary turnover	Employer-initiated separations	Average eligible headcount	How many departures were initiated by the organization?
Regrettable turnover	Voluntary exits classified as regrettable	Average eligible headcount	How much priority talent was lost?
New-hire turnover	New hires who left within the defined tenure window	Employees hired in the defined cohort	Are recently hired employees staying?

The numerator and denominator must cover the same eligible workforce population.

How Do You Calculate Employee Turnover Rate?

Choose the period and employee population, count included separations, calculate average headcount, and apply the formula.

Suppose an organization reports the following annual workforce activity:

Measure	Employees
Opening headcount	1,000
Hires during the year	180
Separations during the year	150
Closing headcount	1,030

First, reconcile the workforce movement:

Opening headcount + Hires – Separations = Closing headcount
1,000 + 180 – 150 = 1,030

Hires support the reconciliation but do not belong in the turnover numerator.

Next, calculate average headcount:
(1,000 + 1,030) ÷ 2 = 1,015

Then calculate annual employee turnover:
150 ÷ 1,015 × 100 = 14.78%

If 110 separations were voluntary:
110 ÷ 1,015 × 100 = 10.84% voluntary turnover

If 28 voluntary exits met the organization’s approved definition of regrettable loss:
28 ÷ 1,015 × 100 = 2.76% regrettable turnover

If 12 monthly headcount snapshots averaged 1,026, total turnover would be 14.62%. This may represent a changing workforce more accurately than two annual snapshots. Document the method and apply it consistently.

Which Employees and Departures Should You Count?

Define the workforce population before calculating the rate. An exit should not appear in the numerator if that employee group was excluded from average headcount.

Calculation Decision	Example Policy
Employee population	Include regular employees; report contractors separately
Separation scope	Report total, voluntary, involuntary, and regrettable turnover separately
Separation date	Use the effective termination date, not the notice date
Headcount basis	Count each active person once; report FTE separately
Internal transfers	Exclude from enterprise turnover; show as business-unit movement
Leave of absence	Follow one documented active-status policy
Multiple assignments	Count each person only once at enterprise level
Rehires	Apply one rule to separation and rehire events
Regrettable loss	Use an approved definition based on role criticality, performance, or succession needs

Turnover is normally person-based. FTE helps Finance measure capacity and labor-cost impact, but mixing a person-based numerator with an FTE denominator changes the rate. Report the two separately.

How Do You Calculate Monthly and Annual Turnover?

Monthly turnover shows recent departures. Annual turnover covers a completed year. Rolling 12-month turnover recalculates the annual window every month, making it easier to compare trends without waiting for year-end.

If 12 employees leave during a month with an average headcount of 1,004:

12 ÷ 1,004 × 100 = 1.20% monthly turnover

Multiplying 1.20% by 12 gives a simple annualized estimate of 14.40%, but assumes one month represents the year. Seasonality, restructuring, acquisitions, or hiring surges can make that misleading.

For executive reporting, show monthly turnover beside a rolling 12-month rate based on actual data. Label any annualized estimate and distinguish it from observed annual turnover.

Employee Turnover vs. Attrition vs. Retention

Turnover, attrition, and retention all describe workforce stability, but their definitions vary across organizations.

Metric	Common Meaning	Important Qualification
Employee turnover	Employees leaving during a period, often followed by replacement activity	May include all or selected separation types
Attrition	Workforce reduction through departures, sometimes without immediate replacement	Often used interchangeably with turnover
Retention	Employees who remained throughout a period	Uses a different numerator and denominator
Replacement rate	Departed employees or positions that were replaced	Measures replenishment rather than departures alone

SHRM calculates retention as employees who remained throughout the period divided by employees present at the beginning. Retention is therefore not always exactly 100% minus turnover.

If turnover and attrition appear in the same dashboard, define both explicitly.

How Do You Calculate the Cost of Employee Turnover?

Turnover rate measures how many people left. Turnover cost estimates the financial effect of replacing those employees or operating without them.

Turnover cost = Separation costs + Vacancy costs + Recruiting costs + Onboarding costs + Ramp-up productivity loss

Cost Category	Possible Components
Separation	Exit administration, final processing, knowledge transfer, and manager time
Vacancy	Overtime, temporary coverage, contractor costs, delayed work, and lost capacity
Recruiting	Advertising, agency fees, assessments, interviews, and recruiter time
Onboarding	Equipment, administration, training, and manager support
Ramp-up	Lower output while the replacement learns the role and organization

Suppose 30 comparable roles turned over during the year and the organization estimated the following average costs per departure:

• Separation and administration: $1,000
• Vacancy and temporary coverage: $6,000
• Recruiting and selection: $4,000
• Onboarding and ramp-up: $9,000

Average cost per departure would be $20,000. Estimated turnover cost for those 30 departures would be:

30 × $20,000 = $600,000

This is an illustrative model, not a universal benchmark. Roles have different vacancy and replacement economics. SHRM provides a turnover cost spreadsheet, but each organization should validate its categories with Finance.

Do not combine estimated lost productivity with booked accounting expenses without identifying the difference. A useful model shows direct costs, modeled costs, assumptions, and owners separately.

How Do Workday, Oracle HCM, and SAP SuccessFactors Support Turnover Reporting?

Workday, Oracle HCM, and SAP SuccessFactors can provide the workforce events and attributes required for turnover reporting. The challenge is mapping different configurations and action codes into one calculation policy.

Source System	Data to Validate
Workday	Worker status, termination effective date and reason, worker type, FTE, organization, location, and effective-dated history
Oracle HCM	Work relationship and assignment status, action and action reason, termination date, FTE, business unit, department, and effective dates
SAP SuccessFactors	Employment status, event and event reason, end date, FTE, organizational assignment, employee type, and effective-dated job history

Configurations differ. Confirm which events represent enterprise departure, how rescinded terminations and rehires are treated, whether an assignment termination ends employment, and which organizational attributes apply on the exit date.

When different regions or acquired businesses use different HCM systems, a governed semantic layer can apply one approved turnover definition across those sources.

What Should an Employee Turnover Dashboard Show?

A turnover dashboard should explain where employees are leaving, how the pattern is changing, and which losses require attention.

Include:

• Total, voluntary, involuntary, and regrettable turnover
• New-hire turnover and critical-role departures
• Monthly and rolling 12-month trends
• Opening headcount, hires, transfers, separations, and closing headcount
• Turnover by department, role, location, tenure, manager, and employee group
• Replacement status and time to fill
• Direct and estimated turnover cost
• Definitions, exclusions, refresh date, and drilldown to supporting events

Keep observed turnover separate from predictive flight risk. A risk model estimates who may be more likely to leave and requires testing, controlled access, and human review. It is not known employee intent.

people analytics software.

How Do You Govern and Secure Turnover Data?

Turnover analysis can expose sensitive compensation, performance, absence, diversity, and employee-level data. A company-wide rate may be shareable while supporting records remain restricted.

Use role-based access, control employee-level drilldown, protect small demographic groups, and approve metric changes. Identify the calculation owner, population, sources, refresh date, and definition.

The same access rules must apply to downloads, alerts, predictive models, and natural-language analysis. A faster way to ask a workforce question should not become a way to bypass the security applied to its underlying data.

Common Employee Turnover Calculation Errors

Most discrepancies come from inconsistent definitions rather than arithmetic. Watch for:

1. Using closing headcount instead of average headcount
2. Adding new hires to the turnover numerator
3. Counting separations from employee groups excluded from the denominator
4. Mixing headcount and FTE in one formula
5. Treating internal transfers as enterprise departures
6. Counting multiple assignments as multiple employees
7. Using notice dates in one source and effective termination dates in another
8. Combining voluntary, involuntary, and regrettable exits into one unexplained rate
9. Annualizing one unusual month without stating the method
10. Comparing business units or benchmarks that use different definitions

The U.S. Bureau of Labor Statistics JOLTS program publishes industry quits and total-separations data, but its measures may not match an organization’s geography, scope, or definition.

When a Governed Workforce Model Replaces Repeated Custom Reports

A custom report may answer one monthly question without creating a reusable definition across HCM systems, Finance models, dashboards, alerts, and AI.

SplashBI Workforce Intelligence provides more than 800 pre-built HR KPIs, over 30 dashboards deployable in under four weeks, and more than 100 HCM connectors. Named sources include Workday, Oracle HCM, SAP SuccessFactors, UKG, Dayforce, iCIMS, and Cornerstone OnDemand.

SplashBI can bring workforce events into a governed layer, support configurable attrition-rate alerts, and connect workforce measures with financial impact. SplashAI lets authorized users ask about departure patterns, cost spikes, and workforce risks using governed HCM data.

Workforce Intelligence inherits native HCM security and applies role-based access control at every layer. Different audiences can receive appropriate access without creating a different turnover definition for each one.

SplashBI helps organizations CONNECT workforce and financial data, UNLOCK it through governed turnover metrics and cost models, and ASK why turnover is changing through SplashAI. The AI BI Flywheel connects those answers back to retention, capacity, and financial planning.

Explore SplashBI People Analytics or request a demonstration of employee turnover reporting across your HCM environment.

Make Turnover Reproducible, Not Merely Reportable

Calculating turnover takes one formula. Using it responsibly requires consistent populations, classifications, periods, cost assumptions, security, and source data. One governed definition makes it a reliable input to retention strategy, workforce analytics, and financial planning.