Read mileage and fuel reports
You will be able to read every figure on the Fuel Tracking list, the All Vehicles Fuel Efficiency report and the dashboard chart, and know which fills they count.
All fuel figures in NShine ERP come from the entries under Vehicles › Fuel Tracking. The list itself is the first report: filter it by date range and vehicle, and the calculated columns update. The same numbers appear on the vehicle profile, the dashboard and the All Vehicles Fuel Efficiency report under Reports.
Fuel Tracking List Columns
Column | What it shows | Source |
|---|---|---|
Date / Transaction No | When the fill happened and its FT number. | Entered |
Vehicle / Ownership Type | The vehicle and whether it is Own or Market. | Vehicle record |
Filled By | The driver or employee on the entry. | Entered |
Fuel Station | The supplier the fuel came from. | Entered |
Fuel Type | Diesel, petrol, CNG and so on. | Vehicle record |
Quantity / Rate Per Unit | Units filled and the price per unit on the receipt. | Entered |
Gross Amount / Tax Amount / Total Amount | Quantity × rate, the tax on it, and the sum. | Calculated |
Odometer Reading | The reading at the time of the fill. | Entered |
Distance Driven | Odometer on this fill minus the odometer on the previous fill of the same vehicle. | Calculated |
Avg Fuel Efficiency | Distance Driven divided by Quantity, worked out between full-tank fills. | Calculated |
Expected Mileage | The target km per unit on the vehicle record. | Vehicle record |
Fuel Cost per km | Total Amount divided by Distance Driven. | Calculated |
Total Fuel Quantity / Total Spent | Running totals for the filtered period and vehicle. | Calculated |
How The Calculated Columns Behave
- Distance Driven needs an Odometer Reading on both this fill and the one before it. A fill without a reading shows blank distance and breaks the chain for the next one.
- Avg Fuel Efficiency is only trustworthy between two fills marked Is Full Tank; a partial fill in between is counted in quantity and cost but not in km per unit.
- Fuel Cost per km uses Total Amount including tax, so a tax-rate change moves it even if litres and distance do not.
- The totals follow the filter. Clear the vehicle filter to see the fleet figure; set a date range for a month-end number.
Vehicles Fuel Efficiency Block And Dashboard Chart
The KPI block at the top of Fuel Tracking and the Vehicles Fuel Efficiency chart on the Dashboard show the same four buckets: Below Expected, Meets-Exceeds Expected, Missing Expected and No Data. View Details on the dashboard opens the vehicles in each bucket. A vehicle moves bucket as soon as a new full-tank fill changes its average or as soon as you fill in its Expected Mileage.
All Vehicles Fuel Efficiency Report
- Open Reports › All Vehicles Fuel Efficiency. Choose a Select Range (Current Month, This Financial Year or custom dates) and optionally a vehicle.
- One row per vehicle with the same distance, quantity, efficiency, expected and cost-per-km figures as the list, so you can compare vehicles side by side.
- Print or export to Excel from the report toolbar.
Fuel On Other Reports
- The vehicle profile’s Fuel Tracking tab lists that vehicle’s fills and exports them to Excel.
- Vehicle Profit/Loss and All Vehicle Profit/Loss show Total Fuel Cost against revenue, supplier hire, employee payments and expenses.
- Booking reports carry a Fuel Expenses Total column, and the custom report builder offers Fuel tracking as a data source for your own layouts.
Tips
- If a vehicle sits in Missing Expected, edit the vehicle and fill in Expected Mileage; no fuel entry needs to change.
- Compare Fuel Cost per km across vehicles of the same type before reading too much into one vehicle’s figure.
Need Help?
Chat with the NShine ERP support team on WhatsApp at +91 79950 87755, or ask from inside the app. Last checked 9 November 2026 against app.nshineerp.com.