Unlike a standard retail business, a petrol pump’s primary commodity (fuel) is both received in bulk tankers and dispensed in variable liters. The core accounting challenge is stock reconciliation: ensuring that the physical stock (measured via tank dips) matches the theoretical stock (opening stock + purchases – sales as per dispenser meters). Discrepancies arise from temperature variations, evaporation, pilferage, or dispenser inaccuracies. Additionally, the business must track:
An Excel-based system, when properly designed, can manage all these variables without recurring software subscription fees.
This creates the final report management looks at. petrol pump accounting in excel sheet download
Table Structure:
| A | B |
| :--- | :--- |
| Income | |
| Gross Fuel Sales (Petrol/Diesel) | ='Sheet1'!Total Sales |
| Lubricant/Oil Sales | (Manual Entry) |
| Total Income (A) | =SUM(Income) |
| | |
| Direct Costs | |
| Cost of Fuel Purchased | =Total Liters Purchased * Purchase Rate |
| Electricity (Pump running cost) | ='Sheet3'!Electricity |
| Gross Profit | =A - Direct Costs |
| | |
| Indirect Expenses | |
| Staff Salaries | ='Sheet3'!Salary |
| Rent | (Manual Entry) |
| Maintenance | ='Sheet3'!Maintenance |
| Net Profit (Loss) | =Gross Profit - Indirect Expenses | Unlike a standard retail business, a petrol pump’s
A downloadable, ready-to-use Excel template for a petrol pump is not a single sheet but a structured workbook with interconnected worksheets. The key modules include:
A robust petrol pump accounting sheet must track three distinct areas: An Excel-based system, when properly designed, can manage
Before you download the template, let’s analyze if Excel is right for your station.
To manage the largest operational cost, record:
Engine oil, grease, and coolants have different tax rates. Track them on a SEPARATE sheet. Do not add liters of oil to liters of petrol.
Verdict: Use Excel for daily reconciliation and monthly profit/loss analysis. For real-time theft prevention, invest in an Automatic Tank Gauge (ATG) or POS system later.