ENRO · All articles

How to reconcile cement stock on a construction site: worked example

Reconcile opening stock, receipts, issues and physical counts without hiding unexplained differences.

By ENRO team

Reconcile cement stock by comparing the expected closing balance with a physical count for the same location and cut-off time. Record the difference separately; do not change an issue quantity just to make the numbers agree.

Work through one store

This is an illustrative example, not a customer result. A store opens with 240 bags, accepts 500 bags, issues 610 bags to work areas and returns 20 bags to the supplier. Expected closing stock is 240 + 500 − 610 − 20 = 110 bags. The count finds 104. The unexplained shortage is six bags, not six bags of proven theft or wastage.

A transfer needs two locations: an outgoing entry at the source and an incoming entry at the destination. If those records use different dates, investigate the timing before treating the difference as loss.

Keep this reconciliation record

  • Project, store, item specification and unit: 50 kg bags, not kilograms mixed with bags.
  • Opening balance and the last signed count date.
  • Accepted receipts with delivery and receipt references.
  • Issues with receiving work area and acknowledgement.
  • Supplier returns, internal transfers and separately recorded damaged stock.
  • Expected balance, counted balance, difference, counter and reviewer.

Count unopened bags separately from damaged or partly used bags. Keep stock awaiting inspection outside the accepted-stock total. Use the same cut-off for paperwork and the physical count; otherwise a late delivery can produce an artificial surplus.

Investigate before adjusting

Check unposted deliveries, duplicate issues, transfers in transit and entries made in the wrong unit. Ask whether the site recorded an issue to a floor as consumption even though usable stock remains there. A store balance and total site stock answer different questions.

Give any adjustment a reason, evidence and approval. Preserve the original entries. Reconcile frequently enough to investigate while the people involved still remember the movement; set that frequency around turnover and risk rather than an arbitrary universal rule.

Related guides

What is material reconciliation?

Recording material issues