Settlement Details
This report will show a list of trips with payment details for the date range selected.
Field | Description |
From/To date | Enter a date range for data to display on the report. This date range is is using the Settlement Created on Dates. |
Carrier | If a carrier is selected, only data for that carrier will display. |
Vendor | If a vendor is selected, only data for that vendor will display. |
Driver | If a driver is selected, only data for that driver will display. |
Truck | If a truck is selected, only data for that truck will display. |
Custom groups | If a group is selected, only data for that group will display. |
Settlement batch | If a settlement batch is selected, only data for that batch will display. |
Brokerage/Truck side | Select which type of loads should display. |
Data type | Select a data option for which type the date range should query to select settlements. |
Group by | Select how the data should be grouped on this report. |
Order by | Select how data should be ordered on this report. |
View | Select Default View or View 2. |
Default View
View 2
View 2 will provide results with a breakdown of empty miles, loaded miles, and total miles while the Default view only provides one column for total miles.
Field | Description |
Trip | This field will display the trip number. |
From | This field will display the pickup city and state. |
To | This field will display the delivery city and state. |
Date delivered | This field will display the date the load was delivered. |
Date settled | This field will display the date the trip was settled on. |
Driver/Carrier | This field will display the driver or carrier from the load. |
Pay plan | This field will display the pay plan from the load. |
Pay to company | This field will display the pay to company if assigned to a carrier. |
Truck | This field will display the truck assigned to the trip. |
Trailer | This field will display the trailer assigned to the trip. |
Empty miles | *View 2 will provide empty/loaded/total miles. |
Loaded miles | *View 2 will provide empty/loaded/total miles. |
Miles | This field will display the miles for the load. |
Shipment revenue | This field will display the shipment's revenue. |
Pay | This field will display the driver's pay for the trip. |
Advances | This field will display the advances applied to the trip. |
Reimbursements/Expenses | This field will display any reimbursements/expenses added to the trip. |
Total paid to driver | This field will display the total pay for the driver including advances and expenses. |