| Date | Shift | Fuel | Open Meter | Close Meter | Sold (Ltr) | Unit Price | Total Sale | Cash | UPI | Card | Expense | Stock After Sale | |------|-------|------|------------|-------------|------------|------------|------------|------|-----|------|---------|------------------|
A single dashboard that automatically pulls data from the above sheets to show: petrol pump accounting in excel sheet download
A robust Excel template for a fuel station typically includes the following essential modules: | Date | Shift | Fuel | Open
| 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) | petrol pump accounting in excel sheet download
: Automatically calculates "Stock In" vs. "Stock Out" to show real-time available stock for each tank.