Cost / Budget / Finance · Excel template
Free Deadhead & Empty Miles Log
A log that splits empty miles from loaded miles and prices the difference — the number a cost-per-mile worksheet needs and a trip sheet never records.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- Empty and loaded miles as separate columns on the same row, which no other sheet in the library does
- An empty-percentage column per movement, per unit and per lane once you filter it
- A reason column, so repositioning, a missing backhaul and a shop run stop looking like the same problem
- An empty-cost column priced at your variable cost per mile rather than your all-in rate
- A worked example covering a repositioning move, a bobtail to the shop, and a loaded run with short deadhead
How to use it
- 1
Log a row per movement between a drop and the next pickup, not per day — the empty leg is the thing being measured.
- 2
Enter empty and loaded miles separately and let the sheet total them and compute empty percentage.
- 3
Record why the miles were empty, using a short fixed set of reasons so the column stays sortable.
- 4
Price the empty column at your variable cost per mile from the cost-per-mile worksheet, not at your rate per mile.
- 5
Flag whether the empty leg was billed, then review empty percentage by lane monthly and drop or re-price the lanes that do not carry it.
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
Deadhead & Empty Miles Log
Empty % = empty miles ÷ total miles. Price empty miles at variable cost per mile — fuel, tyres, wear — because the fixed costs are being carried whether the trailer is loaded or not. Using an all-in CPM here double-counts the fixed side and overstates what the empty leg actually cost you.
| Date | Unit / Driver | Movement (Drop → Next Pickup) | Empty Miles | Loaded Miles | Total Miles | Empty % | Reason | Empty Cost ($) | Billed to Customer |
|---|---|---|---|---|---|---|---|---|---|
| 2026-10-02 | T-204 / R. Okonkwo | Memphis, TN → Little Rock, AR | 137 | 0 | 137 | 100% | Repositioning, no backhaul | 116.45 | No |
| 2026-10-03 | T-117 / D. Whitfield | Little Rock, AR → Dallas, TX | 18 | 318 | 336 | 5.4% | Yard to shipper | 15.30 | No |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
Any mile the unit runs without a revenue load on it: from a drop to the next pickup, from the yard out to the first shipper, back in from the last receiver, and bobtail moves to and from the shop. Separating them by reason matters, because a shop run and a missing backhaul are both empty miles but only one of them is a lane problem.
A mileage log and a trip sheet record distance per trip; neither splits that distance by whether it was earning. Once empty has its own column, a lane that reads as $2.40 per loaded mile can turn out to be well under $2.00 across every mile the truck actually had to run — and the second figure is the one your cost per mile is computed against.
It depends entirely on lane mix, equipment type and whether you have a backhaul network, so a published benchmark is only a sanity check on the arithmetic. What this log is for is your own trend by unit and by lane over time, because that is the number you can actually change.
Whatever the lease says. For equipment leased to an authorised carrier, 49 CFR 376.12(e) requires the written lease to clearly specify which party is responsible for the cost of empty mileage, alongside fuel, fuel taxes, permits, tolls, ferries, detention and accessorial services, and base plates. Check the lease rather than assuming — and log the miles either way, because the allocation gets applied to a mileage figure someone has to produce.
Sources
Every figure, section number and deadline on this page was read at a primary source on the date shown. Regulations are amended — check the source before you rely on it.
- 49 CFR 376.12 — Lease requirements (eCFR, current) — read 2026-10-08
Related guides & tools
- Cost-per-mile worksheet
- Truck cost per mile calculator
- Trip sheet / driver trip log
- Owner-operator escrow refund tracker
Looking for more? Browse all fleet templates or run a fleet calculator.