Unbilled shipper detention on high-hour loads
3 loads (SHP100014, SHP100064, SHP100076) accumulated 63.5 hours of detention that were logged as non-billable despite the delay being customer-caused. Across the full 200-load window, 148.5 hours of detention were routed to non-billable status while detention_billed_amount stayed at $0.
- detention_billable_flag defaulting to 'N' at dispatch
- No policy tying detention flag to shipper contract terms
- Ops team accepts driver-side detention notes without customer sign-off
- Reflag the 3 high-hour loads and issue accessorial invoices this week
- Change detention_billable_flag default to 'Y' once threshold hours exceeded
- Introduce a weekly detention exception review with the customer-service lead
Pulled from transportation-operations-sample.csv. Each row is a real CSV row you can open, verify and act on.
| Source file | CSV row | shipment_id | customer_id | detention_hours | detention_billable_flag | detention_billed_amount |
|---|---|---|---|---|---|---|
| transportation-operations-sample.csv | #15 | SHP100014 | CUST1082 | 9.04 | Y | $0 |
| transportation-operations-sample.csv | #65 | SHP100064 | CUST1040 | 27.06 | Y | $0 |
| transportation-operations-sample.csv | #77 | SHP100076 | CUST1065 | 27.45 | Y | $0 |
3 loads flagged DETENTION_UNBILLED carry 63.5 hours between them, all with detention_billed_amount = $0 despite billable_flag = 'Y'.
CSV row numbers are 1-based including the header row. Sample data shown; the full row list is exported as a CSV alongside your delivered report.