Travel and vehicles

CNG fill-up log: tracking kilos, price and km per kg

Keep a CNG fill-up log with kilos, rate, amount and odometer, calculate km per kg and cost per km, and track the petrol tank of a dual-fuel vehicle separately.

Editorial illustration for CNG fill-up log: tracking kilos, price and km per kg

A CNG pump gives you kilograms, not litres, so mileage is measured in km per kg: kilometres driven between two fill-ups divided by the kilograms you put in. Log the date, odometer, kilograms, rate per kg and amount each time. Cost per km is then your rate per kg divided by km per kg.

What should the log contain?

ColumnWhat to write
DateThe day of the fill
OdometerReading at the pump
Kg filledFrom the pump display or slip
Rate per kgAs printed that day
AmountKg times rate, or the amount shown
NoteTank state, AC use, city or highway

A hypothetical log and the km per kg calculation

Assume you fill until the pump's automatic cut-off each time, and the rate was ₹78 per kg, a made-up figure. The starting odometer, at the first fill, was 31,000 km.

FillOdometerKm since last fillKgAmountKm per kg
231,1801808.2₹64021.95
331,3651858.4₹65522.02
431,5401757.9₹61622.15

The first fill only sets the starting point, so its kilograms are not counted. Across the three fills, distance is 540 km (31,540 minus 31,000) and gas is 24.5 kg (8.2 plus 8.4 plus 7.9). Overall, 540 divided by 24.5 is about 22.04 km per kg. Cost per km is ₹78 divided by 22.04, about ₹3.54.

In a sheet, with kg in D and the odometer in B, the overall figure is =(B5-B2)/SUM(D3:D5), where row 2 is the first fill.

How do I handle a dual-fuel vehicle?

Many CNG cars also carry a small petrol tank, and some start on petrol before switching. Keep a second log for petrol with litres, rate and amount, and read the odometer at every fill of either fuel. Then use the same odometer span for both.

Say that over those 540 km you also put in ₹400 of petrol. Total fuel spend is ₹1,911 for CNG plus ₹400, which is ₹2,311. Cost per km is ₹2,311 divided by 540, about ₹4.28. Report CNG km per kg on its own for efficiency and combined cost per km for the real bill.

Why fill to the cut-off every time?

Because the same stopping point makes the stretches comparable. A fill that stops early understates the gas used for that stretch and overstates the next. Over several fills the errors tend to cancel, but consistent habits help.

Where does a tracker fit?

CNG payments by UPI or card show as a merchant and amount on your statement. SpendixAI can import those lines and file them under a fuel category, so the rupee side of your log is complete. The kilograms and odometer you keep yourself, next to each fill.

CNG pressure and cylinder temperature can make the displayed kilograms vary slightly, and some pumps are more consistent than others. If you have a regular station, use it for your log fills so that the pump itself is a constant. Occasional fills elsewhere can be entered but marked, so a surprising stretch can be traced.

Also remember that a half-empty cylinder weighs the same as a full one for the purpose of the log: only the gas added matters, never the cylinder.

When you compare the result with the vehicle maker's claimed figure, expect a gap. Claimed numbers come from standard test conditions, and your cylinder, traffic and driving style are different. The log is the figure that counts for your budget.

A short checklist

  • Write the odometer, kg, rate and amount at every fill.
  • Calculate km per kg over several fills, not one.
  • Keep petrol fills in a separate column or sheet.
  • Check the log after three months for any stretch that looks unusual.
SPENDIXAI JOURNAL

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

Explore your reports