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.
Template FAQ
Is the Contractor Payment Sheet free to download?
Yes. The .xlsx file is free with no sign-up. It opens in Excel, Google Sheets and LibreOffice.
What columns does the Contractor Payment Sheet include?
Contractor, Work order, RA bill no., Bill date, Gross bill (₹), Retention 5% (₹), TDS 194C 1% (₹), Advance recovery (₹), Other deductions (₹), Net payable (₹), Paid (₹), Balance (₹).
Which columns are calculated automatically?
Retention 5% (₹), TDS 194C 1% (₹), Net payable (₹), Balance (₹) are filled by formulas, so you only enter the other columns. Formulas stay visible so you can audit or change them.
When should I move from this spreadsheet to Construction ERP?
Use the spreadsheet while one person maintains it. Move to construction ERP software when several people need to update it, you need approvals and history, or the numbers must post to GST accounting and reports automatically.
Related tools and templates
Construction Profit Calculator
Free contractor profit calculator for Indian construction projects: contract value vs material, labour, subcontract, equipment and overheads, with margin %, cost breakdown and retention — formula and worked example included.
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 BOQ format in Excel for construction: bill of quantities template with item no., description, unit, quantity, rate and amount, 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 →