Vehicle Expense Sheet
Log every vehicle expense with the odometer reading, and the sheet works out km run, mileage and cost per km — the numbers you need to spot fuel leakage and loss-making vehicles.
Preview
| Date | Vehicle no. | Odometer (km) | Km since last | Fuel litres | Fuel (₹) | Tolls (₹) | Repairs (₹) | Other (₹) | Total (₹) | Mileage (km/l) |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09-01 | PB65AB1234 | 1,20,400 | auto | 210 | 18,900 | 3,200 | 0 | 500 | auto | auto |
| 2026-09-04 | PB65AB1234 | 1,21,310 | auto | 225 | 20,250 | 3,400 | 1,800 | 300 | auto | auto |
| 2026-09-08 | PB65AB1234 | 1,22,180 | auto | 215 | 19,350 | 3,100 | 0 | 400 | auto | auto |
How to use this template
- Use one sheet per vehicle, or filter by vehicle number.
- Mileage is accurate only between full-tank fills.
Template FAQ
Is the Vehicle Expense Sheet free to download?
Yes. The .xlsx file is free with no sign-up. It opens in Excel, Google Sheets and LibreOffice.
What columns does the Vehicle Expense Sheet include?
Date, Vehicle no., Odometer (km), Km since last, Fuel litres, Fuel (₹), Tolls (₹), Repairs (₹), Other (₹), Total (₹), Mileage (km/l).
Which columns are calculated automatically?
Km since last, Total (₹), Mileage (km/l) are filled by formulas, so you only enter the other columns. Formulas stay visible so you can audit or change them.
When should I move from this spreadsheet to Transport & Logistics ERP?
Use the spreadsheet while one person maintains it. Move to transport management software when several people need to update it, you need approvals and history, or the numbers must post to GST accounting and reports automatically.
Related tools and templates
Fleet Cost Calculator
Free fleet and truck running cost calculator: fuel, tyres, maintenance, tolls, driver, EMI, insurance and permits — cost per km and monthly fleet cost.
Use calculator → Free toolFuel Cost Calculator
Free fuel cost calculator for trucks and fleets in India: turn distance, mileage (km per litre) and diesel price into litres needed, fuel cost per trip, cost per km and monthly fuel spend.
Use calculator → Free toolTrip Profit Calculator
Free truck trip profit calculator: freight minus fuel, tolls, driver bata, loading and commission — profit, margin, per-km figures and break-even freight.
Use calculator → TemplateFleet Maintenance Schedule
Free fleet maintenance tracker: last service km and date, service interval, next due km/date, insurance, fitness and permit expiry for every vehicle.
Download →