HR tools built by a senior HR executive · United States

Published standard  ·  Assessments  ·  Contact

HR calculator

Pay Structure and Internal Equity Review

Screen two groups for a pay gap in three steps. One Excel workbook takes your pay data and returns a clear read. A PDF guide walks the method, so you can defend the answer.

FormatCalculator
Contents4 PDF guides, 1 Excel workbook
UseDownload and keep

$39

  • Editable operating files, not a subscription
  • Immediate access through the secure TrueStep HR store
  • Built and reviewed under the published TrueStep HR standard

Digital products carry a 30-day money-back guarantee. General HR information, not legal advice.

Need it working, not sitting in Downloads?

Add a one-hour setup session · $149

Bring the purchased tool and your live situation. A TrueStep HR practitioner helps you set the inputs, make the first decisions, and leave with a usable next step.

See the Setup Session →

What this closes

A practical system that moves the decision into real work.

Pick two groups doing similar work and enter their pay. The review flags differences worth a closer look. It is a screen, never a finding.

DecisionSet pay and raises
IndustryCross-industry
Files4 PDF guides, 1 Excel workbook
ReviewBuilt to the published release checks; sources and change notes sit beside the catalog.

What is inside

Every file in the download, by name.

Taken from the kit’s own Start Here guide, so what you see here is what you open after checkout.

Excel · usePay Structure and Internal Equity Review: 7 tabs: Start Here, Pay Equity Screen, Adjusted View, Action and Privilege, Benchmark and Law, Summary, and Notes.
PDF · printQuick Reference: the whole workbook on one page: what each tab is for, what you enter, and how to read the result.
PDF · readUsing This Workbook in Google Sheets: how to upload the file to Google Sheets and exactly what to check afterward.
PDF · keepTrueStep HR Product License: what you may and may not do with the files you purchased.

How to use it

What this workbook does

This workbook gives you a quick read on whether pay differs between two groups of people doing substantially similar work, for example by gender. You list the group, salary, time in role, and performance for each person. The Pay Equity Screen shows the raw gap between the groups and how they differ on legitimate factors. The Adjusted View removes the effect of one factor, time in role, and shows what gap remains. It is built to tell you whether a difference is large enough to take seriously and look into properly under privilege. It does not decide whether pay is fair or lawful, and a result is never a finding.

Your first 15 minutesOpen the Pay Structure and Internal Equity Review workbook in Microsoft Excel or a free equivalent such as LibreOffice. The first tab, Start Here, walks you through every tab. On the Pay Equity Screen tab, list employees who do one kind of similar work in a single comparison group. Assign each to Group 1 or Group 2, the two groups you want to compare. Edit only the amber cells; the white cells calculate for you.
Pay Structure and Internal Equity Review — the Start Here guide from the download, listing every file and the order to use them.

Before you buy

Clear answers to the practical questions.

The point of a product page is to let you judge the work before checkout.

What exactly do I receive?

4 PDF guides, 1 Excel workbook, each one named in the What is inside section above. The purchase is a download, not a subscription, and the files are yours to keep.

Are these the real screenshots?

Yes. The preview images on this page are taken from the current deliverable, so you can judge the structure and writing before buying.

Can I use the files in my business?

The files are designed to be edited for your own internal operations. Review the included license and have legal counsel check decisions that require jurisdiction-specific advice.

What if I need help applying it?

Use the $149 Setup Session for one hour of implementation help on this tool. TrueStep HR does not offer broader consulting engagements. For a legal question, use qualified counsel.

Extend the system

Build on this decision.

These products address the next connected step in the same situation, operating method, or industry.

Salary Band Builder — the 5 files in this download shown as a stack of real pages: Excel + PDF, 17 pages in all.
CalculatorTSHR-018

Salary Band Builder

Turn market pay data into a working salary structure. Set one anchor, a progression, and a spread. The workbook builds every grade’s minimum, midpoint, and maximum, then shows where each of your people sits against their range.

Merit Increase Matrix — the 5 files in this download shown as a stack of real pages: Excel + PDF, 20 pages in all.
CalculatorTSHR-019

Merit Increase Matrix

Run a merit cycle on performance and where each person sits in their range, not a flat percent. Set your matrix, enter your people, and the workbook returns each raise, the cost, and a check against your budget.

Promotion and Internal Equity Calculator — the 5 files in this download shown as a stack of real pages: Excel + PDF, 20 pages in all.
CalculatorTSHR-020

Promotion and Internal Equity Calculator

Pressure-test one promotion before you commit to it. Enter the current salary, the new grade and its range, the proposed pay, and what peers already earn, and the workbook shows the size of the raise, where it lands in the new range, how it compares to peers, and what it costs in the first year.