How to Reconcile Payroll with Total Compensation
Payroll shows what was paid; total comp shows what was promised. Here’s how to line them up - without double-counting - so variance is real, not an artifact.
Two views of the same person
Total comp aggregates base, bonus, benefits, commission, and equity from their sources into a target and an actual. Payroll gross YTD is the cash actually paid. Reconciling them tells you whether someone is tracking to plan - but only if you combine them correctly.
| Number | Meaning |
|---|---|
| Target total comp | Base + target bonus + benefits + target commission + annualized equity |
| Actual total comp | Base + actual bonus + benefits + commission earned + annualized equity |
| Payroll gross YTD | Cash actually paid to date (shown for reconciliation) |
| Variance to target | Actual minus target |
Don’t double-count payroll
Handle unavailable sources
If the payroll seam can’t be reached, or an employee has been synced but not yet paid, the payroll actual comes back unavailable (or null). Treat both as “payroll actual unavailable” and fall back to the rest of the total-comp view rather than reading a wrong zero as real.
Act on the variance
Using the reconciliation
- Compare attainment (actual ÷ target) per employee
- Roll up target vs actual across the roster for a comp review
- Cross-check payroll gross YTD against actual for anomalies
- Feed findings into the next merit or bonus cycle
Frequently asked questions
What is payroll gross YTD used for in total comp?
As a reconciliation cross-check. It’s shown alongside actual total comp but not re-added, because it already contains paid base, bonus, and commission.
Why not add payroll YTD to actual total comp?
Doing so would double-count base, bonus, and commission that are already in both. Fintra keeps payroll YTD as a separate reconciliation figure.
What if payroll data is unavailable?
The payroll actual comes back unavailable or null; treat both as “unavailable” and fall back to the rest of the total-comp view rather than reading a false zero.
How do I measure attainment?
Actual total comp divided by target total comp, per employee, with a roster roll-up of target vs actual for comp reviews.
Stay in the loop
One practical finance briefing a week - new guides, checklists, and benchmarks.
Real variance, not artifacts
Reconcile payroll actuals with total comp without double-counting.
Talk to us