TDS & TCS Master Table for Tax Year 2026-27 – Free Excel with Instant Code Lookup Tool (New Sections 392, 393, 394)
Summary: The transition to the Income-tax Act, 2025 has brought significant restructuring of Tax Deducted at Source (TDS) and Tax Collected at Source (TCS) provisions, including changes in section numbering, forms, rates and thresholds. To assist tax professionals, accountants and businesses with compliance during Tax Year 2026-27, the author has prepared a free Excel-based TDS and TCS Master Table containing 91 entries, primarily covering the restructured provisions under Sections 392, 393 and 394. The workbook comprises four worksheets covering the master table, an instant four-digit code lookup tool, category-wise classification, and instructions and notes. It provides corresponding old and new section references, payment categories, unique codes, applicable rates, thresholds and form mapping. Users can filter transactions using different parameters, while colour coding identifies TCS transactions and non-resident payments. The instant lookup feature enables practitioners to retrieve relevant information without manually searching the entire master table. The utility can assist in TDS return preparation, determining deductibility, responding to client queries, training junior staff and mapping old provisions to the new statutory framework. The author also highlights specific considerations concerning overseas tour packages and form mapping. While designed to simplify day-to-day compliance, the workbook is not a substitute for statutory provisions. Users should independently verify applicable rates, thresholds and forms against the Income-tax Act, 2025, Finance Act, 2026 and relevant CBDT notifications before undertaking compliance.
- Free TDS and TCS Master Table Excel for Tax Year 2026-27
- Key Features of the TDS and TCS Excel Workbook
- 1. TDS Master Table
- 2. Instant Four-Digit Code Lookup Tool
- 3. Category-Wise TDS and TCS Classification
- 4. Instructions and Notes
- Practical Applications of the TDS and TCS Excel Utility
- Important Notes on TDS and TCS Rates, Thresholds and Forms
- Download Free TDS and TCS Master Table Excel for Tax Year 2026-27
Free TDS and TCS Master Table Excel for Tax Year 2026-27
The new income-tax framework has brought significant restructuring in TDS and TCS provisions. Sections have been renumbered, forms have changed, and several rates and thresholds have been updated. For tax professionals, accountants and businesses, finding the correct section, rate, threshold and applicable form quickly has become more important than ever.
To help the professional community, I have prepared a clean, practical and fully functional TDS Master Table Excel for Tax Year 2026-27, based on the restructured provisions (primarily under Sections 392, 393 and 394).
Key Features of the TDS and TCS Excel Workbook
The workbook has four useful sheets:
1. TDS Master Table
Complete list of 91 entries covering:
- New Section Reference
- Corresponding Old Section
- Unique Code
- Category / Heading
- Nature of Payment / Transaction
- Rate
- Threshold
- New Form
- Old Form
AutoFilter is enabled. You can instantly filter by category, rate, form or any other column. Colour coding is applied as follows:
- Orange rows: TCS transactions
- Purple rows: NRI / Non-resident payments
2. Instant Four-Digit Code Lookup Tool
Simply enter or select the 4-digit Code in the yellow cell.
All related details (New Section, Old Section, Category, Nature of Payment, Rate, Threshold, New Form and Old Form) automatically appear. There is no need to scroll through the entire table.
3. Category-Wise TDS and TCS Classification
Grouped view for quick reference – Salary, Commission, Rent, Interest, Contract & Professional Payments, Dividend, TCS, NRI payments, etc.
4. Instructions and Notes
Clear guidance on how to use the tool, along with important caveats.
Practical Applications of the TDS and TCS Excel Utility
- While preparing TDS returns or checking deductibility, just type the code to get complete details in seconds.
- When clients ask, “What is the TDS rate and form for this payment?”, reply accurately within seconds.
- Training juniors becomes easier – they can use the Lookup Tool instead of memorising the provisions.
- Useful for both resident and non-resident payments.
- Helps in mapping old sections to new sections during the transition period.
Important Notes on TDS and TCS Rates, Thresholds and Forms
- Code 1089 has been intentionally left out. As per the position under the Finance Act, 2026, only a single TCS rate of 2% applies to overseas tour packages (Code 1088*). Final form mapping may still evolve.
- TDS and TCS rates and thresholds are as currently compiled for Tax Year 2026-27. Always cross-verify with the latest CBDT notifications, Finance Act and the Income-tax Act, 2025 before final compliance.
- This is a practical working tool prepared for the benefit of the professional community. It is not a substitute for the Act or official notifications.
Download Free TDS and TCS Master Table Excel for Tax Year 2026-27
The Excel file is attached with this article.
I hope this tool saves valuable time for fellow professionals and helps in smoother compliance during the transition to the new TDS structure.
Feel free to share feedback or suggestions for improvement.
Disclaimer: This Excel and article are for educational and practical assistance only. Users are advised to independently verify all rates, thresholds and forms with the latest official provisions of the Income Tax Act, Finance Act, and CBDT circulars/notifications before taking any action.






