How to Calculate Daily Fuel Sales at a Filling Station

Calculating daily fuel sales is one of the most important activities in filling station management. At the end of every business day or shift, management needs to know how much fuel was sold and how much revenue the station should have received. The calculation may appear simple, but errors in pump meter readings, selling prices, cash records, credit sales, or payment reconciliation can create significant differences. A filling station can be busy throughout the day and still experience financial losses if sales are not properly calculated and reconciled. Understanding the correct process for calculating daily fuel sales helps station managers improve accountability and identify unusual differences earlier. What Are Daily Fuel Sales? Daily fuel sales represent the quantity and financial value of fuel dispensed by a filling station during a specific business day. Depending on the station's operating structure, sales may also be calculated by shift. For example, a station operating morning, afternoon, and night shifts may calculate sales for each shift before producing a final daily sales report. The calculation usually begins with pump meter readings. Fuel pumps record the total quantity of fuel dispensed through each pump or nozzle. By comparing the opening meter reading with the closing meter reading, management can calculate the quantity of fuel dispensed during the period. The Basic Daily Fuel Sales Formula The basic formula for calculating litres sold is: Closing Meter Reading - Opening Meter Reading = Litres Sold For example, imagine the opening meter reading for a petrol nozzle is 125,000 litres. At the end of the day, the closing meter reading is 128,500 litres. The calculation would be: 128,500 - 125,000 = 3,500 litres sold This means the pump dispensed 3,500 litres during the period. To calculate the expected sales value, multiply the litres sold by the selling price. Litres Sold × Selling Price = Expected Sales Value If petrol is sold at GHS 15 per litre, the calculation would be: 3,500 × GHS 15 = GHS 52,500 Based on the pump meter records, the station should account for GHS 52,500 in sales. Record the Opening Pump Meter Reading The first step in calculating fuel sales is recording the opening meter reading. This is the pump's meter position at the beginning of the business day or shift. The reading should be taken directly from the correct pump or nozzle. Station staff should avoid estimating meter readings or copying previous figures without verification. The opening meter reading becomes the starting point for the sales calculation. If this figure is incorrect, the final litres sold calculation may also be incorrect. Each pump or nozzle should have its own opening reading. For stations with several pumps, management should ensure that readings are connected to the correct pump and fuel product. Record the Closing Pump Meter Reading At the end of the business day or shift, the closing meter reading should be recorded. The closing reading shows the pump's total meter position after fuel has been dispensed during the period. Management subtracts the opening reading from the closing reading to determine litres sold. For example: Opening meter: 85,200 litres Closing meter: 87,950 litres Litres sold: 2,750 litres The closing reading from one shift may also become the opening reading for the next shift. This creates a continuous record of pump activity. If there is an unexplained difference between a closing reading and the next opening reading, management should investigate the situation. Calculate Litres Sold for Every Pump A filling station may have several pumps or nozzles dispensing the same fuel product. Sales should be calculated for each pump before the figures are combined. For example: Pump 1 petrol sales: 2,500 litres Pump 2 petrol sales: 3,000 litres Pump 3 petrol sales: 1,800 litres The total petrol sales would be: 2,500 + 3,000 + 1,800 = 7,300 litres If the station also sells diesel, diesel pump sales should be calculated separately. Keeping products separate helps management understand the sales performance and stock movement of each fuel type. Apply the Correct Selling Price After calculating litres sold, management needs to apply the correct selling price. The selling price used in the calculation should match the approved price for the period when the fuel was sold. For example: Petrol litres sold: 7,300 litres Selling price: GHS 15 per litre Expected sales value: 7,300 × GHS 15 = GHS 109,500 Price changes can make sales calculations more complicated. If the selling price changes during the business day, management may need to separate sales according to the applicable prices. Using the wrong selling price can create a difference between expected revenue and actual collections. Calculate Sales by Fuel Product Every fuel product should have its own sales calculation. For example, a station may sell petrol and diesel. The daily report could show: Petrol sales: 7,300 litres Petrol sales value: GHS 109,500 Diesel sales: 4,000 litres Diesel sales value: GHS 64,000 The total daily fuel sales value would be: GHS 109,500 + GHS 64,000 = GHS 173,500 Separating products makes fuel stock and sales reconciliation easier. It also helps management understand which products generate the highest sales volumes. Understand Expected Sales and Actual Collections Calculating the expected sales value is only part of the process. Management must also determine how the money was received. If pump records show expected sales of GHS 173,500, the station should be able to account for the same value through payments and approved transactions. Payments may include cash, mobile money, card payments, bank-related transactions, or approved credit sales. For example: Cash received: GHS 100,000 Electronic payments: GHS 50,000 Approved credit sales: GHS 23,500 Total accounted sales: GHS 173,500 In this situation, the sales position balances. However, imagine the total amount accounted for is GHS 171,500. The station now has a GHS 2,000 difference that requires investigation. What Is Sales Reconciliation? Sales reconciliation is the process of comparing expected sales with the payments and approved transactions recorded by the station. The basic idea is: Expected Sales Value - Accounted Payments = Sales Difference If expected sales are GHS 50,000 and the station accounts for GHS 49,800, there is a GHS 200 difference. Management should investigate the reason for the difference. The difference may result from a cash shortage, incorrect payment record, credit sale that was not recorded, incorrect pump meter reading, or another operational error. A sales difference should not automatically lead to accusations. The records should first be reviewed. Include Credit Sales in Daily Calculations Credit sales are sometimes forgotten during reconciliation. A station may dispense fuel to an approved company or customer without receiving immediate payment. The pump still records the fuel as dispensed. This means the fuel is included in litres sold and expected sales. If the credit transaction is not properly recorded, the station may appear to have a cash shortage. For example: Expected sales: GHS 60,000 Cash and electronic payments: GHS 55,000 Approved credit sales: GHS 5,000 The station has accounted for the full GHS 60,000. Without the credit sales record, management may incorrectly assume that GHS 5,000 is missing. Record Calibration and Approved Fuel Activities Pump meter readings may include fuel dispensed during calibration or approved testing activities. If these quantities are not properly recorded, they may affect the daily sales calculation. For example, a pump may dispense 20 litres during calibration. The pump meter records the 20 litres as fuel dispensed. However, the station did not sell the fuel to a customer. If the calibration activity is not recorded, management may expect payment for those 20 litres. This can create an artificial sales shortage. Calibration and other approved fuel activities should therefore be properly documented. Compare Sales With Fuel Stock Movement Daily fuel sales should also be reviewed alongside fuel stock records. If pump meters indicate that 5,000 litres were sold, management should expect a corresponding movement in fuel stock, subject to deliveries, transfers, calibration, and other approved adjustments. For example: Opening stock: 20,000 litres Fuel received: 10,000 litres Fuel sold: 5,000 litres Expected closing stock: 25,000 litres The station can compare the expected closing stock with the verified tank position. A significant difference may indicate fuel variance. This is why pump sales and tank stock should not be managed as completely separate activities. Common Mistakes When Calculating Daily Fuel Sales Several common mistakes can affect daily fuel sales calculations. Incorrect opening meter readings can create inaccurate litres sold figures. Wrong closing meter readings can affect the entire shift report. Using the wrong selling price can create a difference in expected revenue. Failing to record credit sales may create an artificial cash shortage. Unrecorded calibration activities can affect sales calculations. Combining different fuel products incorrectly can make reconciliation difficult. Spreadsheet formula errors can also produce inaccurate reports. Many of these problems can be reduced through consistent operational processes and proper record keeping. Why Daily Sales Should Be Calculated by Shift For stations operating multiple shifts, calculating only the final daily sales figure may limit accountability. Imagine a station records a GHS 3,000 sales shortage at the end of the day. If management only has one daily report, it may be difficult to determine when the difference occurred. However, if sales are calculated and reconciled by shift, management can identify the affected period. The morning shift may balance. The afternoon shift may balance. The night shift may record the GHS 3,000 difference. Management now has a clearer starting point for investigation. Shift-based reconciliation creates stronger operational accountability. The Problem With Manual Daily Sales Calculations Many filling stations calculate daily sales using notebooks, calculators, and spreadsheets. This process can work, but it depends heavily on manual data entry. A wrong figure can affect several calculations. Station managers may also spend significant time preparing daily reports. For companies operating multiple filling stations, head office may receive several spreadsheets or reports from different branches. Management must then review and combine the information. This delays decision-making and makes branch comparison more difficult. Using Technology to Calculate and Monitor Fuel Sales Filling station management software can help petroleum businesses structure daily sales calculations and reconciliation. Axio Suite is designed to help filling stations manage pump meter readings, fuel sales, payment records, stock activities, reconciliation, and operational reports. Instead of keeping important station information across multiple notebooks and spreadsheets, operational data can be managed through a centralized system. For petroleum companies operating multiple stations, head office teams can gain better visibility into branch sales and operational activities. The goal is to help management identify discrepancies earlier and make decisions using reliable information. Why Accurate Daily Sales Calculations Matter Daily sales figures affect many areas of a filling station. They influence cash reconciliation. They affect fuel stock calculations. They contribute to profit and loss reporting. They help management monitor branch performance. They support staff accountability. They can also help identify unusual operational patterns. An inaccurate daily sales report can therefore affect several management decisions. Filling stations should treat daily sales calculations as an important operational control rather than a simple administrative task. Conclusion Calculating daily fuel sales begins with accurate pump meter readings. The closing meter reading is subtracted from the opening meter reading to determine litres sold. The litres sold are multiplied by the correct selling price to calculate expected sales revenue. Management should then compare expected sales with cash, electronic payments, approved credit sales, and other properly recorded transactions. Daily sales should also be reviewed alongside fuel stock movement and operational activities such as calibration. For filling stations operating multiple shifts, shift-based sales calculations can improve accountability and make discrepancies easier to investigate. Accurate information helps management protect revenue. Axio Suite helps filling stations and petroleum businesses manage pump readings, fuel sales, reconciliation, stock activities, and operational reports from a centralized system. Request an Axio Suite demo and discover a smarter way to monitor your filling station sales and operations.