Employee Total Compensation Calculation Spreadsheet

Determine What the Total Compensation Per Employee is.

How to calculate Base Salary, Time Off, Benefits & Other Compensation.

  1. Home
  2. HR Kits & Templates
  3. Compensation
  4. Employee Total Compensation Calculation Spreadsheet

Employee Total Compensation Calculation Spreadsheet

This document is a spreadsheet template used by HR to calculate the value of total compensation per employee, based on various factors including base salary, paid time off, statutory remittances, benefits, and additional cash compensation.

Can I preview it?

You bet.  
Click on the blue text link(s) below

Employee Total Compensation Calculation Spreadsheet  |  Accompanying Instructions for Staff

Download it for FREE!
Limited Time Bonus.  Get an additional 5 of our most popular HR Templates for free!

How is the Employee Total Compensation Calculation Spreadsheet used?

This template allows HR to calculate the value of total compensation per employee based on various factors, including, base salary, paid time off, statutory remittances, benefits, additional cash compensation (short-term incentive plan, bonus, etc.) and other employee costs (social activities, parking, etc.).

Which HR kit is it included in?

The Employee Total Compensation Calculation Spreadsheet can be used on its own as a stand-alone tool, or as part of the Compensation Kit. 

calculate-workforce-total-compensation-spreadsheet-template

Click image to view full size

 

VIEW THIS KIT

  • "Just a quick note to say thank you!  ConnectsUs HR toolkit is the perfect solution for our needs. The point and click application combined with the rich content of best practices gives us everything we need to create professional results.”

    Theresa Partlow | Director, Human Resources, Emeritus Assisted Living | Seattle, WA
  • ...Finally!  A straightforward and comprehensive HR toolkit that makes sense for small businesses...
    Dana Murray | President, Prospec | Seattle, WA

  • "...We needed a starting point for everything from policies to manager resources and got so much more."

    Karen Buchanan | Office Manager, BCTIA (BC Technologies Industry Association)

  • "...An HR resource at your fingertips; take it as it is, or customize it to meet your needs. Just what every business owner needs!"

    Carol Hama | Director, Professional Development & Services, HRMA - British Columbia Human Resources Management Association

  • "... much-needed and well thought out. We recommend the products to our clients who have a need to cut through the complexities of managing their employees. It’s easy to use and provides immediate value.”

    Greg Pallone | President, TRG Group

  • “…We were constantly “reinventing” the wheel when it came to establishing even the most basic administrative policies, procedures and templates (we were constantly “borrowing” examples from our sister organizations).  Your product provides us with virtually everything we were looking for in one nice, neat customizable package.”

    Brenda Taillefer | Executive Assistant, Athabasca Watershed Council
Testimonials Customer List