Margin Summary
This report will show the shipment count, miles, revenue and revenue per mile, pay, advances, and reimbursements, along with margins per driver or truck.
This reports is based off of shipments and then pulls in Trip data.
This means shipments with no trips will show on this report, where trips with no shipments (Non Revenue) loads will not be on the report.
Recommendation
Use fewer filters to provide more data.
Data Displayed
For this report, Team driver pay will show both driver's pay.
Margin Results data may differ from other margin reports due to the type of data this report includes. For example, this report will include advance data in the margin if specified whereas the Margin Details report will not.
Field | Description |
Margin by | Select if the report should show the margin summary by truck or driver. |
From/To pick up date | Select a pickup date range. |
From/To delivery date | Select a delivery date range. |
From/To booked by date | Select a booked by date range. |
Advance date from/to | Select an advance date range. |
Driver | Select a specific driver to run this report for. |
Driver groups | Select a driver group to run this report for. |
Truck | Select a specific truck to run this report for. |
Truck groups | Select a truck group to run this report for. |
Dispatched by | Select a dispatched by user to run this report for. |
Booked by | Select a specific booked by user to run this report for. |
Company | Select which of your companies to run this report for. |
Driver type | Select which type of drivers should show on this report. (company drivers, leased drivers, carriers, or all) |
Driver Status | Select a status of driver to see results for. |
Order by | Select how the report should be ordered. |
Group by | Select how you would like the results to be grouped. |
Field | Description |
Driver | This field will show the driver or truck id. |
Trip count | This field will show the trip count for the driver or truck. |
Empty miles | This field will show the number of empty miles. |
Loaded miles | This field will show the number of loaded miles. |
Total miles | This field will show the total miles. |
Revenue | This field will show the revenue for the loads. |
Revenue per mile | This field will show the revenue per mile. |
Pay | This field will show the pay from the trips. These trips must be paid to be included in this field. |
Advances given | This field will show the amount of advances given on the loads. |
Advances applied | This field will show the amount of advances applied to the loads. |
Reimbursements | This field will show the amount of reimbursements on the loads. |
Margin | This field will show the margin for the loads. (=Revenue-Pay) |
Margin % | This field will show the margin percent for the loads. (=Margin/Revenue) |