Stock Variance — When the Tank and System Disagree

Dip the tank and the numbers don't match the system — every fuel station runs into this. But not every variance is a problem. Some are simply the nature of measuring liquids; others are warning signs that need immediate action. This article draws a clear line between what is acceptable, what must be investigated, and how to record it in the books

A shortage or surplus left unchecked turns into wrong costs and unreliable profit in the financial statements. Well-run stations therefore set a variance threshold per tank, check on a regular rhythm, and follow a repeatable investigation procedure — rather than guessing from the opening shift's gut feeling

1. Naturally acceptable causes

• Temperature expands volume — fuel measured in the morning and in the afternoon can give different figures; deliveries taken under strong sun show the effect even more clearly
• Measurement tolerance — dip tapes, scales, or each person's way of reading the level can produce slightly different results
• Humidity and water accumulating at the tank bottom — settled water skews the fuel volume reading away from the stock in the system
• Small tolerances accepted by industry standards — as a rule, roughly 0.5-1% per delivery-and-dispensing cycle is considered normal

2. Causes that demand immediate action

Variance beyond the normal threshold, or growing consistently over several cycles, should always be suspected in this group first — the longer you wait, the more it costs. The ones most often found at stations:

• Leaks in the tank or piping — they advance quietly, and the slower the fix, the higher the cost
• Fraud, such as dispensing fuel off the books or adjusting figures between shifts
• Sympathy dispensing — fuel given to acquaintances without recording it or charging in full
• Recording mistakes, such as receiving into the wrong tank, keying the wrong delivery total, or billing the wrong fuel grade

3. The step-by-step investigation procedure

1. Cross-check the delivery total, dispensed total, and system balance for that tank, making sure all three figures come from the same source of data
2. Re-measure with the same method at the same time — first thing every morning, for example — to remove temperature and operator factors from the result
3. Compare the measurement against temperature correction (VCF) to convert to standard volume before concluding the variance
4. Calculate the variance per tank, both in liters and as a percentage of the volume received and dispensed in the period
5. If the variance exceeds the threshold you set, expand to targeted checks: leak testing, re-verifying delivery totals against the supplying (mother) station's tax invoice, and reviewing CCTV footage

4. How to set an acceptance threshold per tank

Many stations use 0.5-1% of the volume moved in the period as the acceptance threshold, then tighten it as the system becomes more accurate. For example, a tank dispensing around 150,000 liters a month with a 0.5% threshold equals 750 liters per month — anything beyond that starts the investigation procedure. Don't forget the daily trend either: a daily variance running in the same direction, even while the monthly total still sits within the threshold, is already a signal worth chasing

5. How to record the stock adjustment in the books

Once the investigation confirms the result, the financial statements must reflect reality: a shortage is recorded as an expense or stock-shortage variance, a surplus as other income, per standard accounting practice. For large amounts or suspected fraud, appoint a committee to assess and investigate before making the entry, because the outcome may change how it is recorded — for example, recovering the loss from those responsible. All accounting details should always be finalized in coordination with the business's accountant

6. Let ATG reduce manual dipping

An automatic tank gauging system (ATG) reads stock in real time, detects leakage, and removes most of the error that comes from manual dipping — so the variance you see reflects reality, not the quirks of a dip tape. Equipment details are on the ATG automatic tank gauging system page, and for seriously abnormal variances follow the deeper hands-on missing fuel investigation guide

In short: make the stock variance check systematic — set a threshold per tank, follow the procedure, and have your accountant confirm the adjustment entries before closing the books. A system that deducts stock automatically and reconciles received, dispensed, and remaining volumes every day tells you about the problem before month-end. If you want to start capturing on-site data so accounting and auditing get easier, the MagnitudePlus team offers a free consultation — and for costs and profit, continue with Reading your fuel station's profit and loss statement