Last updated: Closing the gender pay gap: How to become an equal pay employer

Closing the gender pay gap: How to become an equal pay employer

16 shares

Listen to article

Download audio as MP3

As I write this, women are earning 81 cents for every dollar a man earns. That’s according to an uncontrolled study published by Payscale.

From 2018 to 2019, we saw a 1% improvement, and from 2019 to 2020, 2%. And while in their controlled study, where men and women were measured for the same position and qualifications, women earn 98 cents for every dollar a man earns, closing that 2 cent gender pay gap is expected to take 100 years.

I’m not going to take this time to discuss why equal pay is important – it’s important.

Instead, I’m going to give you the tool to make it happen.

My organization has been privileged to work with companies who want to do the right thing, but they’re unsure about how, or even where, to start. Overhauling your compensation strategy and building out the system to maintain it can be a daunting task. I assure you though, it can be done.

How do I know? Because I require it from any company that wants us to be their HR service provider, and they’ve paid for it.

I’ve realized over the years that this mission to close the gender pay gap is much bigger than I am, and that I’m doing it a disservice by making the solution available to only a select number of companies.

So, here it is:

Closing the gender pay gap: The compensation analysis and pay ranges workbook

Note: Values below are just examples. Companies should do their own research to determine the values that work for them.

Part 1: Building the workbook

  1. Download a copy of your current employer roster with title and pay.
  2. Start a new workbook in Excel or Google Sheets.
  3. Create a tab for each company department (e.g., Administrative, Marketing, Accounting, Operations, Sales).
  4. For each department, label the following columns:Column A: Position
    Column B: Range Width
    Column C: Min (for minimum)
    Column D: Mid (for mid range)
    Column E: Max (for maximum)

Entering Your Data

Column A: Positions

List each department position from entry-level to C-suite (or whatever you call the department leader). It doesn’t matter if not every position is currently filled, you just want what the company has decided on as the career path for the department.

Column B: Range width

Range width will determine the difference in range from one position to its succeeding position.

Non-management positions should have a range width between 15% and 25% because people tend to stay in these positions for a shorter tenure than the management positions.

Management positions should have a range width between 30% and 40%, allowing these employees a longer period to stay in the position before reaching max range.

*Range width does not have to be the same value for all positions in a department.

gender pay gap: how to close it workbook

Column C: Determining minimum values

There are several ways to go about this:

  1. Entering the local minimum wage as the first minimum value (if you plan to pay any positions minimum wage)
  2. Determine the compensation strategy for the company. How competitive the company wants to be will determine the strategy. If the company wants to pay above market, the values need to be above the 50th percentile of the position’s range. It is important that company size and geographical location is considered when determining which range to use.
  3. A company can be more specific in determining that they want to pay in the 70th percentile of the market range. Using at least three salary sources and finding the average 70th percentile value will make these ranges more accurate.

*Values can be in the form of hourly wage or annual salary. If most positions are non-exempt positions, it is best to use hourly wage values. Values should be base salaries and not include commission or bonuses.

Column D: Determining mid-range values

Enter the following formula in all of the cells* in Column D: =(C2+E2)/2

This formula will automatically enter the middle value between the minimum and maximum values.

*Be sure to adjust the formula to use the coordinating number for each row.

Column E: Determining maximum values

Enter the following formula in Column E: =(B2*C2)+C2

This will solve for the determined range width and minimum values entered.

Column F: Additional notes

This is where we like to list the minimum wage and minimum exempt salary for the area to ensure that exempt positions have the minimum salary as the minimum value in Column C.

Closing the gender pay gap, part 2: Analyzing the roster

Review each employee on the roster and highlight them based on how much they are paid:

Yellow = They are paid within their title’s range

Green = They are paid more than their title’s range

Red = They are paid less than their title’s range

Dealing with overpaid employees 

  1. If they are less than 5% over the range and they’re the only one in that position, leave it alone for now or give them more responsibility to justify it.
  2. If they are less than 5% over the range and there are others with the same title and function, bring the others up and increase the minimum value by 5%.
  3. If more than five people with the same title are over the maximum range, go back to the workbook and increase the minimum range.
  4. If they are more than 5% over the maximum range because they have more responsibility or their functions are more complex than others in their position, create another row/range and give this one a “senior” title or increased grade (e.g. Senior Accountant, or Staff Accountant II).
  5. In most cases when employees are 5% or more over the range, a title change will be necessary.

Dealing with underpaid employees 

  1. If they are less than 5% under the range and the only one in that position, increase their salary to bring them in range.
  2. If they are more than 5% under the range, they’re either underpaid or they have an inflated title.
  3. If there are several employees more than 5% under the range, create another row/range and give this one a “junior” or “assistant” title. (e.g. Junior Staff Accountant, or Accounting Assistant).

Auditing for equal pay

When it comes to auditing for the gender pay gap, it’s important to keep the following in mind:

1. In most industries, salaries should be based more heavily on job functions than experience.

If two employees have the same responsibilities and functions, they should be paid the same unless one has had more tenure within the company and received merit increases based on performance over time.

For positions where years of experience and credentials are strongly related to how well and how complex of a job a person can do (engineering, teaching, coaching, government, security, etc.), there is a third part to this project.

2. Women re-entering the workforce.

Sometimes women take time off to have and care for children. Companies cannot use this as leverage to pay her less than males in the same position. Companies need to decide if they believe she will succeed in the position or not. If not, move on and find a candidate the company believes in so she can continue her search for an employer who believes in her.

3. It’s ok to admit fault.

In most cases, companies are not underpaying women intentionally or maliciously. If a company realizes there is pay inequity after this exercise, resolve the matter professionally and commit to ensuring it doesn’t happen again (such as using the workbook for salary decisions moving forward).

There IS a solution for equal pay. Whether the company wants to tackle it themselves or hire a consultant to do it – closing the gender pay gap is achievable.

If there are HR consultants who want to use this for their clients and get paid to do so, you have my blessing. And if you have questions, concerns, or feedback, I’m listening.

Together we can increase this improvement rate for a more equal workplace.

Equality for ALL:
Go from messaging about inclusion to making it a reality.

Share this article

16 shares

Search by Topic beginning with