Employee Turnover Rate Formula: Calculate and Analyse

"Our attrition is high" is one of the most common sentences in Indian boardrooms, and one of the least useful. High compared to what? Over which period? Counting whom? Without a consistent employee turnover rate formula, leaders end up arguing about numbers instead of fixing the problem. This guide explains how to calculate employee turnover rate correctly, which variations matter, how to slice the number so it becomes actionable, and what to do once you know where people are leaving from.

It is written for HR managers, founders and finance partners at Indian SMBs and startups. You will get the core formulas with worked examples, a data checklist, guidance on handling interns, contractors and transfers, a method for cohort and tenure analysis, a dashboard blueprint and answers to common questions. We do not quote industry benchmarks as facts; instead, we show you how to build your own internal benchmarks, which are usually more useful than a generic percentage from a report.

Turnover, Attrition and Retention: Clearing Up the Terms

People use these words loosely, so define them once for your organisation.

• Employee turnover rate: The percentage of employees who leave during a period, relative to the average headcount in that period.
• Attrition: In everyday Indian HR usage, attrition and turnover are often used interchangeably. Some teams reserve attrition for exits that are not replaced, but that is not universal. Pick a definition and document it.
• Retention rate: The share of employees who stay through a period. It is the mirror of turnover, but is often calculated for a specific group, such as everyone present at the start of the year.
• Voluntary turnover: Exits initiated by the employee, such as resignations.
• Involuntary turnover: Exits initiated by the employer, such as terminations, layoffs and non-confirmation.
• Regretted and non-regretted turnover: Whether the company would have preferred to keep the person. We cover this in our guide to regretted attrition measurement and reduction.

Whichever terms you use, write them in a one-page metrics glossary and share it with leadership. Many arguments about "the real attrition number" are really arguments about definitions.

The Basic Employee Turnover Rate Formula

The most widely used formula is:

Turnover rate (%) = (Number of separations during the period ÷ Average headcount during the period) × 100

Where:

• Separations are all employees who left during the period.
• Average headcount is usually (headcount at the start + headcount at the end) ÷ 2. For more accuracy, average the headcount at the end of each month in the period.

Worked example (illustrative)

Suppose a company starts the year with 80 employees and ends with 100 employees. During the year, 18 people leave.

Average headcount = (80 + 100) ÷ 2 = 90.

Turnover rate = 18 ÷ 90 × 100 = 20 percent.

This number is for the whole year. If you calculate for one quarter with 5 separations and average headcount of 92, the quarterly rate is about 5.4 percent. To compare with the annual number, you can annualise by multiplying by four, which gives roughly 21.7 percent. Be careful: annualising a single quarter can mislead if the quarter was unusual, such as the period after appraisals.

Why average headcount, not closing headcount

Using closing headcount distorts the rate when the company is growing or shrinking quickly. A fast-growing startup with a low starting headcount would look as if turnover were falling simply because the denominator grew. Average headcount is steadier. For rapidly changing teams, use the monthly average.

Monthly, Quarterly and Annual Views

Calculate and track all three.

Monthly turnover = separations in the month ÷ average headcount of the month × 100. It is noisy for small companies, since one exit in a team of 25 is 4 percent. Use it for trend direction rather than for judgement.

Quarterly turnover smooths some noise and aligns with business reviews.

Annual turnover is the standard figure for external comparison and board reports.

Rolling twelve-month turnover is often the best single metric. At the end of each month, calculate separations in the last twelve months divided by the average headcount over those twelve months. It avoids calendar-year distortions and updates every month.

Voluntary and Involuntary Turnover

Overall turnover mixes very different stories. A company that fired underperformers and a company where top talent resigned could both show 20 percent. Split the numbers.

Voluntary turnover rate = voluntary separations ÷ average headcount × 100.

Involuntary turnover rate = involuntary separations ÷ average headcount × 100.

A high voluntary rate may point to compensation, management, growth or culture issues. A high involuntary rate may point to hiring quality, role clarity, onboarding or performance management problems. Our performance improvement plan guide and probation policy guide can help address the latter.

First-Year (Early) Turnover

A particularly informative metric is early turnover: the share of new hires who leave within a set period, such as 90 days or the first year.

