Normalization assigns your payroll items to Reflect’s categories. It determines the amounts included in Total paid and Egapro compensation, and the quantities included in Paid hours.

Open Data Management → Data normalization, then choose Pay category. You must be an Admin or have Editor access to the relevant sources. The normalization guide covers editing, AI suggestions and Excel imports.

Check the three columns below for each item. After saving, your analyses use the settings at the next data update. Return to the normalization table when new labels appear.

Once items are normalized, Reflect offers two views of payroll, depending on the level of detail you need.

Total paid adds up items assigned to these four types, for your selected period and filters:

Use this summary view to compare trends across entities or over time.

Pay category distinguishes the source’s payroll items, with labels that may have been standardized in Reflect. The available detail depends on the source: one category may already combine several bonuses, particularly with DSN data.

To compare gross pay with payslips, select only Base, Variable and Bonus. To analyze costs including employer contributions, also include Employer contribution if that data is available. Total paid therefore differs from the net amount paid to employees.

The Payroll type column classifies each item by its nature. The four types contribute to Total paid; an empty type or Ø does not.

FTE annual compensation (Egapro Index) does not depend on the pay type: see section 3.

Use a consistent convention for the four types across sources and entities. This analytical classification does not, by itself, determine whether an item is eligible for Egapro.

Set Is hours-based? to True for items whose amount is linked to a quantity of hours: overtime, additional hours or hours paid at a premium.

Paid hours adds up the paid additional hour quantities supplied by the source for those items, excluding hours covered by base salary. Hours follow the payment period and may have been worked earlier. The measure counts neither payroll lines nor employees.

Do not mark monthly base salary as hours-based simply because the payslip shows a calculation base. That base may represent days, a rate or an amount. Check that it represents hours. An empty cell or False excludes the item from Paid hours; an empty cell still needs completing.

The Egapro Index (France’s professional equality index) is a legal requirement for companies with at least 50 employees. It measures pay gaps between women and men.

Included in Egapro? selects the items used for Egapro compensation. It is independent of Payroll type, except that items assigned Ø remain excluded.

FTE annual compensation (Egapro Index) only uses items set to True in this column. An empty cell or False does not contribute to this compensation. Do not infer this setting from a Base, Variable or Bonus label alone.

Absence-related items: do not automatically exclude all of them from Egapro. Ask your payroll manager to confirm absence deductions and maintained pay item by item. Paid leave compensation other than payments on termination remains included.

Check specific cases with your payroll manager against the official Index compensation rules (in French). To prepare your report, follow the Egapro Index guide.

These measures use payroll amounts for the selected period, with your analysis filters. They do not represent annual contractual salary or automatically convert pay to full-time equivalents.

Reflect divides Total paid among the distinct employees present in the selected payroll transactions: this is Headcount (Finance). An employee appearing in several months counts once over the whole period. The calculation does not use average HR headcount.

Headcount (Finance) does not itself apply Total paid’s selection of four types: an employee can be counted even if all their items have an empty type. Check missing types before interpreting the average. A pay type filter also changes the population included.

Reflect first totals the included amounts for each employee over the period, then takes the middle value of those ranked totals. With an even number of employees, it averages the two middle values. It does not take the median of payslip lines or the average of monthly medians.

Individual totals of zero or a negative amount are retained. An employee with no usable included amount is left out of this median.

To compare two months, use monthly periods and the same scope. An individual’s quarterly total combines several months: average payroll for a quarter is not a monthly average.

DSN-specific amount reconstruction is explained in DSN: understanding compensation in Reflect.

If a difference remains, contact your Reflect representative with the period, entity, indicator, expected source amount and affected items.