Workflow · People · Opening soon
Salary bands compa-ratio
Export your employee compensation file from BambooHR and your salary bands. Mammoth works out each employee's compa-ratio and shows who is below or above range.
Someone typed
“work out each employee's compa-ratio against the midpoint of their salary band and show who is below or above range”
The agent read it as
Work out each employee's compa-ratio against the midpoint of their salary band and show who is below or above range using Employees compensation export and Salary bands.
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
File
Employees compensation export
CSV export · 15 rows
File
Salary bands
CSV export · 6 rows
Join
Bring in salary ranges
15 of 15 paired
Step
Work out compa-ratios
Step 2
Result
Employee Compa-Ratio Flags
15 rows
Schedule
Runs when you say
Proposed
- FileEmployees compensation exportCSV export · 15 rows
- FileSalary bandsCSV export · 6 rows
- JoinBring in salary ranges15 of 15 paired
- StepWork out compa-ratiosStep 2
- ResultEmployee Compa-Ratio Flags15 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 15 rows came out, and the join paired 15 of 15 rows.
- Download Employees compensation export sample (15 rows)BambooHR: Reports > Custom Reports > Employee Compensation > Export CSV
- Download Salary bands sample (6 rows)BambooHR: Reports > Custom Reports > Salary bands export
What you get back
The result of that run, the rows to look at first.
Employee Compa-Ratio FlagsSample data15 rows
| Employee name | Employee # | Compa-ratio | Range status | Employee band | Salary (USD) | Minimum salary (USD) | Midpoint salary (USD) | Maximum salary (USD) |
|---|---|---|---|---|---|---|---|---|
| Omar Lopez | 1111.0 | 0.82 | Below range | G5 | 97,000 | 98,000 | 118,000 | 138,000 |
| Erin Cole | 1107.0 | 1.18 | Above range | G4 | 112,000 | 80,000 | 95,000 | 110,000 |
| Jonah Reed | 1058.0 | 1.19 | Above range | G1 | 59,500 | 42,000 | 50,000 | 58,000 |
| Caleb Price | 1069.0 | 1.07 | Within range | G3 | 83,500 | 65,000 | 78,000 | 91,000 |
| Dylan Fox | 1080.0 | 1.09 | Within range | G4 | 104,000 | 80,000 | 95,000 | 110,000 |
| Eli Turner | 1047.0 | 1.04 | Within range | G2 | 64,500 | 52,000 | 62,000 | 72,000 |
| Hannah Baker | 1086.0 | 0.95 | Within range | G3 | 74,250 | 65,000 | 78,000 | 91,000 |
| Jamal Wright | 1102.0 | 0.94 | Within range | G4 | 89,000 | 80,000 | 95,000 | 110,000 |
| Leah Okafor | 1073.0 | 1 | Within range | G4 | 95,000 | 80,000 | 95,000 | 110,000 |
| Maya Serrano | 1042.0 | 0.98 | Within range | G2 | 61,000 | 52,000 | 62,000 | 72,000 |
| Nora Patel | 1094.0 | 1 | Within range | G5 | 118,000 | 98,000 | 118,000 | 138,000 |
| Priya Nolan | 1051.0 | 1 | Within range | G1 | 50,000 | 42,000 | 50,000 | 58,000 |
How do you work out compa-ratio for salary bands?
Export your employees compensation file from BambooHR and your salary bands. Mammoth matches each employee to a band, then calculates compa-ratio against the midpoint. You can then see who sits below or above range.
How it works
How to use the Employee Compa-Ratio Flags workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Employee Compa-Ratio Flags: questions
Which export should you use?
Use the export that has each employee’s pay, job, or other fields you need to match to the salary bands. Also export the salary bands file with the ranges or midpoints.
What happens to rows that do not match a band?
Rows that do not match stay separate so you can review them. You can then fix the band rules or the source file and run the workflow again.
How do you change the matching or calculation rules?
Edit the rules in words, such as which columns to match on and how to calculate the midpoint and compa-ratio. Then rerun the workflow on the exported files.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent
- Headcount reportBuild a monthly headcount report from a BambooHR employees export, grouped by department and location, with hires and leavers.See the workflow Built by the agent