The short answer: Skill 17 reads the payroll tables in an EXL Cloud model and builds a formula-linked Human Capital executive summary in five sections — Workforce Snapshot, Cost Summary, Anomalies & Flags, Tenure Analysis and CFO Decision Points. It answers two questions at once: what the workforce costs, and whether the model’s payroll data is complete enough to trust.

Why payroll needs its own report

Salaries and wages are usually the largest expense in a services business, yet they often appear in management reports as a single line. The detail that matters — who is costing what, where tenure risk sits, whether incentives and payroll tax are even in the forecast — stays buried in the payroll tables.

And the most common problem isn’t the analysis. It’s the data: missing salaries, flat forecasts with no wage escalation, payroll tax left out. A report built on incomplete payroll data understates cost with complete confidence.

The five sections

  1. Workforce Snapshot — active headcount by role category (classified from job titles into groups such as management, supervisors, team leaders, specialists and field workers).
  2. Cost Summary — base salary, super, STI, bonus and payroll tax, with a gap analysis against benchmark rates you control as blue inputs.
  3. Anomalies & Flags — standard checks for missing salaries, flat forecasts, missing incentives, an empty FTE Restructure, missing job titles, absent payroll tax, high turnover, long-service staff on $0 and salary concentration.
  4. Tenure Analysis — bands of under 1 year, 1–2, 2–5 and over 5 years, with average, median, minimum and maximum.
  5. CFO Decision Points — prioritised P1 to P6, so the summary ends with what to do, not just what is.

Charts for headcount by role and tenure distribution sit below the data, and every count and cost is a formula linked back to the payroll tables.

Built to be trusted

  • Cross-checks confirm category and tenure totals equal active headcount, and costs tie back to the model.
  • Gaps are recorded, not skipped. If a payroll table is missing or empty, the summary says so.
  • Judgement is visible. Where job titles are too messy to classify by formula, classifications are entered as blue inputs with notes explaining the logic.
  • Short flags, not essays. Commentary cells are one-line flags so the sheet stays readable in a board pack.

Where it fits

Run Skill 17 before budget season or a restructure, when salary growth looks too smooth, or whenever a board asks “how many people do we have and what do they cost?”. Feed its CFO Decision Points into Skill 07 — Board Paper Drafter, and use Skill 20 to check the wage escalation and on-cost assumptions behind the forecast.

Go deeper: KPI Portfolio on the Model Citizn Knowledge Hub covers choosing the measures that belong in front of a board.


Skill 17 is included with the EXL Cloud Advanced Content plan. Full skill details →