Blog · Board and management reporting
Compare departures, headcount, and retention by team using a reconciled staffing export. Follow a worked monthly example, then change hiring to see why turnover and retention can move differently.
An employee turnover dashboard shows how many employees left, the size of the workforce they left, and where departures are concentrated. Separate voluntary departures from other exits, then add retention for a fixed starting group. A rising headcount can coexist with substantial employee departures, so show the movement and the rates together.
Start with a company, period, and employee population. This example covers a US business services company for September 2026, including its full-time and part-time employees but excluding contractors. Count people as people; do not use full-time-equivalent staffing as the denominator for a person-based departure count.
A Federal Reserve explanation of worker churn distinguishes quits, layoffs and discharges, and other separations in labor statistics. The categories matter because an employer-initiated reduction and a voluntary departure suggest different operating questions. Establishment-level statistical definitions can also count transfers differently from your company view, so label the boundary before comparing results.
For this dashboard, a departure means leaving the company payroll. A move between its teams is a transfer, not a company exit. Keep retirements in a separately coded category within other exits if the business needs that distinction.
Use opening and closing employee rosters, hires and departure records, and internal transfer records. Each needs a consistent employee identifier, an effective date, and the relevant team. Departure reason codes should map to the agreed categories without guessing from free-text notes.
Use effective dates rather than the date someone entered a record. A September departure entered in October still belongs in the September movement, provided the reporting policy and correction log handle late records consistently. Keep unnecessary personal fields out of the analysis file and show aggregate teams in the review.
The human resources dashboard brings staffing and workforce cost together. This narrower view follows departures and retention, so its principal checks are people counts and employee movements.
The table below contains all employee movements in the example month. There are no internal transfers or rehires, and all departures come from employees present at the start of September. No new hire leaves during the month. Those assumptions will matter when calculating retention.
| Team | Opening headcount | Hires | Voluntary exits | Layoffs and discharges | Other exits |
|---|---|---|---|---|---|
| Sales | 80 | 6 | 3 | 1 | 0 |
| Support | 120 | 10 | 6 | 2 | 1 |
| Operations | 60 | 4 | 2 | 1 | 0 |
| Total | 260 | 20 | 11 | 4 | 1 |
First calculate total exits and closing headcount. Use the simple average of opening and closing headcount for this example; use a consistent snapshot average instead when that better represents material changes within the period.
Total exits = Voluntary exits + Layoffs and discharges + Other exits
Closing headcount = Opening headcount + Hires - Total exits
Average headcount = (Opening headcount + Closing headcount) / 2
Turnover rate = Total exits / Average headcount
| Team | Total exits | Closing headcount | Average headcount | Monthly turnover | Voluntary turnover |
|---|---|---|---|---|---|
| Sales | 4 | 82 | 81.0 | 4.94% | 3.70% |
| Support | 9 | 121 | 120.5 | 7.47% | 4.98% |
| Operations | 3 | 61 | 60.5 | 4.96% | 3.31% |
| Total | 16 | 264 | 262.0 | 6.11% | 4.20% |
Support's exits are 6 + 2 + 1 = 9. Its closing count is 120 + 10 - 9 = 121, and average headcount is (120 + 121) / 2 = 120.5. Turnover is 9 / 120.5 = 7.47%; voluntary turnover is 6 / 120.5 = 4.98%.
The company rate uses summed counts: 16 / 262 = 6.11%, rather than the average of the team percentages. Headcount increased from 260 to 264, but 16 people still left. Growth in the closing count does not establish strong retention.
Percentages are rounded to two decimal places, and average headcount is displayed to one. All calculations use unrounded values.
Retention asks how many of the people present on the opening date remain at the end. Match employee identifiers from the opening roster to the closing roster instead of subtracting every departure without checking when that employee joined.
Starting-cohort retention = Opening employees still employed at close / Opening employees
| Team | Opening cohort | Opening-cohort departures | Opening employees retained | Cohort retention |
|---|---|---|---|---|
| Sales | 80 | 4 | 76 | 95.00% |
| Support | 120 | 9 | 111 | 92.50% |
| Operations | 60 | 3 | 57 | 95.00% |
| Total | 260 | 16 | 244 | 93.85% |
Because every departure in this example belongs to the starting cohort, retained employees are 260 - 16 = 244. Retention is 244 / 260 = 93.85%. The different denominator explains why this is not simply the complement of the 6.11% turnover rate.
In real files, a person hired and separated during September counts in September departures but never belonged to the opening cohort. An internal team transfer also changes team membership without ending company employment. Decide whether a team cohort tracks staying at the company or staying on that team, and label that choice.
Keep Support's opening count and departures unchanged, but change hires from 10 to 2. Every other input stays the same.
| Support measure | Original case | Fewer-hires case | Calculation in fewer-hires case |
|---|---|---|---|
| Opening headcount | 120 | 120 | Unchanged roster |
| Hires | 10 | 2 | Changed input |
| Total exits | 9 | 9 | Unchanged departure records |
| Closing headcount | 121 | 113 | 120 + 2 - 9 |
| Average headcount | 120.5 | 116.5 | (120 + 113) / 2 |
| Turnover | 7.47% | 7.73% | 9 / 116.5 |
| Starting-cohort retention | 92.50% | 92.50% | 111 / 120 |
Turnover rises because the average workforce is smaller, even though the departure count is unchanged. Starting-cohort retention remains unchanged because hiring does not change who stayed from that original group. Show both measures before calling the increase a deterioration in employee retention.
The company movement is 260 + 20 - 16 = 264. That must match the distinct employees in the closing roster. Team closing counts sum to 82 + 121 + 61 = 264, and departure categories sum to 11 + 4 + 1 = 16. Any company-wide mismatch needs investigation before the dashboard is circulated.
Support has the largest departure count and the highest turnover rate in the example. Ask its manager about departure reasons, hiring timing, role mix, and whether vacancies are affecting delivery. Use the employee performance dashboard for operating output and the employee satisfaction dashboard for survey context; neither proves why a particular employee left.
For external context, the Census Bureau's workforce statistics provide employment and employment-flow measures by industry, geography, and firm characteristics. Choose a comparable population and check its measure definitions. An external series with a different workforce boundary or denominator is context rather than a direct target for this internal calculation.
Upload staffing snapshots and employee movement records, or bring a Google Sheet containing the same fields. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See capacity planning for the wider staffing review.
Divide departures during the period by average headcount for the same population and period. State how you calculate average headcount. The average of opening and closing counts is a practical approximation, while frequent snapshots can better represent a workforce that changes sharply during the month.
Turnover counts departures during a period against a headcount base. Retention follows a fixed group of starting employees and asks how many remain. New hires affect the workforce denominator but do not join that original retention cohort, so the two rates are not always complements.
For a company-wide measure, moving between departments usually remains an internal staffing movement rather than an exit from the company. For a department view, show transfers separately from departures. Document the boundary so team totals can reconcile to the company without counting transfers as company exits.
A monthly rate does not establish what the full year will look like. Hiring patterns, seasonal work, and departure timing can change the result. For an actual annual measure, use annual departures and a documented annual average headcount instead of labeling a monthly projection as an observed annual result.