Load a workforce file and see two numbers side by side: the gender pay gap across your whole workforce, and the like-for-like gap between women and men doing similar work. Then see why they differ, by WGEA category and by department, and as a sample WGEA-style report.
The two numbers answer different questions. The headline gap compares the average pay of all women with all men. The like-for-like gap compares women and men doing similar work. Executives and boards often mix them up.
A large headline gap with a small like-for-like gap usually points to who holds the senior and higher-paying roles, not to unequal pay for the same job. This tool shows both numbers and splits the difference between them.
The like-for-like view can also allow for performance rating, time in role and location, so a gap is not explained away, or missed, because of them. The headline view breaks the gap down by WGEA occupational category and by department, and a sample report lays the results out the way a WGEA benchmark report does, with an invented comparison group. A talking points page turns the numbers into a short brief for executives that you can download and edit.
It was "vibe coded": you describe what you want to an AI assistant in plain English and let it write the code. Once built, it is ordinary code. It runs the same calculation every time and uses no AI when you run it.
This is the real tool, running in your browser on an invented workforce. Switch tabs, change the pay measure, or load your own file.
Your file is read by your own browser. Nothing is uploaded.
Five steps from a raw file to a pay gap story. Press Play, or step through at your own pace.
| employee_id | gender | level | job_family | base_salary | total_remuneration |
|---|---|---|---|---|---|
| E1042 | W | Level 3 | Finance | $98,500 | $112,300 |
| E1043 | M | Level 3 | Finance | $104,200 | $118,900 |
| E1107 | W | Level 4 | Technology | $131,000 | $149,500 |
| E1118 | M | Level 2 | People | $84,600 | $93,800 |
| E1190 | M | Level 5 | Technology | $168,000 | $201,400 |
Start with a file. One row per person. No names needed, an ID is enough.
The headline gap. The average pay of all men compared with all women: (men − women) ÷ men. This is the style of figure WGEA publishes for employers.
Same job, same level. Now compare only people doing similar work. The group gaps are averaged, with bigger groups counting for more.
Why the numbers differ. Most of this invented gap comes from who holds the senior roles, not from pay for the same job.
Protect small groups. Groups with only a few people are hidden, so no one's pay can be worked out.
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 who will use it.
Do not let the AI guess the maths. Tell it exactly what to calculate.
Pay data is sensitive. Put the protections into the tool itself.
Ask the AI to give you a test you can check by hand, then check it.
| Person | Men | Women |
|---|---|---|
| 1 | $100,000 | $90,000 |
| 2 | $100,000 | $100,000 |
| 3 | $120,000 | $100,000 |
| 4 | $160,000 | $110,000 |
| Average | $120,000 | $100,000 |
| Median | $110,000 | $100,000 |
If the tool gives a different answer, it is wrong. Tell the AI what you expected and ask it to fix the calculation.
Individual pay and gender, which people rightly treat as highly sensitive. An employee ID is enough. Leave names, dates of birth and addresses out of the file.
The finished tool runs in your browser and nothing is uploaded. When you build your own, give the AI assistant invented data only. Do not paste or upload real pay data into a public AI tool. Use tools your employer has approved.
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.
This tool is for exploring your own data. It does not produce or replace your WGEA submission. Its sample report copies the layout of a WGEA benchmark report, but the comparison group and last-year figures in it are invented.
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: Back to all use cases