Running the stock sheet

How Petronyx calculates expected stock and variance per fuel grade, and how to export it.

6 min readUpdated

The stock sheet is the core of Petronyx. For every fuel grade on every shift it shows where the fuel went and whether the tanks agree.

The calculation

Opening stock
plus Deliveries received
plus Transfers in
minus Meter sales
minus Transfers out
minus Losses
equals Expected closing stock

Expected closing stock is compared with the closing dip, or with the electronic tank gauge reading where you have one. The difference is the variance for that grade.

Capture modes

ModeUse whenWhat you enter
ManualReadings are taken by hand from mechanical totals and dipsticksMeter readings and dips
ElectronicPumps and tanks report readings electronicallyElectronic meter totals and tank gauge readings
HybridSome pumps or tanks are electronic and others are notBoth, side by side, so the two can be compared

Reading the variance

  • Small variances are normal: temperature changes the volume of fuel and dipsticks have limited precision.
  • A consistent shortfall on one grade often points to a leak, a calibration fault or a nozzle mapped to the wrong tank.
  • A one-off large variance is usually an unrecorded delivery, a missed test return or a typing error.

Money on the stock sheet

Each grade's meter sales are valued at the price in force, giving expected sales. Declared takings are entered per payment method with references and optional proof attachments, so cash shortfalls are visible on the same sheet as fuel shortfalls.

Exporting

A stock sheet can be exported to PDF for signing and filing, or to Excel for your accountant. Exports include product lines, nozzle lines and finance lines.

Still stuck? Ask support and include the name of this guide.