6 Simple Pay Health Checks for EU Pay Transparency Readiness. Part One: Setting up your data for Success

SkillsTrust Team

• 4 minute read

Pay transparency will become the norm in the EU in 2026. Employees will have a lot more information about comparative pay for colleagues in similar roles. This visibility will mean that past pay anomalies and inconsistencies are likely to be surfaced and discussed. This can be very damaging to employee trust and so there is a strong rationale to check for these issues now and resolve them if needed.

Every company has pay anomalies but this is especially true for companies that have not had structured pay practices in the past (such as pay levels, salary bands etc.).

Small and medium sized companies tend to fall into this category. Faced with pay transparency rules and the need for more structured pay management, SMB employers are also those with small HR teams and no dedicated Total Rewards expertise to help prepare for pay transparency.

If this is the situation that you are in - never fear.

You can quickly get an initial view on the health of your pay using a simple set of checks in Excel.

In this content series, you’ll learn how to prepare your data and perform six easy checks to evaluate pay practices and uncover any irregularities.

The output of this exercise is a pay risk list that you can triage. Triaging the risk list means that you will need to determine which pay issues have an objective, gender-neutral justification and which may require remediation such as a pay adjustment.

With that in mind, let’s get started by pulling & cleaning the necessary data to perform the pay analysis. 

Preparing your Data

There are two inputs needed for running these checks:

  1. Simple Job Categories

  2. Pay Dataset

Simple Job Categories

The EU Pay Transparency Directive requires employers to group jobs into categories of work of equal value. This categorisation is necessary to meet various requirements under the directive, such as pay gap reporting and fulfilling employee information rights. For small and medium-sized businesses, job categorisation might sound daunting, but it can be approached in a straightforward way. Here’s how to get started:

Start with simple assumptions about levels and families
A basic framework can be quite simple, with just 5–7 job levels. Some companies might choose to break these levels down further by job family (like Marketing, Sales, or Engineering). If this is the case, a job category would be the combination of a job level and job family as in the example below. The main guiding principle is that roles in the same job category should represent work of equal value (i.e. they are comparators for pay purposes).

Write a description for each level and job family 

Write a short description of the criteria required for a job to be assigned to each level and each family. The Directive says that jobs should be categorised based on objective factors including responsibility, skills, effort and working conditions. This might sound abstract but here is a simple example of how you can describe job families & levels in these terms: 

Your first draft doesn’t need to be perfect. Even a basic draft framework will give you a foundation to build on and you can add more nuance as you go. 

Pay Dataset

When running these checks, we recommend using the pay dataset as described in Article 9 of the EU Pay Transparency Directive.This dataset will be required for EU pay gap reporting. It is a 12 month earnings dataset that covers base, variable and BIK, plus hours worked and gender.

Once you have created job categories & pulled the relevant pay data, you are ready to start conducting your pay gap analysis. 

And that’s it! You’re ready to start analysing your pay & job data to understand the pay health of your company. 

In the next article, we will focus on the first analysis: Pay Gap within Job categories. Make sure you’re subscribed so you don’t miss that post. 

If the data prep is already seeming like a daunting task, feel free to reach out to our team. We can cut out the heavy lifting of job evaluation with our AI-assisted engine, delivering a clear, editable job architecture that categorises work of equal value - aligned with the EU Pay Transparency Directive.

You can book a call to speak with our team here if you have any questions. 

Related Articles:

Read more articles

Michelle Dervan

2 Nov 2026

All About Averages | Pay Analytics 101

