To find what your vehicle really costs to run, log every fuel fill-up with the odometer reading, log every service or repair separately, and divide total spend by the kilometres covered. The sheet below gives you mileage in km per litre and cost per km from two data tabs and four formulas.
What goes on the Fuel tab?
Name the first tab Fuel and use these columns, with headers in row 1:
- A: Date
- B: Odometer in km, read at the pump
- C: Litres filled
- D: Amount paid in rupees
- E: Full tank - Yes if you filled to the brim, No if you topped up
The first row should be a full-tank fill and so should the last row you want to measure. Mileage only works when the tank starts and ends at the same level, which is why a full tank is the reference point. Partial top-ups in between are fine; just mark them No and still enter their litres.
What goes on the Service tab?
Create a second tab named Service with Date, Odometer, Item (oil change, chain lubrication, tyre, brake pads, puncture), Garage and Amount. Annual insurance and pollution check can go here too, but note them separately, because they cost the same whether you ride 500 km or 5,000 km.
How do I calculate mileage and cost per km?
On a tab named Summary, use these formulas. They assume the Fuel data sits in rows 2 to 500 and the Service amounts in column E of that tab, rows 2 to 500. Here B2 holds kilometres, B3 mileage and B4 fuel spend.
- B2, kilometres covered: =MAX(Fuel!$B$2:$B$500)-MIN(Fuel!$B$2:$B$500)
- B3, mileage in km per litre: =B2/SUM(Fuel!$C$3:$C$500)
- B4, fuel spend: =SUM(Fuel!$D$3:$D$500)
- B5, cost per km, fuel and service: =(B4+SUM(Service!$E$2:$E$500))/B2
The litres and spend start from row 3, not row 2, because the first fill only sets the starting level. The fuel you bought afterwards is what was burned between the first and last odometer readings.
A two-wheeler example over three months
Say the first full tank is at 12,000 km. Over the next three months you fill up five times, all full tanks, at a pretend price of ₹100 a litre.
| Odometer (km) | Litres | Amount |
|---|---|---|
| 12,000 (start) | - | - |
| 12,250 | 5.0 | ₹500 |
| 12,520 | 5.4 | ₹540 |
| 12,760 | 4.8 | ₹480 |
| 13,010 | 5.0 | ₹500 |
| 13,260 | 5.0 | ₹500 |
Kilometres covered are 13,260 - 12,000 = 1,260. Litres after the first fill: 5.0 + 5.4 + 4.8 + 5.0 + 5.0 = 25.2, so mileage is 1,260 / 25.2 = 50 km per litre. Fuel spend is ₹2,520, which is ₹2.00 per km.
Now add two service entries, an oil change of ₹450 and chain lubrication of ₹150, so ₹600. Total cost is ₹3,120, and 3,120 / 1,260 is about ₹2.48 per km. The service bills lifted the real cost by nearly fifty paise a km, which fuel alone would never show.
Can I use this for a car or a different fuel?
Yes. Replace litres with kg for CNG, or keep litres for petrol and diesel. For a car on FASTag, add a third tab for toll and parking so you can see them as a per-km cost too. Keep it honest: if you cannot read a number off a bill or the odometer, do not guess it.
Checklist for the first month
- Fill to full, then note the odometer and the date. That is your start row.
- Enter every later fill-up the same day while the receipt is in your hand.
- Record each repair with its odometer reading.
- After three fills, read the mileage figure and compare it with what the maker claims; treat a big gap as a reason to check tyre pressure, not as an alarm.
- Add up your fuel spend and compare it with what your bank statement shows for the same period.
If fuel is bought mostly by UPI or card, SpendixAI can import your statements and group those payments under a fuel category, which is a useful cross-check for the amounts in your log.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


