Free download, CSV for Excel
Material reconciliation template for contractors
A reconciliation of client-issued steel or cement: issued, at site, consumed, theoretical consumption, the permitted variation and any recovery for excess.
Columns and filled rows
All 10 columns, filled from one work order so the arithmetic can be checked. The download opens in Excel, Google Sheets or LibreOffice.
| Material | Issued (MT) | At site (MT) | Consumed (MT) | Theoretical (MT) | Variation allowed | Allowed (MT) | Excess (MT) | Recovery rate (₹/MT) | Recovery (₹) |
|---|---|---|---|---|---|---|---|---|---|
| Fe 500D, 10 mm | 15.000 | 0.640 | 14.360 | 14.000 | 2.5% | 14.350 | 0.010 | 1,28,000.00 | 1,280.00 |
| Fe 500D, 16 mm | 30.000 | 0.700 | 29.300 | 29.115 | 2.5% | 29.843 | 0.000 | 1,28,000.00 | 0.00 |
| Total, as at RA 6 | 45.000 | 1.340 | 43.660 | 43.115 | 0.010 | 1,280.00 |
When the material reconciliation is used
When the client issues cement or steel to the contractor and recovers any consumption above the theoretical quantity, usually at a penal rate set in the contract.
- Theoretical consumption comes from the billed quantities: here 43,115 kg of reinforcement billed up to RA 6.
- Consumed is issued minus stock at site, verified jointly.
- Allowed is theoretical plus the variation in your contract: 14.000 x 1.025 = 14.350 MT.
- Value of work done, this bill20,84,879
- Retention, 5%- 1,04,244
- Mobilisation advance recovery- 1,50,000
- Interest on advance- 12,375
- Secured advance adjusted- 2,40,000
- Labour welfare cess, 1%- 20,849
- Income-tax TDS, 2%- 41,698
- GST TDS, 2%- 41,698
- GST on the invoice, 18%+ 3,75,278
- Recoveries, 7 lines- 6,10,864
- Net payable₹18,49,293