First-year turnover (%) = (Employees who joined in the period and left within 12 months ÷ Employees who joined in the period) × 100

Use a cohort approach. Take everyone who joined in a particular quarter, then check how many are still there after 90 days, six months and twelve months. Early exits often indicate a mismatch between what was promised during hiring and what the job actually is, or weak onboarding. Link your analysis with your remote and hybrid onboarding checklist and your new hire documentation checklist to look for process gaps.

Do not confuse early turnover with offer dropout, where the candidate never joins. That is a separate pre-joining problem we address in our guide on reducing offer dropouts.

Retention Rate and Survival Curves

Retention rate for a defined group answers a different question: of the people who were here at the start, how many are still here at the end?

Retention rate (%) = (Employees at start who are still employed at end ÷ Employees at start) × 100

Note that it excludes new joiners, which makes it a cleaner measure of how well you keep existing staff.

A more powerful visual is a survival curve by tenure. Group employees by joining cohort, then plot the percentage still employed at 3, 6, 12, 24 and 36 months. You may see cliffs at predictable points: after the first appraisal, after a lock-in or bonus date, or at the two-year mark when employees look for external moves. Knowing where the cliffs occur tells you when to invest in engagement.

Cost of Turnover

Turnover has a price, even if you do not track it. Build a simple internal estimate rather than quoting a generic multiplier. Include:

• Separation costs: Final settlement items beyond regular pay, administrative effort, exit interviews and knowledge transfer time. See our full and final settlement guide.
• Vacancy costs: The output lost while the seat is empty, or the overtime and contractor costs used to cover it.
• Replacement costs: Advertising, agency fees, recruiter and interviewer time, assessments and background verification. Our cost per hire and time to hire guide explains how to compute them.
• Onboarding and ramp-up costs: Training time, manager time and the period before the new hire is fully productive.
• Indirect costs: Team morale, customer relationships and lost institutional knowledge.

You can estimate cost per leaver using your own data, then multiply by the number of leavers to show leadership the financial case for retention initiatives. Label it clearly as an estimate and document assumptions.

Preparing Your Data

Good analysis starts with clean data. Before calculating anything, audit your records.

1. Unique employee IDs that are never reused.
2. Accurate joining dates and exit dates. Exit date should be the last working day, not the date of resignation or the date of the final settlement.
3. Exit type recorded consistently: resignation, termination, end of contract, retirement, absconding, death, transfer.
4. Exit reason captured from a defined list, supplemented by free-text notes. A well-designed list might include compensation, career growth, manager relationship, role content, work-life balance, relocation, higher studies, health or family reasons, better opportunity, and company-related reasons. Handle sensitive reasons with care and limit access.
5. Department, location, level, manager and tenure for each employee at the time of exit.
6. Employment type: full-time, part-time, fixed-term, intern, contractor, apprentice.
7. Regretted or non-regretted flag assigned by the manager and HR together.
8. Performance rating at the last review, so you can see whether you are losing high or low performers.

If your master data is messy, fix it first. Our guide to an employee master data audit provides a step-by-step method. Remember also that employee data is personal data; handle it in line with our guidance on the DPDP Act and employee data privacy.

Deciding Who Counts

Many disagreements arise because teams count different populations. Decide and document the following.

Interns and trainees. Many companies exclude them from the core rate because they have fixed durations, and report separately. If interns often convert to full-time roles, track conversion rate. See our guide on internship stipend compliance.

Apprentices. They have statutory arrangements and may be reported separately. See our Apprentices Act guide.

Contract and third-party workers. Usually excluded from employee turnover, but you may track them separately for workforce stability. Be careful about classification; see our article on employee and contractor classification.

Fixed-term employees. End of contract is not usually considered turnover in the voluntary sense. Report contract completions separately or exclude them from the main rate, and state your rule clearly.

Internal transfers and promotions. These are not separations from the company. Track internal mobility separately. They may count as exits from a department's perspective, so decide whether you report by company or by department.

Employees on long leave. Keep them in headcount until they separate. Our guides on paternity and adoption leave and creche and maternity benefit compliance explain related situations.

