How to Calculate Attrition Rate: Formula, Example, and HR Dashboard

Attrition rate is calculated by dividing employee separations during a defined period by the average headcount for that period, then multiplying by 100. For reliable reporting, organizations must also define which employees and exits count, how average headcount is calculated, and whether the result represents monthly, annual, or rolling 12-month attrition.

The arithmetic is simple. The numerator and denominator determine whether the result is reliable enough for an executive or board report.

What Is the Attrition Rate Formula?

The standard attrition rate formula measures employee exits as a percentage of the average workforce during the same period.

Attrition rate (%) = Employee exits during the period ÷ Average headcount during the period × 100

For a simple calculation, average headcount can be estimated as:

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

SHRM describes turnover using the same basic structure: separations during the measurement period divided by the average number of employees during that period, multiplied by 100. SHRM also emphasizes defining the positions, employee population, and time frame being measured.

Opening and closing headcount provide a practical estimate for a stable workforce. If headcount changes materially, average consistent monthly or daily snapshots instead.

Calculation	Numerator	Denominator	Primary Use
Total attrition	All included exits	Average eligible headcount	Overall workforce loss
Voluntary attrition	Included voluntary exits	Average eligible headcount	Employee-initiated departures
Involuntary attrition	Included involuntary exits	Average eligible headcount	Employer-initiated departures
Regretted attrition	Voluntary exits classified as regretted	Average eligible headcount	Loss of priority talent
Rolling 12-month attrition	Included exits from the latest 12 months	Average headcount across those months	Comparable trend reporting

“Eligible” matters. Every version should use a documented population and separation policy.

How Do You Calculate Attrition Rate?

Start by selecting the reporting period and workforce population. Then count included exits, calculate average headcount, divide, and convert the result into a percentage.

Suppose an organization reports the following annual workforce activity:

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

First, reconcile the movement:

Opening headcount + Hires − Exits = Closing headcount

1,000 + 180 − 150 = 1,030

Next, calculate average headcount:

(1,000 + 1,030) ÷ 2 = 1,015

Then calculate annual attrition:

150 ÷ 1,015 × 100 = 14.78%

If 110 exits were voluntary, voluntary attrition would be:

110 ÷ 1,015 × 100 = 10.84%

If 28 voluntary exits met the organization’s approved definition of regretted loss, regretted attrition would be:

28 ÷ 1,015 × 100 = 2.76%

Suppose the average of 12 monthly snapshots was 1,026. Total attrition would then be 14.62%. Choose the method that best represents the workforce, document it, and apply it consistently.

Which Employees and Departures Should You Count?

The numerator and denominator must cover the same population. Do not count an exit from a group excluded from average headcount.

Create a calculation policy before publishing the metric:

Decision	Example Policy
Workforce population	Include regular employees; report contractors separately
Separation scope	Show total, voluntary, involuntary, and regretted exits separately
Exit date	Use the effective termination date, not the resignation or notice date
Headcount basis	Use one active person per snapshot; report FTE separately

• Internal transfers: Exclude from enterprise attrition; show as movement between business units
• Leave of absence: Retain as active unless organizational policy says otherwise
• Multiple assignments: Prevent one person from being counted more than once at enterprise level
• Rehires: Apply one documented rule for exit and rehire events
• Regretted loss: Use an approved definition based on criticality, performance, or succession needs

Attrition is normally person-based. FTE can show lost capacity and cost, but combining person exits with an FTE denominator changes the measure. Report them separately.

Monthly vs. Annual vs. Rolling 12-Month Attrition

Monthly attrition shows recent movement. Annual attrition covers a completed year. Rolling 12-month attrition recalculates that window each month for easier comparison.

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

12 ÷ 1,004 × 100 = 1.20%

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

For executive reporting, show the actual monthly rate beside a rolling 12-month rate. If a monthly rate is annualized, label the method clearly rather than presenting the estimate as observed annual attrition.

Attrition vs. Turnover vs. Retention

Attrition, turnover, and retention all describe workforce stability, but organizations do not always define them consistently.

