= (Variation / Total Sales in Liters) * 100
Automation: Quantity sold = Closing Meter - Opening Meter. | 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 | Shortage | | Diesel | 1,500 | 4,000 | 5,500 | 800 | 4,695 | -5 | Acceptable | petrol pump accounting in excel sheet download
Yes, the "Profit" tab includes a section for OMC commission (usually a fixed rupee/liter or percentage). Enter your commission rate once, and it auto-calculates daily. = (Variation / Total Sales in Liters) *