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.
Previews are taken from the deliverable itself.
HR calculator
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.
$29
- 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.
Enter the proposed promotion and the new salary. The workbook shows the size of the raise, where it lands in the range, and how it sits next to peers.
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 · usePromotion and Internal Equity Calculator: 7 tabs: Start Here, Promotion Calculator, Internal Equity Check, Cost, Benchmark, 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.
Also in the download: Promotion Internal Equity Calculator (Excel, file 5). Every file is in the same folder, named with the number shown here so the steps below point straight at it.
How to use it
What this workbook does
This workbook checks a single proposed promotion before you commit to it. You enter the current and proposed salary and the pay range for the new role, and it shows the size of the increase, the new compa-ratio, and where the salary lands in the range. The Internal Equity Check compares the new salary to peers already in that role and tests for compression with the next level up. The Cost tab adds the loaded first-year cost, and the Benchmark tab shows what promotion increases and pay placement typically look like.
Your first 15 minutesOpen the Promotion and Internal Equity Calculator workbook in Microsoft Excel or a free equivalent such as LibreOffice. The first tab, Start Here, walks you through every tab. Start on the Promotion Calculator tab and fill the amber cells: current salary, proposed salary, and the new range minimum, midpoint, and maximum. Then go to the Internal Equity Check, list the peers already in the target role with their salaries, and enter the next level up salary.
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.
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.
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.