Absconding cases. Count them as separations from the date the company formally closes the case, based on your policy. See our guide on absconding employees.

Retirements and deaths. Report separately as unavoidable turnover so they do not distort controllable turnover.

Layoffs and retrenchment. Report separately as involuntary, restructuring-related turnover. See our guide on retrenchment compliance.

A good practice is to report a headline "controllable voluntary turnover" metric that excludes retirements, deaths, contract completions and layoffs, alongside the all-in rate.

Slicing the Data to Find the Story

An overall number rarely tells you what to do. Slice it.

By department and team

Compare departments, but adjust for size. Two exits in a team of five is 40 percent. Present both the rate and the count, and avoid conclusions from tiny groups.

By manager

Turnover often clusters under specific managers. Look at the team's rate over at least a year, with caution. Treat it as a prompt for a conversation, not a verdict. Consider team size, role difficulty and whether the manager inherited a troubled team.

By tenure band

Groups such as 0 to 3 months, 3 to 12 months, 1 to 2 years, 2 to 5 years and over 5 years reveal where the leak is. Early exits point to hiring and onboarding; exits at two to three years point to growth and compensation.

By level and role

Compare junior, mid and senior levels. Losing senior people has a different impact than losing entry-level staff, but high churn in junior roles may signal a pay or workload problem.

By location

Local labour markets differ. A city with intense competition for your skill set may show higher turnover. Pay compared with the local market matters; see our salary benchmarking guide.

By hiring source

Do referral hires stay longer than job-board hires? Do campus hires have a different pattern? Link retention to source to improve your sourcing mix. Our guides on employee referral programs and campus hiring offer ideas.

By performance rating

Cross-tab exits with the last performance rating. Losing mostly low performers could be healthy. Losing top performers is a red flag. Ensure ratings are fair and comparable; see our performance calibration guide.

By compensation position

Compare the compensation of leavers with the pay band midpoint or market data. Many exits happen from employees paid below the band. Use a compa-ratio, which is salary divided by the band midpoint, to see whether pay is a factor. Do not assume it is the main cause without checking exit reasons.

By time of year

Exits cluster after bonus payouts, appraisals and festive seasons. Our guides on statutory bonus and Diwali workforce planning explain related timing. Seasonal patterns help you plan hiring and retention efforts.

By exit reason

Group stated reasons into themes and count them. Remember that exit interview answers are not always candid. People may cite "better opportunity" when the real cause is their manager. Triangulate with engagement survey results, manager feedback and stay interviews. See our engagement survey design guide and exit interview checklist.

Advanced Metrics

Once the basics are stable, consider adding:

Hazard rate by tenure: The probability of leaving in a given tenure month among those who reached it. It shows risk at each stage.

Time to exit after promotion or increment: Do people leave soon after a raise or after being passed over?

Bench strength and replacement ratio: For critical roles, how many ready successors exist?

Internal mobility rate: The share of vacancies filled internally. Higher internal mobility often supports retention.

Manager-level stability index: The share of a manager's team members who remain over a year.

Leading indicators: Rising absenteeism, falling engagement scores, increased late marks, reduced participation and delayed leave applications. Our guides on chronic absenteeism and late-coming policy discuss patterns you can monitor. Use them as conversation starters, not as automatic predictors, and be careful about fairness and privacy.

A Worked Dataset Example (Illustrative)

Consider a 120-person company that analyses the last twelve months. They find:

• Separations: 27. Average headcount: 115. Overall turnover about 23.5 percent.
• Of the 27, 20 were voluntary, 5 involuntary and 2 were contract completions. Voluntary turnover is about 17.4 percent, involuntary about 4.3 percent, and contract completions are reported separately.
• Of the voluntary leavers, 9 had less than twelve months of tenure.
• Eleven of the voluntary exits came from one function, sales operations, which has 22 employees.
• Of the voluntary leavers, 8 were flagged as regretted.
• Exit reasons were dominated by career growth and manager relationship.

This simple analysis reveals a story: an early-tenure problem, a hotspot in one function and a growth-and-management theme. The company can now investigate the sales operations team's hiring, onboarding and management practices, rather than launching an expensive company-wide retention campaign.

(All numbers in this example are fictional and used only to show the method.)

