Free template

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.

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Columns marked “auto” are formulas.

Preview

DateVehicle no.Odometer (km)Km since lastFuel litresFuel (₹)Tolls (₹)Repairs (₹)Other (₹)Total (₹)Mileage (km/l)
2026-09-01PB65AB12341,20,400auto21018,9003,2000500autoauto
2026-09-04PB65AB12341,21,310auto22520,2503,4001,800300autoauto
2026-09-08PB65AB12341,22,180auto21519,3503,1000400autoauto

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