Employee Total Rewards Statement, Total Compensation Statement Template Excel


Personalize with Name or Company Name


Total rewards statements can help summarize the value of all the compensation, benefits, extra perks, retirement contributions, continuing education, etc. – each personalized with the employee’s specific information in a nice 1 or 2 page summary.

Are you looking for a way to communicate the value your organization invests in employee benefits, as an extra way to let your employees know they are appreciated for the work they do?  Many benefits go unnoticed and overlooked, but with a total rewards statement you can bring everything together in a simple 1-page statement, personalized for each employee to show the value of all their compensation and benefits – from base pay, overtime, bonuses, to health benefits, insurance, stock and any extra perks specific to your company like tuition reimbursement, company parties, continuing education and more.

Watch the video demo of how this template works below:

How it works –
Everything is linked together through the employee ID, and you can copy and paste your employee data into the specified tabs/pages, which will link to the statement. 

There are 4 separate pages to paste your employee data into-
• Employee General Data Page – This page consists of the general compensation data, base pay, bonuses received and time off value estimates.
• Employee Benefits Data – Here you will enter or copy/paste the employee ID, name and benefit amounts for the different benefits they have received – including medical, dental, vision insurance, flexible spending accounts, insurance benefits and retirement benefits.
• Employee Stock Data page – Here you can enter up to 2 different stock programs. You can name the program here, so it will appear on the statement, so if an employee is not eligible you can leave it blank in their cell. For example, 1 employee could have ‘Stock Options’ as their stock plan 1, and ‘Restricted Stock’ as their stock plan 2, with the amounts you set.
• Extra Perks page – Here you can enter up to 5 different ‘perk’ names, and associated values. The perk names can be different for each employee, so if a small group is eligible/ has received Tuition Reimbursement, you would name that as a perk for them, but leave it blank or list another perk for those who didn’t receive it.

After all the data is filled out in these pages, you will just go to the Statement tab and change out the employee ID – the rest of the amounts/program names and the 2 charts will update with each new employee ID.

The 1 page total rewards statement can be saved as a PDF to distribute to employees by printing or email.  The template is set up to work for up to 1,000 employees, however it generates 1 report at a time, which must be saved as a PDF or printed.   So for each report, you just need to change out the employee ID, and then either print or save the page as a PDF.  Directions are included on how to save each statement as a PDF.

Upgrade Option - 2 page statement with detailed benefits:

The upgrade option includes a 2nd page for the rewards statement, with some extra charts and more detailed information, including these new features:

  • Medical page- Here you can enter provider cost, employee cost, and employer cost for up to 4 levels for your Medical, Dental, and Vision Plans.
  • Employee General page- The upgraded page includes the option to track 4 additional types of time off to report about 7 types of Time Off.  
  • Employee Benefits page- The upgraded page includes the option to track Medical Benefits with more detail as pulled from the Medical Page, the option to also track additional Health Plan Type and Retirement Benefits, and Vehicle Usage.
  • Insurance Benefits page- A new page to report plan level, employee contribution, and employer contribution for 10 additional Insurance Types.
  • Deferred Compensation page- A new page to report 3 types of deferred compensation under 2 plan options.

You will receive an Excel spreadsheet, along with PDF directions via email.  The directions will guide you through how to fill out the worksheet, as well as how to generate and save each statement as a PDF.

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

Custom Changes – If there’s anything I can do to help customize this worksheet for your specific organization or reporting needs, I’d love to help out!  My background is in Compensation/HR – with about 7 years compensation experience, and PHR and CCP certified.  Feel free to contact me here for more information or a custom quote

Thanks for visiting!

Additional information

Upgrade Options


Customer Reviews

Based on 3 reviews
Benefit Statements

I just finished creating all the statements for our employees - I added the "Total Paid " out on an employee, so they could see that overall dollar figure easily. Would suggest adding that to your form. I would have liked the ability to merge a file of excel with it to create the individual documents - that would have made it quick and easy. Overall I did appreciate the help with the design and will use again when needed. If there is an updated version in the future - let me know

Jennifer Huttemann-Kall
FCS Review

Instructions were a little hard to follow and most of the data did not pertain to our agency otherwise it was great.

Denita G.
Quality Solutions

If you are looking to overhaul your compensation and benefits program, several tools available here will assist in gaining buy in from executives and help you build in equity across multiple pay grades. It not only saves you time but eliminates the headache of creating form like this yourself. Similar products offered through HRIS or payroll systems will cost you per employee as well as a base amount. I love these.

You may also like…

  • Cost to Hire Worksheet Template

    Select options
  • Annual Merit Increase Matrix – Excel Template for Compensation

    Select options
  • Variable Compensation Plan Template

    Select options
  • Human Resources Excel Spreadsheet Templates Package

    Select options