People data is the most sensitive data most companies hold, which is why it usually stays in one HR spreadsheet that one person updates. This template lets HR publish the numbers managers need — headcount, leavers, absence, open roles — while pay, performance ratings and personal details stay hidden with column-level permissions. A manager sees their own team and nothing else.
It reads from your HR system, applicant tracking tool or the spreadsheets you already keep, joined to the ledger for workforce cost. Attrition is broken down by manager, tenure band and department, because “12% attrition” hides the one team at 40%.
The hiring funnel is built the same way as a sales funnel: applications through to accepted offers, by role and source, so recruiting spend is judged on hires rather than applicants. For the broader picture of which measures matter by department, see the KPIs every business should track.
- HR leads who want to give managers their own team numbers without sharing the master spreadsheet.
- Line managers who need headcount, absence and open roles for their team on one page.
- Founders and finance leads watching workforce cost against revenue as the company grows.