Total Rewards Statement Builder: Show Employees the Full Value of Their Job, Not Just Their Paycheck

Employees see their salary and rarely see the health premium, retirement contribution, payroll taxes and training budget you pay. This workbook turns your payroll and benefit numbers into a clear one-page statement for each person, with federal employer payroll tax built in.

What you get

• Roster tab: 50 employees with 16 inputs of employer-paid amounts and 7 calculated totals.
• Statement tab: pick a name and print a one-page statement with a share-of-total column and a one-sentence summary.
• Settings tab: company name, year, employer Social Security and Medicare rates and the wage base.
• Example tab: a filled sample for a fictional employee with a total of $68,911.
• 5 page PDF guide: what to include, where each number comes from, a sample statement, manager talking points, a copy-paste email and an employee FAQ.

How it works

1. Set your company name, year and payroll tax settings.
2. Enter each employee’s employer-paid amounts on the Roster.
3. Pick a name on the Statement tab and print.

Requirements

Excel, Google Sheets or LibreOffice and a PDF reader. No macros.

What it is not

A planning and communication tool, not tax, legal or financial advice. Statements are estimates, not a contract. Time away is shown as a memo and not added to the total. Ask a licensed attorney to review your wording.

Digital products: no refunds once downloaded. A corrupted, incomplete or not-as-described file reported within 14 days of purchase is replaced or refunded in full. Refunds return to your original payment method within ten business days.

These are general HR tools, not legal advice. For a situation with legal stakes, talk with an employment attorney.