Turning Insight into Action

Analysis is only valuable if it leads to action. Use the findings to prioritise.

If early exits dominate: Improve role clarity in job descriptions and interviews, strengthen pre-boarding and onboarding, assign buddies, and run 30-60-90 day check-ins. Our job description guide helps align expectations.

If exits cluster after two to three years: Review career paths, promotion timelines, skill-building opportunities and pay progression. Consider structured OKR or KPI-based goal setting to make growth visible.

If pay is a factor: Review pay bands against the market and fix glaring inequities. Examine your CTC structure and benefits such as group health insurance.

If a manager hotspot exists: Coach, support or reassign. Offer manager training on feedback, recognition and workload planning.

If recognition is weak: Build a thoughtful programme. See our employee recognition programme guide.

If flexibility is the issue: Review hybrid and remote policies. See our guides on return-to-office policy and hybrid work allowances.

If workload and absenteeism are rising: Look at staffing levels and workforce planning.

If grievances are unresolved: Strengthen your grievance redressal process.

Run stay interviews with high-value employees: ask what keeps them here, what would make them leave and what they would change. These conversations catch problems before the resignation letter.

Building a Turnover Dashboard

A good dashboard is simple and consistent. Include:

1. Rolling twelve-month turnover, total and voluntary.
2. Monthly separations and headcount trend.
3. First-year turnover by joining cohort.
4. Turnover by department, tenure band and level.
5. Regretted turnover count and rate.
6. Top five exit reasons by theme.
7. Hiring versus exits (net headcount change).
8. Cost of turnover estimate.
9. Actions underway and owners.

Keep definitions on the dashboard so everyone reads the numbers the same way. Put it into your monthly HR MIS report, and review it with leadership regularly. Your HRMS should calculate these automatically from master data; manual spreadsheets are error-prone.

Spreadsheet Setup for Small Teams

If you do not yet have an HRMS reporting module, a simple spreadsheet can work.

• Sheet 1: Employee master with ID, name, department, level, location, manager, joining date, exit date, exit type, exit reason, regretted flag and last rating.
• Sheet 2: Monthly headcount with opening headcount, joiners, leavers and closing headcount for each month.
• Sheet 3: Calculations using formulas for monthly turnover, rolling twelve-month turnover and tenure at exit (exit date minus joining date).
• Sheet 4: Pivot tables by department, tenure band and exit reason.

Restrict access, because this data is sensitive. Archive snapshots monthly so that historical numbers do not change when records are corrected, and document corrections.

Common Mistakes

• Using closing headcount instead of average. It distorts rates in growing companies.
• Mixing definitions across reports. Finance and HR report different numbers and lose credibility.
• Counting transfers and promotions as exits. Or forgetting to count absconding cases.
• Treating all turnover as bad. Some exits are healthy.
• Overreacting to small numbers. Percentages in tiny teams swing wildly.
• Relying on exit interviews alone. They are one data source among several.
• Comparing with external benchmarks blindly. Industries, roles and company stages differ. Build your own baseline first.
• Ignoring data privacy. Restrict access and avoid exposing individuals in reports.
• Reporting without action. Numbers should lead to owners and deadlines.
• Neglecting hiring quality. Turnover is partly a recruitment outcome; see our structured interview scorecard guide.

A Quarterly Review Routine You Can Copy

Metrics only matter if someone looks at them on a schedule. Here is a lightweight routine that works for most SMBs.

Before the meeting (HR, two days). Refresh the master data, confirm every exit has a last working day, exit type, reason and regretted flag, and update the dashboard. Prepare a one-page summary with the rolling twelve-month rate, the voluntary rate, first-year turnover and the three slices that moved the most since last quarter.

In the meeting (leadership, sixty minutes). Spend the first fifteen minutes on the headline numbers, the next thirty on the two or three hotspots, and the last fifteen on decisions. For each hotspot, ask four questions: what do we know, what do we not know, what is the smallest action we can test, and who owns it?

After the meeting (owners, within a week). Record actions, owners and dates in a shared tracker. Communicate to managers what is being done, without exposing individual names or confidential exit comments.

