Free download, CSV for Excel
Recovery schedule template for contractors
The recovery schedule of an RA bill, line by line from the value of work done to the net payable, with the basis and configured rate of each line.
Columns and filled rows
All 5 columns, filled from one work order so the arithmetic can be checked. The download opens in Excel, Google Sheets or LibreOffice.
| Line | Basis | Rate as configured for this contract | Add or less | Amount (₹) |
|---|---|---|---|---|
| Value of work done, this bill | Abstract of cost | 20,84,879 | ||
| Retention | Value of work done | 5% | Less | 1,04,244 |
| Mobilisation advance recovery | Recovery schedule in the contract | Fixed instalment | Less | 1,50,000 |
| Interest on mobilisation advance | Outstanding advance | As per contract | Less | 12,375 |
| Secured advance adjusted | Material consumed this bill | 75% of value | Less | 2,40,000 |
| Labour welfare cess | Value of work done | 1% | Less | 20,849 |
| Income-tax TDS | Value of work done | 2% | Less | 41,698 |
| GST TDS | Taxable value | 2% | Less | 41,698 |
| GST on the invoice | Taxable value | 18% | Add | 3,75,278 |
| Net payable | 18,49,293 |
When the recovery schedule is used
Every RA bill, after the abstract. It shows the client exactly how the net payable was worked out.
- Set each rate from the contract once, and never change it bill by bill without a reason.
- Round each line the way your client rounds it. A rupee of difference is enough to send a bill back.
- Recover the secured advance on the bill in which the material was used, not later.
Abstract of cost · RA Bill No. 7
| Description | This bill | Amount ₹ |
|---|---|---|
| Earthwork in excavation, foundationAll soils, lift up to 1.5 m | 165.30 | 41,077.05 |
| PCC 1:4:8, 40 mm aggregateIn foundation and plinth | 14.25 | 91,371.00 |
| RCC M25 in slabs and beamsUp to floor five | 74.20 | 6,65,203.00 |
| Reinforcement, Fe 500DCut, bent and placed | 9,745 | 7,64,008.00 |
| Brickwork 1:6, superstructureModular bricks | 36.50 | 2,59,880.00 |
| 12 mm cement plaster 1:6Internal walls | 770.00 | 2,63,340.00 |
Value of work done, this bill20,84,879.05Net payable after recoveries and GST18,49,293