Introduction
The Freight Report calculates and displays freight payments using data pulled directly from scale tickets. It multiplies the Freight Rate × Quantity to show Freight Pay per ticket. This report was originally built for one customer but is available for other customers as long as freight rate values are entered on tickets.
📌 FleetWatcher does not allow users to enter or store Freight Rates directly in the platform. Rates must be entered on each ticket.
Navigation
To access this report:
Go to: MMS > MMS Reports > Freight Report
Use This Report To:
Review tickets by date, customer, and vehicle
Calculate freight pay totals per vehicle or job
Export detailed CSVs with Freight Rate and Freight Pay columns
Audit truck-level material movement by quantity and unit
Report Setup
Pick Date Range
Enter both a Start Date and End Date with time
Time entry uses a 24-hour clock
Click Generate Report to run
Format Options
Output Format:
Screen
CSV
Excel-Formatted CSV
Show Full Details: Check this to display Freight Rate and Freight Pay columns
📌 If "Show Full Details" is not checked, Freight Rate and Freight Pay will be hidden from view and exports.
Report Columns (When Full Details is Enabled)
Column | Description |
Ticket Number | Scale ticket reference number |
Date / Time | When the load was recorded |
Customer | Name listed on the ticket |
Carrier | Carrier name (if available) |
Vehicle | Truck or unit ID |
Qty | Quantity delivered |
Unit | Unit type (e.g., Tons) |
Freight Rate | Pulled from scale ticket |
Freight Pay | Calculated as Qty × Freight Rate |
Notes
Freight Rate and Pay fields are ticket-based — the report will only show values if the Freight Rate was added during ticket entry
Total Freight Pay appears at the bottom of the report when Full Details is shown
Customers without Freight Rate data on tickets will see $0.00 in Freight Pay