Skip to content
Work
Case study · Fuel Retail

PetroDiesel  Fuel Station Management

Fuel retail management deployed across three stations — custom fuel-entry billing, shift reconciliation, credit outstanding, cashier sales and thirty-plus operational reports.

Engagement
Sector
Fuel Retail
Year
2024
Role
Frappe developer
Status
Live
3
Locations live

multi-site rollout

30+
Custom reports

built from operator asks

Per shift
Variance attribution

was next-day, paper

At point of sale
Credit control

was monthly review

01The problem

Fuel retail reconciles in a way no standard ERP module expects: dip readings against nozzle totalisers against cash collected against credit issued, per shift, per nozzle, per attendant. Shortages need to be attributable to a shift before the next one starts. Across three sites, this was being reconciled on paper the following day, by which point nobody could say which shift the shortfall belonged to.

02What we built

A custom fuel billing module on Frappe capturing nozzle-level entries with opening and closing totaliser readings, tank dips and density, then reconciling against cash, card and credit at shift close — so a variance is attributed while the attendant is still on site. Credit customers carry outstanding limits enforced at the point of sale rather than reviewed monthly. Role-based access separates cashier, shift manager and owner: a cashier can bill but cannot adjust a reading. Thirty-plus reports were built against what the operators actually asked for each morning — daily summary, credit outstanding ageing, cashier-wise sales, nozzle-wise throughput, shift variance — surfaced as a real-time dashboard rather than an export.

03Feature highlights
  • Nozzle-level entry with totaliser, dip and density capture
  • Shift-close reconciliation with attributed variance
  • Credit limits enforced at the point of sale
  • Role-based access separating cashier, manager and owner
  • 30+ operational reports and a real-time dashboard
  • Deployed and running across three stations
04Technology
Frappe FrameworkERPNextPythonMariaDBCustom DocTypesQuery reportsJinja print formats
Delivered under
Next available cycle

Send a business name
and a city.

We'll run the geo-grid scan on your current Maps position and send back the grid — the same artefact a paying client gets monthly. No call required, no obligation attached.

Direct lines