Subcontractor RA Bill Format in Excel: What to Include (And What to Do After)
A clear breakdown of the standard subcontractor RA bill format used by Indian civil contractors — key sections, common mistakes, and how to protect your margins once the bill is approved.
Honest answer first: Construct Daily does not generate CPWD/PWD RA bills. For that, use Excel — it's the industry standard and it works. But once your bill is approved and the subcontractor starts work, that is exactly where most contractors start losing money. Missed bhatta payments, wrong head-counts, petty cash with no record. That's what we fix.
The Standard RA Bill Format (For Your Excel Sheet)
A Running Account (RA) bill is a cumulative, periodic payment claim submitted by the subcontractor for work completed to date. To meet CPWD/PWD requirements, your Excel format must include these sections:
| Section | Details Required | Why It Matters |
|---|---|---|
| Header | Project name, work order number, billing period | Identifies the contract and timeframe. |
| Bill Abstract | Gross value, secured advances, price escalations | High-level summary of the claim. |
| Measurement Sheet | UOM, BOQ vs Actual Quantity, Rate, Total Amount | The core itemized breakdown of work. |
| Deductions | Retention money, TDS, recoveries (diesel/water) | Statutory and site-level deductions. |
| Net Payable | Final calculated amount | The exact figure requested for release. |
Where the Real Bleeding Starts — After the Bill Is Approved
The RA bill gets your subcontractor paid. But the profit erosion happens on site, every single day, in the gaps your Excel sheet never captures:
- Bhatta and daily wages with no record: You pay your labour team in cash every evening. By end of month, you have no idea what was paid to whom, or whether the headcount was right.
- Petty cash with no audit trail: ₹500 for diesel, ₹300 for cement bags — small amounts that vanish without receipts. Over a 6-month project, this adds up to lakhs.
- Vendor dues you forget about: Your material supplier bills you every 15 days. Without a running ledger, you don't know what you owe until they stop delivering.
Use Excel for the RA Bill. Use Construct Daily for Everything After.
Once the tender is approved and work begins, Construct Daily tracks daily labour attendance, bhatta payments, petty cash expenses, and vendor dues — all from your phone. So you don't bleed out the profit you just quoted.
Start Free →