Reconcile site material before calling the difference wastage

Illustrative example: a civil contractor reconciles its own steel in one site store at 6 p.m. on 30 September. All quantities below are tonnes. There are no transfers in this first calculation, and the opening balance was previously agreed.

The 2 tonnes are a stores variance. They are not yet a consumption loss. Check whether the count covered the same locations and material grades, whether a late receipt entered the ledger, and whether a dispatch awaiting acknowledgement was treated consistently.

Suppose a 2-tonne transfer left this store before cutoff and reached another project the next morning. If its dispatch record was omitted, correcting that record changes this store’s expected balance from 35 to 33 tonnes. The receiving project should recognise the agreed in-transit position rather than invent an early receipt. The company still has to reconcile the transfer, but the evidence no longer supports calling it missing steel.

The 120 tonnes issued in the example belong in a second reconciliation. They have left the store, but may be installed, unused with the subcontractor, returned, cut into reusable pieces or classified as scrap.

For this part of the example, assume the subcontractor started September with no material in custody and had no direct receipts or transfers from other work fronts. After the 5-tonne return, net issues are 115 tonnes. Approved measurement supports 108 tonnes installed during September, the closing count identifies 4 tonnes unused, and 2 tonnes of scrap are physically verified. That accounts for 114 tonnes and leaves 1 tonne unresolved. This is a different exception from the earlier 2-tonne stores shortfall.

On an operating project, carry opening work-front stock into the calculation. The quantity to explain is opening custody plus issues, direct receipts and transfers in, less acknowledged returns and transfers out. Compare that with installation during the period, closing stock and other evidenced destinations. Omitting opening custody, or comparing one month's issues with installation since the project began, produces a meaningless residual.

The quantity surveyor should explain the installed basis: the approved drawing and bar bending schedule where relevant, their revisions, the measured work and any agreed conversion. A theoretical quantity and a weighbridge quantity may have different measurement bases. Record that difference before interpreting the residual.

For steel with recoverable lengths, use a separate offcut reconciliation. For material owned by the client, keep the owner and subcontractor balance separate from contractor-owned stock.

A useful site material balance needs more than a date and quantity. Each row should identify the item and grade, stock unit, owner, source and destination, transaction reference, physical movement time, entry time and acknowledgement. For a return, link the original issue where practical. For a transfer, use one reference visible at both ends.

This is a reason to preserve movement types in software. ERPNext documents separate receipt, issue and transfer purposes. That is a product capability example; the project still needs to decide how ownership, subcontractor custody and acceptance status will be represented.

Avoid a single “site stock” bucket that mixes main stores, work fronts and material in transit. Equally, avoid creating so many locations that the storekeeper cannot record a movement accurately. Choose boundaries that someone can physically count and accept responsibility for.

Units deserve the same discipline. If procurement buys bags, stores issues bags and the consumption calculation uses tonnes, retain the original quantity and the approved conversion. Do not silently apply one conversion across different materials or package sizes.

Begin with the least interpretive checks: arithmetic, duplicate references, unit conversions and cutoff. Next check missing receipts, returns and transfers. Then inspect stock held outside the main store. Only then examine the installed quantity and classification of remnants, damage or scrap.

If movements continue during counting, record them against the count time and reconcile each location to the agreed cutoff. A recount should resolve a doubtful observation before anyone posts an adjustment. Held or damaged stock still physically present needs its own status; leaving it out of the count does not make it disappear from custody.

An exception register can be small: material, quantity, location, reason under investigation, supporting references, owner, due date and decision. “Pending subcontractor confirmation” is more useful than “adjustment required”, because it identifies the next action.

Stores should own movement completeness and the count. The site engineer and QS should validate the work and consumption basis. Finance should approve the accounting treatment under company policy. Commercial should separately approve any recovery using the executed contract and agreed evidence. The same person may hold more than one role on a small project, but the decisions should remain distinguishable.

The Department of Expenditure’s works manual addresses material and works reconciliation within contract closure. Its section 7.6.3 is public-works guidance within that manual’s scope; it does not establish a universal private-project loss allowance. Use the project’s actual terms for recoveries.

A controlled spreadsheet can work for a limited number of items and movements if one owner protects formulas, records revisions and reconciles source documents. A site inventory application becomes more useful when multiple people capture issues and returns or several stores exchange material. An ERP extension matters when the operational balance must also reconcile to project costing and financial records.

The acceptance test is the same for all three: can another reviewer reproduce the closing balance, identify where an unresolved quantity sits and trace an adjustment to its approval? A dashboard showing zero variance is weak evidence if users can overwrite the opening balance to achieve it.

Track unresolved quantity by material and owner, its age, and the share of adjustments with complete evidence. Do not add tonnes of steel to bags of cement to create one quantity KPI. A value view can help prioritise investigation, provided finance supplies a consistent valuation basis.

A useful reconciliation leaves fewer ambiguous quantities. It may reveal an omitted transfer, an unrecorded return or a genuine loss, but those outcomes require different corrections. Preserving that distinction makes the next bill and the next material order easier to defend.

1. Select one high-value material and agree the owner, locations, unit and cutoff.
2. Rebuild the stores balance from opening stock and identifiable movements.
3. Reconcile opening work-front custody and period movements to period installation, closing stock and evidenced scrap, without subtracting returns twice.
4. Assign each residual to an investigator and retain the eventual approval.
5. If the same recording gaps recur, use the inventory-system evaluation to decide what needs to change.