At the next review. Check whether the action happened and whether the metric moved. If it did not move, change the action rather than repeating it. Retire initiatives that show no effect after two quarters.

Guardrails for fairness and privacy

Turnover analysis involves personal information, so set rules early. Share manager-level or team-level results only when groups are large enough to avoid identifying individuals. Do not circulate named exit-interview comments beyond HR and the people who need them. Keep sensitive reasons, such as health or family circumstances, out of general reports. Do not use turnover analysis to quietly label individuals as flight risks in ways that could harm them, for example by withholding opportunities. Use insights to improve conditions for everyone, and discuss career development openly with employees. When predictive models are tempting, remember that they inherit the biases in the underlying data, and any decision about a person should involve human judgment.

Linking turnover to workforce planning

Finally, feed the numbers into your hiring plan. If your voluntary turnover is around a certain level, you will need to hire replacements just to stand still, before any growth. Add expected attrition to your headcount forecast, so recruiters are not surprised by backfill demand, and so that finance budgets for it. This links directly to the planning exercise in our FY27 HR and payroll budget planning playbook.

Frequently Asked Questions

What is the formula for employee turnover rate?

Divide the number of employees who left during a period by the average headcount for that period, then multiply by 100. Average headcount is typically the sum of opening and closing headcount divided by two, or the average of month-end headcounts for better accuracy.

How do I calculate monthly attrition and annualise it?

Compute the monthly rate as separations in the month divided by the month's average headcount. To annualise, you can multiply by twelve, but be careful: a single unusual month can mislead. The rolling twelve-month method is generally more reliable.

What is a good employee turnover rate?

It depends on industry, role mix, location and company stage. Rather than chasing a generic number, compare your own rate over time, between departments and between voluntary and involuntary exits. Focus on regretted turnover, which matters most.

Should interns and contract workers be included?

Usually they are reported separately, because their engagement terms differ. Whatever you decide, document the rule and apply it consistently. Report conversion of interns to employees as its own metric.

How is turnover different from retention?

Turnover measures how many people leave relative to average headcount. Retention measures how many people from a defined starting group stay. They are related but answer slightly different questions, so tracking both is useful.

What should we do with exit interview data?

Categorise reasons into themes, look for patterns by team and tenure, and compare with engagement survey results. Share anonymised insights with leaders, and assign owners to act on recurring themes. Protect confidentiality, especially for small teams.

How do we separate regretted from non-regretted attrition?

Ask the manager and HR to assess, using agreed criteria such as performance, critical skills, potential and difficulty to replace. Record the flag at the time of exit. Review it periodically to ensure it is applied consistently and not used to justify bias.

How often should we review turnover?

Monthly for operational review and trend detection, quarterly for deeper analysis and action planning, and annually for strategic decisions on compensation, career paths and workforce planning.

Can small companies with a few employees use this?

Yes, but interpret carefully. With fewer than fifty employees, a single exit moves the percentage a lot. Use counts alongside rates, extend the period to twelve months and focus on qualitative insight from conversations.

Does a low turnover rate always mean a healthy company?

Not necessarily. Very low turnover can hide disengaged employees who stay because of limited alternatives, or a lack of fresh talent. Combine turnover with engagement, performance and internal mobility data for a balanced view.

Conclusion

The employee turnover rate formula is simple. The value lies in applying it consistently, cleaning the underlying data, splitting the number into voluntary and involuntary, early and late, regretted and non-regretted, and then asking why. A single percentage tells you that something is happening. Cohorts, tenure bands, manager views and exit reasons tell you where, when and, with a bit of listening, why.

Start this month: write down your definitions, clean your exit dates and types, calculate rolling twelve-month turnover and first-year turnover, and pick the one slice that looks most worrying. Run a few stay interviews, choose one action, assign an owner and measure again next quarter. Repeating that cycle will do more for retention than any one-off programme.

If you would like these numbers to update automatically instead of living in spreadsheets, CozyHR can bring employee master data, exits and reports together so that turnover, headcount and trends are always current. Explore CozyHR to see how connected HR data can make attrition analysis faster, more accurate and easier to act on.

Disclaimer: This article is for general information only. Definitions and practices vary by organisation; adapt them to your context and consult professionals for legal, tax or data protection questions.