This article is written to provide you with and explain an Internal Benchmarking Approval to Hire (ATH) Form which can be used for your business to determine the candidate’s total rewards package and compare it to current employees in similar roles.
In part 1 of this series, we introduced to you the leading Approval to Hire (ATH) Process which is overseen by HR, and explained that there are 3 forms which can be used for your business. It is worth mentioning that each form has its own complexities when it comes to the formatting features, which we will discuss. In this part, we are going to discuss the Internal Benchmarking ATH Form.
When you download the Internal Benchmarking ATH Form found below, you will find it gathers information relating to current employees and the candidate, providing you with a high-level but detailed summary of what their proposed total rewards package will look like. This form has been split into six sections:
I. Candidate Information
II. Internal Benchmarking
III. Candidate Total Compensation
IV. Additional Information
V. Additional Notes
This form is moderately complex and is best fitted for businesses who may want to internally benchmark new hires to their current employees who are in the same/similar role. This workbook includes graphs on tab 3, which shows at a high-level where the candidate is benchmarked compared to the current employees.
Note: The only individuals who are privy to view the ATH form are those who are directly involved in compensation determination and payroll.
It is vital that this form has accurate information captured with the appropriate approvals as:
- The information is translated into the offer of employment that is communicated to the candidate
- Payroll utilizes this form to ensure the candidate is paid appropriately
- The form is documentation evidence relating to compensation determination
Now that you have been introduced to the Internal Benchmarking Form, we will provide you with some general notes about the workbook.
General Notes about the Document Type
This form has been developed using Excel, as this application offers more feature capabilities which:
- Reduces manual entries
- Automates calculations using formulas
- Increases efficiency when adjusting tables, cells, columns, fonts, colours, or other formats
- Allows you to effortlessly type information into the cells
- Allows you to easily add, delete, or insert rows and columns (as seen in a video included below)
- Allows you to effortlessly add or delete notes/comments to cells (as seen in a video included below)
- Allows you to configure cells to show data in various formats like text, date, percentage, currency, etc.
There is so much more to Excel, however, these are just the basic functions to know with this form.
Applying this Workbook for Your Business’s Branding
- Reformat the workbook to meet your company’s branding initiatives (i.e. logo, colours, font, etc.)
- The company logo is inserted in Row 1 (cell A1)
- The form’s title is typed in Row 1 (font right alignment)
- The company’s primary colour is used for the headers
Note: Using grayscale is acceptable if your company’s primary colours are difficult to read (i.e. Neon).
Using this Workbook
- This workbook has three tabs:
- Instructions – displays how a completed form would look
- Template – an uncompleted form for you to use
- Benchmarking Graphs – a high-level overview of the internal benchmark between current employee(s) and the candidate
- Comments were added to this workbook to provide clarification on the terms or formulas used
- Comments are displayed as a red triangle in the top, right-hand side of a cell. To view the comment, hover your mouse over the cell to disclose what it reads.
- This workbook has three tabs:
- Type information only in the cells that are highlighted in yellow
- Any cells in columns A to C that are not highlighted are formulated to calculate data
- Hide the Row(s) which the candidate does not receive
- Match the naming conventions that your company uses
- Please refer to our HR Glossary if you need definitions relating to any terms found on this form
Using the Benchmarking Graphs
- Data on this tab is auto-populated from the Approval to Hire Template tab
- Graphs auto-complete based on the auto-populated fields found on the Benchmarking Graphs tab under Candidate Employee Information
- There is no reason to manually enter data
- If any changes are made on the Approval to Hire Template tab, ensure the formulas are adjusted accordingly
This brings us to the end of this part of the series. Please stay tuned for part 4 of this series when we discuss the next form in our Approval to Hire series, Salary Survey Benchmarking.
Excel – Rows & Columns
Excel – Notes & Comments