How to reconcile construction site material every month
Published 23 October 2026. 6 min read.
Every site loses some material. The question at month end is whether you can explain where it went. A material reconciliation compares what your records say should be on site with what is physically there, then asks whether the material used matches the work done. Done every month, it takes a few hours per site and catches problems while the people involved still remember what happened.
The stock equation
For each material, over the month:
Opening stock + received + transferred in − used − transferred out − returned to supplier = book closing stock
Then count what is physically on site. The difference between the physical count and the book closing stock is your variance. A shortfall means material left the site without a record. An excess usually means a receipt was entered twice or consumption was over-booked.
Two rules make the equation work. First, opening stock is last month’s physical count, not last month’s book figure; otherwise old errors carry forward for ever. Second, every term uses the same unit. Cement stocked in bags stays in bags. If a supplier bills in tonnes, convert at 50 kg a bag (20 bags a tonne) before you enter it.
Where each number comes from
| Term | Source document | What to watch |
|---|---|---|
| Opening stock | Last month’s signed physical count sheet | Use the count, not the book figure |
| Received | Goods receipt notes (GRNs) against the purchase order, delivery challan or bill | Take the quantity that arrived, not the quantity billed |
| Transferred in | Transfer slips from the central store or another site | The sender must show the same quantity going out |
| Used | Issue slips, the daily material register, pour records, bar bending schedules | Consumption booked late is the most common gap |
| Transferred out | Transfer slips signed by the receiving site | Handwritten slips that never get entered |
| Returned to supplier | Return challans, with the supplier’s credit note | Material sent back on the supplier’s truck with no paperwork |
Purchase orders do not enter the equation, but they are the check on receipts. A GRN for more than the PO quantity needs an explanation before it is accepted.
A worked example: cement and TMT steel
Here is October for a residential site. The physical count was taken on 31 October after work stopped for the day.
| Term | Cement (bags) | TMT steel (tonnes) |
|---|---|---|
| Opening stock (count on 30 September) | 420 | 18.450 |
| Received (GRNs) | +2,400 | +42.300 |
| Transferred in from central store | +150 | 0 |
| Used (booked) | −2,280 | −47.800 |
| Transferred out to another site | −200 | −3.200 |
| Returned to supplier | −50 | 0 |
| Book closing stock | 440 | 9.750 |
| Physical count | 402 | 9.180 |
| Variance | −38 | −0.570 |
Step 1: explain the variance before you call it a loss
The store keeper and site engineer went through the month’s slips. For cement, 25 bags issued to the plastering gang on 30 October had never been entered as used. That leaves 13 bags nobody can explain. For steel, a handwritten slip showed 0.480 tonnes (480 kg) sent to another site on 28 October that was never entered as a transfer. The remaining 0.090 tonnes (90 kg) is within the accuracy of estimating loose bars by count and weight per metre.
Enter the missed records with the dates they actually happened. Only what remains unexplained, the 13 bags and the 90 kg of steel, becomes a stock adjustment, with a written reason and approval from someone senior who does not run the site.
Step 2: compare consumption with the work done
A clean book can still hide waste. Ask the site engineer for the theoretical quantity: the work measured this month multiplied by the consumption your mix designs or estimates allow. Say October’s concrete, blockwork and plaster should have needed 2,230 bags.
Actual consumption, including the late entry and the 13 lost bags, was 2,280 + 25 + 13 = 2,318 bags. That is 88 bags, about 3.9%, above theoretical.
Suppose your company allows 2% over theoretical for cement. That figure is a placeholder for this example; replace it with the allowance in your contract, specification or internal norms. Two per cent of 2,230 is about 45 bags, so 43 bags are excess. At ₹380 a bag, that is ₹16,340 of cement the site should be able to account for.
Do the same for steel using the bar bending schedule: the theoretical weight of bars placed against the weight issued. Weigh scrap and offcuts and record them. They are part of the answer, and they have resale value.
Judging acceptable wastage
There is no single wastage figure that fits every site. Where the client supplies cement or steel, the contract often states a permitted variation and how excess consumption will be recovered. Where you buy the material yourself, your company sets its own norms, and they should vary with the type of work, how material is handled and how far it travels on site.
Write down the allowance for each major material before the month starts, so the month-end discussion is about numbers, not opinions. Then watch the trend as much as the figure. A site that runs at 1% one month and 6% the next has a problem, even if the average looks fine.
Common causes of variance
- Short supply accepted. The challan says 500 bags, 480 came off the truck and someone signed for 500. Count while unloading and receive only what arrived. For steel, note whether the bill uses weighbridge weight or theoretical section weight, because the two can differ.
- Unrecorded transfers. Material lent to the next site “for two days” and never written down.
- Consumption not booked. Material issued late in the day or on a Sunday that waits for an entry that never comes.
- Measurement errors. Sand and aggregate bought by the brass (100 cubic feet, about 2.83 m³) in a truck body that was not full; steel counted by bundle after bundles were opened; torn or part-used cement bags counted as full.
- Damage not written off. Cement that set after rain, bags burst while unloading, bars bent beyond use.
- Theft. Usually small and regular rather than one large loss. Watch whatever is easy to resell: cement, steel offcuts, binding wire, cable, fittings.
- Unit mistakes. A receipt entered in tonnes against a material stocked in bags, or in kg against one stocked in tonnes.
Monthly checklist
- Fix the cut-off: the last working day, after work stops. No movements during the count.
- Enter every pending GRN, transfer slip, issue slip and return before counting.
- Count with two people: the store keeper and someone who does not report to the store keeper. Count stack by stack and sign the sheet.
- Check that every transfer appears at both ends with the same quantity.
- Work out book closing stock for each material and the variance against the count.
- Investigate every variance above your threshold before writing anything off, and enter missed records with their real dates.
- Adjust only the unexplained remainder, with a reason and approval from outside the site.
- Compare consumption with theoretical quantities for cement, steel and other high-value materials.
- Carry the signed physical count forward as next month’s opening stock.
- Keep a one-page summary per site: material, variance, explanation, value and action taken.
Where software helps
Most of this routine is chasing paper. If your stock is kept in BuildAura’s inventory module, the terms of the equation come from records the site already makes: goods received against a purchase order, challan or bill, with a check that stops more being received than was ordered; transfers between the central warehouse and sites; material used entries; and a movement history for each material. Stock adjustments need a reason and an approval, which is step 7 above. Requests, orders and receipts sit together in procurement.