A petrol pump runs on its staff—from pump attendants to cashiers and managers. Use a dedicated employee sheet to manage:
Most stations run 24/7 across 2 to 3 shifts. Sales must be audited by nozzle meter readings per shift.
This sheet calculates total fuel volume sold based on meter readings from each dispensing pump. petrol pump accounting in excel sheet download
Use the basic multiplication formula to calculate total sales per nozzle. For example, if your liters sold is in Cell C2 and the price is in Cell D2, your formula would be =C2 × D2.
Never let shifts overlap without a full tally of cash, digital payments, and fuel dispensed. A petrol pump runs on its staff—from pump
Enter the opening and closing meter readings for each nozzle. Ensure your formula is set to:
Instead of downloading unknown, risky macro-enabled files from untrusted websites, you can safely build your own template in under ten minutes using the exact table outlines provided above. Copy the headers into a fresh Microsoft Excel or Google Sheets workbook, apply the listed math formulas, and save the file as a master template ( .xltx ). Reuse a clean copy every month to keep your file sizes small and your processing speeds fast. This sheet calculates total fuel volume sold based
Transitioning to Excel is a smart move, but there are common mistakes to avoid:
Look at the Shortage/Surplus cell. If it balances to zero (or within an acceptable rounding tolerance), lock the sheet for the day. Security Best Practices for Excel Bookkeeping
You can find pre-built, automated petrol pump accounting templates (often including VBA/Macros for faster data entry) at these sources: