Cost & Comp: Employee Payroll Report

The Employee Payroll Report breaks down every compensation cost item by employee and project, with type-specific columns for hours, quantities, percentage bases, mileage, and weight. Use it to review pay for a given period, reconcile payroll, and diagnose gaps in your cost and compensation setup.

Use This Report to Answer Questions Like:

How much total compensation was paid out this pay period?
How many hours did each employee work across their projects?
Which employees are paid hourly vs. commission?
What is the per-project compensation breakdown for a specific employee?
Are all billing libraries configured with compensation items?

Filters

This report shares the same filters as other Cost & Comp reports (Date Range, Date Type, Branch, Project Statuses, Include Cancelled Jobs, Coordinator, Project Type, Job Tags, Salesperson, Project Tags, Job Type) plus one additional filter:

Employees — Filter to one or more specific employees to view their compensation across all assigned projects.

Report Sections

1 - KPI Summary Metrics

Metric	Description
Projects	Distinct projects with compensation data.
Employees	Distinct employees with compensation items.
Total Hours	Sum of hours from hourly and timesheet-based compensation items.
Total Compensation	Sum of all computed compensation amounts.

2 - Employee Comp Summary

Aggregated view of compensation per employee. Columns: Employee, Payroll ID, Employee Id, Position, Role, Projects, Cost Items, Total Hours, Total Compensation, Avg Comp / Project.

Payroll ID is the employee's external payroll system identifier, configured in their profile settings. Use it for matching with your payroll system exports.

3 - Payroll Items (Cost Item Details)

One row per compensation cost item per employee per project. Includes project and job context alongside the following calculation columns:

Column	Description
Rate	The compensation rate — displayed as dollars for hourly/flat/per-unit items, or as a percentage for commission items.
Rate Type	How the rate is applied: Per Hour, Percentage, Per Quantity, Flat, Flat (Manual), Per Mile, Per Pound, or Per CWT.
Hours	Hours used in the calculation. Populated for per-hour and timesheet-based items only.
Quantity	Quantity used in the calculation. Populated for per-quantity and flat items only.
Percentage Base	The dollar amount the percentage is calculated against (bill item total, bill total, or invoice grand total). Populated for percentage items only.
Miles	Project mileage. Populated for per-mile items only.
Weight (lbs)	Project weight. Populated for per-pound and per-CWT items only.
Computed Amount	Final calculated compensation: rate multiplied by the applicable multiplier.

4 - Overall Cost and Compensation Coverage

Percentage of projects in the selected range with compensation items configured. A quick health check on billing library setup.

5 - Cost Coverage Diagnostic

Identifies gaps in your cost and compensation configuration per billing library — missing compensation items, $0 rates, or rates computing $0 due to missing project data (hours, mileage, or weight). Includes a direct link to each billing library's Cost & Compensation settings.

Export Options

Employee Comp Summary — Per-employee totals for payroll reconciliation or uploading to your payroll system.
Payroll Items — Full line-item compensation data with rates, hours, and calculated amounts for audit or accounting.

Need Help? If you need assistance with Reports, contact our Product Experts team at help@supermove.com

Search