Petrol - Pump Management Excel Sheet Free Download Best

Open a blank workbook and create three sheets: Daily_Sales , Stock_Inventory , and Customer_Ledgers . Label your columns clearly in bold headers, and freeze the top row so headers remain visible when scrolling down. Step 2: Input Automated Formulas

: A dedicated section to track fuel provided on credit to fleet customers or regular parties, including a Credit Register to manage outstanding balances and payments received.

Date, Shift, Employee Name, Cash Collected, Credit Sales, UPI/Card Sales, Total Sales, Shortage/Excess. Formula: Shortage = (Cash + Credit + UPI) - Total Sales . 4. Expense & Petty Cash Tracker

For net sales: =SUM(C2-B2)-D2 (where C is closing, B is opening, and D is testing). petrol pump management excel sheet free download

: Track operational costs like staff salaries, electricity, and maintenance in one place. Credit Sales Management

Excel is already available on most computers at no extra expense. Training is minimal because many staff members already possess basic Excel skills for everyday data entry and calculations.

[Master Workbook] ├── Tab 1: Daily Price Matrix (Petrol, Diesel, CNG) ├── Tab 2: Shift Nozzle Readings & Sales ├── Tab 3: Underground Tank Dip Chart Reconciliation ├── Tab 4: Credit Customer Ledgers └── Tab 5: Monthly Profit & Loss Dashboard Step 1: Establish the Nozzle Formula Open a blank workbook and create three sheets:

At the end of each shift, perform a cash reconciliation. Count the physical cash and compare it to the day's total sales from your log. Any variance (a shortage or surplus) should be recorded and investigated.

The unique receipt or voucher number issued at the pump.

Calculated via formula: Closing Physical Dip Reading - Book Stock . A persistent negative variance indicates a leak, high evaporation, or dispensing inaccuracy. 3. Shift Cash and Payment Reconciliation Sheet Date, Shift, Employee Name, Cash Collected, Credit Sales,

Clear identifiers for tracking.

If you need help customizing this template for your specific station, let me know: How many and nozzles does your petrol pump have? Do you need to track lubricant/oil sales alongside fuel?