Free download, CSV for Excel
Secured advance register template for contractors
A register of materials brought to site against which secured advance was paid, and how much of the advance is recovered as the material is used.
Columns and filled rows
All 11 columns, filled from one work order so the arithmetic can be checked. The download opens in Excel, Google Sheets or LibreOffice.
| Bill | Material | Unit | Qty brought to site | Rate (₹) | Value (₹) | Advance % | Advance paid (₹) | Qty used | Recovered (₹) | Balance (₹) |
|---|---|---|---|---|---|---|---|---|---|---|
| RA 6 | Cement, OPC 53, 50 kg bags | bags | 3,000 | 400.00 | 12,00,000.00 | 75% | 9,00,000.00 | 0 | 0.00 | 9,00,000.00 |
| RA 7 | Cement, OPC 53, 50 kg bags | bags | 0 | 400.00 | 0.00 | 75% | 0.00 | 800 | 2,40,000.00 | 6,60,000.00 |
When the secured advance register is used
When the contract pays a secured advance on non-perishable materials brought to site for use in the work.
- Recovery equals the quantity used times the rate times the advance percentage: 800 bags x ₹400 x 75% = ₹2,40,000.
- Work out quantity used from the items billed, not from the store issue register alone.
- Keep the material's site photos and invoices with the register; the advance is paid against them.
- 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