Three Numbers, One Truth: Reconciling Headcount and Turnover
Verdant Health Partners has 4,800 employees and a new CHRO who wants one workforce dashboard within 90 days. The board pack currently reports 4,812 employees; payroll reports 4,657 on the same date. HR reports annualized voluntary turnover of 18.4%; finance reports 21.1%. Recruitment reports 47 open requisitions; finance has approved budget for 39. The HRIS includes contract staff in the headcount field for two business units. Termination dates are entered by managers and are sometimes the last day worked, sometimes the pay-through date. Manager ID is blank for 6% of records, so team-level reporting is unreliable. Rehires are counted as new hires in one report and as continuations in another. A monthly Excel reconciliation takes one analyst four days and is not documented. The CHRO has been asked to present a restated dashboard at the next board meeting in ten weeks.
1. Reconcile the numbers and define the metrics. Show the arithmetic that explains the 155-person headcount gap and the turnover difference.
Read the worked answer
Diagnose before defining. The 155-person headcount gap is reconcilable if it decomposes cleanly: 84 contractors included in HRIS headcount for two units, 41 employees terminated but still on payroll through month-end, and 30 future starters with records created before their start date. 84 + 41 + 30 = 155. The gap is definitional, not fraud, but that is only credible if each component is evidenced record by record.
Turnover. The 18.4% versus 21.1% difference is most likely definitional: HR is counting voluntary separations only and dividing by end-of-period headcount; finance is counting all separations and dividing by average headcount. Both are defensible; together they are unusable. A 2.7-point gap on 4,800 employees is about 130 separations, which is material in a board narrative.
Definitions to adopt. Headcount: active employees on payroll as of the period end, excluding contractors, excluding future starters, including employees on paid leave. Turnover: separations in period divided by average headcount, annualized, reported voluntarily and total separately. Requisitions: approved and posted, with approved-but-not-posted shown separately. Rehires: counted as hires, not continuations; flag them so retention analysis can exclude them.
Test the definitions. Rebuild three prior months under the new rules and compare to the legacy numbers before the board sees them. The restatement should be explainable in one page, not discovered in the meeting.
2. Propose the governance and data-quality operating model needed to keep the dashboard trustworthy after launch.
Read the worked answer
One owner, one dictionary, one close. The dashboard needs a named metric owner (people analytics), a written metric dictionary with calculation logic and source system, and a monthly close that reconciles HRIS to payroll before any number is published. The current four-day Excel reconciliation should be automated and documented; manual reconciliation that lives in one analyst's head is an outage waiting to happen.
RACI. HRIS team owns system configuration and integrations; payroll owns pay and termination dates; recruitment owns requisition status; finance owns budgeted positions; people analytics owns definitions and publication; business unit HR owns data entry quality. Ambiguity here is how the 155-person gap happened.
Controls. Make manager ID a required field at hire and transfer, with a weekly exception report. Standardize termination date as the last day worked and add a separate pay-through field. Add validation rules that block future start dates from appearing in active headcount. Run a quarterly data-quality audit sampling 50 records and publish the error rate.
Change control. Any definition change is versioned, approved by the CHRO and CFO, and disclosed with a restated trend line. Dashboards should show the definition and the as-of date on the face of the report, not in an appendix.
Timeline. Weeks 1-3: dictionary and reconciliation. Weeks 4-6: validation rules and manager ID cleanup. Weeks 7-8: rebuild historical trend. Weeks 9-10: pre-brief and publish.
3. Advise the CHRO on how to present the restatement to the board without losing credibility.
Read the worked answer
Pre-brief, do not surprise. The CFO and CHRO should walk the audit or compensation committee chair through the reconciliation before the meeting, with the one-page bridge from 4,812 to 4,657 and the definition changes. A board that hears it first in the room will focus on control failure rather than on the improved reporting.
Lead with the definition, not the apology. 'We previously reported headcount on an HRIS basis that included contractors and future starters. We have adopted payroll-basis headcount and report voluntary and total turnover separately. Here is the restated trend.' Then show three years of restated data so the board can see whether the underlying trend changed; usually it does not, which is the reassuring point.
Be explicit about control. Name the causes, the owner for each fix, and the date the controls go live. State the data-quality error rate and the target. Boards tolerate a definitional correction; they do not tolerate a vague assurance that it will not happen again.
Avoid over-promising. Do not commit to a dashboard date until the historical rebuild is complete. A late, correct dashboard is better than an on-time one that gets restated twice. Offer a monthly one-page workforce summary in the interim so the board is not blind while the full build finishes.
Prepare for the turnover question. If total turnover is 21.1%, the board will ask whether that is a problem. Have the voluntary, regretted, and first-year splits ready, plus a benchmark and a view on whether the level is expected.