Petrol Pump Management Excel Sheet Free Download Online
Create a small table on the side that converts "Dip Stick Levels" (cm/inches) to Liters.
This is the transaction log. Each row represents a nozzle or a shift. Columns must include:
Many small to medium-sized station owners rely on memory or scattered notebooks. This leads to three common problems:
A structured Excel template solves all of this instantly.
To take your free Excel sheet from "basic" to "professional," add these features: petrol pump management excel sheet free download
Once you download the file, follow these steps to customize it for your specific station:
Step 1: Input Tank Calibration Data Every tank has a unique strapping table (how many liters per centimeter of dip). Enter your tank’s specifications into the "Tank Master" sheet.
Step 2: Set Shift Timings Adjust the header to match your local operating hours (e.g., Shift A: 6 AM to 2 PM).
Step 3: Enter Opening Stock Physically dip the tanks at midnight. Enter that exact figure as your "Opening Stock" for Day 1. Create a small table on the side that
Step 4: Train Your Staff Operator error is the biggest pitfall. Train your nozzle attendants to write meter readings clearly. The Excel sheet should have a "Data Entry" tab that is locked to prevent editing of formulas.
Step 5: The Daily Audit Every morning, the manager copies the previous day’s sheet, pastes it as "Values" into an archive sheet, and clears the active sheet for the new day.
This sheet tracks the fuel in your underground tanks.
| Column | Header Name | Purpose |
| :--- | :--- | :--- |
| A | Date | Date of transaction. |
| B | Fuel Type | Petrol / Diesel. |
| C | Stock In (Ltrs) | Quantity filled by the tanker. |
| D | Stock Out (Ltrs) | Link this to Sheet 1 (Total Sales). |
| E | Current Stock | Formula: =Previous Stock + C - D. |
| F | Tank Capacity | The max volume of your tank (e.g., 10,000 Ltrs). |
| G | Low Stock Alert | Conditional Formatting: If E < 1000, turn Red. | A structured Excel template solves all of this instantly
Pro Tip: Use the "Stock Out" column to link back to your Daily Sales Log using the SUMIF formula so inventory updates automatically when you enter sales.
This is your data entry hub. It records every shift or day's operations.
| Column | Header Name | Purpose |
| :--- | :--- | :--- |
| A | Date | Format as DD/MM/YYYY. |
| B | Shift | Morning / Evening (or Shift A/B). |
| C | Fuel Type | Petrol / Diesel / Premium. |
| D | Opening Reading | The cumulative meter reading at the start of the shift. |
| E | Closing Reading | The cumulative meter reading at the end of the shift. |
| F | Sale Qty (Ltrs) | Formula: =E-D (Closing minus Opening). |
| G | Rate Per Litre | The selling price on that day. |
| H | Gross Sales | Formula: =F*G (Qty x Rate). |
| I | Cash Collected | Actual cash handed over by the attendant. |
| J | Card/UPI Sales | Digital transaction totals. |
| K | Difference | Formula: =H-(I+J) (Should be zero). |
Why this works: By using Opening and Closing meter readings, you eliminate the chance of attendants reporting false numbers. The math must match the meter.
If you want, I can:
If you tell me what you need to track (daily sales, stock in/out, tank levels, cash/card payments, supplier details, etc.), I can give you a ready-to-use Excel template structure with formulas — you just copy it into a blank sheet.