Remuneration health check

Load a workforce file (or use the invented sample) to get a quick snapshot of how healthy pay is, for the whole organisation or any area of it. Six checks, the same every time.

Invented data
Drag a CSV file here, or press Enter to choose one

Your file is read by this page on your own computer. Nothing is uploaded or sent anywhere.

What does my file need?
  • One row per employee, with a header row.
  • Required columns: employee_id, gender, department, level (or grade/band), job_family, base_salary, reference_point.
  • Reference point = the pay figure you compare each person with, usually the midpoint of the range for their role. Compa-ratio = base salary divided by the reference point.
  • Optional, and each one switches on a check: rating, manager_id (the employee_id of the person's manager), years_in_role (or start_date, which is converted to years as at today).
  • Pay should be annualised full-time-equivalent dollars. Symbols like $ and commas are fine.
  • Gender values accepted: W, F, Woman, Female; M, Man, Male; X, Non-binary, NB, Other.
  • Use employee IDs, not names.

Choose an area

Groups with fewer than this many people (or, for gender figures, fewer than this many women or men) are hidden so no individual's pay can be worked out. Sometimes one more group is hidden too, so a hidden figure cannot be worked out by subtracting the others from the total.

Thresholds

Example thresholds. Replace them with your own.

Summary

This list names individuals by ID. It is your working list. It is not included in the printed summary.

People behind the flags

General information to help you explore your own data. Not advice. All sample data is invented. Thresholds are examples.