Free Excel format
RA bill format in Excel (free download)
Short answer
An RA bill format lists each BOQ item with agreement quantity, quantity billed before, this bill, up to date, rate and amount, then adds GST and takes off deductions. Download the sheet below; totals are already in formulas.
Preview
| Item no | Description | Unit | Agreement qty | Previous qty | This bill qty | Up to date qty | Rate (₹) | This bill (₹) | Up to date (₹) | % used |
|---|---|---|---|---|---|---|---|---|---|---|
| 1.1 | Earthwork in excavation for foundation (example) | cum | 850 | 0 | 200 | 200 | 310 | 62,000 | 62,000 | 23.5% |
| 1.2 | PCC 1:4:8 below footings (example) | cum | 95 | 0 | 14.58 | 14.58 | 5,600 | 81,648 | 81,648 | 15.3% |
| 2.1 | RCC M25 in footings and columns (example) | cum | 260 | 0 | 62.5 | 62.5 | 9,200 | 5,75,000 | 5,75,000 | 24% |
| … | your items |
Example rows from a sample project. Delete them and type your own.
What's inside
- Bill sheet with formulas for up-to-date quantity, amounts and % used
- GST, TDS, GST TDS, cess and security deposit with editable rates
- Net payable at the bottom
- 30 blank item rows ready to fill
Tired of copying previous quantities? PRIME ERP carries them forward on every bill. Start 14-day free trial
How to fill it
- Type the name of work, agreement number and bill number at the top.
- For each item, type the agreement quantity and rate once, then the previous quantity from your last bill and this bill’s measured quantity.
- Set the GST and deduction rates under the bill to match your agreement. Net payable works itself out.
Questions
What columns does an RA bill have?
Item number, description, unit, agreement quantity, previously billed quantity, this bill quantity, up-to-date quantity, rate, amount for this bill, up-to-date amount and percentage of agreement used.
Where does the previous quantity come from?
It is the up-to-date quantity of the same item on your last RA bill. Copy it across carefully: a mistake here repeats on every later bill.
Does the sheet apply the SOP 2018 rate cut?
No. If an item goes past 125% of agreement, change its rate for the extra quantity by hand, or use the free SOP 2018 rate cut calculator to work it out.
Can I change the deduction rates?
Yes. The GST, TDS, GST TDS, cess and security deposit rates sit in their own cells under the bill. Change them to match your agreement and the net payable follows.