: Save a copy of the workbook daily. Use a clear naming convention, such as Petrol_Pump_Log_YYYY_MM_DD.xlsx . Alternatively, host the file on a secure cloud storage service with automated version history.
Always ensure formulas start with an equal sign ( = ).
Input your current tank opening stocks and nozzle readings to start tracking.
This sheet tracks the opening and closing meter readings for every nozzle. Automatically calculates total liters sold per nozzle. Multiplies liters sold by the daily fuel rate. Segregates sales by fuel type (Petrol, Diesel, CNG). 2. Dip Reading & Density Log (Inventory Management)
Consolidates sales, expenses, and net profit data into a single dashboard. Core Features of an Effective Fuel Station Spreadsheet petrol pump management excel sheet free download
Link the total sum of this column back to the column in your Inventory sheet using the =SUM() formula. Step 3: Automate the Credit Ledger Name the third tab "Credit Customers" .
Open the file in Microsoft Excel or upload it to Google Sheets.
This is the most important daily task, typically done at the end of each shift. Enter each sale or delivery as a new row in your Daily Sales Log. Ensure you fill in:
Net Sales=Closing Reading−Opening Reading−TestingNet Sales equals Closing Reading minus Opening Reading minus Testing 2. Dip Reading and Inventory Reconciliation : Save a copy of the workbook daily
Protect your worksheet cells containing formulas so that operators cannot accidentally delete or modify them.
What or measurement unit (liters/gallons) do you use?
Using the right formulas prevents manual mathematical errors during busy shift changes.
: A central command center that provides instant updates on total sales , operational expenses , net profit , and current fuel stock levels . Always ensure formulas start with an equal sign ( = )
Forgetting to log a single fleet delivery hurts cash flow. A dedicated credit tab flags unpaid slips instantly. How to Get Your Free Petrol Pump Management Excel Sheet
The Leaky Hose
“Every drop counts,” he said, pointing to the screen. “At the end of your shift, you type the closing meter reading . You type the cash in the drawer . You type the digital payments .”