: = (Closing Reading - Opening Reading) - Testing
Managing a petrol pump involves tracking fuel inventory, daily sales, credit accounts, and ledger books. Doing this manually leads to errors and lost revenue. A specialized Excel sheet solves this problem by automating your daily calculations without the high cost of custom software.
Disclaimer: This template is for management and estimation purposes. For tax filing (VAT/GST), ensure your calculations align with your government's official fuel taxation rules.
This template includes pre-set formulas for automatic calculation of daily sales and stock inventory. Key Tips for Using the Spreadsheet
Add a column for "Testing Amount" (the small amount dispensed to test the nozzle before opening).
Q: Is the petrol pump management Excel sheet free? A: Yes, our petrol pump management Excel sheet template is free to download.
File details: Format: .xlsx (Compatible with Excel 2016, 2019, 365, and Google Sheets) | Size: 124 KB
| Column | Header Name | Purpose | | :--- | :--- | :--- | | | 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). |
That’s it. The sheet will calculate profit, loss, and variance automatically.