Fleet & Transport
Trip Sheet Format for Transport Businesses (Free Template)
By ZUGEE teamPublished
If you run trucks, tankers, cabs or buses, the trip sheet is the most important paper in your business. It decides what you bill, what you pay the driver, and whether a trip made money or lost it.
Yet in many transport offices, trip sheets are half-filled, collected days late, or lost in the driver's cabin. This guide gives you a clear trip sheet format you can start using today, and explains what each field is for.
What is a trip sheet?
A trip sheet is a record of one trip by one vehicle. It notes where the vehicle went, who drove it, how far it travelled, what was carried, and what was spent on the way. The office uses it to:
- Bill the customer correctly
- Settle the driver's advance and expenses
- Track fuel use and vehicle running
- Work out the profit on each trip
Trip sheet format: fields to include
1. Trip details
- Trip sheet number (running, never repeated)
- Date
- Booking or order reference
- Customer name
2. Vehicle and driver
- Registration number
- Vehicle type
- Driver name and mobile
- Helper or cleaner name, if any
3. Route
- From
- To
- Stops in between
- Departure date and time
- Arrival date and time
4. Distance
- Opening odometer
- Closing odometer
- Total km
5. Load details
- Goods carried (or passengers)
- Weight or quantity
- LR / consignment note number
- E-way bill number, if one was generated
6. Expenses during the trip
- Diesel (litres and ₹)
- Toll / FASTag
- Loading and unloading
- Driver bata
- Other expenses
- Total
7. Money
- Advance given
- Expenses paid by the driver
- Balance to return or pay
- Freight amount agreed with the customer
8. Sign-off
- Driver signature
- Office signature
- Proof of delivery received (yes/no)
Ready-to-use trip sheet template
Copy this into Excel or Google Sheets, or print it:
| Field | Entry |
|---|---|
| Trip sheet no. | (blank) |
| Date | (blank) |
| Customer | (blank) |
| Vehicle no. | (blank) |
| Driver name & mobile | (blank) |
| From → To | (blank) |
| Departure (date/time) | (blank) |
| Arrival (date/time) | (blank) |
| Opening km | (blank) |
| Closing km | (blank) |
| Total km | (blank) |
| Goods / passengers | (blank) |
| Weight / quantity | (blank) |
| LR no. | (blank) |
| E-way bill no. | (blank) |
| Diesel (litres / ₹) | (blank) |
| Toll (₹) | (blank) |
| Loading / unloading (₹) | (blank) |
| Driver bata (₹) | (blank) |
| Other expenses (₹) | (blank) |
| Total expenses (₹) | (blank) |
| Advance given (₹) | (blank) |
| Balance (₹) | (blank) |
| Freight amount (₹) | (blank) |
| POD received? (Yes / No) | (blank) |
| Driver signature | (blank) |
| Office signature | (blank) |
5 common trip sheet mistakes
1. Not recording the odometer reading at the start. Without the opening reading, you can't check the kilometres or the diesel claimed. Make the driver note it before leaving the yard.
2. Collecting trip sheets at the end of the week. By then, receipts are lost and details are forgotten. Collect them as soon as the trip ends.
3. No running number. If trip sheets aren't numbered, a missing sheet means a trip that never gets billed. Number every sheet, and check for gaps.
4. Expenses without bills. Ask for a photo of every fuel slip and toll receipt. It protects both the owner and an honest driver.
5. Billing from memory. Raise the customer's bill from the trip sheet, not from a diary or a phone call. The trip sheet is your proof.
When paper trip sheets stop working
Paper works fine with one or two vehicles. As the fleet grows, problems pile up: sheets get lost, totals are added up wrongly, and no one can say how many trips a vehicle ran this month without counting pages.
That's when transport owners move to digital trip sheets. Each trip is saved against its vehicle, driver and booking. Expenses are added as they happen, and the bill is raised straight from the trip record, so no trip is missed.