Free template

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.

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Columns marked “auto” are formulas.

Preview

ContractorWork orderRA bill no.Bill dateGross bill (₹)Retention 5% (₹)TDS 194C 1% (₹)Advance recovery (₹)Other deductions (₹)Net payable (₹)Paid (₹)Balance (₹)
Shree Ram BuildersWO-014RA-032026-09-108,45,000autoauto50,0000auto6,00,000auto
Kaur ElectricalsWO-021RA-012026-09-182,10,000autoauto05,000auto0auto

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