In this guide 6 sections
Site use departs from the BOQ at every hand-off. Steel carries cutting loss, cement is lost in bags and mixing, shuttering is reused beyond its planned cycles, and issues are booked against the wrong activity. The gap is only visible when purchase, receipt, issue, wastage and billed quantity share one record.
The BOQ is a plan, not a ledger
A BOQ line says 40 tonnes of reinforcement for a slab, based on the drawing. It does not know that the bar bending schedule changed after a revision. Nor does it know the supplier delivered 12 metre lengths for a 9 metre cut.
Drawings are measured net. Sites consume gross. That difference is the first place the numbers split, and nobody records it.
Treat the BOQ as the budget for one activity. Treat the site store as the ledger of what actually left the shed. Reconciling the two is a monthly job at best, and usually a rushed one.
- Net drawing quantity against gross cut quantity
- Revision of the bar bending schedule
- Cutting length against delivered length
- Activity code on every issue slip
Follow steel from purchase order to the slab
Start with the purchase order. It lists diameter, grade and tonnage. The goods receipt note then records what the weighbridge slip says, and the two rarely match to the kilo. Mill tolerance alone moves the number.
Next comes the store issue to the bar bending yard. If the issue slip names no pour or element, the tonnage lands in a general bucket. Cutting offcuts then pile up in a corner and get sold as scrap, often unrecorded.
Last, the running bill measures the steel in place. The quantity billed is net of binding wire, laps and chairs. So the purchase, the issue and the bill each tell a different truth.
Cement and shuttering leak differently
Cement leaks through torn bags, rain damage, spillage and mix design set by the batching crew. A ready-mix pour is billed by delivery challan volume, and returned concrete or an overfilled formwork adds to it. Bag cement is counted at the gate and rarely again.
Shuttering is not consumed, it is reused. Plywood sheets, props and steel plates have a planned number of cycles. Sites push past that number, then write off the loss in one go at handover.
Track shuttering as issued stock with a return date, not as a purchase. A sheet that does not come back should raise a question the same week.
- Gate count of bags against store receipt
- Slump test and mix ratio for each pour
- Challan volume against formwork volume
- Reuse count for each set of plywood and props
What the site record must lock
The record has to fix a few fields at the moment of issue, not afterwards. Every issue slip carries the activity code, the element or pour, the gang and the person who took the material. Without those, wastage cannot be told apart from theft or misposting.
Add a wastage entry as its own transaction. Offcuts, broken bags and rejected concrete are booked with a reason. Wastage written openly is a number you can manage, while wastage hidden in the issue is an argument.
Stop edits on closed days. Once the store keeper signs a day, a change should leave a trail. A software build for a construction firm can enforce all this on a phone at the store window.
Run a monthly variance, one activity at a time
Do not reconcile the whole site at once. Pick one activity, such as the first floor slab, and line up four numbers: BOQ quantity, issued quantity, recorded wastage and billed quantity. The leftover is the unexplained part.
Review it with the site engineer and the store keeper in the same room. Short meetings work, and the question is always the same. Where did the difference go, and who signed for it?
Next month, add a second activity. In a quarter you have a wastage norm for steel, cement and shuttering drawn from your own sites, which beats any handbook figure.
Material variance sheet by activity
Each activity takes one row on a single-page worksheet. Columns hold BOQ quantity, purchase order quantity, goods receipt quantity, issued quantity, recorded wastage, billed quantity and unexplained balance. A second block lists issue slips missing an activity code, and a third block lists shuttering sets with issue date and return date.
Open a blank worksheet to printQuestions owners ask
Is some gap between BOQ and actual use normal?
Yes. Cutting loss, spillage and reuse limits are real. The aim is to record the gap with a reason, so a normal loss is separated from a leak.
Who should own the material record on site?
The store keeper enters it and the site engineer signs it. The project manager reviews variances. Splitting entry from approval stops one person from adjusting both sides.
Can Excel hold this reconciliation?
It can for one small site. It struggles when several sites, gangs and subcontractors issue material the same day, because edits go unrecorded and versions multiply.
How do we treat subcontractor material?
Book it as a separate stock owner. Free-issue material and the subcontractor’s own purchase should never mix, or the recovery in the running bill will be wrong.
