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.
Previews are taken from the deliverable itself.
HR calculator
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.
$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.
Set one market anchor as your first midpoint. The builder generates a minimum, midpoint and maximum for every grade, then places your people in them.
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 · useSalary Band Builder: 6 tabs: Start Here, Band Builder, Employee Placement, 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.
How to use it
What this workbook does
This workbook turns market pay data into a full salary structure. You set one anchor, the Grade 1 midpoint, plus a midpoint progression and a range spread, and it builds every grade with a minimum, midpoint, and maximum on the standard compensation formulas. Then you place your people against those ranges and see at a glance who sits below, within, or above where their pay should land. It is the bridge between a salary survey and an individual
Your first 15 minutesOpen the Salary Band Builder workbook in Microsoft Excel or a free equivalent such as LibreOffice. The first tab, Start Here, walks you through every tab. Start on the Band Builder tab and set the three amber inputs: the Grade 1 midpoint from your market data, the midpoint progression between grades, and the range spread from minimum to maximum. The grade table builds itself.
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.
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.
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.