TDS Calculation in Excel for FY 2026-27: Complete Sections 192, 194C, 194J Guide & Formulas

Automating TDS Deductions in Excel for Financial Year 2026-27

Tax Deducted at Source (TDS) under the Indian Income Tax Act requires finance and accounts departments to deduct appropriate tax percentages before remitting payments to vendors, contractors, and employees. Automating TDS deduction logic in Excel avoids costly interest penalties under Section 201(1A) and late filing fees under Section 234E.

Key TDS Sections & Rates Matrix (FY 2026-27)

• Section 194C (Payments to Contractors): 1% for Individuals/HUF; 2% for Companies and Partnership Firms. Threshold: Single bill > ₹30,000 or aggregate annual payment > ₹1,00,000.
• Section 194J (Fees for Professional & Technical Services): 2% for Technical services/call center operators; 10% for Professional fees/royalty. Threshold: ₹30,000 per financial year.
• Section 194H (Commission or Brokerage): 5% with an annual threshold limit of ₹15,000.
• Section 194I (Rent): 2% for Plant & Machinery; 10% for Land, Building, or Furniture. Threshold: ₹2,40,000 per annum.
• Section 206AA (Higher Deduction): 20% flat if valid PAN is not furnished by the deductee.

Excel Formula: Automated Section 194C Calculation with Threshold Tracker

To accurately calculate TDS while tracking the ₹1,00,000 cumulative limit across multiple invoices in an accounts payable register:

=LET(
    pan_valid, ISNUMBER(MATCH(LEN(TRIM(D2)), {10}, 0)),
    entity_type, UPPER(TRIM(E2)),
    invoice_amt, F2,
    cumulative_amt, SUMIFS(F$2:F2, C$2:C2, C2),
    rate, IF(NOT(pan_valid), 0.20, IF(entity_type="INDIVIDUAL", 0.01, 0.02)),
    IF(OR(invoice_amt > 30000, cumulative_amt > 100000), invoice_amt * rate, 0)
)

Section 192: Salary TDS Calculation under New vs Old Regime

When calculating monthly TDS for payroll under Section 192, default employee taxation to the revised New Tax Regime slab rules while allowing standard deduction adjustments (₹75,000 standard deduction under the Finance Act updates):

=LET(
    taxable_inc, MAX(0, Gross_Salary - Standard_Deduction),
    tax, IFS(
        taxable_inc <= 300000, 0,
        taxable_inc <= 700000, (taxable_inc - 300000) * 0.05,
        taxable_inc <= 1000000, 20000 + (taxable_inc - 700000) * 0.10,
        taxable_inc <= 1200000, 50000 + (taxable_inc - 1000000) * 0.15,
        taxable_inc <= 1500000, 80000 + (taxable_inc - 1200000) * 0.20,
        TRUE, 140000 + (taxable_inc - 1500000) * 0.30
    ),
    rebate, IF(taxable_inc <= 700000, tax, 0),
    net_tax, tax - rebate,
    cess, net_tax * 0.04,
    annual_tds, net_tax + cess,
    annual_tds / Remaining_Months
)

For instant comparative calculations, test your salary breakdowns using our free interactive Income Tax Calculator and reference our Old vs New Tax Regime guide.