Petrol Pump Management Excel Sheet Free Download May 2026

Add a column for "Testing Amount" (the small amount dispensed to test the nozzle before opening).

As an AI, I cannot generate a .xlsx file, but you can create one in 30 seconds using the text below.

Instructions:

Date	Shift	Fuel Type	Opening Meter	Closing Meter	Sale Qty (Ltrs)	Rate	Total Sales	Cash	Card	Difference	Expense Type	Expense Amt
01/11/2023	Morning	Petrol	10050	10200	150	100	15000	10000	5000	0	Electricity	5000
01/11/2023	Morning	Diesel	5000	5200	200	90	18000	18000	0	0	Salary	0
01/11/2023	Evening	Petrol	10200	10400	200	100	20000	20000	0	0	Maintenance	0

Formulas to apply after pasting:

If you download a free template that requires manual calculation in every cell, delete it immediately. A good petrol pump management excel sheet uses these automated formulas: petrol pump management excel sheet free download

Pro Tip: Use conditional formatting (red for loss, green for gain) to spot discrepancies instantly.

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). Add a column for "Testing Amount" (the small

Step 3: Enter Opening Stock Physically dip the tanks at midnight. Enter that exact figure as your "Opening Stock" for Day 1.

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.

To take your free Excel sheet from "basic" to "professional," add these features: Date Shift Fuel Type Opening Meter Closing Meter

This calculates the "Dry Stock" profit (profit on lubricants/snacks) and "Wet Stock" profit (fuel).

Key Metrics to Track:

This is the transaction log. Each row represents a nozzle or a shift. Columns must include:

That’s it. The sheet will calculate profit, loss, and variance automatically.