Rolling 12 Month Employee Turnover Rate Formula and Reporting Rules
Calculate rolling turnover from actual separations and average headcount over the same 12 months. Follow a worked monthly dataset, choose a consistent denominator, and publish a rate another analyst can reproduce.

What is the rolling 12 month employee turnover rate formula?
Following Manatal's rolling calculation, the rolling 12 month employee turnover rate formula is separations during the latest 12 months divided by average employee headcount over those same months, multiplied by 100. Under the monthly-average method, first calculate each month's average headcount. Add those 12 averages and divide by 12 to get the denominator.
PerformSpark's calculation guidance requires departures and headcount to cover the same period and population. Put both inputs in your monthly headcount report so HR does not have to reconstruct the calculation whenever a department leader asks why turnover changed.
- Fix the reporting window. Record the first and last dates, including the month you are reporting.
- Count qualifying separations. Use effective departure dates and the employee population named in your reporting policy.
- Calculate each month's average headcount. For the endpoint method below, add opening and closing employee counts, then divide by 2.
- Calculate the rolling denominator. Add the 12 monthly headcount averages and divide by 12.
- Calculate and publish the rate. Divide total separations by the denominator, multiply by 100, and round only the final percentage.
Which months belong in the rolling reporting window?
Include the reporting month and the preceding 11 months. PerformYard's June 2024 example therefore covers July 2023 through June 2024. When July 2024 closes, remove July 2023 and add July 2024. The window stays at exactly 12 months of actual activity.
As PerformYard explains, unlike calendar-year turnover, rolling annual turnover does not reset in January. Keep the start and end dates visible in the report title or calculation statement; an unlabeled annual percentage leaves readers guessing which departures it includes.
| Measure | Reporting window | How it changes | What it tells you |
|---|---|---|---|
| Rolling 12-month turnover | Latest 12 completed months | Add the newest month; remove the oldest | Actual turnover across a continuously updated annual window |
| Calendar-year turnover | January through December | A new reporting year starts in January | Actual turnover for a fixed calendar year |
| Monthly turnover | One specified month | Calculate each month separately | Departures relative to that month's workforce |
Annualizing a month answers a different question. Multiplying its turnover rate by 12 projects that month's pace across a year; it does not count actual trailing-year departures. PerformSpark recommends actual rolling-period data rather than projecting an unusual month across a year. Use actual rolling-period records when the report calls for rolling turnover.
Do not add or average monthly turnover percentages to produce this measure. Each monthly percentage has its own denominator. Manatal's rolling formula instead uses the separation counts and headcount observations, then applies the rolling formula once.
How does a complete monthly calculation work?
Add separations across all 12 rows, then average the monthly headcount averages. The example below yields 34 separations and average headcount of 250, producing 13.6% turnover. Those totals reproduce Turn On Work's published annual illustration. The monthly allocation is constructed teaching data, not an employer's observed records.
| Month | Opening headcount | Closing headcount | Monthly average | Separations |
|---|---|---|---|---|
| July 2023 | 240 | 244 | 242 | 2 |
| August 2023 | 244 | 248 | 246 | 2 |
| September 2023 | 248 | 252 | 250 | 2 |
| October 2023 | 252 | 256 | 254 | 2 |
| November 2023 | 256 | 260 | 258 | 2 |
| December 2023 | 260 | 260 | 260 | 2 |
| January 2024 | 260 | 256 | 258 | 4 |
| February 2024 | 256 | 252 | 254 | 4 |
| March 2024 | 252 | 248 | 250 | 4 |
| April 2024 | 248 | 244 | 246 | 4 |
| May 2024 | 244 | 240 | 242 | 4 |
| June 2024 | 240 | 240 | 240 | 2 |
| Period summary | 240 at start | 240 at end | 250 period average | 34 total |
The monthly averages total 3,000, so average headcount is 3,000 ÷ 12 = 250 employees. Rolling turnover is 34 ÷ 250 × 100 = 13.6%. Reuse these columns with your records, and retain the source references separately so another analyst can trace each input.
Update both sides of the calculation
Now extend the example into July 2024: opening headcount 240, closing headcount 248, average headcount 244, and 3 separations. Remove July 2023's 2 separations and average headcount of 242. Separations become 35. The denominator becomes (3,000 − 242 + 244) ÷ 12 = 250.1667, giving updated turnover of 13.99%, rounded.
Move the headcount window whenever you move the separation window.
Which average headcount denominator should you use?
Choose a documented denominator that represents workforce size throughout the window. Here, we average 12 monthly headcount averages, following Manatal. PerformSpark's guidance supports beginning-and-ending counts for a relatively stable workforce and more frequent snapshots for substantial or seasonal changes. Do not quietly switch between methods. Label the denominator and use it consistently across reporting periods.
Separate monthly endpoints from annual endpoints
This example averages opening and closing counts within each month, then averages those monthly results. Using only the year's endpoints gives (240 + 240) ÷ 2 = 240. That produces 14.17% turnover instead of 13.6%. The arithmetic is correct, but the annual endpoints miss the higher headcounts inside the year.
PerformSpark recommends considering monthly or daily observations when seasonal or substantial mid-period changes make whole-period endpoints unrepresentative. Even monthly endpoints can overlook a short-lived staffing peak between snapshots. Choose the observation frequency based on the workforce you are measuring, not just the easiest export to obtain.
Write down snapshot timing and correction rules
Specify when opening and closing counts are taken and how effective-dated hires and departures affect each snapshot. Retain the historical records needed for point-in-time headcount reporting. If you change methods, mark the break in the series or recalculate comparable history. Otherwise, a calculation change can look like a workforce change.
Which departures count in total and voluntary turnover?
Count actual employment separations within the employee population you defined. Total turnover includes the separation categories in your policy; voluntary turnover includes only those designated voluntary. PerformSpark excludes internal transfers from company-wide separations, while Omni Calculator excludes temporary leave. Turn On Work says to exclude contractor departures when contractors are outside the employee headcount denominator.
| Event | Company-wide total turnover | Reporting treatment |
|---|---|---|
| Resignation | Include | Classify as voluntary under the stated policy |
| Retirement | Include | Disclose whether grouped with voluntary exits or shown separately |
| Layoff or termination | Include | Classify separately from voluntary departures |
| Internal transfer | Exclude | Label separately as department outflow when relevant |
| Temporary leave | Exclude | The employee has not ended employment |
| Contractor departure | Exclude from employee-only turnover | Keep contractor population and movement reporting separate |
Apply the population filter to both sides of the formula before calculating anything, following PerformSpark's population-alignment guidance. A location-only separation count needs that location's headcount, not company-wide headcount. The same discipline applies to department and role reports. Mixing scopes produces a percentage that no longer describes the group named in the heading.
Keep the denominator unchanged when splitting voluntary and involuntary turnover. As a further teaching allocation, divide the example's departures into 23 voluntary and 11 involuntary exits. With average headcount of 250, the rates are 9.2% and 4.4%. They reconcile to 34 departures and 13.6% total turnover.
Department outflow is a separate measure. As PerformSpark's internal-transfer guidance makes clear, someone moving from Sales to Operations leaves a department, not the company. Report that movement separately instead of inflating company-wide turnover with people who still work there.
What should a publishable turnover report include?
Publish the dates, employee population, separation categories, separation count, average headcount, denominator method, and turnover rate together. PerformSpark specifically recommends showing the separation count and average headcount alongside the rate. Add the rounding convention and report version. A percentage alone is not a finished report. Another analyst should be able to reproduce it and distinguish workforce movement from a scope or calculation change.
Following PerformSpark's reporting guidance, show separation counts and average headcount beside the rate, especially for small populations. Carry the same definitions into your operational dashboards and KPI reporting. Readers should not have to track down a separate explanation to learn which employees a chart includes.
How should you interpret results and compare benchmarks?
PerformSpark advises comparing rates only when reporting periods, employee populations, geography, separation categories, and denominator methods are compatible. Break the result into relevant groups to find concentrations, then investigate causes separately. Turnover measures departures relative to workforce size. It does not explain why people left or establish that every departure was undesirable.
Treat benchmark compatibility as a requirement, not a footnote. Under PerformSpark's comparability criteria, a universal healthy-turnover threshold cannot replace a like-for-like comparison. A voluntary-only benchmark cannot directly judge a total-turnover result that includes a restructuring. Label the mismatch rather than letting the comparison imply more than it supports.
- Compare like groups. Review departments, locations, roles, or tenure groups with matching separation and headcount filters. Put counts beside every rate.
- Inspect monthly activity beside the rolling rate. An older departure stays in the numerator until its month leaves the window.
- Investigate reasons separately. Use exit information and operational context; the percentage alone does not prove poor management, burnout, or compensation problems.
Before explaining a movement, check what changed: new departures, the month dropping out, workforce size, classification, or corrected records. Start the review there. It keeps the discussion tied to the calculation rather than the first plausible story.
How Cogniver helps you organize workforce reviews and follow-up
Cogniver gives HR and operations a shared company structure for workforce discussions. Its drag-and-drop org chart supports reorganizations, and every other module reads from that same chart. Groups and grades determine approver resolution and module access. Incoming hires appear as reserved seats before their first day, keeping planned placements visible alongside the company structure.
Admin and HR dashboards put headcount, attendance, pending approvals, and the recruiting funnel in one operating view. Each dashboard snapshot loads in a single round trip. For questions during a review, admin and HR copilots answer from live organization snapshots and link directly to the relevant section. Reviewers can move from the discussion to the work behind it.
Follow-up stays practical. Cogniver includes exit interviews that remain anonymous by construction, plus workflow agents that route requests and chase approvers. Teams configure approval chains in a visual builder instead of forwarding requests by hand. People decide how to respond to workforce issues; the agents handle routing and reminders.
Frequently asked questions
Can you add or average monthly turnover rates to calculate rolling turnover?
No. Following Manatal's rolling formula, total separations from the latest 12 months, then divide by the average of those months' average headcounts. Adding monthly rates mixes denominators. Averaging them measures average monthly turnover, not the rolling annual rate defined here.
Should you use beginning-and-ending headcount or monthly averages?
Use the method documented for your report. This guide follows Manatal's average of 12 monthly averages, each calculated here from that month's opening and closing headcount. PerformSpark supports whole-period endpoints for stable populations and more frequent observations for substantial workforce changes.
Do retirements, layoffs, and temporary leave count as separations?
Retirements and layoffs end employment and belong in total separations under the stated reporting policy. When reporting voluntary turnover, disclose whether retirements are classified as voluntary or shown separately. Omni Calculator excludes temporary leave because employment has not ended.
Can rolling turnover be compared directly with a calendar-year benchmark?
Check compatibility first. Both measures cover 12 months, but the dates can differ. PerformSpark says employee populations, geography, separation categories, and methods must also be comparable. Label any remaining differences instead of presenting the comparison as exact.


