Crew Hours (Hourly Pay) Report
The Crew Hours (Hourly Pay) Report tracks work hours and earnings for movers, providing a breakdown by week, individual, and job. It’s designed to support payroll processing and labor cost analysis. This report helps you understand total hours worked (regular and overtime), pay distribution, and tip earnings, ensuring accurate and timely compensation.
Use This Report to Answer Questions Like:
How many hours did each mover work last week?
Who is owed overtime, and how much?
What were total labor costs for a specific week or client job?
Are there movers consistently exceeding weekly or daily overtime thresholds?
Report Inputs (Filters at the Top)
Customize the report view using the inputs at the top:
| Input | Description |
|---|---|
| Workweek | Sets the date range for the report (e.g., Year to Date, custom range like 1/01/2025–7/31/2025). |
| Overtime Starts At (Per Week) | Defines the weekly hour threshold after which overtime pay is applied (e.g., 40 hours). |
| Overtime Starts At (Per Day) | Sets the daily hour threshold for overtime calculations (e.g., 8 hours). |
| Week Starts On | Choose the first day of the workweek (e.g., Monday). |
| Movers | Filter to view hours and pay for a specific mover or team member. |
How Filters Affect the Data
Changing the date range impacts all summary and detailed views.
Adjusting overtime rules recalculates totals according to the selected weekly or daily thresholds.
Filtering by specific movers lets you isolate data for individual performance or pay review.
Report Sections
1 - Weekly Summary
This section aggregates total work and pay across all movers per week.
| Column | Description |
|---|---|
| Week | Weekly time span (e.g., 03/17/2025 – 03/23/2025). |
| Hours (Regular / Overtime / Total) | Total hours worked during the week across all employees. |
| Pay (Regular / Overtime / Tip / Total) | Breakdown of hourly earnings, including any tips received by category over the week. |
2 - Mover Summary
Displays total hours and earnings by mover across the entire date range selected.
| Column | Description |
|---|---|
| Mover | Name of the mover. |
| Hours (Regular / Overtime / Total) | Total hours logged by that mover. |
| Pay (Regular / Overtime / Tip / Total) | Detailed earnings breakdown. |
3 - Hours Worked (Detailed View)
This granular table shows individual job entries and hour logs for each mover per week.
| Column | Description |
|---|---|
| Week | The week the time was logged. |
| Mover | The employee's name. |
| Payroll Identifier | The Identifier of the payroll entry. |
| Position | The employee's role (e.g., Driver, Packer). |
| Job Date | Date of the associated job. |
| Job | The Job ID associated with the job. Can be clicked to link to the job in the Supermove Office app. |
| Client | The client name as a link to the client's profile in the Supermove office app. |
| Hours (Regular / Overtime / Total) | Detailed time breakdown per job. |
| Hourly Rate | Pay rate applied for regular hours. |
| Pay (Regular / Overtime / Overtime Ineligible / Tip / Total) | The amount paid to the employee based on the time worked. |
| Project Type | Overall type of move project (e.g., Local Move). |
| Total Revenue | Total Revenue of the project |
| Total Valuation Coverage | Total coverage included on the project. |
| Total Payment Fees | Total payment with all fees and tips included. |
| Total Tips | Tips included on the project. |
| Total Supplies | Total cost of supplies. |
Export Options
Weekly Summary Download – Export summary totals for all movers, by week.
Mover Summary Download – Export total hours/pay per mover.
Hours Worked Download – Export the detailed breakdown for audit or payroll.
Comments
0 comments
Please sign in to leave a comment.