Detention pay calculator for a week of loads

Paste a week of stops with arrival and departure times, set your free time, rate and billing increment, and get detention owed by stop and broker, with invoice lines and claim notes.

Free tool · Trucking · Excel · Updated

1Add your stops

One row per stop: load, bill to, facility, arrived and departed. An ELD, TMS or check-in log saved as CSV works.

Example loads with made-up brokers and times. Replace them with yours.

Times like 6:40 AM, 14:05 or 0640. A departure earlier than the arrival counts as the next day.

2Set the terms from your rate confirmation

hours
$per hour
hours

Leave blank for no cap.

hours on site

Leave blank if layover is not in your terms.

$each

Billed in place of hourly detention for that stop.

Different terms for one customer? Change them here. Blank uses the terms above.

Bill toFree time (h)Rate per hour
Northline Logistics
Bluegate Freight
Summit Foods

3Detention owed, by customer and stop

Detention owed
$1,781.25
Billable hours
23.75
Stops to bill
6 of 9
Owed by Summit Foods
$768.75
Totals by customer
Bill toLoadsStops billedBillable hoursOwed
Summit Foods11 of 110.25$768.75
Bluegate Freight23 of 47.25$543.75
Northline Logistics22 of 46.25$468.75
Every stop
LoadBill toFacilityIn and outOn siteBillableAmountCheck
41207Northline LogisticsColumbus OH grocery DC11/2 6:40 AM to 11:52 AM5 h 12 min3.00 h$225.00–
41207Northline LogisticsIndianapolis IN store DC11/2 3:55 PM to 5:20 PM1 h 25 min0 h$0.00–
41211Bluegate FreightDayton OH cold storage11/3 8:25 AM to 1:10 PM4 h 45 min2.75 h$206.25Arrived 25 min after the appointment
41211Bluegate FreightLouisville KY receiver11/3 5:30 PM to 10:45 PM5 h 15 min2.75 h$206.25–
41215Summit FoodsCincinnati OH plant11/4 9:50 PM to 11/5 10:10 AM12 h 20 min10.25 h$768.75–
41218Northline LogisticsFort Wayne IN warehouse11/5 5:45 AM to 7:30 AM1 h 45 min0 h$0.00–
41218Northline LogisticsToledo OH distribution11/5 12:50 PM to 6:05 PM5 h 15 min3.25 h$243.75–
41222Bluegate FreightLexington KY plant11/6 8:55 AM to 12:40 PM3 h 45 min1.75 h$131.25–
41222Bluegate FreightNashville TN receiver11/6 6:58 PM to 8:30 PM1 h 32 min0 h$0.00–

4Invoice lines and claim notes

Each load gets one invoice: prefix plus load number.

days
5 invoices, 6 lines. To import, open QuickBooks Online: Settings > Import data > Invoices.
Load 41207, Columbus OH grocery DC: $225.00
Detention claim for load 41207
Facility: Columbus OH grocery DC on 11/2
Appointment 7:00 AM, arrived 6:40 AM, departed 11:52 AM.
Time on site: 5 h 12 min.
Clock started at the appointment time, 7:00 AM.
Free time: 2 h. Billable: 3.00 h at $75.00 per hour = $225.00.
Please add $225.00 to load 41207. Our in and out records for this stop are attached.
Load 41211, Dayton OH cold storage: $206.25
Detention claim for load 41211
Facility: Dayton OH cold storage on 11/3
Appointment 8:00 AM, arrived 8:25 AM, departed 1:10 PM.
Time on site: 4 h 45 min.
Free time: 2 h. Billable: 2.75 h at $75.00 per hour = $206.25.
Please add $206.25 to load 41211. Our in and out records for this stop are attached.
Load 41211, Louisville KY receiver: $206.25
Detention claim for load 41211
Facility: Louisville KY receiver on 11/3
Appointment 6:00 PM, arrived 5:30 PM, departed 10:45 PM.
Time on site: 5 h 15 min.
Clock started at the appointment time, 6:00 PM.
Free time: 2 h. Billable: 2.75 h at $75.00 per hour = $206.25.
Please add $206.25 to load 41211. Our in and out records for this stop are attached.
Load 41215, Cincinnati OH plant: $768.75
Detention claim for load 41215
Facility: Cincinnati OH plant on 11/4
Appointment 10:00 PM, arrived 9:50 PM, departed 11/5 10:10 AM.
Time on site: 12 h 20 min.
Clock started at the appointment time, 10:00 PM.
Free time: 2 h. Billable: 10.25 h at $75.00 per hour = $768.75.
Please add $768.75 to load 41215. Our in and out records for this stop are attached.
Load 41218, Toledo OH distribution: $243.75
Detention claim for load 41218
Facility: Toledo OH distribution on 11/5
Appointment 1:00 PM, arrived 12:50 PM, departed 6:05 PM.
Time on site: 5 h 15 min.
Clock started at the appointment time, 1:00 PM.
Free time: 2 h. Billable: 3.25 h at $75.00 per hour = $243.75.
Please add $243.75 to load 41218. Our in and out records for this stop are attached.
Load 41222, Lexington KY plant: $131.25
Detention claim for load 41222
Facility: Lexington KY plant on 11/6
Appointment 9:00 AM, arrived 8:55 AM, departed 12:40 PM.
Time on site: 3 h 45 min.
Clock started at the appointment time, 9:00 AM.
Free time: 2 h. Billable: 1.75 h at $75.00 per hour = $131.25.
Please add $131.25 to load 41222. Our in and out records for this stop are attached.

