📍 When to use this template
- Daily fuel issue + consumption tracking.
- Monthly fuel reconciliation.
- Cost analysis + efficiency reporting.
- Pilferage investigation.
Sections & fields
Preview of the template structure. Download Excel to fill on site.
1Fuel Storage5 fields
Tank Capacity (Liters)
_____________
Fuel Type (HSD / Petrol / LPG)
_____________
Storage Location
_____________
Petroleum Act Compliance
_____________
2Daily Issue6 fields
Equipment ID (issuing to)
_____________
Quantity Issued (Liters)
_____________
Issuer + Authorisation
_____________
Reading Before + After
_____________
3Equipment Consumption6 fields
Equipment ID
_____________
Operating Hours / Distance
_____________
Fuel Consumed (Liters)
_____________
Fuel Efficiency (L/hr or L/km)
_____________
Manufacturer's Specification
_____________
Variance (% above / below normal)
_____________
4Reconciliation5 fields
Opening Stock
_____________
Total Issues (Period)
_____________
Closing Stock
_____________
Theoretical Consumption (per Equipment Operation)
_____________
Variance (Possible Pilferage / Inefficiency)
_____________
5Cost4 fields
Fuel Cost (₹ / Liter)
_____________
Total Fuel Cost (Period)
_____________
Cost per Activity / Cost Center
_____________
Cumulative Fuel Cost (Project to Date)
_____________
💡 Sample filled excerpt
Date: 12-May-2026. HSD issued to Crane TC-002: 35 L (full tank). Operated 8 hrs. Consumption: 4.4 L/hr (manufacturer spec: 4.0 L/hr, +10 % variance — within tolerance). Tank stock: 800 L opening, 35 L issued, 765 L closing. Cost: ₹95/L × 35 = ₹3,325.
⚖ Compliance notes
- Fuel storage > 5,000 L requires Petroleum Storage License + safety provisions per Petroleum Rules.
- Standardise fuel issue procedure: log book, authorisation, ID matching.
- Pilferage detection: variance > 10 % typically; investigate root cause.
- Fuel efficiency tracking → identify under-performing equipment for repair / replacement.
- Bunded storage area for fuel; firefighting equipment within 30 m.
- Major fuel deliveries logged with delivery slips + tank measurements before / after.