BOQ Builder·Auto-BOQ from dimensions, DSR ratesNEWBidEasy·Government tenders, searchableLIVEInfraLens App·Free on Play Store, offline-readyNEW
PMC📦 Procurement & StoresMaterial Reconciliation Register

Material Reconciliation Register

register
PMC-PRC-REG-009·v1.0-beta·⚠ Beta — review before use

Periodic reconciliation of materials — receipt vs consumption + balance + theoretical usage per BOQ. Detects pilferage, wastage, mix-ups. Key tool for cost + quality control.

ReferencesCPWD Works Manual 2019 (Stores Accounting)Project Quality + Stores ProcedureISO 9001:2015
Download
📍 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
_____________
Prepared By
_____________
Reviewed By
_____________
Approved By
_____________
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)
_____________
% Variance
_____________
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
_____________
Owner
_____________
Target Resolution Date
_____________
Status
_____________
💡 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.

Engineer's Notes — Material Reconciliation Register

Why Material Reconciliation matters

Material costs are typically 40-55% of construction project budget. Even modest material accounting gaps (5-10% slippage) translate to lakhs of rupees lost per project. Material Reconciliation is the systematic process of comparing what was procured vs what was issued vs what was physically present vs what was actually consumed.

Reconciliation should match: Opening Stock + Procurement = Issues + Closing Stock. And: Issued material = Material at site or in store + Material consumed in work. Any gap = pilferage, mis-counting, lost / damaged, unrecorded consumption, or wastage beyond tolerance.

For Indian government / PWD projects, CPWD Works Manual Chapter 9 mandates monthly reconciliation. For private projects following ISO 9001 or contractual quality requirements, periodic reconciliation is standard practice.

How reconciliation works

Cycle: monthly (typical) or weekly (for high-value materials like cement, steel):

Inputs: - Inward total per material (from Stores Inward Register / FMT-STR-009) - Issues total per material (from Issue Vouchers / FMT-STR-003) - Returns total (from Material Returns Notes / FMT-STR-004) - Physical stock (from Bin Cards / FMT-STR-005 + physical count) - Activity consumption (from BBS for steel; per-m² norms for cement / sand / aggregates)

Calculations: - Opening stock + Net Inward (Inward − Returns) = Total Available - Total Available − Closing Stock = Issued - Issued − Activity Consumption = Gap (wastage / pilferage / unaccounted)

Tolerance limits (industry-typical): - Cement: 2-5% gap (sometimes higher for early in project) - Sand: 3-5% (variable; some bulking) - Coarse aggregates: 3-5% - Steel: 2-3% (lowest tolerance due to high cost + theft potential) - Other materials: 5-10%

Investigation when gap exceeds tolerance: - Look for unrecorded transactions (missing vouchers) - Verify physical stock count by independent party - Check for double-counting (same lot received twice) - Investigate suspected pilferage - Review BBS / consumption norms (may be wrong)

Common reconciliation failures

1. Reconciliation skipped during execution — only done at project end → impossible to identify issues + recover.

2. Different BBS / consumption norms — site team's norms differ from contractor's commercial norms → reconciliation always shows large gap.

3. Inadequate physical stock counts — counted by site team alone (no independent verification); double-counted or under-counted intentionally.

4. Sub-contractor materials not tracked — main contractor's stores tracked but subcontractors' own materials uncontrolled.

5. No follow-up on findings — reconciliation shows gap; nobody investigates; trend continues.

6. Wrong opening stock — error in initial inventory cascades through subsequent reconciliations.

7. Returns not netted — material returned to supplier still showing as 'consumed' in reconciliation → inflated apparent consumption.

8. No closure / final reconciliation — at project close, no formal closure; final asset writeoffs lost in commercial chaos.

Cross-references

Companion formats: - Stores Inward Register (FMT-STR-009) — material receipt log - Issue Voucher (FMT-STR-003) — material issued - Material Returns Note (FMT-STR-004) — returns to supplier - Bin Card (FMT-STR-005) — running stock card - Cement Consumption Register (FMT-STR-007) — cement-specific tracking

References: - CPWD Works Manual Chapter 9 — Stores Accounting (Indian government reference) - ISO 9001:2015 Clause 8.4 (control of externally provided processes) - Indian Contract Act 1872 — contract performance + material accountability - Internal company stores policy — typically aligned with above standards