📍 When to use this template
- Each RA bill processing.
- Final bill computation.
- Tax + audit reconciliation.
- Dispute resolution on payments.
Sections & fields
Preview of the template structure. Download Excel to fill on site.
1Bill Header4 fields
RA Bill Number + Date
_____________
Gross Bill Value (Before Deductions)
_____________
Cumulative Bill Value to Date
_____________
Period Covered
_____________
2Deduction Breakup11 fields
Retention (5-10 % typical, per contract)
_____________
Mobilisation Advance Recovery
_____________
Plant Advance Recovery (if applicable)
_____________
Material Advance Recovery
_____________
Liquidated Damages (LD)
_____________
Performance Penalty (Quality / Safety)
_____________
VO Negative Adjustment
_____________
Income Tax TDS (1-2 % typical)
_____________
GST TDS / TCS
_____________
PF + ESI Contributions
_____________
Insurance + BG Deductions
_____________
3Recovery Schedule5 fields
Recovery Item
_____________
Cumulative Recoverable
_____________
Recovered This Bill
_____________
Cumulative Recovered
_____________
4Net Payable5 fields
Total Deductions
_____________
Net Payable Amount
_____________
Payment Due Date
_____________
Mode of Payment (Bank Transfer / Cheque)
_____________
Cheque / Reference Number
_____________
💡 Sample filled excerpt
RA #15, May 2026. Gross: ₹2.5 cr. Deductions: Retention 10 % = ₹25 lakh, Mob Advance Recovery 1 % = ₹2.5 lakh, TDS 1 % = ₹2.5 lakh, GST TCS = ₹1.25 lakh, Other 0.5 % = ₹1.25 lakh. Total deductions: ₹32.5 lakh. Net Payable: ₹2.175 cr.
⚖ Compliance notes
- Per FIDIC Sub-clause 14.6, deductions must be itemised + transparent.
- TDS rates: 1 % for individual/HUF, 2 % for others (under sec 194C of Income Tax Act).
- GST: TCS 1 % under section 51 GST Act for government deductors.
- Retention typically 5-10 % of bill value, released 50 % at substantial completion + 50 % at DLP expiry.
- LD per contract: usually capped at 5-10 % of contract value; daily LD rate specified.