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?
| Column | What to write |
|---|---|
| Date | The day of the fill |
| Odometer | Reading at the pump |
| Kg filled | From the pump display or slip |
| Rate per kg | As printed that day |
| Amount | Kg times rate, or the amount shown |
| Note | Tank 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.
| Fill | Odometer | Km since last fill | Kg | Amount | Km per kg |
|---|---|---|---|---|---|
| 2 | 31,180 | 180 | 8.2 | ₹640 | 21.95 |
| 3 | 31,365 | 185 | 8.4 | ₹655 | 22.02 |
| 4 | 31,540 | 175 | 7.9 | ₹616 | 22.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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


