Pay register
What women and men are paid by professional group, with the gap (art. 28 ET and RD 902/2020)
Watch the video
A narrated walkthrough of this module, step by step. The videos are in Spanish.
Pay register
What the workforce earns by sex and group, with its gap
1:22Read the transcript (in Spanish)
Toda empresa tiene que llevar un registro retributivo: la media y la mediana de lo que cobran mujeres y hombres, por grupo profesional y por concepto. LaborApp lo calcula a partir de las nóminas. Arriba, cuántas personas entran, la brecha de la media y la de la mediana, y cuántos grupos hay que justificar. Debajo, cada concepto con la media y la mediana de mujeres y hombres, y su brecha. Y lo mismo grupo a grupo. Se compara equiparado a jornada completa y año entero, para que la parcialidad no salga como brecha. Una brecha del veinticinco por ciento pide justificación, que se escribe aquí mismo. Cada concepto de la nómina cuenta como salario base, complemento, percepción extrasalarial o fuera del registro. LaborApp lo propone, y la gestoría lo revisa. Los importes los carga la gestoría, desde Suasor si lo tiene conectado, o con un Excel que se baja con la plantilla ya puesta. Y el registro se exporta a Excel para la representación de la plantilla. Esto es el Registro retributivo en LaborApp: la brecha de cada concepto y cada grupo, calculada con los datos de la nómina.
Contents
1. What it is and who uses it
Every company must keep a pay register (art. 28 of the Workers’ Statute and RD 902/2020): the mean and median of base salary, of each supplement and of each non-salary payment, by sex and by professional group, category or level.
- The company finds it in Compliance > Pay register.
- The agency finds it in Compliance > Pay register, with the company chosen in the selector at the top.
The screen has three tabs: Register, Pay items and Data. At the top, four figures: People in the register, Mean gap, Median gap and Groups to justify.
2. Load the year’s data
In the Data tab, choose the Year and load what was accrued over the whole year in one of two ways:
Choose the year
From Suasor or with the Excel
Review the pay items
Read the register
- From Suasor: if the company’s agency has Suasor connected, Load … from Suasor reads the year’s payroll and each person’s sex, group, category and working hours. If it is not connected, the screen says so: use the Excel.
- With the agency’s Excel: Download the … template already lists the company’s staff (current and those who left during the year). Fill in one row per person and pay item and upload it with Upload the Excel (.xlsx up to 10 MB).
| Template column | What goes in it |
|---|---|
| NIF, Sexo, Código concepto, Importe anual | Required. Sexo: Mujer (woman) or Hombre (man). |
| Grupo profesional, Categoría, Nivel salarial | What the register is grouped by: at least one. |
| Jornada % | 100 for full time, 50 for half time. Empty = 100. |
| Días en el año | Days employed. Empty = the whole year. |
| Tipo | Optional: if left empty, LaborApp proposes one. |
| Nombre (no se guarda) | Only to help fill it in. |
The template headings are in Spanish. If a person receives base salary, two bonuses and allowances, that is four rows with the same NIF. Rows that cannot be read (no sex, invalid NIF, no code, amount that is not a number) are reported by row number and the rest is loaded.
3. How each pay item counts
The Pay items tab lists each payroll item with its Code, the People who receive it, the Year total and its Type:
| Type | For example |
|---|---|
| Base salary | Base salary, collective agreement salary |
| Salary supplement | Bonuses, seniority, overtime… (anything that does not fit the others) |
| Non-salary payment | Allowances, mileage, compensation, reimbursements (art. 26 ET) |
| Outside the register | Withholdings, contributions, totals, net pay, benefits |
LaborApp proposes the type from the item’s name (with Suasor it also knows which items are withholdings) and marks it Proposed by LaborApp. Change it in its drop-down if it is wrong: it is marked as reviewed and a new load does not touch it. The same applies to what is written in the Excel’s Tipo column.
4. Read the register and the gap
In the Register tab, choose Group by (Professional group, Category or Salary level) and the Amounts:
- Full-time equivalent (default): what was paid, converted to full time and a whole year, amount ÷ (hours % ÷ 100) ÷ (days employed ÷ days in the year). This is what is compared, so part-time work does not show up as a gap.
- Actually paid: the amounts as they are.
Whole company comes first, then one table per group, with Women and Men, each sex’s mean and median, and the Gap:
- The totals (Base salary, Salary supplements, Non-salary payments and Total pay) are calculated over everyone in the group and sex.
- Each pay item, only among those who receive it; the Women and Men columns say how many they are.
- Gap = (men’s mean − women’s mean) ÷ men’s mean. Positive: men earn more; negative: women do.
5. Justify a difference
- Click Justify on that group, write the reason (seniority, job supplements, working hours…) and save. Leaving it empty removes it.
- A group already justified shows the text and the See the justification button.
- From 5 % the group is flagged Above 5 %, as a warning: that is where Directive (EU) 2023/970 requires a joint assessment with staff representatives.
- With fewer than 50 people the law does not require justifying 25 % differences, but the register is still mandatory.
The Groups to justify figure at the top counts those still pending.
6. Export to Excel
In the Register tab, Export to Excel downloads the year’s register with the chosen grouping, in two sheets: Equiparado (full-time equivalent) and Efectivo (actually paid). Each row is a total or a pay item of a group, with women and men, means, medians, gaps and, on total pay, the justification. The Excel is in Spanish.
It is the document given to the staff’s legal representatives, who are entitled to see it (art. 28.2 ET) and are bound to confidentiality (art. 65 ET): they have no menu entry of their own. The Excel footer says so.
For an employee downloads the other Excel, the one given when the company has no staff representatives and an employee asks for it (art. 5.3 RD 902/2020): only the % difference, in whole numbers, of the mean and the median of each total and pay item, by group, with no amounts, headcounts or justifications. Where there are fewer than 3 women or 3 men, the total shows «—» and the pay items are left out, and the median needs at least 5 of each sex, so as not to reveal what a specific person earns; «n/d» means it cannot be calculated. Give each person a single grouping (your classification system): crossing two could reveal what someone earns. Who downloads it is logged, as with the other. It is also in Spanish.
Not using LaborApp yet?
We'll show you how it works for your case, no strings attached. The form is in Spanish.