Metric	What It Commonly Measures	Important Qualification
Attrition	Employees leaving a defined workforce	May mean all exits, voluntary exits, or roles not replaced, depending on policy
Turnover	Employee separations during a period	Often used interchangeably with attrition
Retention	Employees who remain throughout a period	Uses a different population and denominator from attrition

SHRM calculates retention as employees who remained for the entire period divided by employees present at the beginning. People hired during the period are not included in the retained group.

This is why retention is not always 100% minus attrition. Different denominators, new hires, internal movement, and employee populations can produce different results. For a broader definition, see the SplashBI attrition glossary.

What Should an Attrition Dashboard Show?

An attrition dashboard should show where departures occur, whether the pattern is changing, and which losses require action.

A useful dashboard includes:

• Total, voluntary, involuntary, and regretted attrition
• Monthly and rolling 12-month trends
• Opening headcount, hires, transfers, exits, and closing headcount
• Attrition by department, location, job family, tenure, manager, and employee group
• New-hire attrition and critical-role departures
• Labor-cost or replacement-cost impact where reliable Finance data is available
• Definitions, exclusions, refresh date, and drilldown to supporting events

Observed attrition should remain separate from predictive flight risk. A flight-risk model estimates who may be more likely to leave. It requires testing, monitoring, controlled access, and human review.

How Do You Govern and Secure Attrition Reporting?

Attrition analysis can expose sensitive compensation, performance, absence, and diversity data. Board-level totals and employee-level records require different access.

Strong governance includes role-based access, controls over employee-level drilldown, suppression or careful handling of very small groups, and a review process for metric changes. Every dashboard should identify the calculation owner, reporting population, source systems, last refresh date, and approved definition.

The same controls must extend to exports, predictive models, alerts, and natural-language analysis. An easier way to ask a workforce question should not become a way to bypass the access rules applied to the underlying data.

Common Attrition Calculation Errors

Most attrition discrepancies come from inconsistent definitions rather than incorrect division. Check for these common errors:

1. Using closing headcount instead of average headcount
2. Counting exits from employee groups excluded from the denominator
3. Mixing headcount and FTE in the same formula
4. Treating internal transfers as enterprise departures
5. Counting multiple assignments as multiple employees
6. Using notice dates in one system and effective termination dates in another
7. Combining voluntary, involuntary, and regretted exits into one unexplained rate
8. Annualizing one unusual month without identifying the method
9. Comparing business units or external benchmarks that use different definitions
10. Publishing a percentage without showing its trend, population, and supporting events

Industry benchmarks require particular care. The U.S. Bureau of Labor Statistics JOLTS program publishes quits and total-separations data by industry, but those measures may not match every organization’s attrition definition, workforce scope, geography, or reporting period.

When a Pre-Built Workforce Model Beats Another Custom Report

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 and over 30 dashboards, with deployment of those dashboards in under four weeks. It also includes more than 100 pre-built HCM connectors, including Workday, Oracle HCM, SAP SuccessFactors, UKG, Ceridian Dayforce, iCIMS, and Cornerstone OnDemand.

For attrition analysis, SplashBI can bring workforce events into a governed layer, support configurable attrition-rate alerts, and connect HR measures with financial impact. SplashAI allows authorized users to ask questions such as what is driving attrition, using the governed HCM data beneath the analysis.

Security remains part of the model. SplashBI states that Workforce Intelligence inherits native security from HCM systems and applies role-based access control at every layer. This helps organizations provide different levels of access to executives, HR teams, managers, analysts, and Finance users without creating separate definitions for each audience.

SplashBI helps teams CONNECT workforce data across HCM, payroll, recruitment, and Finance systems, UNLOCK it through governed workforce models, and ASK questions through SplashAI. This applies the AI BI Flywheel to a metric that must remain consistent from the HR dashboard to the board pack.

Explore People Analytics or request a demonstration of attrition reporting across your HCM environment.

Make the Attrition Definition as Visible as the Percentage

Calculating attrition takes one formula. Reporting it responsibly requires consistent populations, exit classifications, time periods, security, and source data. With one governed definition, attrition becomes a reliable input to retention strategy, workforce analytics, planning, and financial decisions.