Want this done on your whole Excel? We fix detention and layover money that never gets claimed because nobody adds up the stop times on your real data, tested with you.

Walk us through your detention claims

How do you calculate detention pay?

Detention pay is the time on site past free time, rounded to your billing increment, times the hourly rate.

Billable hours = (departed − clock start − free time), rounded to the increment Detention pay = billable hours × rate per hour

Example: appointment 7:00 AM, arrived 6:40 AM, departed 11:52 AM, 2 hours free, 75 dollars an hour, billed in 15-minute steps rounded up. The clock starts at 7:00, so 4 h 52 min counts. Take off 2 hours free and 2 h 52 min is left, which rounds up to 3.00 hours. Detention is 3.00 × 75 = 225 dollars.

When does the detention clock start?

Your rate confirmation sets when the clock starts, so the calculator lets you choose the rule.

  • Early arrival: the clock can start at the appointment time, not when the truck pulled in.
  • Late arrival: some terms pay no detention at all; the calculator flags every late stop either way.
  • Retroactive billing: some terms bill from the start of the clock once free time runs out.
  • Cap: some terms limit billable hours per stop.

Terms often differ by broker or shipper. Step 2 lets you set free time and rate for each customer.

How do I write a truck detention invoice?

A detention invoice shows the load number, facility, arrival and departure times, free time, billable hours and rate, with your in and out records attached.

The invoice lines download has one invoice per load and one line per billed stop. In QuickBooks Online, go to Settings > Import data > Invoices and map the columns. Intuit allows up to 1,000 rows and 100 invoices per import, in accounts without sales tax set up.

The claim notes download has a short note per stop to paste into the broker’s portal or an email.

What is layover pay in trucking?

Layover pay is a flat amount for a stop that holds the truck for a long set period, often overnight, as written in your rate confirmation.

Layovers = whole periods on site ÷ layover period Layover pay = layovers × layover amount

Example: the terms pay 300 dollars for each full 24 hours on site. A truck held 26 hours earns one layover, 300 dollars, in place of hourly detention for that stop.

Does detention time count against hours of service?

Under 49 CFR 395.2, on-duty time includes attending a truck being loaded or unloaded and remaining in readiness to drive.

Under 49 CFR 395.3, a driver may not drive after 14 consecutive hours from coming on duty. Hours spent waiting at a dock come out of that window. See what that time costs per mile with the trucking cost per mile calculator.

Questions

Is my data uploaded anywhere?

No. Your stops are read and calculated in your browser. Close the tab and they are gone.

What if the truck leaves after midnight?

Type the times as they are. A departure earlier than the arrival, with no date of its own, counts as the next day.

Can each broker have its own free time and rate?

Yes. Step 2 lists every customer in your rows, and a change there applies only to that customer’s stops.

Which times should I use?

Use times you can show: the in and out times on the signed bill of lading, the gate log, or your ELD location history. Attach them to the claim.

Sources

Lines of light running into one large blue period

Walk us through one problem.

We’ll tell you what we’d fix first.

Walk us through one problem

Free. 30 minutes. A one-page note within two business days.