Total Compensation by Employee
What does this report show me?
Review employee compensation totals across personnel and supplemental expenses.
Purpose
The Total Compensation by Employee report in Allovue is used to review, validate, and communicate employee-level compensation totals by combining pay and benefit amounts into a single view. It’s most commonly used to:
Verify completeness of pay + benefit data (catch “missing pays/benefits” issues early).
Understand cost drivers at the employee level (who is costing what, and why).
Support scenario planning by comparing how staffing/comp changes affect total compensation.
Provide an audit-friendly output for finance/HR collaboration and approvals.
Key Features (what the report typically includes)
While exact columns can vary by configuration and product version, the report is generally characterized by:
Employee-level rollup
One row per employee
Identifiers like employee name, employee ID/code, position/job, location/site, department, fund/accounting strings (where available)
Pay components
Pay, Benefits, Supplemental Pays and any Additional Benefits
Other features
The report can be exported (CSV/Excel) for reconciliation, sharing, and audit documentation
The report reflects the selected future scenario/budget.
Access Total Compensation by Employee Report
In Allovue, select Budget.
From the All Budgets or Single Budgets tab, select Budget Planning.
From Budget Planning, select Reporting.
Select Export Data.
A copy of the report will be emailed to the email address associated with your account. In the email, select the report name to download a copy to your device.
Exports will maintain any filters that are selected in the application.
If the All Budgets Tab is selected, the report will surface all organizations within your account.
If the Single Budgets Tab is selected, the report will surface data that matches the selected organization’s Budget scope.
Report Fields
Fields | Description |
|---|---|
Employee Code | The employee’s unique identifier used by Allovue to link records across sources (e.g., Manage, Personnel Expenses, Supplemental Expenses). This is the primary key the report groups on. |
Employee Name | The employee’s full display name (pulled from the |
Pays | The summed total of the employee’s pay compensation coming from Personnel Expenses in the selected scenario/budget context (e.g., base pay/salary and other personnel pay modeled in personnel expenses). It’s an aggregate (sum) per employee. |
Benefits | The summed total of the employee’s benefits cost coming from Personnel Expenses in the selected scenario/budget context (e.g., employer-paid benefits modeled alongside personnel expenses). Also aggregated (sum) per employee. |
Supplemental Pays | The summed total of the employee’s supplemental pay coming from Supplemental Expenses (distinct from standard personnel expenses). Aggregated (sum) per employee. |
Additional Benefits | The summed total of benefits associated with supplemental expenses (i.e., benefit costs attached to supplemental pay/expenses), aggregated per employee. |