📍 When to use this template
- Monthly for major materials (cement, steel, aggregates).
- Quarterly for minor materials.
- At handover for final reconciliation.
- Audit + dispute resolution.
Sections & fields
Preview of the template structure. Download Excel to fill on site.
1Reconciliation Header5 fields
Reconciliation Period
_____________
Project Reference
_____________
2Material-wise Reconciliation10 fields
Material Name
_____________
Opening Balance (Stock + Quantity)
_____________
Receipts During Period (qty + value)
_____________
Consumption per Site Records (qty)
_____________
Closing Balance (Physical Count)
_____________
Theoretical Consumption (from BOQ × Quantity Done)
_____________
Variance (Actual − Theoretical)
_____________
Acceptable Wastage % (per IS / project)
_____________
Excess Wastage (if any) — Action
_____________
3High-value Item Detail7 fields
Item (e.g., Cement / TMT Steel / Diesel)
_____________
Cumulative Receipts
_____________
Cumulative Consumption
_____________
Cumulative BOQ Theoretical
_____________
Cumulative Variance
_____________
Trend (Increasing / Stable / Decreasing)
_____________
Root Cause Analysis
_____________
4Corrective Actions5 fields
Issue Identified
_____________
Action Required
_____________
Target Resolution Date
_____________
💡 Sample filled excerpt
Period: May 2026. Cement: 1,250 MT received, 1,180 MT consumed, 50 MT stock. BOQ theoretical: 1,150 MT. Variance: +30 MT (2.6 %) — acceptable (within 3 % wastage per IS norms). TMT Steel: variance 4.2 % — investigation underway (possible site cutting + theft).
⚖ Compliance notes
- Acceptable wastage % varies by material — IS specifications + project drawings define norms.
- Common wastage benchmarks: Cement 2-3 %, Steel 3-5 %, Aggregates 5-7 %, Tiles 5-10 %.
- Cumulative wastage > 5 % typically requires investigation + root-cause analysis.
- Material reconciliation feeds into final accounts + closeout reconciliation.
- CPWD Works Manual Chapter 9 (Stores Accounting) is the reference for Indian projects.