How to read a stock sheet variance before it becomes a loss

A variance is not a verdict. It is a question with a short list of possible answers, and the order you check them in matters.

Every fuel station has a number that keeps owners up at night: the gap between what the tanks say and what the meters say. On paper stock sheets that gap is often discovered days later, when the person who could explain it is off shift and the delivery note is in a drawer. By then a variance has become an argument.

The fix is less about catching people and more about catching the number early, while the shift is still open and the evidence is still on the forecourt.

What a variance actually is

For each fuel grade, the stock sheet works out what should be in the tank at the end of the shift, then compares it with what was measured.

Opening stock
plus Deliveries received
plus Transfers in
minus Meter sales, net of test returns
minus Transfers out
minus Recorded losses
equals Expected closing stock

Variance is the measured closing stock minus the expected closing stock. A negative variance means less fuel in the tank than the paperwork explains. A positive variance means more.

Check in this order

Most variances have an ordinary cause. Working from the most common to the least common saves time and keeps the conversation fair.

  1. The readings

    A mistyped closing meter or a dip read at the wrong mark explains a large share of variances. Re-read the meter and re-dip before anything else.

  2. The delivery

    Was the delivery recorded against the right tank, with the litres actually received rather than the litres on the invoice? A delivery logged to the wrong grade creates two variances that cancel out across the station but not per tank.

  3. Transfers and test returns

    Fuel moved between tanks must be recorded on both sides. Fuel pumped for a calibration test and poured back must be recorded as a test return, or the meters count it as a sale that never happened.

  4. Temperature and measurement

    Fuel volume changes with temperature, and manual dips have a margin of error. Small variances inside your tolerance are expected.

  5. Everything else

    Only after the first four are ruled out is it time to look at equipment faults, leaks or theft.

Set a tolerance, then hold to it

A tolerance turns a vague feeling into a rule. In Petronyx it is a workspace setting: variance inside the tolerance passes, anything outside it is flagged on the stock sheet. You can also require a supervisor, finance or both to review the sheet before it is final.

Compare two meters, not one

Where pumps report electronic totals, Petronyx can record both the electronic and the manual meter for each nozzle, and the stock sheet keeps the manual dip and the automatic tank gauge closing side by side. When the two sources disagree, you learn something: either a reading was wrong, or the equipment needs attention.

Money is part of the same sheet

Litres that left the pump should turn into money. Petronyx calculates the expected sales amount from meter sales and price, and finance lines record what was declared, with a reference number and a proof attachment. A fuel variance and a cash variance on the same shift tell a different story than either one alone.

The habit that matters most

Review the variance before the shift closes, not the next morning. The attendant is still there, the meter can still be re-read, and the delivery driver's paperwork is still on the desk. That single change does more than any report.

See your own station in Petronyx.

Bring last week's stock sheet. We will rebuild it in Petronyx with you and show how each variance gets flagged before close.