Every morning, update the current day's fuel prices and enter the previous shift's closing meter readings.
Excel is a highly accessible tool that requires no monthly subscription fees. A well-designed spreadsheet acts as a central hub for your entire station.
Opening Stock + Receipts - Net Sales Volume . Actual Dip Stock: The physical measurement using a dip rod. petrol pump management excel sheet free download new
Aggregates credit sales for specific customers across a month-long log to generate instant statements.
👉
Input fields for daily changing fuel prices (Petrol, Diesel, Lubricants).
Records which vehicle took fuel and under what authorization voucher. Every morning, update the current day's fuel prices
A monthly overview tab aggregates your daily figures to show actual net profits.
Subtracts the opening reading from the closing reading to calculate the exact volume sold in liters. Opening Stock + Receipts - Net Sales Volume
Microsoft Excel (.xlsx) Compatibility: Excel 2007, 2010, 2013, 2016, 2019, and Office 365.