The Importance of the Average When talking about pay data, the term average appears time and time again, but what does it actually mean? Put simply, an average salary gives us one figure to help describe pay across a group of employees. It takes all the salary values from that group and calculates a figure that would represent a ‘typical’ employee in that group. This is useful because it allows us to compare pay between different employee groups without having to look at every individual salary. The average can become an even more powerful metric when we begin to understand and analyse the different ways it’s calculated. It might seem counterintuitive that a figure like the average can be calculated in different ways and possibly provide different answers. After all, how can the same set of salaries produce different averages? The key is that each method looks at the data differently, helping us bring a different part of the picture into focus. There are two types of average that are particularly important when it comes to understanding pay: the mean and the median. So, how do they work, and what can each tell us about pay? Let's introduce them using a simple example company, PeopleTech Ltd. The Mean: What would everyone earn if pay were shared equally? The mean is what many people think of when they hear the word average. It shows us what each employee would earn if the company's total pay were shared equally among everyone. In everyday conversation, the terms mean and average are often used interchangeably. However, this isn't technically accurate, as the mean is just one of the ways to calculate an average, as we'll explore later on. To calculate the mean, we simply add together all the salaries and divide the total by the number of employees. Let's look at the example company, PeopleTech Ltd. Imagine the five employees earn the following annual salaries: €30,000 + €40,000 + €40,000 + €50,000 + €100,000 = €260,000 PeopleTech Ltd. has a total annual salary bill of €260,000 across its five employees. To calculate the mean, we divide this total by five: €260,000 ÷ 5 = €52,000 So, the mean salary at PeopleTech Ltd. is €52,000. In other words, if the company's total salary bill were shared equally between all five employees, each person would receive €52,000. The mean is useful because it gives us an overall picture of pay across the company. However, as we'll see, it doesn't always reflect what most employees actually earn, particularly when there are significant differences between the highest and lowest salaries. The Median: What is the salary in the middle? But what happens when one or two employees earn significantly more than everyone else? This is where the median can give us a different perspective. While the mean looks at the total of all salaries, the median looks directly at the middle of the data. Imagine arranging all our employees in a straight line, from the lowest-paid to the highest-paid. The salary of the person standing in the middle would represent our median salary. Let's look at PeopleTech Ltd. again. Using the same salaries as before, we arrange them from lowest to highest: €30,000 | €40,000 | €40,000 | €50,000 | €100,000 The middle salary is €40,000, making this the median salary for PeopleTech Ltd. What makes the median particularly useful is that it is not affected by unusually high or low salaries, often referred to as outliers. In our example, let's assume the €100,000 salary belongs to the CEO, which is double the next highest salary. This unusually high salary pulls the mean upwards, making the average salary appear higher than what most employees actually earn. The median, however, is not affected by this unusually high salary. At €40,000, it gives us a different perspective on what a typical employee earns in PeopleTech Ltd. This is particularly useful for HR professionals because it helps us understand what employees typically earn, without the results being skewed by a small number of particularly high or low salaries. Neither figure is wrong. They simply tell us different things about how pay is distributed across the company. Looking at both together gives us a more complete picture than relying on either one alone. One thing to note: when there is an even number of employees, there won't be one person sitting exactly in the middle. In this case, we take the two middle salaries and calculate their average to find the median. How does this all relate to the EU Pay Transparency Directive? The EU Pay Transparency Directive requires employers to report on both the mean and median gender pay gap. These gaps are calculated by finding the average pay for male employees and the average pay for female employees, and then measuring the difference between them. The difference is expressed as a percentage of men's average pay. For example, a gender pay gap of +10% means that women's average pay is 10% lower than men's average pay. But why does the Directive want to look at both figures? The size of a company's mean gender pay gap and median gender pay gap can tell us different things about how pay is distributed across the organisation. If a company's mean gender pay gap is larger than its median gender pay gap, this could suggest that higher-paid employees are having a greater influence on the overall gap. Think back to our PeopleTech Ltd. example, where the CEO's €100,000 salary pulled the mean upwards. A similar effect could occur in an organisation where the pay gap between most male and female employees is relatively small, but a highly paid position, such as the CEO role, is occupied by a man. Even though the difference in pay across the wider workforce may be relatively modest, this one high salary could pull the mean upwards and result in a much larger overall gender pay gap. On the other hand, if a company's median gender pay gap is larger than its mean gender pay gap, this could suggest that the difference in pay is more evident across the wider workforce, rather than being driven primarily by a small number of highly or lower paid positions. In other words, the gap may be more noticeable among employees around the middle of the pay distribution, rather than being concentrated at the top. This could highlight wider differences in how men and women are paid across the organisation, and may warrant further investigation. It is important to remember that neither the mean nor the median tells us exactly why a gender pay gap exists. They are indicators that help us identify patterns and differences in pay, rather than explanations in themselves. By looking at both measures together, HR professionals can begin to build a clearer picture of pay within their organisation, identify areas that may need further investigation and take a more informed approach to understanding and addressing any gaps.

Read article

Michelle Dervan

2 Nov 2026

All About Averages | Pay Analytics 101

