Employee Placement Tracking: See Where Your People Sit in Their Bands
The Problem Isn't Finding the Salary — It's Knowing What It Means
Picture this: you're preparing for a merit cycle at a 90-person professional-services firm. Your HRIS holds salaries. Your job bands live in a spreadsheet. Connecting the two means exporting a roster, pasting it next to the band table, manually writing a formula for each row, and hoping nothing shifts before the manager reviews go out.
By the time you're done, you have a snapshot — accurate for roughly 48 hours, obsolete the moment anyone gets an off-cycle adjustment. Worse, the analysis lives in yet another file that nobody but you knows to look at, and it tells you nothing about whether the distribution across your bands is equitable or defensible.
Employee placement tracking is the practice of recording and monitoring where each person sits within their assigned pay band at any point in time — not just their dollar salary, but their position relative to the band's minimum, midpoint, and maximum. Done well, it turns a static roster into a live compensation governance tool. This article explains how to build that practice, which metrics actually matter, and how to use placement data to make better decisions in merit cycles, pay-equity reviews, and leadership conversations.
What "Band Position" Actually Measures
Every pay band has three structural points:
- Minimum — the lowest the company is willing to pay for that role/level.
- Midpoint — the market anchor, typically pegged to a published percentile (commonly the 50th percentile of a relevant survey, such as BLS OEWS for US roles).
- Maximum — the ceiling, typically set at a fixed percentage above the midpoint (often called the range width or midpoint spread — for example, a ±20% spread puts the min at 80% of mid and the max at 120%).
Two metrics capture where a person sits relative to those points.
Compa-ratio is the most common. It expresses an employee's current salary as a percentage of the band midpoint:
Compa-ratio = Current Salary ÷ Band Midpoint × 100
A compa-ratio of 100 means the employee is paid exactly at market midpoint. Below 100 means below midpoint; above 100 means above. For a deeper treatment of how to calculate and interpret compa-ratios — including how to read a department-level average — see the compa-ratio explained guide.
Range penetration (sometimes called band penetration) answers a slightly different question: how far through the band has the employee progressed, from minimum to maximum?
Range penetration = (Current Salary − Band Min) ÷ (Band Max − Band Min) × 100
A penetration of 0% means the employee is at the exact minimum. A penetration of 50% means they're at midpoint. A penetration of 100% means they're at the maximum — or above it (a negative penetration value, indicating a red-circle situation, is also possible if the band was adjusted downward).
Why both metrics? Compa-ratio tells you where someone sits relative to the market anchor. Range penetration tells you where they sit in the journey through your band. Both are useful. Compa-ratio matters most in pay-equity analysis and salary-budget modeling. Range penetration matters most in merit planning — it tells you who has room to grow within their band and who is approaching the ceiling.
Building a Placement Tracking View Without Duplicating Salary Data
The practical challenge most HR generalists face is architectural: salaries live in one system (the HRIS or payroll platform), and job bands live somewhere else (usually a spreadsheet). Duplicating salary data into a band-tracking sheet creates two sources of truth and doubles your audit exposure.
A cleaner approach separates two concerns:
- The band structure — maintained in a dedicated place, with role, level, min, midpoint, and max for every defined position.
- The placement view — a reference that pulls or receives current salary from the HRIS and computes position metrics on the fly; it stores the computed metrics, not the salary itself.
In practice this means your placement view contains columns like:
| Column | What it holds |
|---|---|
| Employee ID | The HRIS identifier — no name needed for analysis |
| Role / Level | The job band assignment |
| Band Min / Mid / Max | From the band structure table (lookup, not manual entry) |
| Compa-Ratio | Formula: salary ÷ midpoint |
| Range Penetration | Formula: (salary − min) ÷ (max − min) |
| Position Flag | Computed label: Below Range / In Range / Above Range |
Salaries flow in as a point-in-time import; computed fields update automatically. The result is a placement snapshot you can refresh each time you need it — before merit, before a pay-equity review, before a leadership briefing — without maintaining a live duplicate of the payroll file.
For a worked example: suppose your Band 3 for a particular role has a min of $52,000, a midpoint of $65,000, and a max of $78,000 (a ±20% spread). An employee currently earning $58,500 has a compa-ratio of 90 (58,500 ÷ 65,000 × 100) and a range penetration of 50% ((58,500 − 52,000) ÷ (78,000 − 52,000) × 100). They sit at the midpoint of the journey through the band but 10% below the market anchor — useful intelligence for a merit conversation. (These are illustrative example inputs, not published survey figures.)
Reading the Distribution: What the Placement Map Tells You
Individual metrics are useful; the distribution is powerful. Once you have placement data for everyone in a band, you can plot — or simply sort — employees along a spectrum from minimum to maximum. Patterns that surface in that distribution are where compensation governance actually lives.
Clustering near the minimum in a band often signals one of three things: a recent influx of new hires, a band that was repriced upward faster than salaries followed, or a department where merit increases have been thin for several cycles. Each has a different resolution.
Clustering above the midpoint in a band that has not been updated recently may indicate the band itself has drifted below market — everyone has crept toward the ceiling because the midpoint no longer reflects current conditions. The fix is a band revision, not a merit freeze.
Dispersion by protected-class group is the most consequential pattern. If women or employees in a specific demographic group are systematically placed lower in the same band than similarly tenured peers, that is a pay-equity signal that warrants a formal analysis. The pay-equity audit guide covers how to structure that analysis and what documentation to retain.
Red-circle employees — those paid above the band maximum — appear as penetration values above 100%. This is not automatically a problem (it may reflect a legacy hire, a role reclassification in progress, or a retention premium), but it must be tracked and documented. Unmanaged red-circle situations create compliance exposure as pay-transparency laws require disclosed ranges to reflect good-faith expectations.
Using Placement Data in the Merit Cycle
Placement tracking earns its keep most visibly during annual or semi-annual merit cycles. When managers receive a merit-budget allocation, they almost invariably default to distributing it evenly across their team — or to rewarding the employees they interact with most. Placement data gives HR a principled basis to redirect that budget.
A position-aware merit approach works as follows:
Set merit guidelines by range penetration tier. Employees in the lower third of their band (penetration 0–33%) are eligible for larger increases. Employees in the upper third (67–100%) receive smaller increases or are considered for reclassification instead. Guidelines, not mandates — managers retain discretion, but now with visible context.
Flag equity exceptions before the cycle closes. Before approving any merit sheet, run a comparison of proposed compa-ratios by gender, tenure cohort, and hiring source. If the proposed awards would widen existing gaps, surface that to the manager before approval, not after.
Track band-position change, not just dollar increase. A 3% merit increase for an employee at 78% compa-ratio is not the same merit event as a 3% increase for an employee at 105%. Tracking the compa-ratio before and after each cycle shows whether your merit investment is moving people toward or away from equitable placement over time.
The merit cycle planning guide walks through the full merit budget architecture, including how to calibrate merit matrices to range penetration tiers.
Placement Tracking as Ongoing Governance, Not a Point-in-Time Report
The most common mistake with placement tracking is treating it as a once-a-year exercise that precedes the merit cycle. The value compounds when placement data is reviewed at three recurring moments:
On every new hire offer. Before extending an offer, the hiring manager should see where the proposed salary lands in the band — and particularly whether it would place the new hire above any current team members with equivalent or greater tenure. New hire compression is one of the leading causes of regrettable attrition and is almost always preventable with a placement check at the offer stage.
On every promotion or reclassification. Moving someone from Band 2 to Band 3 without adjusting their salary to a reasonable penetration point in the new band is a common structural error. The placement view surfaces this immediately.
On every off-cycle adjustment. Ad hoc increases, counter-offers, and retention bonuses all shift placement. Tracking them in real time prevents the accumulating drift that makes distribution analysis unreliable at merit time.
When placement tracking is embedded in these three moments rather than confined to an annual export, it becomes part of how compensation decisions get made — not a retrospective audit of decisions already made. That shift from reactive to proactive is what separates a compensation governance practice from a spreadsheet exercise. If you're evaluating how a structured band approach fits your broader governance obligations, the HR director compensation governance guide and the complete job band structure guide provide the surrounding framework.
Get a Cleaner View of Where Your People Sit
Building and maintaining a placement-tracking view is significantly easier when your band structure and placement metrics live in the same tool. Job Band Builder computes compa-ratios and range penetration for every employee position in real time, flags out-of-range placements automatically, and lets you export a placement report formatted for leadership review or pay-equity documentation — without creating a duplicate salary file.
Start a free trial at app.jobbands.com/signup and run a placement analysis on your current band structure in your first session. See the pricing page if you'd like to compare plan features before signing up. ```
Ready to go beyond the guide?
Build a defensible, BLS-benchmarked band structure in under 30 minutes.