Q1: Is this template compatible with Google Sheets? Yes. Upload the downloaded .XLSX file to Google Drive and open with Google Sheets. Most formulas (SUMIF, VLOOKUP, IF) work perfectly.
Q2: Can I track multiple fuel types (Petrol, Diesel, Kerosene)? Absolutely. The template has 3 product slots by default. You can add more by inserting columns between the existing ones.
Q3: Does this sheet calculate the dealer’s commission from the Oil Marketing Company (OMC)? Yes, the "Profit" tab includes a section for OMC commission (usually a fixed rupee/liter or percentage). Enter your commission rate once, and it auto-calculates daily.
Q4: I have 8 nozzles. Will this work? Yes, simply copy-paste the "Nozzle" columns vertically. The summation formulas will automatically include new rows if you drag them down. (Watch our video tutorial). petrol pump accounting in excel sheet download
Q5: How do I handle credit sales to corporate clients? Use the "Credit Register" sheet. Enter the fleet driver's name and vehicle number. The main dashboard shows "Total Outstanding Credit" so you never exceed your limit.
Use SUMIFS for conditional totals (e.g., SUMIFS(SalesAmount, DateRange, =Date, ProductRange, "Diesel")). Use XLOOKUP or INDEX/MATCH to fetch product rates or pump mapping.
The template consists of 4 interconnected sheets: Q1: Is this template compatible with Google Sheets
To manage the largest operational cost, record:
Before you download the template, let’s analyze if Excel is right for your station.
Managing a petrol pump (gas station) is one of the most cash-intensive and inventory-sensitive small businesses in the world. With razor-thin margins on fuel, high-volume daily transactions, and complex reconciliation requirements between the nozzle, the tank, the cashier, and the bank, accounting errors can literally drain your profits. Use SUMIFS for conditional totals (e
While expensive Enterprise Resource Planning (ERP) software exists, many station owners in India, Pakistan, Bangladesh, and Africa start with a simpler, more cost-effective tool: Microsoft Excel.
In this article, we provide a comprehensive guide to petrol pump accounting and offer a free, ready-to-use Petrol Pump Accounting Excel Sheet download.
= (Calculated_Closing_Stock - Actual_Dip_Reading) / Opening_Stock * 100
Tracks operational costs like electricity, staff salaries, and oil purchases.
| A | B | C | D |
| :--- | :--- | :--- | :--- |
| Date | Expense Head | Description | Amount |
| 01-01-24 | Electricity | Monthly Bill | 5,000 |
| 01-01-24 | Salary | Staff Wages | 20,000 |
| 01-01-24 | Maintenance | Machine Repair | 2,000 |
| | | TOTAL EXPENSE | =SUM(D2:D4) |
Q1: Is this template compatible with Google Sheets? Yes. Upload the downloaded .XLSX file to Google Drive and open with Google Sheets. Most formulas (SUMIF, VLOOKUP, IF) work perfectly.
Q2: Can I track multiple fuel types (Petrol, Diesel, Kerosene)? Absolutely. The template has 3 product slots by default. You can add more by inserting columns between the existing ones.
Q3: Does this sheet calculate the dealer’s commission from the Oil Marketing Company (OMC)? Yes, the "Profit" tab includes a section for OMC commission (usually a fixed rupee/liter or percentage). Enter your commission rate once, and it auto-calculates daily.
Q4: I have 8 nozzles. Will this work? Yes, simply copy-paste the "Nozzle" columns vertically. The summation formulas will automatically include new rows if you drag them down. (Watch our video tutorial).
Q5: How do I handle credit sales to corporate clients? Use the "Credit Register" sheet. Enter the fleet driver's name and vehicle number. The main dashboard shows "Total Outstanding Credit" so you never exceed your limit.
Use SUMIFS for conditional totals (e.g., SUMIFS(SalesAmount, DateRange, =Date, ProductRange, "Diesel")). Use XLOOKUP or INDEX/MATCH to fetch product rates or pump mapping.
The template consists of 4 interconnected sheets:
To manage the largest operational cost, record:
Before you download the template, let’s analyze if Excel is right for your station.
Managing a petrol pump (gas station) is one of the most cash-intensive and inventory-sensitive small businesses in the world. With razor-thin margins on fuel, high-volume daily transactions, and complex reconciliation requirements between the nozzle, the tank, the cashier, and the bank, accounting errors can literally drain your profits.
While expensive Enterprise Resource Planning (ERP) software exists, many station owners in India, Pakistan, Bangladesh, and Africa start with a simpler, more cost-effective tool: Microsoft Excel.
In this article, we provide a comprehensive guide to petrol pump accounting and offer a free, ready-to-use Petrol Pump Accounting Excel Sheet download.
= (Calculated_Closing_Stock - Actual_Dip_Reading) / Opening_Stock * 100
Tracks operational costs like electricity, staff salaries, and oil purchases.
| A | B | C | D |
| :--- | :--- | :--- | :--- |
| Date | Expense Head | Description | Amount |
| 01-01-24 | Electricity | Monthly Bill | 5,000 |
| 01-01-24 | Salary | Staff Wages | 20,000 |
| 01-01-24 | Maintenance | Machine Repair | 2,000 |
| | | TOTAL EXPENSE | =SUM(D2:D4) |