Create a new workbook and create the following sheets (right‑click on the bottom tabs → Rename):
Nozzle Number, Fuel Type (Petrol/Diesel), Opening Meter, Closing Meter, Testing Liters, Net Sales (Liters), Rate per Liter, Total Amount.
: Modify formulas, add columns, or change layouts to fit your specific station setup. petrol pump management excel sheet free download
When selecting a management sheet, ensure it includes these essential components: Meter Reading & Sales
Stop tracking your daily sales on loose paper or complicated registers. We have designed a ready-to-use, formula-locked Excel template that handles everything mentioned above. Create a new workbook and create the following
Automatically calculates dead stock, sales, and testing losses.
Date, Fuel Type, Opening Stock (Liters), Tank Inflow/Receipts, Daily Sales (Liters), Expected Closing Stock, Actual Dip Reading, Variance/Loss. Conditional formatting that highlights an item in red
Conditional formatting that highlights an item in red when inventory falls below safety levels. 5. Expense and Purchase Ledger
By referencing these cells in your daily logs using VLOOKUP or basic cell references ( =Settings!$B$2 ), you only need to update the price once in the settings tab to update the entire workbook. Step 2: Format the Daily Entry Sheet