Description
See it in action
Bring structure and fairness to pay. Set a midpoint and range spread for each grade and the minimum and maximum are calculated for you. Add your employees’ grades and salaries, and the template shows each person’s compa-ratio, how far up their band they are, and whether they sit below, within or above range — with a dashboard and chart for the whole organisation.
What it does
- Pay structure builder – midpoint and range spread per grade, with minimum, maximum and mid-point progression calculated
- Employee placement – band minimum, midpoint and maximum, compa-ratio, range penetration and position for every salary
- Pay dashboard – payroll, average compa-ratio, people below and above range, and the cost to bring everyone to minimum
- By grade – employees, average salary, average compa-ratio and out-of-range counts for each grade
- Pay band chart – visual band for each grade from minimum through midpoint to maximum
- Department filter and any currency – view one team or everyone; set your own currency symbol
- Protected formulas – calculations are locked and hidden so nothing breaks by accident
Who it’s for
HR and reward teams, finance managers and business owners designing pay grades, reviewing salaries or preparing pay reviews.
What’s included
- 1 Excel workbook (.xlsx): How to Use, Dashboard, Pay Structure and Employees
- 8 sample grades and 43 sample employees showing every band position
- Built-in How to Use guide and sample data you can clear in one step
Requirements
Microsoft Excel 2010 or later, including Excel 2019, 2021 and Microsoft 365 (Windows or Mac). Not designed for Google Sheets.
This is a digital download. No physical item will be shipped. Your file is available to download immediately after purchase.
Reviews
There are no reviews yet.