HR and Social Dashboard: Key Metrics to Track in an SME

Quick answer. A useful HR dashboard for an SME tracks five families of metrics: payroll mass, labour cost, absenteeism, turnover and social compliance. From 50 employees, the BDESE database becomes mandatory (article L2312-36 of the French Labour Code) and shapes this monitoring. Aim for a monthly refresh aligned with the payroll cycle.

Your payroll mass is often the largest cost item in your company, sometimes 40 to 60 % of revenue in service businesses. Yet many owners only look at it once a year, at the closing, when it is too late to correct a drift. A social dashboard fills that gap: it turns payroll, experienced as an administrative chore, into a decision tool.

At Hayot Expertise, we build these dashboards with our SME and start-up clients. The point is not to pile up figures, but to keep the few metrics that trigger a management action. Here are which ones, how to compute them, and how to read them.

An HR dashboard links an accounting figure (payroll mass) to a human reality: who leaves, who is absent, what a role truly costs. Without it, the owner is reactive: they discover a social overrun at the closing, a wave of departures after the fact, an absenteeism that drags down productivity with no identified cause.

Monthly monitoring delivers three concrete benefits. First, cash anticipation: the loaded payroll mass, including employer contributions, drives your cash outflows. Second, early detection of weak signals, such as an absenteeism rate creeping up in one department. Third, compliance: from 50 employees, the company must maintain an economic, social and environmental database (BDESE) that requires precisely these figures.

The data already exists. Each month, your nominative social declaration (DSN), filed by the 5th or 15th of the month following the employment period, contains the essentials: pay, headcount, sick leave, movements. The dashboard simply makes it readable for management. This is one of the deliverables of an outsourced CFO mission for start-ups and SMEs: connecting payroll to steering.

You should not track everything. A good social dashboard fits on one page and focuses on five families. Here are the metrics we prioritise, with their calculation logic.

The absenteeism rate divides hours of absence over a period by theoretical working hours over the same period. The French Ministry of Labour notes there is no single legal definition: you set the scope (illness, accident, unjustified absences) and keep it stable from month to month so comparisons stay meaningful.

Method matters as much as metrics. Here is the sequence we apply in our engagements.

1. Define the scope and the audience: one dashboard for general management, possibly a more detailed one for team leaders.
2. Pick five to eight metrics at most, those that trigger a decision. Resist the urge to add more.
3. Fix the definitions in writing: does a partial absence count? Is a non-renewed fixed-term contract a departure? Without a written rule, figures become uninterpretable.
4. Connect the source: the DSN and payroll software provide 80 % of the data with no re-keying.
5. Set a frequency: monthly for payroll mass and absenteeism, quarterly or annual for turnover.
6. Add a target and an alert threshold per metric, so the dashboard speaks for itself.
7. Comment every month: a figure without interpretation is useless.

For reporting, a Power BI dashboard connected to the payroll software avoids re-keying and automates updates. But a well-built spreadsheet is enough to start in an SME with fewer than 50 employees. What matters is the discipline of definitions, not the tool.

Before building the dashboard, collect these items. Most come from your payroll and social management.

• Payslips and the payroll ledger for the last twelve months.
• Monthly DSN summaries (pay, headcount, leave).
• The staff register (entries, exits, contract types).
• Contractual hours per employee, to compute FTEs and the absenteeism denominator.
• Coded absence reasons (illness, accident, leave, training).
• Monthly revenue, for the staff cost ratio.
• The applicable collective agreement, which may require specific indicators.

A raw figure says nothing. It is its variation and breakdown that inform.

For payroll mass, always separate the volume effect (you hired) from the price effect (you raised salaries). An 8 % rise in the loaded payroll mass does not mean the same thing whether it comes from three hires or a general increase. Watch the weight of variable items too: overtime, bonuses, which can mask an organisational or understaffing problem. Keep in mind the social thresholds indexed on the social security ceiling: the annual ceiling stands at 48,060 euros in 2026, or 4,005 euros per month, and drives many contributions.

For absenteeism, a global rate of 4 or 5 % can hide wide disparities. Break it down by department, type of absence and seniority. Absenteeism concentrated in one workshop or team points to a local, organisational or managerial cause rather than a fate. The payroll consistency check before closing helps make this data reliable before displaying it.

Not all SMEs track the same metrics. Context shifts the trade-off.

• Fewer than 50 employees: the BDESE is not mandatory, but a lighter dashboard (payroll mass, cost per role, turnover) remains very useful to budget hires.
• Crossing the 50-employee threshold: the BDESE becomes mandatory (article L2312-36) and so does the gender equality index. Best to start collecting data twelve months ahead.
• Strong seasonality (hospitality, events, retail): think in FTEs and hourly cost rather than raw headcount, or every ratio will be distorted.
• Fast growth / start-up: track the acquisition cost of an employee and the ramp-up time, more telling than turnover on a young workforce.
• Heavy use of freelancers: include external services in your reading of labour cost, otherwise the dashboard underestimates your reliance on workforce.

Two mistakes recur in the files we take over. The first: an unstable denominator. If the reference headcount changes definition from month to month, the rates become incomparable. Lock your calculation rules and document them.

The second concerns compliance. The gender equality index, mandatory from 50 employees, must be published each year by 1 March (article L1142-8 of the Labour Code). A company whose index stays below 75 points for three years faces a financial penalty of up to 1 % of its annual payroll. A dashboard that tracks the gender pay gap all year long avoids the February surprise. Our article on the gender equality index calculation details the method and thresholds.

One last point: do not confuse the dashboard with the BDESE. The BDESE is a social-dialogue document for the works council; the dashboard is an internal steering tool. They share data but have neither the same audience nor the same rhythm. Our review of the BDESE content and works council obligations clarifies this boundary.

Recently, the owner of a 35-employee service SME asked us why their margin was eroding with no obvious explanation. The income statement showed payroll mass up 11 % year on year, blamed on hiring. By rebuilding a social dashboard from the DSN, the analysis separated the volume effect from the variable effect: two thirds of the rise actually came from overtime, concentrated in one chronically understaffed department. The issue was not payroll, but organisation. A targeted hire cost less than the overtime drift endured for eighteen months.

Our view is simple: an HR dashboard is not there to produce metrics, it is there to ask the right questions at the right time. The underestimated risk in SMEs is not the absence of data, it is its scattering. Payroll sits in software, turnover in the owner's head, absenteeism nowhere. Centralising already means deciding faster.

The frequent trade-off pits the simple tool against the full one. A shared spreadsheet is enough for an SME under 50 employees watching five metrics. Beyond that, or in fast growth, a tool connected to payroll becomes worthwhile: it removes re-keying, makes figures reliable and lets you drill down to department level. As chartered accountants registered with the French institute, we calibrate this trade-off with you, without selling the heaviest solution by default.

Hayot Expertise tip. Start small: five metrics, one page, a monthly refresh aligned with payroll. Write down the definition of each figure before computing it. Link the social dashboard to your cash monitoring: the loaded payroll mass is the bridge between HR and finance. We can build this foundation with you, then industrialise it as your headcount grows.