Cost per kilometre is total vehicle spending divided by kilometres driven: =SUM(costs)/(end odometer - start odometer). Two versions are useful. The variable-only figure counts fuel and service, and for the example below it is ₹7.50 per km. The all-in figure adds insurance, EMI and parking, and comes to ₹19.17 per km, because fixed costs are spread over the same 1,200 km.
What goes into each version?
- Variable costs rise with each kilometre: fuel, servicing, tyres and wear items, tolls and FASTag recharges for the trip.
- Fixed costs come due even if the vehicle stays parked: insurance, EMI, parking rent, annual fees.
- Variable-only answers: what does one more kilometre cost me?
- All-in answers: what does owning and running this vehicle cost me per kilometre actually driven?
A monthly log in the sheet
- A Month, B Odometer at start, C Odometer at end, D Kilometres =C2-B2.
- E Fuel spend, F Service and tyres (set aside a monthly share of the year's total), G Insurance share (yearly premium divided by 12), H EMI, I Parking and tolls.
- J Variable per km: =(E2+F2)/D2.
- K All-in per km: =SUM(E2:I2)/D2.
- At the foot, for a year: =SUM(E2:F13)/SUM(D2:D13) and =SUM(E2:I13)/SUM(D2:D13).
Use the ratio of yearly sums for the foot figure, not an average of the twelve monthly ratios. A month with few kilometres has a very high cost per km and would distort the average.
A worked month
Say one month shows 1,200 km on the odometer, fuel ₹7,800, service set-aside ₹1,200, insurance share ₹1,500 (a ₹18,000 yearly premium), EMI ₹11,500 and parking ₹1,000.
| Version | Costs counted | Total | Per km |
|---|---|---|---|
| Variable-only | Fuel + service | ₹9,000 | ₹7.50 |
| All-in | All five lines | ₹23,000 | ₹19.17 |
Fuel alone can be tracked with fill-to-fill readings: kilometres between two full tanks divided by litres filled gives km per litre, and price per litre divided by that gives fuel cost per km.
Is a cab or the metro cheaper for my commute?
Suppose the commute is 24 km a day, 22 days a month: 528 km. At ₹7.50 per km it costs about ₹3,960 in running costs. At the all-in ₹19.17, it is about ₹10,120. A cab at an assumed ₹360 a day would be ₹7,920 a month. So the cab costs more than just running the car, but less than the all-in cost. Which comparison is right? If you will keep the vehicle anyway, compare the variable-only figure. If giving up the commute would let you sell the vehicle, compare the all-in figure.
A habit helps more than a formula: take a photo of the odometer on the first of every month, and keep fuel and service receipts together with the transaction. Without start and end readings, kilometres become guesses, and the whole cost-per-km figure inherits the guess.
What about a two-wheeler?
The same sheet works with fewer lines. Say a month shows 600 km, fuel of ₹2,100 and a service set-aside of ₹400. Variable cost per km is (2100+400)/600, about ₹4.17. Add insurance and any EMI for the all-in figure. Because a bike is cheaper to run, the commute comparison with a cab or metro often turns on the all-in number only if you would really sell the bike.
Quick checks
- Kilometres come from the odometer, not from a guess.
- Yearly costs such as insurance are divided by 12, not entered in one month.
- A month with a long trip and tolls is not misread as the typical month.
- Both figures are labelled, so you never compare a variable-only figure with an all-in one.
Fuel, FASTag and EMI rows usually sit in your statements. If you import them into SpendixAI and give them a vehicle category, the monthly totals for the sheet can be read off a report instead of added up by hand.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


