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

  • “...As an HR Professional, the toolkit is an indispensable resource. It includes templates I would never have thought to include for HR best practices..."

    Cyndy Ruiz | Principal HR Consultant, CRL & Associates | Seattle, WA

  • "...In a small business, best HR practices are sometimes not implemented due to a lack of resources or HR knowledge. With ConnectsUs products, we were able to implement them quickly and easily."

    Chris Breikss | President, 6S Marketing Inc. | New York, New York

  • "...My partner and I will be forever grateful to ConnectsUs HR toolkits for helping us get our personnel back on track with clear policies and procedures. Getting on board with the product was a piece of cake..."

    Sherrita Magalde | Co-Owner, Amigo Travel | Salt Lake City, UT

  • "... We had a menu of everything we could possibly need to quickly create HR best practices. The toolkit helped me understand what every small business should have in place."

    Salina Visram Landstad | Partner, Creative Spirits

  • “I love your products. You have done a truly fabulous job with your toolkits. I’ve just spent 3 hours customizing your toolkit for one of my clients, and what I’ve done already would have any senior management team ecstatic. Talk about return on investment!”

    Deborah Nicols | Principal HR Consultant, Nicols & Dymes Consulting Inc.

  • "Entirely straightforward!  Our Office Administrator basically took the templates and ran with them in a few days…professionally written using common language, and demonstrates significant and immediate value."

    Kent Toy | Director, Finance & Administration, Antarctica Systems
Testimonials Customer List