Contractor Payment Sheet
Track every contractor RA bill with gross value, retention, TDS (194C), advance recovery and other deductions, and the net amount payable — so payments match the work order and nothing is paid twice.
Preview
| Contractor | Work order | RA bill no. | Bill date | Gross bill (₹) | Retention 5% (₹) | TDS 194C 1% (₹) | Advance recovery (₹) | Other deductions (₹) | Net payable (₹) | Paid (₹) | Balance (₹) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Shree Ram Builders | WO-014 | RA-03 | 2026-09-10 | 8,45,000 | auto | auto | 50,000 | 0 | auto | 6,00,000 | auto |
| Kaur Electricals | WO-021 | RA-01 | 2026-09-18 | 2,10,000 | auto | auto | 0 | 5,000 | auto | 0 | auto |
How to use this template
- TDS u/s 194C is 1% for individuals/HUF and 2% for others — change the rate per contractor.
- Release retention only after the defect liability period and a final measurement.
Related tools and templates
Construction Profit Calculator
Free construction project profit calculator: contract value vs material, labour, subcontract, equipment and overheads, with margin %, cost breakdown and retention impact.
Use calculator → Free toolProject Cost Calculator
Free project cost estimator: direct cost, overheads, contingency, target margin and GST to arrive at a quote value for construction and contracting jobs.
Use calculator → Free toolBOQ Calculator
Free online BOQ calculator: add items with unit, quantity and rate, get amounts, sub-total, GST and grand total, and export the bill of quantities to CSV.
Use calculator → TemplateConstruction BOQ Template
Free construction BOQ Excel template: item number, description, unit, quantity, rate and amount with section totals, GST and grand total.
Download → TemplateConstruction Project Budget Template
Free construction project budget template: budget, committed and actual cost by cost head, variance and percentage used, with totals.
Download →