Daily sales & dip register, free in Excel
Record nozzle readings and tank dips, and let the sheet work out litres sold, book stock and any gain or loss for every tank.
Built by people who run fuel software
The same book stock and loss logic we use in FuelBotics, in a spreadsheet you can start using today. No sign-up, no macros.
Download free (.xlsx)- Excel, 90 KB
- Works in Google Sheets
- No macros
- Litres sold from meters
- Test litres handled
- Book stock per tank
- Gain / loss in litres & value
- Flags gaps over 1% & 50 L
- Monthly summary by product
What's inside
Five sheets that follow a normal day at the station. White cells are for your entries; grey cells calculate themselves.
- How to useA one-page guide to filling in the register.
- SetupYour station name, products, prices per litre and the product on each nozzle.
- Daily ReadingsOpening and closing meter readings and test litres for each nozzle and shift. Litres and sales value are calculated.
- Tank DipsOpening dip, deliveries and closing dip per product. Book stock, gain or loss and a check flag are calculated.
- Monthly SummaryPick a month to see litres sold, sales value, deliveries and stock gain or loss by product.
Get more out of it
Short guides that explain the numbers behind each sheet.
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 readRead guide Daily operationsTank dipping: how to take accurate dip readings
A practical routine for manual tank dips: when to dip, how to read the stick, checking for water and converting depth to litres with your calibration chart.
5 min readRead guide Stock controlHow to calculate fuel stock loss at your petrol station
A step-by-step guide to working out book stock, comparing it with tank dips and spotting fuel losses before they add up, with a worked example.
6 min readRead guideOutgrown the spreadsheet?
FuelBotics does all of this automatically, for every station, with alerts and monthly profit & loss.
