How do I read a daily tank variance report, and when should I worry?
For owners, station managers, accountants · By the Petro team · Last reviewed
The short answer
A daily tank variance report sets, for each tank, the opening stock plus deliveries less pump sales (the book stock) against the dip, and shows the difference as a shortage or a gain. Check it every morning tank by tank: first that the opening matches yesterday's closing, the deliveries match their notes and every pump is on the right tank, then look at the difference. Worry about patterns, not single days: a tank short most days, a running total drifting one way, or one large unexplained jump.
What is on a daily variance sheet?
Layouts differ, but every daily wet-stock sheet has the same lines for each tank.
- Opening stock: yesterday's closing dip or closing book stock, depending on how your station carries it forward.
- Deliveries (inbound): litres received into the tank that day.
- Pump sales (outbound): for each pump on the tank, the closing meter less the opening meter, less any test litres poured back.
- Book stock: opening plus deliveries less sales.
- Dip stock: today's dip, converted to litres with the chart.
- Difference: dip less book. Negative is a shortage, positive a gain.
What should I check before I look at the difference?
A difference is only meaningful if the lines above it are right. A quick morning check catches most errors while they are still easy to fix.
- Does each tank's opening match yesterday's closing? If not, something was changed after yesterday was closed.
- Does every delivery match its delivery note, and is it on the right tank and the right day?
- Does every pump's opening meter match the previous shift's closing meter?
- Is every pump listed under the tank it actually draws from?
- Are the test litres plausible for the tests the pumpers did?
- Was the dip taken at the usual time, after the pumps had rested?
Which patterns should worry me?
- Small, mixed differences: normal. They should roughly cancel over a week.
- A tank short most days: a steady cause such as a drifting meter, a slow leak, test litres not returned, or a chart error. Investigate this week.
- A steady gain: usually a delivery or meter reading recorded short, or a chart error. Investigate just as seriously.
- One large jump: usually a paperwork event, such as a missed or duplicated delivery, a mistyped reading, or a dip taken during settling. Check that day's entries first.
- A gain in one tank and a matching loss in another of the same fuel: a delivery or pump on the wrong tank.
- Loss on petrol and diesel alike: not evaporation, since diesel barely evaporates. Look at testing, meters and paperwork.
How do I keep a running total?
A single day tells you little. Keep, for each tank, the month-to-date total of the daily differences and the month-to-date litres sold, and divide one by the other. That percentage can be compared from month to month and against the tank's own normal level.
Who should read the report, and when?
- The manager: every morning, before the first shift is busy, with the previous day's sheet. Fix entry errors the same day.
- The owner: weekly, looking at the running total per tank and any tank flagged by the manager.
- The accountant: at month end, agreeing the stock in the accounts with the last dip, and posting the month's gain or loss as an adjustment once the causes are known.
Frequently asked questions
- Should the opening be yesterday's dip or yesterday's book stock?
- Stations do both. Carrying forward the dip resets the book every day, so each day's difference stands alone. Carrying forward the book keeps a cumulative difference. What matters is doing it the same way every day and knowing which one you use.
- Can I correct a variance by changing the dip?
- No. The dip is the physical fact. Correct the entries that are wrong, such as a delivery, a meter reading or test litres. If the stock really is different from the books, record that as a stock adjustment with a note, not by editing the dip.
- What if I find an error from last week?
- Correct the original entry rather than adjusting today, so the history stays right and the running total is not distorted. Then re-check the days after it, since the opening of each day may have changed.
How Petro handles this
Petro's Fuel Stock Balance is a daily wet-stock sheet with a tab per fuel and a card per tank: the previous day's closing, each pump's in, out and difference, total inbound and outbound, book reading, dip reading, dip difference marked as a shortage or a gain, and sales value. It works out the totals as you type, and once saved and submitted it can be printed for the file.
See fuel operations in PetroThis guide is general information for Sri Lankan fuel stations, written by the Petro team. Figures in examples are made up. For a decision about your own tax or legal position, check with your accountant or the authority named in the sources.
