Why Your Staff Costs Are Eating Your Profit - And How to Track It

Staff costs are the largest expense in most service businesses - and the hardest to see clearly. The salary bill is visible. The employer NI, pension contributions, holiday pay, sick pay, training costs, and recruitment costs that sit on top of it are often invisible in routine reporting. And the relationship between what each person costs and what they generate for the business is almost never tracked in real time.

The true cost of an employee

The gross salary is just the starting point. Employer National Insurance adds 15% on everything above £5,000 a year. Auto-enrolment pension contributions add a minimum of 3%. Holiday adds 12.07% on top of the rate for staff paid by the hour; for salaried staff it is already inside the salary, but it means the cost is carried by about 46 working weeks rather than 52. On a £30,000 salary, National Insurance is £3,750 and the minimum pension £900, so the employee costs £34,650 a year before recruitment, training, management time or any overhead allocation.

The revenue side of the equation

Knowing what each person costs is only useful when set against what they generate. For a service business, this means tracking billable output, utilisation rates, or revenue attributable to each team member. The gap between cost and contribution is the metric that matters - and it varies significantly across teams and individuals in almost every business.

How to build the visibility

Staff cost tracking that connects payroll data to revenue data requires connecting two systems most businesses keep entirely separate. Power BI or an automated Excel model can bridge this - pulling payroll costs from the HR or payroll system and revenue data from the accounting or CRM system, then producing a cost-per-head and revenue-per-head view by team member, updated automatically.

What the numbers usually reveal

When businesses first build a cost-per-head model, the results are almost always surprising. The highest-paid team members are not always the highest contributors. Long-tenured employees who have received annual pay rises without corresponding increases in output often sit at the worst cost-to-revenue ratios. High performers who were hired at below-market rates often sit at exceptional ratios that are invisible without this analysis. The visibility changes decisions - around pay reviews, team structure, hiring plans, and which clients to prioritise.

The practical starting point

The fastest way to build initial visibility is in Excel. Take your payroll export, add the employer cost uplift (NI, pension, holiday), and set it against a revenue attribution from your CRM or billing system. Even a rough cut - total team cost divided by total revenue, broken down by department - gives you more than most businesses have. From there, Power BI can automate the update so the numbers are live every week without anyone rebuilding the model.

When to invest in a proper system

A manual Excel model works until the team grows beyond 15-20 people or the data starts coming from too many sources to manage manually. At that point, an automated dashboard connected directly to your payroll and revenue systems is worth building. The time saving alone - typically 3-4 hours per month of manual reconciliation - pays for the build within a few months. The better decisions it enables pay for it many times over.

Related articles