Monthly Stores Reconciliation

Construction sites are inventory-heavy — typical medium project (₹100 cr) carries ₹3-8 cr of materials in stores at any time: cement, steel, bricks, tiles, sanitary, electricals, paint, sealants. Each day, dozens of GRNs come in and dozens of MIRs go out.

Without monthly reconciliation, this flow has no closure: the bin card says 500 cement bags; physical count finds 450; the 50-bag gap could be: - Wastage (legitimate breakage) - Pilferage (theft) - Measurement error (delivery short) - Issue not recorded (informal supply to sub-contractor) - GRN posting error (received but not entered)

Without monthly closure, all these errors compound. By project end: - Material consumption ratios unreliable (estimate vs actual) - Sub-contractor recovery disputed - Cost-control reports inaccurate - Audit findings in statutory + internal audits - Project closure delayed by uncertain inventory

The Monthly Stores Reconciliation forces month-end closure: theoretical balance (computed) vs physical balance (counted); variance identified, investigated, and adjusted with approval.

Governed by ISO 9001:2015 Clauses 7.5 + 8.5 + CPWD Works Manual 2019 (Stores Section) + Ind AS 2 (Inventories) + CARO 2020 auditor reporting requirements.

Standard month-end reconciliation workflow:

Step 1 — Cut-off discipline: - Last day of month: no MIRs / GRNs after 5 PM - All pending paperwork completed before count - Open POs identified (material in transit) - Open MIRs identified (issued but not consumed)

Step 2 — Theoretical closing balance (computed): For each item:

Opening stock (Day 1 of month) = Previous month's closing + Receipts during month (sum of GRN quantities) − Issues during month (sum of MIR / Issue Voucher quantities) + Returns from site (Material Return Notes — MRN) − Returns to supplier (rejection / over-supply)

= Theoretical closing stock

This comes from bin card + ledger.

Step 3 — Physical verification: - Joint count: Storekeeper + Auditor (or Site Engineer) - Two-person count (one counts, other verifies) - Bag count for bagged materials - Weight check for steel (random bundles) - Volume / number for other items - Done in last 2-3 days of month - Bin cards posted current to count date - Physical count recorded item-wise

Step 4 — Variance computation: - Item-wise: Physical − Theoretical = Variance - Variance % = (Variance ÷ Theoretical) × 100 - Value variance = Variance × Unit cost - Categorise: - Within tolerance: ≤ 1-2% (typical industry); no action - Investigate: 2-5%; track cause - NCR / Action: > 5%; formal investigation + corrective action

Step 5 — Variance analysis (for each significant variance): - Wastage: industry-norm 3-5% for cement, 3% steel, 5% bricks, 5-10% tiles, 10-15% paint - Pilferage: investigate; CCTV review; entry / exit log; gate-pass audit - Measurement error: GRN had wrong qty; corrective entry - Issue not recorded: informal verbal issue; storekeeper accountability - Damage: material damaged in storage (water leak, fire); insurance claim - Mis-storage: item physically present but logged elsewhere; reconcile

Step 6 — Adjustment entries: - Wastage adjustment (PM approval, within delegation) - Pilferage write-off (PM + HO approval, accountability action) - Damage adjustment (insurance claim filed) - All adjustments documented with reasons + approvals - Posted to next month's opening stock

Step 7 — Sign-off + reporting: - Storekeeper signs - Site Engineer verifies - Project Manager approves - Monthly report to HO - Filed for audit - KPIs tracked: total wastage %, pilferage cases, recurring items

Cost-control linkage: - Reconciled consumption × unit cost = monthly material cost - Cross-check with cost-control report - Identify cost overruns by item - Feed into project P&L

1. No cut-off — MIRs back-dated to fit pre-count narrative; reconciliation becomes fiction.

2. Storekeeper alone counts — single-person count; no independent verification; collusion possible.

3. Bin cards not posted current — count on Aug 30; cards posted to Aug 25; 5 days of movement missed.

4. Cement bag weight assumed — should be 50 kg; actually 47-48 kg (under-filled by supplier); reconciliation off; investigate at GRN stage instead.

5. Steel weight by piece count — 16 mm bar nominal 1.580 kg/m × 12 m × 100 nos = 1,896 kg expected; actual 1,820 kg; 4% under-weight; ₹ lakhs over project.

6. No physical count for bulky items — sand / aggregate counted by truck-load; actually 5-8 m³ per truck not 8 m³; under-supply.

7. Variance accepted without investigation — "some wastage normal"; pilferage hidden as wastage.

8. Returns not tracked separately — items returned by site (excess / damaged); become opaque adjustments.

9. Sub-contractor's material mixed with main — sub-con steel kept separately on paper, mixed in physical stack; reconciliation impossible.

10. No mid-month spot count — only month-end count; gap could have been detected earlier.

11. Adjustments without PM approval — storekeeper does on his own to close month; later audit finding.

12. Pilferage written off as wastage — no investigation; theft becomes recurring.

13. Period-end pressure — month-end rush; counts hurried; errors injected.

14. Computerised system not used — manual register + spreadsheet; errors accumulate.

15. No KPI tracking — reconciliation done but no trends analysed; recurring issues not identified.

16. No closure with site engineer / PM — storekeeper signs alone; no triangulation.

Companion formats: - Stores Bin Card (FMT-STR-003) — daily item movement - Stores Ledger (FMT-STR-004) — master inventory - Material Receipt Note (FMT-STR-001) — GRN - MIR / Indent (FMT-STR-002) - Material Test Report (FMT-STR-005) - Cement Consumption Register (FMT-STR-007) - Steel Consumption Register (FMT-STR-008) - Material Expediting Log (PMC-PRC-LOG-009) — incoming - Cost Control Report (PMC-BIL-LOG-004) — cost-side

Standards + references: - ISO 9001:2015 Clause 7.5 — Documented information - ISO 9001:2015 Clause 8.5.1 — Control of production - Indian Accounting Standard 2 (Ind AS 2) / AS 2 — Inventories - CARO 2020 — Companies (Auditor's Report) Order, Clause iii(b) (inventory) - CPWD Works Manual 2019 — Section on Stores Accounting - State PWD Codes / Manuals — store-keeping procedures - GST Act 2017 — Stock register requirements for tax - Companies Act 2013 Sec 128 + 129 — Accounts + Inventory disclosure - NABL Audit — for projects requiring quality + inventory traceability