When searching for "petrol pump accounting in excel sheet download" , users should look for templates that include (e.g., a button to reset daily readings) or at least advanced formulas. Trusted sources include:
On the first day of the month, physically measure the dip (stick) of your tank. Enter this value in the column. This is your source of truth. petrol pump accounting in excel sheet download
Enter meter readings or unit prices and let Excel instantly calculate total sales and shift totals. Profit Analysis: When searching for "petrol pump accounting in excel
This is the most critical part. You start with (liters in the underground tank), add Purchase (liters delivered by tanker), subtract Sales (liters sold via pumps), and arrive at Closing Stock (physical dip). This is your source of truth
| Payment Mode | Amount | | :--- | :--- | | Cash Sales | $1,200 | | Card Swipe Machine | $800 | | Credit (Fleet Card) | $500 | | Company Credit (Local trucks) | $300 | | | $2,800 | | Actual Cash in Drawer | $1,180 | | Cash Short/Excess | -$20 (Short) |