How to Calculate Quarterly Turnover Rate

This calculator works out your quarterly employee turnover rate: the percentage of your workforce who left during a three-month period. You enter the number of employees at the start and end of the quarter, plus how many left during that time, and you get the turnover percentage instantly. It also shows the average headcount, which is the denominator in the standard formula.

Formula

The standard quarterly turnover rate formula is:

Turnover Rate (%) = (Number of Separations ÷ Average Number of Employees) × 100

Where:

• Number of Separations = total employees who left during the quarter (voluntary resignations, retirements, layoffs, terminations).
• Average Number of Employees = (Headcount at start of quarter + Headcount at end of quarter) ÷ 2.

Both headcounts are measured in full-time equivalent (FTE) or raw headcount, whichever you use consistently. The result is a percentage.

Worked Example

Using the default values from the calculator:

• Employees at start of quarter = 100
• Employees at end of quarter = 95
• Employees who left during quarter = 10

Step 1: Calculate the average headcount.

(100 + 95) ÷ 2 = 195 ÷ 2 = 97.5

Step 2: Divide separations by average headcount.

10 ÷ 97.5 = 0.10256…

Step 3: Convert to a percentage.

0.10256 × 100 = 10.3% (rounded to one decimal)

So the quarterly turnover rate is 10.3%.

When to Use This Calculation

Use quarterly turnover when you want a more stable measure than monthly (which can be noisy) but more current than annual. It is common in HR reporting, workforce planning, and retention analysis. The same formula works for any period – monthly, quarterly, or annual – as long as you count separations and average headcount over that exact period.

How to Read the Result

A turnover rate of 10% per quarter means that, on average, 10 out of every 100 employees left during that three-month window. It does not mean 10% of the workforce left each month. To annualize a quarterly rate, you can multiply by 4 for a rough estimate, but note that this ignores compounding and seasonality – it is only an approximation.

There is no universal “good” or “bad” turnover rate; it varies widely by industry, role, and region. Use this number to compare against your own historical quarters or industry benchmarks, not as an absolute judgment.

Common Mistakes

• Using the wrong headcount: The average is (start + end) ÷ 2, not just the ending headcount. Using only the end number understates turnover if your workforce grew during the quarter.
• Including or excluding the wrong leavers: Decide whether to count layoffs and retirements. The formula is the same, but the interpretation changes. Be consistent.
• Mixing FTE and headcount: If you use full-time equivalents for headcount, count separations in FTE too. Mixing raw counts with FTE distorts the ratio.
• Forgetting to multiply by 100: The formula gives a decimal; you must multiply by 100 to get a percentage.
• Rounding too early: Round only at the final step. Rounding the average headcount to a whole number before dividing can change the result by a few tenths of a percent.

Tips

• Use the same definition of “left” every quarter – include voluntary resignations, retirements, and layoffs, but exclude internal transfers or promotions, which are not true separations.
• If your headcount changes dramatically mid-quarter (e.g., a large hiring surge), consider using a more precise average, such as the sum of weekly headcounts divided by the number of weeks, but the simple start/end average is standard for most reporting.
• Track turnover separately for different departments or roles – company-wide numbers can hide problem areas.
• Calculate both voluntary and involuntary turnover separately if you need to understand why people are leaving.
• Compare quarter-over-quarter rather than just looking at one number in isolation.

Troubleshooting

Your result seems too high or too low. Check that you entered the number of separations, not the number of hires. Also verify that the start and end headcounts are for the correct dates – the beginning of the quarter and the end of the quarter, not the middle.

Your average headcount is a decimal. That is normal. The formula uses the average, which can be fractional. You can round the final percentage to one or two decimals.

Your headcount changed dramatically during the quarter. The simple average may not reflect reality. In that case, compute the average of monthly headcounts (or weekly if you have the data) and use that as the denominator instead.

You get a negative number. That is impossible with this formula because headcounts and separations are non-negative. Double-check that you didn’t enter a negative value for separations.

Your result does not match a colleague’s calculation. Compare definitions: did they include retirees? Did they use a different average? Did they round differently? Agree on the inputs first.

Frequently Asked Questions

Q: Should I include employees who were laid off in the turnover rate?
A: It depends on your purpose. For overall turnover, include all separations. For voluntary turnover, exclude layoffs and terminations. Just be consistent and label which you are reporting.

Q: Can I use this formula for monthly or annual turnover?
A: Yes. Replace “quarter” with the period you want. The formula is the same: separations divided by average headcount over that period.

Q: What is a good quarterly turnover rate?
A: There is no universal benchmark. It varies by industry – retail and hospitality often run higher, while utilities and education run lower. Compare to your own past quarters or industry surveys.

Q: How do I annualize a quarterly turnover rate?
A: Multiply the quarterly rate by 4 for a rough annual estimate. For a more accurate annual rate, calculate it directly from annual data, because quarterly rates compound and seasonality can distort a simple multiplication.

Q: Should I use headcount or full-time equivalents (FTE)?
A: Use whichever you use for other HR metrics, but be consistent. FTE gives a more accurate picture if you have many part-time staff, while headcount is simpler and more common.

Q: What if an employee leaves and is rehired in the same quarter?
A: Count the separation when it happens. If they are rehired, they count as a new hire. The turnover rate counts separations, not unique people.

Related

• Linear Regression Equation: Step-by-Step Guide
• EST to UTC+1 Converter: How It Works
• Buffer Calculator Acetate: How to Use It

in start | Employees at start of quarter | - | 100 | 0
in end | Employees at end of quarter | - | 95 | 0
in left | Employees who left during quarter | - | 10 | 0
out rate | Quarterly turnover rate | % | (left / ((start + end) / 2)) * 100 | 1
out avg | Average headcount | - | (start + end) / 2 | 1