Human Resources Excel Spreadsheet Templates Package


Personalize with Name or Company Name


Organize your human resource tasks and projects

Streamline your HR processes with easy to use excel spreadsheet templates, so that you can save time and get all your projects completed.

Designed specifically for your HR challenges, this template package includes a set of 7 HR and compensation related templates.

Salary Increase Analysis Worksheet

Quickly calculate compensation metrics like market index, range penetration and compa-ratio. 
Click Here for Full Details.

Pay Structure Design Worksheet

Helpful when implementing new range structures, will calculate range spreads and midpoint differentials.
Click Here for Full Details.

Employee Total Rewards Statements

Summarize the value of all the compensation, benefits, extra perks, retirement contributions, continuing education, etc
Click Here for Full Details.

Employee Stock Administration Template

Quickly and easily calculate employee stock options and/or restricted stock with this easy to use excel spreadsheet template (works with up to 2 stock programs)
Click Here for Full Details.

Annual Merit Increase Matrix

Worksheet will calculate merit increases for up to 1,000 employees
Click Here for Full Details.

Variable Compensation/Bonus Worksheet

Will calculate bonuses based on company results and individual performance ratings for up to 1,000 employees
Click Here for Full Details.

Turnover Report Template

Calculate turnover for up to 20 functional areas, and up to 18,000 employees
Click Here for Full Details.

You will receive an Excel spreadsheet, along with PDF directions via email.

Each template comes personalized with the company name of your choice.  All templates are to be used for 1 company only and are not to be distributed outside the organization.

Custom Changes –  This package doesn’t include customizations, but I’m happy to help with any questions you have in using the templates.  If you would like help with customizing any of the worksheets for your specific organization, I’d love to work with you.  My background is in compensation, where I previously worked for about 7 years as a compensation analyst and a few years before that in recruiting/ organizational development.  Feel free to contact me here for more information or a custom quote.

Thanks for visiting!

Want to try a free comp metrics template?

You may also like…