Total Compensation Statement Generator

These statements have a believability problem

A total compensation statement exists to make a number look bigger than the salary, and there is nothing wrong with that when the number is true. The trouble is that the three most common ways of making it bigger all sound reasonable said out loud in a meeting, and all three are visible to the person reading it.

One: paid time off counted as an addition

“Your twenty vacation days are worth 5,385” is the single most common line on these statements, and it is the same money twice. The salary is paid whether the days are taken or not. Nothing additional changes hands. The statement has taken a portion of the salary, given it a second name, and added it back to the salary.

So it is never in the total here. It is printed underneath with that reason in the reader’s own terms, because leaving it off the page entirely makes the statement look like it forgot something.

Two: mandated employer costs counted as a benefit

Employer payroll taxes are owed on every employee by law. They are a cost of employing somebody rather than something chosen for them, and adding them lifts every statement in the company by roughly the same share of salary while telling each reader nothing about their own package.

The tool adds up what those two refusals cost the headline and shows it as a figure of its own: the percentage points this statement is not claiming. On a typical file it is ten to fifteen.

Three: one total, when the total is not spendable

A health insurance premium is real money the employer really spends, and it is not money anybody can spend. A statement showing a single figure invites the reader to hold it up against a salary offer from somewhere else, and that is the comparison it loses, every time, because the other number is cash.

Each statement here carries three figures instead: cash you receive, money set aside for you, and money spent on your behalf. Then the total, and underneath it, what share of the total is cash. A reader who can see the split has no reason to suspect the parts.

The plan average presented as a personal figure

If a benefit column holds the same number for everybody, it is the average cost of the plan rather than an amount traced to any one person. Telling somebody “we spent 14,400 on your cover” when the file means “this is what we spend on average” is the kind of thing a reader checks once and never trusts again.

The tool notices when a column is uniform across everybody and the statements say so in a line at the bottom. It still counts the money, because the money is real. It just does not claim it is personal.

Nothing is guessed into a number somebody will be shown

Columns are classified from their names and every guess is shown for correction before anything is generated. A column that matches nothing is left out of every total rather than placed into one, because a wrong line on a statement is much harder to find later than a missing one.

What this does not do

It is not a payslip and not a tax calculation, and it says so on every statement. It does not work out what anybody takes home, which depends on things no roster contains. It reports what the employer’s own records show was spent, sorted into what the money actually does.

The statements download as one plain text file per person in a zip, built in your browser. Plain text because it opens on any machine, pastes into any letter or mail merge, and contains nothing but what you can read in the preview above. Pair it with the Compa-Ratio Calculator and the Merit Increase Modeler for the pay side of the same conversation.