The Labor Rate Summary report totals work order labor by Labor Rate. For each rate, it shows how many work orders used it, total hours, total labor cost, and total billable amount. It's built for billing and reconciliation — for example, checking labor totals by rate for a Site before invoicing.
Labor Rate Summary is a Report Row Type for Custom Reports, alongside the existing Standard and Billables Breakout types, which haven't changed. (Note: the field once called "Breakout Type" is now called Report Row Type.)
- Accessing Custom Reports
- Create a Labor Rate Summary Report
- What Each Row Shows
- How the Totals Are Calculated
- Customize the Output (Custom Report Mapping)
- Download or Schedule the Report
Accessing Custom Reports
- You'll need Building Admin or Building Manager permission to create Custom Reports and to download reports.
Create a Labor Rate Summary Report
Step 1: In Dash, go to Work Orders > Reports > Custom Reports and create a new report
Step 2: Under Report Row Type, select Summary.
Labor Rate is the only summary type for now, so it's applied automatically — there's nothing to select.
Step 3: Choose how to group your results. The available options depend on where you're creating the report:
| Report Level | How Results Are Summarized | Grouping Options |
|---|---|---|
| Network | Labor Rate totals, grouped by Site | Site, or Site + Building |
| Site | Labor Rate totals for that Site | Building (optional). Group by Site isn't shown since the report already covers a single Site. |
Step 4: Set your filters and date range, then save the report.
What Each Row Shows
| Description | |
|---|---|
| Labor Rate | The labor rate the hours were logged against |
| Work Order Count | The number of unique work orders that used this rate |
| Total Labor Hours | The sum of all labor hours logged at this rate |
| Total Labor Cost | The sum of labor cost at this rate |
| Billable Total | The sum of billable amounts at this rate |
Network-level reports also show Site subtotals and a Grand Total. These add up the unique work order count, labor hours, labor cost, and billable total.
How the Totals Are Calculated
- Totals come from the individual labor entries behind each Labor Rate row.
- Work orders are counted once per rate. If a work order has several labor entries at the same rate, it counts as one work order, but all of its hours and costs are still included.
- One work order can appear in more than one row. If labor on a work order was logged at two different rates, it counts toward both rows.
Example: Work order W-100 has 2 hrs at Standard and 1 hr at Overtime. Work order W-101 has 3 hrs at Standard.
- Standard row: Work Order Count = 2, Hours = 5
- Overtime row: Work Order Count = 1, Hours = 1
Customize the Output (Custom Report Mapping)
Summary reports work with Custom Report Mapping, but only for fields that have one clear value (or one total) per summary row.
- Supported Cove Data Fields: Site, Labor Rate, Work Order Count, Work Order IDs, Labor Hours, Labor Cost, Billable Total. [Building ID, GL Account, and Cost Code still to be confirmed.]
- Supported field types: Cove Data Field, Static, Blank, and Sequence. You can reorder columns, rename headers, and add static, blank, or sequence columns.
- Fields that don't have one clear value per summary row aren't available for Summary mapping.
Include Work Order IDs
This option only appears for Summary reports. To use it, your report must include a Labor Rate column.
When it's turned on, the export lists the unique work order IDs for each Labor Rate row, separated by commas. Each ID appears only once per row.
The on-screen table still shows Work Order Count, not the list of IDs.
Download or Schedule the Report
Download: The exported file uses the same structure as the Table view, including Labor Rate rows, Site groupings, and Site subtotals. If custom mapping is turned on, the export uses your mapped columns.
Batch reporting: Select the Labor Rate Summary report in a batch to get the CSV by email. If you haven't set up custom columns, the CSV uses the same columns as the table.