Load a workforce file and get a quick snapshot of how healthy pay is, for the whole organisation or any area of it. Six checks, the same every time, each with a clear status.
Most reward teams can answer "how is pay in Technology?" only after days of spreadsheet work. So the question gets asked once a year. A health check that runs in seconds can be run for any area, at any time, and before a problem turns into resignations or a pay gap figure.
It runs six checks: where people sit against their reference point; pay compression (differences too small to reflect seniority or experience), across managers and their reports, newer and experienced people, and the steps between levels; whether pay follows performance ratings; how widely pay spreads within the same job; which people are paid far from their peers; and a gender snapshot.
A status is a prompt to look, not a verdict. The thresholds behind Healthy, Watch and Act are examples that you change to suit your organisation.
This is not use case 06 (the remuneration analyser). This one runs fixed checks as ordinary code on your own computer. That one answers free-form questions and is built with IT. For the gender detail, use the pay gap analyser (use case 01).
This is the real tool, running in your browser on an invented workforce. Pick an area, change a threshold, or load your own file.
Your file is read by your own browser. Nothing is uploaded. All sample data is invented.
Five steps from a workforce file to a shareable picture. Press Play, or step through at your own pace.
Technology · 80 people
Whole organisation · 320 people
Load the file, pick an area. One row per person, with an ID, not a name. Choose a department, a level, a job family, or leave them all on "All".
No overall score. Each status has an icon and a word, so it never depends on colour alone.
Six checks, one status each. Every check ends in Healthy, Watch or Act. Thresholds are examples that you replace with your own.
Compare with the whole organisation. The same figure sits beside the whole organisation's, so "is this unusual?" is answered on screen.
Compressed: the best-paid report earns 95% or more, but less than 100%, of the manager's base. Inverted: 100% or more.
See what is behind a flag. The "People behind the flags" list shows who, and why, for your own working use. It sits closed until you open it.
Share the picture, keep the people private. The printed summary and the AI summary prompt carry grouped figures only. No employee ID appears in either.
All figures in this walkthrough are invented, for illustration only.
You can build your own version with any capable AI assistant your employer allows, for example Microsoft Copilot, Claude or ChatGPT. You describe what you want, it writes the code, and you check the answers.
Build it with invented data, never your real file. Expect two or three rounds of "that's not quite right, change X".
Say what the tool is, what goes in, and what comes out.
This is where vibe coding goes wrong. If you write "check for pay compression", the AI will invent its own definition and you will not know which one. Give it the full definition of every check, then adapt these to your own policy. Compa-ratio means a person's pay divided by the reference point for their role.
The numbers above are invented examples. Your organisation will have its own view of what is "healthy".
Agree the thresholds with your team before anyone outside it sees a red status. If a number appears on screen as "Act" and nobody has agreed what that means, the conversation becomes about the label and not about the pay.
Hiding a small group is not enough on its own. If a total is shown and every other group is shown, anyone can subtract the others from the total and work out the hidden one. So when a small group is hidden, one more group may need hiding too.
Ask the AI for a tiny case with round numbers, work the answer out yourself, then compare. Here is one for check 4 (spread within the same job) and check 5 (outliers).
| Person | Base salary |
|---|---|
| 1 | $80,000 |
| 2 | $90,000 |
| 3 | $100,000 |
| 4 | $110,000 |
| 5 | $150,000 |
| Median | $100,000 |
| 10th percentile | $84,000 |
| 90th percentile | $134,000 |
$150,000 is 50% above the median. $80,000 is exactly 20% below it, which is not more than 20%, so it is not an outlier. If the tool disagrees, it is wrong. Tell the AI what you expected and ask it to fix the calculation.
Individual pay, ratings, reporting lines and time in role for everyone in the file.
The tool runs on your own computer, saves nothing and is technically blocked from sending anything. Use IDs, not names. The printed summary and the summary prompt carry grouped figures only. The people list is your working data, so treat a downloaded copy like any confidential pay file.
Privacy rules for employee records differ between private employers and government agencies, so check with your privacy officer. Start with the OAIC's guidance on the Australian Privacy Principles and on employment and privacy. General information, not legal advice.
It is a single file. Save it anywhere and double-click to open it. The sample file can be downloaded from inside the tool.
What next: Pay gap and pay equity analyser (use case 01) · Remuneration analyser (use case 06) · Back to all use cases