What is wetstock reconciliation and why does it matter?
Wetstock reconciliation compares the fuel that should remain in a station’s tanks with the fuel actually measured there. It connects opening stock, accepted deliveries, metered sales and closing stock within the same reporting window. A difference is called tank variance. The purpose is not to make every day balance artificially, but to identify exceptions early enough to investigate them while delivery records, shift events and measurement conditions are still available.
For a gas station or petrol station, unexplained fuel loss reduces saleable stock and can also signal an environmental or safety issue. However, not every shortfall is physical fuel shrinkage. Incorrect timestamps, inconsistent temperature bases, meter differences and missing delivery entries can produce apparent losses. Good wetstock management therefore combines dependable measurements with operational investigation rather than treating the daily spreadsheet as proof of what happened underground.
How do you calculate book stock and tank variance?
Define one cutoff for each tank and the dispensers supplied by it. Obtain an opening dip or automatic tank-gauge reading, add deliveries received within that interval and subtract metered sales for the same interval. Compare that expected book stock with the closing measurement. Keep transfers, authorised test draws and returns separately documented; the basic formula assumes no additional stock movements and must be expanded when those movements exist.
All quantities must use the same volume basis and reporting interval. Negative variance means measured closing stock is below book stock.
For example, an illustrative opening stock of 20,000 litres plus a delivery of 10,000 litres less metered sales of 8,000 litres gives book stock of 22,000 litres. A closing measurement of 21,970 litres produces a negative variance of 30 litres. That result flags a difference requiring explanation. It does not, on its own, distinguish measurement uncertainty from an actual escape of product or another physical loss.
| Reconciliation item | Litres | Treatment |
|---|---|---|
| Opening dip | 20,000 | Starting measured stock |
| Accepted delivery | 10,000 | Add within reporting window |
| Metered sales | 8,000 | Subtract within reporting window |
| Book stock | 22,000 | 20,000 + 10,000 − 8,000 |
| Closing dip | 21,970 | Ending measured stock |
| Variance | −30 | 21,970 − 22,000 |
Which denominator makes variance percentage useful?
Choose a denominator and label it explicitly. Variance divided by metered sales expresses the difference relative to throughput, whereas variance divided by book stock answers a different question. For the illustrative day above, negative 30 litres divided by 8,000 litres sold equals negative 0.375%. Do not switch denominators between reports or compare a stock-based threshold with a sales-based result. Low-volume days can produce volatile percentages even when the litre difference is small.
Which measurements should a forecourt trust?
Treat both manual dips and automatic tank-gauge readings as measurements with conditions, not unquestionable truths. Follow approved procedures for settling time, safe access, equipment checks and water detection. Never improvise tank opening or inspection procedures. Staff should only perform tasks for which they are trained and authorised, using the site’s safety controls. Escalate access restrictions or equipment faults rather than filling gaps with an unlabelled estimate.
Check that delivery documentation, tank readings and sales counters use comparable units and temperature treatment. Temperature changes affect measured fuel volume, so mixing ambient litres with temperature-compensated quantities can create misleading differences. Do not apply an improvised correction factor to force agreement. Document the basis of each source and obtain technical support where conversion or calibration is needed, preserving the original observations for investigation.
How should deliveries be matched?
Record the tank, product, delivery start and finish times, supplier quantity and receipt confirmation. A delivery spanning the reporting cutoff can create a shortfall on one day and a surplus on the next if the invoice and tank movement land in different periods. Match the event before attributing a loss. Retain evidence of disputed quantities and follow the agreed supplier process without altering original records to remove the discrepancy.
How should daily cumulative variance be monitored?
Plot both daily exceptions and a cumulative measure. For this illustrative chart, cumulative variance percentage equals the sum of daily variance litres divided by cumulative metered sales litres, multiplied by 100. Each daily variance uses its own measured opening and closing stock, so do not carry an unexplained book balance forward and then count it again. For a continuous period with consistent boundaries, the summed daily calculation should reconcile to the period-level stock equation.
The illustrative downward trend deserves investigation before and after it crosses the displayed band. A band is a management screening tool, not evidence that losses inside it are harmless. Set site thresholds using equipment capability, operating conditions, supplier terms and applicable regulatory requirements. Any alarm, suspected leak or other safety signal overrides a routine reporting threshold. Never wait for cumulative variance to become large before following the emergency response process.
How do you investigate unexplained fuel loss?
Begin with safety triage. If there is an alarm, visible release, unusual odour or another reason to suspect leakage, follow the site emergency plan and applicable notification rules immediately. Use qualified personnel to assess equipment and determine whether isolation is required. Financial reconciliation must never delay environmental response, and a balanced report must never be treated as assurance that a suspected physical problem is safe.
- Confirm the reporting window, units, tank mapping and completeness of opening and closing readings before comparing results.
- Match delivery records to actual receipt times and tank movements, including deliveries that span a cutoff.
- Reconcile dispenser totals with point-of-sale records and documented tests, returns or authorised stock movements.
- Ask qualified technicians to assess persistent measurement or equipment concerns, then document the cause, corrective action and verification.
Use the pattern to narrow the question without declaring the answer prematurely. A difference concentrated around deliveries points towards receipt measurement or timing, while a recurring shift-specific exception may indicate an operating-process issue. Persistent losses across periods warrant further technical assessment. Keep commercial disputes, data errors and suspected physical losses separately classified so each follows the right escalation route and the site does not close a serious issue with an accounting entry.
Who should own the daily wetstock process?
Give the shift team responsibility for timely readings and complete event records, the site manager responsibility for exception review, and finance responsibility for consistent valuation and reporting. Assign qualified specialists to equipment assessment. Andrils Daily supports wetstock reconciliation alongside shift and cash reconciliation, helping operators connect tank movements with sales records and identify where an exception needs practical follow-up.
Maintain an exception register with the tank, period, litre difference, percentage basis, evidence, owner and next action. Preserve original values when corrections are made, showing who changed what and why. Verify that a resolved issue stays resolved over subsequent operating cycles. Training should cover handovers and missing-data escalation, not just spreadsheet completion, because many reconciliation failures begin with an undocumented event between shifts.
How does wetstock control improve financial performance?
Do not allow missing measurements to disappear into a normal-looking trend line. Mark incomplete days, explain any estimate and distinguish provisional results from reconciled results. When valid data becomes available, restate the affected period with a clear audit trail. Otherwise a later correction may look like a sudden operational improvement or deterioration, diverting attention from the original data-quality problem and undermining confidence in the daily review.
Translate confirmed volume losses into money using an explicitly stated valuation basis. For example, an illustrative unrecovered loss of 100 litres at an acquisition cost of $1.00 per litre represents $100 of inventory cost. Foregone sales value is a different measure and should not be added automatically to inventory cost as another loss. Distinguish real product loss from measurement corrections when reporting the effect on margin.
Connect the wetstock review to the operating plan without encouraging staff to hide adverse numbers. A worsening variance should prompt investigation, not an automatic adjustment to meet budget. The daily performance view from Andrils brings stock reconciliation, margin per litre and plan-versus-actual reporting together so managers can separate a pricing problem from a stock-control problem and check whether corrective actions are improving the underlying result.
Review the process after equipment maintenance, tank configuration changes or updates to sales systems. A previously reliable mapping between dispensers and tanks can become wrong after operational changes. Confirm that reporting still reflects the physical installation, and test the revised workflow with documented checks. Make this verification part of change control so recurring differences are not misdiagnosed as new product losses.
