How to keep a petrol pump daily sales register (with free template)

What to record at every shift, how to work out litres sold from meter readings, and how to reconcile cash, cards and credit. Includes a free Excel register.

6 min read FuelBotics team

The daily sales register is the backbone of a petrol station's records. Get it right and stock control, cash reconciliation and profit reports all follow. Get it wrong and every number built on top of it is wrong too.

What to record for every nozzle, every shift

FieldWhy it matters
Date and shiftLets you trace any gap to a specific shift and team.
Nozzle and productTies sales to the right tank for stock reconciliation.
Opening meter readingShould equal the previous shift's closing reading.
Closing meter readingTaken at handover, confirmed by both attendants.
Test litres returnedFuel dispensed for pump tests and poured back into the tank. It isn't a sale.
Selling price per litreNeeded to turn litres into the money you should have collected.
AttendantAccountability for cash and readings.

Working out litres sold

Litres sold = Closing meter − Opening meter − Test litres returned
Sales value = Litres sold × Selling price per litre

For example, if nozzle 1 opened at 125,430.0, closed at 126,210.5 and 5 test litres were returned, litres sold is 126,210.5 − 125,430.0 − 5 = 775.5 litres. At 272.50 per litre, that's 211,323.75 in sales.

Rule of thumb: the opening reading of a shift must always equal the closing reading of the previous shift. If it doesn't, stop and find out why before going any further.

Reconciling cash at the end of the shift

Once you know what should have been collected, compare it with what was actually collected:

ItemAmount
Expected sales (all nozzles, from meters)1,031,900
Cash counted612,400
Card payments287,500
Credit sales to account customers131,200
Total collected1,031,100
Short / (excess)800 short

Record the shortage against the shift and attendant. Small differences happen, but a pattern of shortages on the same shift is a signal worth acting on.

Connect the register to your tanks

Litres sold from the register feed straight into your stock reconciliation: opening dip + deliveries − litres sold = book stock. Compare that with the closing dip and you have your daily gain or loss for each tank. We walk through it in how to calculate fuel stock loss.

Free daily sales & dip register Readings, litres sold, tank dips, book stock and a monthly summary in one Excel file.
Download free

Five habits that keep the register accurate

  1. Read meters at a fixed time. The same handover time every day makes shifts comparable.
  2. Two people, one reading. The outgoing and incoming attendant both confirm each closing reading.
  3. Never overwrite. If a reading is corrected, record who changed it and why.
  4. Record test litres separately. Don't just subtract them in your head.
  5. Update prices on the day they change. A price change mid-day means splitting the shift into before and after.

From paper to software

A paper register or spreadsheet works for one station, but it relies on someone copying numbers correctly every shift, and owners usually only see the totals days later. With FuelBotics, attendants enter readings for all nozzles in one go on a phone, tablet or PC, litres and totals are worked out instantly, and owners can see every station's sales as the day goes on.

Let FuelBotics do the maths for you

Readings, dips, stock loss and profit worked out automatically. Book a free demo and start a 14-day free trial.

Chat on WhatsApp
Book a free demo