The Importance of the Average When talking about pay data, the term average appears time and time again, but what does it actually mean? Put simply, an average salary gives us one figure to help describe pay across a group of employees. It takes all the salary values from that group and calculates a figure that would represent a ‘typical’ employee in that group. This is useful because it allows us to compare pay between different employee groups without having to look at every individual salary. The average can become an even more powerful metric when we begin to understand and analyse the different ways it’s calculated. It might seem counterintuitive that a figure like the average can be calculated in different ways and possibly provide different answers. After all, how can the same set of salaries produce different averages? The key is that each method looks at the data differently, helping us bring a different part of the picture into focus. There are two types of average that are particularly important when it comes to understanding pay: the mean and the median. So, how do they work, and what can each tell us about pay? Let's introduce them using a simple example company, PeopleTech Ltd. The Mean: What would everyone earn if pay were shared equally? The mean is what many people think of when they hear the word average. It shows us what each employee would earn if the company's total pay were shared equally among everyone. In everyday conversation, the terms mean and average are often used interchangeably. However, this isn't technically accurate, as the mean is just one of the ways to calculate an average, as we'll explore later on. To calculate the mean, we simply add together all the salaries and divide the total by the number of employees. Let's look at the example company, PeopleTech Ltd. Imagine the five employees earn the following annual salaries: €30,000 + €40,000 + €40,000 + €50,000 + €100,000 = €260,000 PeopleTech Ltd. has a total annual salary bill of €260,000 across its five employees. To calculate the mean, we divide this total by five: €260,000 ÷ 5 = €52,000 So, the mean salary at PeopleTech Ltd. is €52,000. In other words, if the company's total salary bill were shared equally between all five employees, each person would receive €52,000. The mean is useful because it gives us an overall picture of pay across the company. However, as we'll see, it doesn't always reflect what most employees actually earn, particularly when there are significant differences between the highest and lowest salaries. The Median: What is the salary in the middle? But what happens when one or two employees earn significantly more than everyone else? This is where the median can give us a different perspective. While the mean looks at the total of all salaries, the median looks directly at the middle of the data. Imagine arranging all our employees in a straight line, from the lowest-paid to the highest-paid. The salary of the person standing in the middle would represent our median salary. Let's look at PeopleTech Ltd. again. Using the same salaries as before, we arrange them from lowest to highest: €30,000 | €40,000 | €40,000 | €50,000 | €100,000 The middle salary is €40,000, making this the median salary for PeopleTech Ltd. What makes the median particularly useful is that it is not affected by unusually high or low salaries, often referred to as outliers. In our example, let's assume the €100,000 salary belongs to the CEO, which is double the next highest salary. This unusually high salary pulls the mean upwards, making the average salary appear higher than what most employees actually earn. The median, however, is not affected by this unusually high salary. At €40,000, it gives us a different perspective on what a typical employee earns in PeopleTech Ltd. This is particularly useful for HR professionals because it helps us understand what employees typically earn, without the results being skewed by a small number of particularly high or low salaries. Neither figure is wrong. They simply tell us different things about how pay is distributed across the company. Looking at both together gives us a more complete picture than relying on either one alone. One thing to note: when there is an even number of employees, there won't be one person sitting exactly in the middle. In this case, we take the two middle salaries and calculate their average to find the median. How does this all relate to the EU Pay Transparency Directive? The EU Pay Transparency Directive requires employers to report on both the mean and median gender pay gap. These gaps are calculated by finding the average pay for male employees and the average pay for female employees, and then measuring the difference between them. The difference is expressed as a percentage of men's average pay. For example, a gender pay gap of +10% means that women's average pay is 10% lower than men's average pay. But why does the Directive want to look at both figures? The size of a company's mean gender pay gap and median gender pay gap can tell us different things about how pay is distributed across the organisation. If a company's mean gender pay gap is larger than its median gender pay gap, this could suggest that higher-paid employees are having a greater influence on the overall gap. Think back to our PeopleTech Ltd. example, where the CEO's €100,000 salary pulled the mean upwards. A similar effect could occur in an organisation where the pay gap between most male and female employees is relatively small, but a highly paid position, such as the CEO role, is occupied by a man. Even though the difference in pay across the wider workforce may be relatively modest, this one high salary could pull the mean upwards and result in a much larger overall gender pay gap. On the other hand, if a company's median gender pay gap is larger than its mean gender pay gap, this could suggest that the difference in pay is more evident across the wider workforce, rather than being driven primarily by a small number of highly or lower paid positions. In other words, the gap may be more noticeable among employees around the middle of the pay distribution, rather than being concentrated at the top. This could highlight wider differences in how men and women are paid across the organisation, and may warrant further investigation. It is important to remember that neither the mean nor the median tells us exactly why a gender pay gap exists. They are indicators that help us identify patterns and differences in pay, rather than explanations in themselves. By looking at both measures together, HR professionals can begin to build a clearer picture of pay within their organisation, identify areas that may need further investigation and take a more informed approach to understanding and addressing any gaps.

Read article

The information on this page is not intended to serve and does not serve as legal advice. All of the content, information, and material on this website are only for general informational use.

Copyright © 2026 SkillsTrust. All Rights Reserved.

The information on this page is not intended to serve and does not serve as legal advice. All of the content, information, and material on this website are only for general informational use.

Copyright © 2026 SkillsTrust. All Rights Reserved.

The information on this page is not intended to serve and does not serve as legal advice. All of the content, information, and material on this website are only for general informational use.

Copyright © 2026 SkillsTrust. All Rights Reserved.

The information on this page is not intended to serve and does not serve as legal advice. All of the content, information, and material on this website are only for general informational use.

Copyright © 2026 SkillsTrust. All Rights Reserved.