Driver Logs & HOS · Excel template
Free Trip Sheet / Driver Trip Log
A driver trip sheet that captures each trip's route, miles, fuel, and stops — the owner-operator's daily record for settlements, IFTA, and cost tracking.
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
- Trip header: driver, vehicle, date, and route
- Per-leg columns for start/end location, odometer, miles, and state
- Fuel, tolls, and expense capture per trip
- A layout that feeds IFTA and owner-operator settlements
- Editable spreadsheet for daily use
How to use it
- 1
Start a new trip sheet at the beginning of each trip or shift.
- 2
Log each leg: origin, destination, start/end odometer, and the state crossed.
- 3
Record fuel purchases, tolls, and any trip expenses as they occur.
- 4
Total the miles and expenses at the end of the trip.
- 5
Use the per-state miles for IFTA and the totals for settlement or cost-per-mile analysis.
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
Trip Sheet / Driver Trip Log
| Date | From | To | Start Odo | End Odo | Miles | State(s) | Fuel (USD) | Tolls (USD) |
|---|---|---|---|---|---|---|---|---|
| 2026-05-10 | Newark, NJ | Allentown, PA | 118,000 | 118,090 | 90 | NJ/PA | 0 | 12.50 |
| 2026-05-10 | Allentown, PA | Columbus, OH | 118,090 | 118,520 | 430 | PA/OH | 328.35 | 28.00 |
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.
A trip sheet is the source record for settlements (what you earned vs. what the trip cost), IFTA (per-state miles and fuel), and cost-per-mile. Without it, those numbers are guesses.
An HOS log tracks duty status and hours for compliance. A trip sheet tracks the commercial details of the trip — miles, fuel, stops, and expenses. You typically keep both.
Yes — logging miles by state and fuel by jurisdiction gives you exactly what the quarterly IFTA worksheet needs. Keep fuel receipts to back up the entries.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.