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.

Related tools and templates