Blog · Board and management reporting · Finance and FP&A teams
A payroll cost dashboard compares gross wages, paid hours, overtime and signed adjustments by cost center. Work through a US company's payroll export, reconcile the totals and see what changes when overtime falls.
Payroll dashboard examples are most useful when they show why wages changed: paid hours, overtime, earning rates and corrections by cost center. A cost review should connect the headline total to the payroll export and the accounting record. It should also show which exceptions still need an owner.
Start with gross wages for a stated pay period. Keep regular earnings, overtime earnings, bonuses and signed adjustments visible. Employer taxes and benefits can sit beside that total, but they belong in separately labeled columns.
The distinction matters because employee withholding reduces the employee's payment rather than creating a second wage expense. The IRS employer's tax guide describes income tax withholding from wage payments. For this dashboard, use the gross earnings field rather than trying to reconstruct wages from the bank payment alone.
A broader compensation measure can include employer contributions as well as wages and salaries, as the BEA definition of employee compensation explains. This example deliberately measures wages only. Use the headcount cost analysis method when the review needs employer costs and staffing movements together.
Consider a US industrial service company reviewing a completed pay period. Its workforce export has cost center, pay-period end, anonymous employee identifier, earning code, paid hours, earnings amount and adjustment reference. Budget rows use the same cost centers and period.
Regular paid hours include hour-bearing straight-time earning codes. Overtime is separate. Bonuses and the adjustments below carry dollars but no additional paid hours. If your payroll export assigns hours to an adjustment, keep those hours too; do not copy this example's assumption without checking the earning code.
The following grouped input rows summarize the underlying payroll register. Rates are uniform within each cost center only to keep the example reproducible; a real department can contain many rates.
| Cost center | Regular paid hours | Overtime hours | Regular rate (USD/hour) | Overtime rate (USD/hour) |
|---|---|---|---|---|
| Operations | 2,400 | 240 | 28 | 42 |
| Service | 1,600 | 80 | 32 | 48 |
| Administration | 800 | 0 | 40 | 60 |
| Total hours | 4,800 | 320 |
Use the approved earnings amounts and earning-code definitions in the export. This is a cost analysis, not a calculation of statutory overtime entitlement or a payroll processing instruction.
| Cost center | Bonus earnings (USD) | Signed adjustment (USD) | Wage budget (USD) |
|---|---|---|---|
| Operations | 2,400 | 1,200 | 72,000 |
| Service | 1,600 | -400 | 55,000 |
| Administration | 0 | 0 | 32,000 |
| Total | 4,000 | 800 | 159,000 |
Gross wages = Regular hours × Regular rate + Overtime hours × Overtime rate + Bonus earnings + Signed adjustments
Overtime share = Overtime hours / Total paid hours
Wage variance = Actual gross wages − Wage budget
Operations regular earnings are 2,400 × $28 = $67,200. Its overtime earnings are 240 × $42 = $10,080. Adding the $2,400 bonus and $1,200 adjustment gives gross wages of $80,880.
Service has $51,200 of regular earnings and $3,840 of overtime earnings. Add its $1,600 bonus and subtract the $400 correction to reach $56,240. Administration contributes $32,000 of regular earnings.
| Cost center | Total paid hours | Gross wages (USD) | Overtime earnings (USD) | Overtime share | Wage variance (USD) |
|---|---|---|---|---|---|
| Operations | 2,640 | 80,880 | 10,080 | 9.09% | 8,880 |
| Service | 1,680 | 56,240 | 3,840 | 4.76% | 1,240 |
| Administration | 800 | 32,000 | 0 | 0.00% | 0 |
| Total | 5,120 | 169,120 | 13,920 | 6.25% | 10,120 |
Percentages are rounded to two decimal places. The company overtime share is 320 / 5,120 = 6.25%, calculated from total hours. Gross wages exceed budget by $10,120, or $10,120 / $159,000 = 6.36%. The positive sign means spending above budget.
Operations owns most of the dollar variance. That observation narrows the review, but does not establish the cause: its budget might have assumed different hours, bonuses or rates. The cost dashboard places this wage variance alongside other departmental spending without treating all expense movements as labor problems.
First, tie $169,120 to the gross earnings total on the completed payroll register. Next, reconcile that register to the wage accounts for the same service period, listing accruals, reversals and posting timing separately. A payment-date export can differ from the wage expense recognized in the month.
Then check that the cost center rows sum to both the wage and hours totals. If an employee worked across departments, allocate the relevant earning lines rather than copying the employee's whole pay into each department.
The signed adjustments sum to $800, but their absolute amounts sum to $1,600. Keep the $1,200 Operations addition and $400 Service reversal visible, with references back to their underlying entries. A net total alone would hide the size and direction of the corrections.
The compensation dashboard examples extend this view to benefits, variable compensation and workforce cost distribution. Keep that broader review distinct from a pay-period reconciliation.
Now change only Operations overtime hours from 240 to 120. Regular hours, rates, bonuses, adjustments and budget stay fixed. Overtime earnings fall by 120 × $42 = $5,040.
| Measure | Original period | Changed-hours case |
|---|---|---|
| Operations overtime hours | 240 | 120 |
| Company paid hours | 5,120 | 5,000 |
| Company overtime hours | 320 | 200 |
| Company overtime share | 6.25% | 4.00% |
| Wage measure | Original period (USD) | Changed-hours case (USD) |
|---|---|---|
| Operations gross wages | 80,880 | 75,840 |
| Company gross wages | 169,120 | 164,080 |
| Company wage variance | 10,120 | 5,080 |
The company overtime share becomes 200 / 5,000 = 4.00%. Wages fall, but paid hours also fall. This variation does not prove better productivity or unchanged service capacity; those conclusions require output and staffing evidence beyond the payroll file.
Bring a payroll earnings export and a matching cost center budget, using aggregated or anonymized rows where appropriate. Covirage maps the columns; its tools compute and check the wage, hours and variance totals, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See Covirage for finance teams for the wider financial review.
Include gross wages, paid hours, overtime hours and earnings, signed adjustments, budget variance and reconciliation exceptions. State whether employer taxes and benefits are included. Use the same pay period and cost center mapping throughout the comparison.
No. Net pay is what employees receive after deductions and withholding. A wage dashboard starts with gross earnings. A broader employer-cost dashboard adds employer taxes and benefits, while keeping employee deductions separate to avoid understating wages.
Divide overtime hours by total paid hours within each department, using a consistent definition of paid hours. Also show overtime dollars because departments can have different pay rates. Recalculate the company percentage from summed hours rather than averaging department percentages.
Show the signed net amount for reconciliation, but retain the individual positive and negative corrections for review. A small net adjustment can hide larger offsetting entries. Check their earning codes, affected periods and approval references before explaining the cost movement.