Note: A consistent negative variance indicates an underground leak or a calibration error in the dispensing units. 4. Cashier Reconciliation Sheet
To download the (updated for 2025 tax structures):
Note: A small negative variance is normal due to evaporation, but sudden drops indicate underground tank leaks. Tab 4: Credit Sales Ledger
Easily tailor the spreadsheet to your specific station layout, pumps, and products (Petrol, Diesel, Lubricants). petrol pump management excel sheet free download new
A robust petrol pump management sheet typically includes specialized modules to automate your daily workflow: Gas Station Petrol Pump Accounting Excel Template - Etsy
This is the most crucial sheet. It tracks the physical inventory of fuel stored in underground tanks (UGT). Stock at the start of the day (in Liters). Received Stock: Fuel received from the tanker.
(Formula: =[Closing Reading] - [Opening Reading] - [Testing] ) Tab 2: Daily Pricing & Revenue Tab 4: Credit Sales Ledger Easily tailor the
A "new" and effective management sheet should include the following core modules:
While expensive software solutions exist, a robust is often the most cost-effective and flexible solution for small to medium-sized fuel stations.
Record "Sales entries" only if you want granular data (optional). For minimal effort, just record the Closing Reading (8:00 PM). Stock at the start of the day (in Liters)
| A | B | C | D | E | F | G | H | I | |---|---|---|---|---|---|---|---|---| | | Shift | Fuel Type | Opening Dip (L) | Closing Dip (L) | Received (L) | Sold (L) =E+C-F | Rate/L | Sale Value =G*H |
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
First, let us know where you live so we can make sure that we can provide service in your area.
