The most critical sheet. It records the tank’s physical dip in centimeters, converts it to liters (using a tank calibration chart lookup), adds received stock, subtracts sales, and calculates the expected closing stock. A variance column ( =Physical Stock - Theoretical Stock ) immediately flags shortages or overages.
| Product | Opening Stock (L) | Received (L) | Total Available | Total Sales (L) | Dip Reading (L) | Variation (L) | Status | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | Petrol | 2,000 | 5,000 | 7,000 | 1,200 | 5,750 | -50 | | | Diesel | 1,500 | 4,000 | 5,500 | 800 | 4,695 | -5 | Acceptable | petrol pump accounting in excel sheet download
Running a petrol pump is a high-volume, low-margin business where every drop—and every penny—counts. Between fluctuating fuel prices, credit sales to fleet owners, and daily shift handovers, keeping your books straight can be a nightmare. The most critical sheet
: Hosts sample daily sales reports and profit/loss formats available for download in XLSX or PDF format. Excel vs. Dedicated Accounting Software Petrol Pump Accounting Excel Template in Excel - Download | Product | Opening Stock (L) | Received