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. Use it alongside our fleet calculators to size the costs this template tracks, or browse fleet management software when you are ready to automate the workflow. See all downloads in the template library, and check the fleet glossary for any unfamiliar terms.
Built and reviewed by the FleetOpsClub research team. Preview it free below.
- 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 CSV. Yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
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.
What's inside
- 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
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 |
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.