Construction Material Stock Register
Template in Excel & Interactive Calculator
Track cement, steel, sand, and aggregates across job sites. Calculate daily opening stock, received challans, site consumption, and closing balances with our free interactive tool and downloadable template.
Stock Balance Calculator
Quickly verify daily closing stock and theoretical consumption for any site material.
Standard Register Columns
Pre-formatted layout included in the download| Date | Material Item | Unit | Opening | Inward | Challan No | Consumed | Closing |
|---|---|---|---|---|---|---|---|
| 01-Oct | Cement (PPC) | Bags | 150 | +200 | CH-8901 | -120 | 230 |
| 01-Oct | TMT Steel 12mm | MT | 4.5 | +5.0 | WB-4412 | -2.2 | 7.3 |
| 01-Oct | River Sand | Brass | 8.0 | +10.0 | CH-112 | -5.0 | 13.0 |
| 01-Oct | Red Bricks | Nos | 5,000 | 0 | - | -1,200 | 3,800 |
Want to eliminate paper challan registers completely?
Explore HajariBook Material Management AppBest Practices for Construction Material Stock Registers
1. Why Construction Sites Suffer 5% - 15% Material Losses
Building sites lose millions in steel, cement, and aggregates every year through unrecorded deliveries, poor batching reconciliation, double-billed vendor challans, and theft during transit or off-hours. A disciplined daily stock register stops these leakages by establishing clear accountability.
2. The 4 Essential Golden Rules of Site Inventory
- Photo-Verify Every Challan: Never accept a delivery truck without stamping the driver's challan and recording the weighbridge ticket or bundle count.
- Record Task-Wise Consumption: Log consumed quantities against specific site activities (e.g. 120 bags for 3rd Floor Slab Casting) so project engineers can verify actual against theoretical quantity.
- Reconcile Daily Balances: Closing stock must be checked daily. Any unexpected drop triggers an immediate site inspection.
- Track Inter-Site Transfers: If steel is transported to a sister site, create an outbound dispatch slip immediately.
3. Upgrade to HajariBook Digital Material Tracking
While Excel spreadsheets help keep structured columns, they still require manual compilation at the end of each week. HajariBook's material tracking module lets supervisors snap delivery challans on their phones, logs daily consumption on site, and sends real-time stock registers straight to the builder's desktop dashboard.