In this guide 6 sections
Reconcile bulk and packed stock in five steps. Take tank dip readings and temperature, then convert volume to mass with density. Count drums and totes, add stock in process or in transit, then compare with book stock. Explain any gap against an agreed loss allowance.
Fix the cut-off before anyone counts
Pick a time and stop movements. No transfers, no filling, no dispatch. If the plant cannot stop for the whole count, log every drum filled, every tanker loaded and every transfer made, each with its time.
Assign one person to the tank farm and one to each warehouse bay, all working from the same sheet with the same units and the same rounding. Mixed formats cause errors. Keep it uniform.
Note open transfers. A pipe full of product between a tank and the filling line is stock too.
Read each tank properly
Take the dip or radar level, the product temperature and a sample density, all logged together so the readings describe one state of the tank. Read the dip twice. A tilted tape or a film of product on the dipstick moves the figure by more than most people expect. The tank’s strapping table then converts level to volume for that vessel.
Volume at today’s temperature is not volume at the reference temperature, so correct it, then multiply by density to reach mass, because the books hold kilograms or tonnes.
Record the tank number, the dip reference point, the gauge type and who read it. Short, but vital. Skip none.
- Dip or radar level
- Product temperature at the time
- Density from a fresh sample
- Strapping table version used
- Reader’s name and time
Count drums, totes and part containers
Count sealed drums by product and batch, not by product alone, and count intermediate bulk containers by label and seal. Weigh a part-used drum and subtract its tare.
Do not trust the label on a pallet’s top layer, because some pallets carry two products or two batches, so lift a sample from the lower layers. Photograph oddities for the reviewer.
List returnable empties apart, since they hold residue and belong to no product line.
- Sealed drums by batch
- Totes by label and seal
- Part-used containers weighed
- Pallets with mixed layers
- Returnable empties listed separately
Add stock in process, in transit and in quarantine
Reactors, blending vessels and filling-line hoppers hold product that is neither bulk nor packed, so include it using the same dip or weighing method as the tanks.
Add goods dispatched but not delivered if ownership has not passed, and incoming tankers not yet unloaded. Quarantine stock awaiting QC release counts too. Show it apart.
Convert everything to one unit. Mixed litres and kilograms hide shortages. Kilograms are best.
Explain the gap against a loss allowance
Compare counted mass with book mass. Some gap is normal, such as evaporation, residue on tank walls, hose draining and filling giveaway, so agree an allowance for each product and operation before the count.
A gap beyond the allowance needs a reason first, so check unposted transfers, a wrong density, an outdated strapping table or a receipt booked in the wrong unit.
Post the adjustment with its cause and an approver. This week, run the whole sequence on one tank and its packed stock. Keep the sheet as your template.
Bulk and packed stock reconciliation sheet
Three blocks share one printed page. The tank block has tank number, level, temperature, volume, density and mass, and the packed block has product, batch, drums, totes and part-used weights. The summary block shows counted mass, book mass, allowance, unexplained gap, cause and approver.
Open a blank worksheet to printQuestions owners ask
How often should bulk and packed stock be reconciled?
Many plants do a short tank-only check weekly and a full count each month, though fast-moving or hazardous products may need it more often.
Why convert volume to mass?
Density changes with temperature, so the same tank holds a different volume on a hot afternoon than on a cool morning. Mass stays constant, which makes counts comparable.
Who approves a stock adjustment?
Someone outside the counting team, such as the plant head or finance. The counter should not approve their own gap.