Travel and vehicles

EV cost per km when you mix home and public charging

Work out one blended EV cost per km by combining home and public charging, using kWh added and rupees paid on each charge across a month.

Editorial illustration for EV cost per km when you mix home and public charging

To get one honest cost per km when you charge at home and in public, add up the money paid and the units (kWh) delivered across every charge in the month, then divide money by the kilometres driven. The blended rate per unit is total money divided by total units. Both numbers matter, and the example below uses six home and three public charges with entirely made-up figures.

What do I record for each charge?

Four things: the date, the kWh added, the rupees paid, and where you charged. Public sessions usually show kWh and the amount in the app receipt, so screenshot it. For home charging, a sub-meter on the charger circuit gives the exact kWh. Without one, estimate from the charger's rated power and hours, or from the car's display. Price home units from your electricity bill's per-unit rate, and say in your sheet that this is an estimate.

The made-up month

Assume home electricity at ₹8 per unit. Public sessions were billed at ₹18 or ₹19 per unit.

ChargeWherekWhAmount
1Home22₹176
2Home18₹144
3Home25₹200
4Home20₹160
5Home24₹192
6Home21₹168
7Public20₹360
8Public15₹285
9Public25₹450

Home total: 130 kWh and ₹1,040. Public total: 60 kWh and ₹1,095. Month total: 190 kWh and ₹2,135.

How do I get the blended cost per km?

Say the odometer read 18,400 km at the start of the month and 19,500 km at the end, so you drove 1,100 km. Then:

  • Blended price per unit: ₹2,135 divided by 190 is about ₹11.24.
  • Efficiency: 1,100 km divided by 190 kWh is about 5.79 km per kWh.
  • Cost per km: ₹2,135 divided by 1,100 is about ₹1.94.

In a sheet with money in column D and kWh in column C, the month's cost per km is =SUM(D2:D10)/(odometer end - odometer start), with the odometer cells typed in place of the words.

Why not average the home rate and the public rate?

Because you did not charge equally in both places. A simple average of ₹8 and ₹18.25 (your public rate worked out as ₹1,095 divided by 60 units) gives about ₹13.13, but 130 of your 190 units were at the cheaper home rate. The weighted figure, ₹11.24, is closer to what you really paid. Dividing total money by total units always handles that weighting for you.

The same month also gives you a useful side figure: the share of energy bought in public. Here 60 of 190 units, a little under a third, came from public chargers but they accounted for ₹1,095 of the ₹2,135 spent, roughly half the money. If you want to bring the cost per km down, that is the lever to look at first.

What can go wrong with the numbers?

  • Units from the wall and units into the battery are not the same thing. Charging has losses, so use one definition consistently across home and public.
  • A public session may add a parking or idle fee. Add it to the amount, because you paid it.
  • Missing a screenshot means a missing charge. Keep the receipt the moment the session ends.

If your public payments show up on a bank statement, SpendixAI can import that statement for the rupee side and keep the receipt with the transaction. The kWh still has to come from the app or your meter, so type those in your sheet beside each charge.

A monthly habit

Read the odometer on the first of the month, enter every charge as it happens, and compute the three figures above. After three months, compare them. If the blended price creeps up, the cause is almost always more public charging.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports