Using this tool is easier than you think. Follow these steps to get started:
Step 1: Download the File Click the download link below and save the file to a secure folder on your computer.
Step 2: Enter Your Station Details Go to the Settings tab. Enter your:
Step 3: Daily Entries Every morning, enter the dipstick readings and the meter readings from the dispensing units. The sheet will automatically calculate the sales and closing stock. petrol pump management excel sheet free download new
Step 4: End-of-Month Reconciliation At the end of the month, print the summary report to compare your physical stock against the book stock.
If you are a dealer operating under an Oil Marketing Company (OMC), this sheet helps you estimate your commission based on sales volume and current tariff rates.
Ready to take control of your petrol pump’s data? Stop guessing and start tracking. Using this tool is easier than you think
File Format: Microsoft Excel (.xlsx) Compatibility: Excel 2007, 2010, 2013, 2016, 2019, and Office 365.
⬇️ DOWNLOAD PETROL PUMP MANAGEMENT SHEET (NEW VERSION)
(Note: This template is provided for educational and operational assistance purposes. Always cross-verify your accounts with a professional chartered accountant for tax purposes.) Step 3: Daily Entries Every morning, enter the
Open the Master Data sheet.
A: Basic version does not auto-compensate for temperature (diesel expands at 30°C). To adjust, manually reduce the dip reading by 0.05% per degree above 20°C. (Advanced users: Unprotect the sheet and add a temp coefficient column).