How to Calculate the Rate of Turnover for Your Business

Replacing a few employees can feel manageable until the same roles keep opening again. Then owners and managers need answers: is the workforce stable, or are people leaving faster than the business can replace them?
Learning how to calculate rate of turnover gives you a strong starting point. The calculation is simple, but the definition behind it matters.
This guide shows the turnover formula, worked monthly and annual examples, Excel and Google Sheets formulas, voluntary and involuntary turnover methods, and steps after the result is known. You will also learn how to connect turnover with hiring, retention, and operating decisions.
What Is Employee Turnover Rate, and Why Does the Calculation Matter?
Define employee turnover in plain language
Employee turnover rate is the percentage of employees who leave a defined workforce during a defined period. The period might be one month, a quarter, a year, or a rolling 12 months. The workforce might be the whole company, a plant, a shift, a department, or a job family.
The word “leave” needs a clear definition. Total turnover may include voluntary resignations, involuntary terminations, layoffs, retirements, deaths, and other separations.
A voluntary turnover rate usually counts resignations or other employee-initiated exits. An involuntary turnover rate usually counts employer-initiated terminations and layoffs.
Turnover, attrition, retention, and vacancy rate are related but different:
- Turnover measures employees who leave during a period.
- Attrition often describes a reduction in headcount when an employee leaves, and the role is not replaced. Organizations do not always use the term in the same way.
- Retention measures how many employees remain, often from a starting cohort.
- Vacancy rate measures open positions compared with approved or budgeted positions.
Every percentage should state its period, population, and separation definition. A 5% monthly turnover rate and a 5% annual turnover rate are not equivalent. The first may signal a serious short-term problem, while the second may be reasonable for a particular role or labor market.
Why owners and HR teams track it
Turnover affects more than the HR report. Repeated exits can create:
- More recruiting and interview work
- Overtime for employees covering open shifts
- Lower output while new hires learn the job
- Higher training and onboarding expense
- More safety exposure when inexperienced employees work without enough support
- Extra time for supervisors, payroll, HR, and procurement teams
- Inconsistent customer service or production quality
For workforce planning, turnover helps leaders estimate how many hires they need just to keep headcount steady. A business planning to add 20 employees may need to recruit more than 20 if it expects regular separations during the same period.
A company-wide rate can also hide the real issue. Overall turnover may look moderate even when the night shift, one manager, one location, or one job family has a serious retention problem.
Set the measurement rule before reporting
Choose a formula and definition before building your baseline. Write down:
- The measurement period
- Employees included in the population
- Separation categories included
- The headcount denominator
- The data source and report owner
The Society for Human Resource Management (SHRM) describes turnover as separations during a period divided by the average number of employees during that period, multiplied by 100. That average-headcount method is the main formula used in this guide.
What Is the Employee Turnover Rate Formula?
The standard formula
Use this formula for total employee turnover:
Employee turnover rate =
(Number of separations during the period ÷ Average number of employees during the period) × 100
The formula has three parts.
Separations are employees who left during the period. Decide whether your total includes resignations, terminations, layoffs, retirements, deaths, transfers, or another category. Keep the rule consistent.
Average number of employees is the typical employee count during the period. For a quick calculation, use:
Average headcount = (Beginning headcount + Ending headcount) ÷ 2
Measurement period is the time and population being measured. Label the result as monthly company turnover, annual manufacturing turnover, quarterly warehouse turnover, or another specific measure.
Example: calculate average headcount
Suppose a company had 80 employees on January 1 and 90 employees on December 31. Its simple average headcount is:
(80 + 90) ÷ 2 = 85 employees
If eight employees separated during the year:
8 ÷ 85 × 100 = 9.41%
Rounded to one decimal place, the annual turnover rate is 9.4%.
This is a fictional example for illustration. Use payroll or HRIS records for an actual company report.
The beginning-headcount method
Some organizations divide separations by the number of employees at the start of the period:
Beginning-headcount turnover = (Separations ÷ Beginning headcount) × 100
This method can help when the question is, “What share of the starting employee group left?” It can also be useful for a fixed cohort. It may produce a different result from the average-headcount formula when a business grows or shrinks quickly.
Neither method should be mixed casually with the other. Document the method in your HR dashboard, reports, and benchmark notes.
If your HRIS, investor report, client contract, or industry benchmark already requires one definition, follow that standard. When comparing two businesses, confirm that their numerator, denominator, period, and employee population match.
Which formula should your business use?
For a normal monthly, quarterly, or annual operating report, the average-headcount formula is a practical default. It reflects changes in staffing during the period and is easy to explain to operations and finance leaders.
For a new-hire cohort, use the cohort as the denominator. For example, 6 of 40 new hires leaving within 90 days is a 15% 90-day new-hire turnover rate. Do not compare that number directly with the total-company annual turnover rate as if they measured the same population.
How to Calculate the Rate of Turnover Step by Step
Step 1: Choose the measurement period
Match the period to the decision you need to make.
Monthly turnover helps identify spikes, seasonal exits, attendance problems, and shift-level issues. It can move sharply in a small team, so treat it as a signal.
Quarterly turnover smooths some monthly variation and works well for leadership reviews. It is useful when a team is too small for a stable monthly percentage.
Annual or rolling 12-month turnover supports budget planning, workforce forecasting, and longer-term trend analysis. A rolling 12-month report reduces the effect of choosing one calendar year boundary.
If your business has seasonal hiring, compare the same period in the previous year. A distribution center may see more exits after a peak season, while a manufacturer may see more movement after a production ramp.
Step 2: Define who is included
Write a short population rule before pulling data. Decide whether the calculation includes:
- Full-time employees
- Part-time employees
- Seasonal employees
- Temporary workers on the company payroll
- Employees on approved leave
- Interns or apprentices
- Contractors paid by another employer
The answer depends on the business question and the reporting standard. A company-wide payroll report may include regular full-time and part-time employees.
A manufacturing shift report may focus on employees assigned to that line. Agency workers may require a separate measure if they are employed by a staffing provider.
Classify internal transfers carefully. If an employee moves from production to quality within the same company, that is usually an internal movement rather than an external separation.
If your goal is to measure stability in the production department, track the transfer as a department loss in a separate internal-mobility measure.
Create a written data dictionary. HR, payroll, finance, managers, and procurement should use the same terms for employee, separation, transfer, rehire, and active headcount.
Step 3: Count separations consistently
For total turnover, count all separations covered by your rule. For diagnosis, split them into categories:
- Voluntary resignation
- Job abandonment
- Retirement
- Involuntary termination
- Layoff or reduction in force
- Death or disability
- Internal transfer
- End of a seasonal assignment
Do not label a rate “voluntary” if it includes employer-initiated terminations. Use the separation reason recorded in the HRIS or payroll system. Exit interviews can add context, but they should not replace the official separation record.
The U.S. Bureau of Labor Statistics (BLS) also separates quits, layoffs and discharges, and other separations in its Job Openings and Labor Turnover Survey. The BLS categories are useful for external context, but an employer should compare its own definitions with the BLS definitions before using the figures as a benchmark.
Step 4: Calculate average headcount
For a quick estimate, add beginning and ending headcount and divide by two. This works reasonably well when headcount changes gradually.
For a fast-growing, shrinking, or seasonal business, use average monthly headcount. Add each month’s headcount snapshot and divide by the number of months. More frequent snapshots can improve accuracy when the workforce changes quickly.
The numerator and denominator must describe the same population. If separations include only production employees, the average headcount should also include only production employees.
Step 5: Apply the formula and round consistently
Divide separations by average headcount, then multiply by 100. Use one decimal place for an operations dashboard and keep the unrounded value in the spreadsheet. Always label the result with its period and type, such as “Q2 voluntary turnover, production employees, 7.8%.”
Step 6: Validate the result
Before publishing the number, ask:
- Does the separation count match payroll or HRIS records?
- Are duplicate employee records removed?
- Are internal transfers classified consistently?
- Did the numerator and denominator use the same population?
- Are rehires treated according to the written rule?
- Is the result compared with the same period last year?
Practical data checklist for employers
Keep these fields available for a useful turnover analysis:
- Beginning and ending headcount
- Separation date and reason
- Department, location, shift, and job title
- Hire date and tenure at separation
- Manager or supervisor
- Employment type
- Source system and report date
These fields allow a leader to move from “turnover is high” to “90-day voluntary turnover is high on the night shift under one supervisor.” That is a much more useful management question.
How to Calculate Monthly, Quarterly, Annual, and Segment-Specific Turnover
Monthly turnover example
This fictional example uses a production department.
- Beginning headcount: 120
- Ending headcount: 116
- Employees who left: 7
- Average headcount: (120 + 116) ÷ 2 = 118
- Monthly turnover: 7 ÷ 118 × 100 = 5.9%
A 5.9% monthly rate does not automatically mean annual turnover will be 70.8%. Monthly rates can reflect seasonal work, a one-time restructuring, or a small denominator. Review the next few months and compare the same month in the prior year.
Quarterly turnover example
Suppose a company begins the quarter with 300 employees, ends with 294, and records 18 separations.
Average headcount = (300 + 294) ÷ 2 = 297
Quarterly turnover = 18 ÷ 297 × 100 = 6.1%
Compare the result with the previous quarter and the same quarter last year. A seasonal business may have a predictable increase in one quarter. A sudden increase outside the normal pattern deserves investigation.
Annual turnover example
Suppose an employer starts the year with 500 employees, ends with 530, and records 64 separations.
Average headcount = (500 + 530) ÷ 2 = 515
Annual turnover = 64 ÷ 515 × 100 = 12.4%
Annual turnover is not automatically the average of monthly percentages. If your organization adds monthly rates together, use the method required by your reporting standard and document it.
Using monthly average headcount can provide a more accurate annual calculation when hiring and exits vary substantially throughout the year.
Voluntary turnover rate
Use this formula:
Voluntary turnover rate = (Voluntary resignations ÷ Average headcount) × 100
Your policy should state whether job abandonment, employee-initiated retirement, or relocation counts as voluntary.
A resignation reason should come from the HRIS record instead of an assumption made after the employee leaves.
Involuntary turnover rate
Use this formula:
Involuntary turnover rate = (Terminations and layoffs ÷ Average headcount) × 100
Performance terminations, policy violations, reductions in force, and seasonal layoffs may need separate categories.
A high involuntary rate does not prove that recruiting failed. It may reflect restructuring, a change in production demand, or a performance-management issue. Review the business context before choosing an intervention.
First-year and 90-day turnover
First-year turnover measures the share of a new-hire cohort that leaves before completing 12 months. Thirty-day and 90-day turnover measure early retention. The denominator is the relevant new-hire cohort, not the full company headcount.
For example, if six of 40 employees hired in April leave within 90 days:
90-day new-hire turnover = 6 ÷ 40 × 100 = 15%
This measure can reveal problems with job previews, onboarding, supervisor support, scheduling, or the selection process.
Department, location, shift, role, and manager turnover
Use the same formula for a department or shift, but name the population clearly. Manufacturing employers may compare day shift, night shift, weekend shift, production lines, maintenance, quality, warehouse, and engineering groups.
Useful cuts include:
- Tenure band
- Manager or supervisor
- Pay band
- Work location
- Job family
- Employment type
- Source of hire
Protect privacy when a team is very small. A report showing one or two individual exits can reveal personal information. Combine small groups or report trends over a longer period when needed.
How to Calculate Turnover Rate in Excel or Google Sheets
Simple spreadsheet layout
Create one row per period with these columns:
Period | Beginning Headcount | Ending Headcount | Separations | Average Headcount | Turnover Rate
If the first data row is row 2, the formulas can be:
Average headcount: = (B2+C2)/2
Turnover rate: = D2/E2
Format the turnover-rate cell as a percentage. If cell D2 contains 7 separations and E2 contains an average headcount of 118, the result displays as 5.9%.
Add voluntary and involuntary separation columns when you need diagnostic detail.
For a rolling 12-month measure, sum the last 12 months of separations and divide by the chosen annual average-headcount denominator. Use the same method each month.
Spreadsheet controls
Good controls make the result easier to trust:
- Add a data-validation list for separation reasons.
- Freeze the row containing definitions.
- Record the source system and report owner.
- Protect formula cells.
- Keep a change log for definition or population changes.
A copy-and-paste template is a useful content upgrade for managers who want to start quickly. If you publish one, include the formula definition and a sample row so users do not confuse 0.059 with 5.9%.
How to Interpret a High or Low Turnover Rate
Do not call a rate good or bad without context
There is no universal turnover number that fits every employer. Compare the result with your own history, role family, location, season, and labor market.
Hourly entry-level roles may experience different turnover patterns from skilled technicians, engineers, or plant managers.
A low rate can be positive, but it can also hide limited internal mobility, an aging workforce, or employees staying because they see no other option.
A higher rate may be expected in a seasonal operation. The question is whether the rate is expected, affordable, and aligned with business goals.
Compare the right measures
The BLS reported a 3.3% total nonfarm separations rate and a 2.1% quits rate for September 2026. Its JOLTS release explains that total separations include quits, layoffs and discharges, and other separations.
Manufacturing’s September 2026 total separations rate was 2.5% in the BLS industry table. These are monthly, seasonally adjusted national estimates, not a target for an individual company.
Use the BLS JOLTS latest numbers for labor-market context. Before comparing, confirm the frequency, seasonal adjustment, industry, employee population, and separation definition.
Look for patterns behind the percentage
Slice the rate by:
- 0–30 days, 31–90 days, 3–12 months, and over one year of tenure
- Manager or supervisor
- Shift and schedule
- Pay band and overtime exposure
- Job family and location
- Voluntary versus involuntary reason
- Source of hire and recruiter
The earliest point of exit is especially useful. If most employees leave within 30 days, investigate the job preview, offer process, schedule, transportation, training, and first-week support.
If employees leave after two years, review pay progression, manager effectiveness, career growth, and workload.
Connect turnover to operating metrics
Turnover becomes more useful when paired with other measures:
- Time to fill and time to start
- Cost per hire and cost of vacancy
- Overtime hours caused by open positions
- Absenteeism and no-show rates
- Productivity, quality, and safety results
- Offer acceptance
- 30-day and 90-day retention
Bluebix’s manufacturing hiring guidance recommends connecting recruiting activity to operating outcomes. This same approach helps an employer explain why a turnover pattern deserves investment.
What Should a Business Do After Calculating Turnover?
Diagnose before launching a retention program
Start with evidence. Review exit interviews, stay interviews, attendance, engagement surveys, supervisor feedback, pay data, scheduling, job descriptions, and onboarding records.
Ask whether the problem begins with attraction, selection, job expectations, training, supervision, compensation, workload, scheduling, or career growth.
For recurring exits in one role, use a simple five-whys exercise. For example, employees leave the night shift. Why? The schedule changes often. Why? The team receives the schedule late. Why? The supervisor waits for production forecasts. That path points toward a scheduling process change rather than a broad morale campaign.
Reduce preventable early turnover
Set accurate expectations before the offer. Explain pay, shift times, overtime, physical demands, attendance rules, commute considerations, equipment, and job duties. A realistic job preview may reduce applicants, but it can improve fit and new-hire retention.
Then reduce avoidable delays between application, screening, interview, offer, and start date. Use a structured first-day and first-week plan. Schedule supervisor or peer check-ins on days 7, 30, 60, and 90.
Improve manager and shift-level conditions
Frontline managers need support with feedback, schedule communication, coaching, and respectful performance management. Review shift premiums, transportation barriers, mandatory overtime, break practices, and schedule predictability.
Create a documented escalation path for safety, harassment, payroll, and scheduling concerns. Employees should know where to raise a problem and when to expect a response.
Build a measurable action plan
Use this four-part template:
- Finding: Night-shift 90-day turnover is 18%.
- Likely driver: Schedule mismatch and unclear overtime expectations.
- Intervention: Publish schedules earlier, explain overtime during screening, and add a first-week supervisor check-in.
- Success measure: Reduce night-shift 90-day turnover to 12% over two quarters while monitoring attendance and productivity.
Do not change five things at once if you cannot tell which action worked. Set a review date and track the result with the same formula.
When staffing support can help
Staffing support can help when vacancies are causing overtime, production delays, recruiter overload, or urgent multi-shift demand. It can also add flexibility when an employer needs temporary coverage while building a permanent talent pipeline.
Bluebix’s manufacturing staffing services and manufacturing staffing case study describe temporary, contract, and direct-hire support for production, quality, engineering, logistics, maintenance, and related operations.
An employer considering support should share the role, location, shift, volume, qualifications, and target start date so the staffing model matches the operational need.
Turnover Reporting Dashboard and Review Cadence
Weekly operating view
Review new starts, no-shows, open vacancies, separations, first-week exits, overtime caused by vacancies, and urgent replacement requests. This view helps supervisors act before a monthly percentage arrives.
Monthly HR and manager view
Review total turnover, voluntary turnover, involuntary turnover, 30-day turnover, 90-day turnover, absenteeism, time to fill, offer acceptance, and source of hire. Add department, shift, location, and manager cuts where privacy allows.
Quarterly leadership view
Show the trend against prior quarters, cost of turnover, high-risk roles, manager or shift patterns, retention actions, and progress against targets. Assign one owner to the dashboard. Publish the formula definition, timestamp every report, and explain any change to the population or denominator.
FAQs About Calculating Employee Turnover
What is the simplest employee turnover formula?
Divide the number of separations during a period by the average number of employees during that period, then multiply by 100. State whether separations include all exits, voluntary resignations, or another category. Also state the period and employee population so readers can interpret the percentage correctly.
How do I calculate annual turnover?
Divide annual separations by average annual headcount, then multiply by 100. For a seasonal workforce, calculate average headcount from monthly snapshots instead of using only beginning and ending headcount. Use the same annual definition each year so the trend remains comparable.
Should new hires be included in the turnover denominator?
For company-wide turnover, use the defined employee population and average headcount for the period. For first-year or 90-day turnover, use the relevant new-hire cohort. Keep cohort turnover separate from the company-wide rate because the two measures answer different questions.
What is the difference between turnover and retention?
Turnover measures employees who leave. Retention measures employees who remain, often from a starting group. They are related but not interchangeable. A company can have acceptable overall turnover and still have weak new-hire retention if many recent hires leave before completing their first 90 days.
Can I calculate turnover for one department or shift?
Yes. Use the same formula with a clearly defined department or shift population. Match the separation count to the same group’s average headcount. Combine very small groups or extend the reporting period when a result could identify an individual employee.
How often should a business calculate turnover?
Track it monthly for operating signals, review it quarterly for patterns, and report it annually or on a rolling 12-month basis for planning. Small teams may need quarterly reporting because one exit can create a large monthly percentage that does not show a reliable trend.
What should I do if turnover is high?
Segment the rate by tenure, shift, manager, role, location, pay, and separation reason. Identify where exits begin, validate the pattern with HRIS and employee feedback, and test a focused intervention. Avoid launching a broad retention program before you understand the likely cause.
Can I add monthly turnover percentages to calculate annual turnover?
Some reporting standards add monthly rates, but that method should be documented. A direct annual calculation uses annual separations divided by average annual headcount. Monthly percentages can use different denominators, so adding them may not match the direct annual result.
What is a good employee turnover rate?
There is no single good rate for every business. Compare the measure with your own history, role, location, season, labor market, and operating cost. A rate is more concerning when it is rising, concentrated in critical roles, linked to early exits, or creating overtime and production problems.
How can a staffing agency help reduce turnover?
A staffing partner can help define job requirements, source candidates, screen for skills and availability, and match hiring models to demand. The employer still owns workplace conditions and retention. Share the shift, pay, duties, training, and success measures so the partner can recruit for a realistic job.
Conclusion
Calculating turnover is simple after your business defines the period, employee population, separation types, and denominator. Use the standard formula: separations divided by average headcount, multiplied by 100.
Then compare consistent measures, segment the result, and connect it with time to fill, cost of vacancy, onboarding, manager practices, and 30- or 90-day retention.
Use the dashboard to assign ownership, review progress regularly, and keep definitions stable as the business grows.
If recurring vacancies are creating overtime, delayed production, or workforce-planning pressure, contact Bluebix Inc. to discuss your role, location, shift, hiring volume, and next steps.
About the Author
BluebixInc Editorial Team
Staffing insights and workforce solutions for employers.
