Free download, CSV for Excel
Abstract of cost template for contractors
The abstract of cost for a running account bill: every BOQ item with its up-to-date, previous and this-bill quantities and the amount for this bill.
Columns and filled rows
All 9 columns, filled from one work order so the arithmetic can be checked. The download opens in Excel, Google Sheets or LibreOffice.
| Item no | Description | Unit | BOQ qty | Rate (₹) | Up-to-date qty | Previous qty | This bill qty | This bill amount (₹) |
|---|---|---|---|---|---|---|---|---|
| 1.1 | Earthwork in excavation, foundation | cum | 1,240 | 248.50 | 1,186.4 | 1,021.1 | 165.3 | 41,077.05 |
| 2.3 | PCC 1:4:8, 40 mm aggregate | cum | 104 | 6,412.00 | 96.25 | 82 | 14.25 | 91,371.00 |
| 3.2 | RCC M25 in slabs and beams | cum | 468 | 8,965.00 | 412.8 | 338.6 | 74.2 | 6,65,203.00 |
| 4.1 | Reinforcement, Fe 500D | kg | 56,000 | 78.40 | 52,860 | 43,115 | 9,745 | 7,64,008.00 |
| 5.4 | Brickwork 1:6, superstructure | cum | 230 | 7,120.00 | 188.4 | 151.9 | 36.5 | 2,59,880.00 |
| 6.1 | 12 mm cement plaster 1:6 | sqm | 3,900 | 342.00 | 2,410 | 1,640 | 770 | 2,63,340.00 |
| Value of work done, this bill | 20,84,879.05 |
When the abstract of cost is used
Every RA bill. The abstract is the first page the client's engineer reads, and every other sheet in the bill package refers back to its item numbers.
- Never type the previous quantity. Copy it from the up-to-date column of the last certified bill, not the last bill you submitted.
- This bill quantity is always up-to-date minus previous. If it comes out negative, a measurement was withdrawn and needs a note.
- Keep the BOQ quantity column, so items running over BOQ show up before the client's engineer finds them.
3.2RCC M25 in slabs, 74.20 cumQuery
Executive Engineer · 2 Nov, 11:05
Slab S3 depth reads 150 mm. Drawing S-104 shows 125 mm. Please confirm.
Site engineer · 2 Nov, 11:40
Revised drawing S-104 R2, 14 Sept, attached with the measurement photo.
Certify 74.20 cumCertify partHold