Move Jobs Revenue by Truck Report

The Move Jobs Revenue by Truck Report provides insights into how revenue is distributed across different trucks used in completed moving jobs. It enables operational teams to monitor truck usage and identify trends in performance and job allocation. This report includes a bar chart that visualizes revenue by truck and a detailed job-level table for deeper analysis.

Use This Report to Answer Questions Like:

Which trucks are generating the most revenue?
Are there completed jobs that weren’t assigned trucks?
What is the revenue distribution across trucks over time?
Are there underutilized trucks or patterns in job assignments?

Report Inputs (Filters at the Top)

The filters at the top of the report allow you to customize and refine the data displayed:

Input	Description
Job Start Date	Defines the date range of jobs to include in the report (e.g., Last 3 months or a specific custom date range).
Branch	Filters jobs by company branch. Leave blank to include all branches.
Project Status	Filters by the current status of the job (e.g., Completed, Booked).
Project Tags	Filters jobs by custom project tags.
Project Types	Limits results to selected project types such as Local Move, Long Distance, or Storage.
Job Types	Filters by specific operational job types (e.g., Move, Pack, Load).
Job Tags	Filters by user-defined job tags.
Salesperson	Filters results by the salesperson associated with the job.
Coordinator	Filters by the coordinator responsible for the job.
Referral Sources	Filters jobs by the lead source, such as Google or a partner site.

How Filters Affect the Data

Job Start Date filters control which jobs are included in both the chart and the table.
Truck Assignment affects how revenue is grouped—jobs without trucks appear in a separate category.
Project Status, Job Type, Branch, and other filters further refine the results shown in both visual and tabular sections.
All sections of the report (chart and job table) remain dynamically synced with the selected filters.

Report Sections

1 - Revenue by Truck Chart

This bar chart displays total revenue generated by each truck across the selected time range.

Additional Filters For Revenue by Truck Chart:

Date Range Grouping – Toggle between Daily, Weekly, Monthly, or Yearly groupings.

Feature	Description
Total Revenue by Date Range Grouping	Each bar shows total revenue captured by all trucks on aggregated across the date range you've selected.
Bar Height	Shows total revenue in dollars.

2 - Jobs Table (Detailed View)

The table provides a detailed breakdown of every job that contributes to the chart above. Each row represents a completed job that meets the filter criteria.

Column	Description
Job	Unique job ID (clickable for more detail).
Truck Name	Name of the assigned truck. If none, shows “No Truck Assigned.”
Trucks	The list of trucks linked to the job, if multiple.
Client	Name of the customer.
Job Type	Type of operational job performed (e.g., Move).
Start Date / End Date	When the job took place.
Per Truck Revenue	Revenue allocated per truck.
Total Revenue	Total revenue generated from the job.
# of Movers	Number of movers assigned to the job.
# of Trucks	Number of trucks assigned.
Project Type	Project classification (e.g., Local Move).
Project Status	Final status of the job (e.g., Completed).
Salesperson	The salesperson assigned to this client.
Coordinator	The coordinator managing the client.
Referral Source	How the client heard about the company (e.g., LeadsPedia Lead, Website).
Referral Details	A deeper dive into the details of the referral.
Project Tags	A running list of project tags that are associated with the project in Supermove.
Job Tags	A running list of job tags that are associated with the job in Supermove.

Export Options

Chart Export: Download a visualization of revenue by truck.
Job Table Export: Export the complete list of jobs with all associated data as a CSV.

Search