Expense categories

How to track CNG month by month

How to track CNG month by month: log kilograms and amount, work out cost per kilometre, handle dual-fuel top-ups, and run a simple monthly review.

Editorial illustration for How to track CNG month by month

To track CNG, log the date, kilograms and amount for each fill, plus the odometer reading, then divide the month's spend by the kilometres driven. The result, cost per kilometre, is the number that tells you whether your fuel habits are changing. A dual-fuel car needs the same details for its petrol top-ups so the two fuels stay comparable.

What goes in each entry?

  • Date and station
  • Kilograms filled and amount paid
  • Odometer reading at the fill
  • Payment mode: cash, UPI or card
  • A note if it is a petrol top-up or a trip

A rate per kilogram is easy to work out from the slip. Hypothetical example: ₹850 for 9 kg is about ₹94.40 per kilogram. Do not compare that with anyone else's figure, as rates differ by city and change over time. Use only your own slips.

How do you work out cost per kilometre?

If those 9 kg took you 190 km, the car did about 21.1 km per kilogram, which is 190 divided by 9. The cost per kilometre is ₹850 divided by 190, about ₹4.47. Do this for each pair of consecutive fills, then average over the month.

What does a sample month look like?

ItemAmountDistance covered
CNG fill 1₹850190 km
CNG fill 2₹900205 km
CNG fill 3₹800180 km
Petrol top-up₹60025 km
Month total₹3,150600 km

Month cost per kilometre is ₹3,150 divided by 600, which is ₹5.25. If you leave out the petrol top-up, the CNG-only cost per kilometre is ₹2,550 divided by 575, about ₹4.43. The gap shows what the backup fuel adds.

How often should you look at the numbers?

CNG fills are frequent, so a quick glance every week is more useful than a long review once a month. At the weekly glance, check that each fill has its odometer reading and that none is missing. At the monthly review, calculate the cost per kilometre and compare it with the previous two months.

What signals a real change?

  • Kilograms per hundred kilometres rising: check tyre pressure, load, traffic and servicing
  • More petrol top-ups than usual: check whether the queue pattern or station access has changed
  • Cost per kilometre rising with the same routes: the rate per kilogram may have changed, which your slips will show
  • Sudden gaps in the log: a fill went unrecorded, so estimate it and add a note

What if you drive a CNG auto or taxi for a living?

Then the same log doubles as a business record. Track fills per vehicle, and add a daily or weekly figure for kilometres or trips if you keep one. Compare fuel against what the vehicle earned for the same period, using your own takings. That tells you how much of every hundred rupees earned went into the tank, which is a more useful figure than the total. Keep the station slips for the month in one place until you have entered them.

How does a long queue affect your numbers?

A day when you skipped the CNG queue and used petrol will make that month's cost per kilometre look worse, even though nothing else changed. Do not treat it as a mistake. Add a note such as queue too long, petrol top-up, so that when you read the month later you know why the figure rose. Over several months you may find a pattern that tells you whether a different station or a different time of day is worth the effort.

Where a tracker helps

If you pay by card or UPI, SpendixAI can import the statement, flag possible duplicate imports and sort fills into your fuel sub-category using your own rules. Kilograms and odometer readings are not on the statement, so keep them in your notes.

A short monthly checklist

  1. Add up CNG and petrol separately.
  2. Divide each by the kilometres it covered.
  3. Compare with the last two months.
  4. Note any one-off trips or kit servicing.
  5. Decide whether a different refilling routine would suit you better next month.
SPENDIXAI JOURNAL

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

Explore your reports