The Indian government has officially replaced Form 16 with the new Form 130 starting Fiscal Year 2026-27. Consequently, salaried taxpayers will now receive Form 130 instead of the traditional Form 16 for tax year 2026-27 onwards. However, Form 16 remains valid for the Financial Year 2025-26, and employers must issue it by June 15, 2026. Why Form 16 Became Form 130 Aspect Form 16 (FY 2025-26) Form 130 (FY 2026-27+) Number of Parts 2 parts (A & B) 3 parts (A, B, & C) Generation Method Employer-issued TRACES portal-only Manual…
Free Download Automatic One by One Income Tax Form 16 Part A and B and Part B in Excel for F.Y.2025-26
Streamlining Income Tax Compliance Employers and tax professionals frequently face the daunting task of managing complex tax documents. Consequently, utilising an automatic Excel utility for Form 16 serves as a highly effective solution. Indeed, this tool simplifies the entire process by allowing you to input salary details directly into a structured template. Furthermore, it generates individual forms with remarkable precision, which significantly reduces the time spent on manual data entry. Because accuracy remains paramount in tax filings, these automated sheets minimise human errors. Therefore, many professionals now prefer this method…
Free Download and Prepare at a time 50 Employees Form 16 Part A and B in Excel for F.Y.2025-26
Firstly, Form 16 works as a TDS certificate that employers issue to salaried employees, showing salary income, deductions, and tax deducted for the year. Secondly, when you build this certificate in Excel, you gain full control over formats, formulas, and bulk preparation for multiple staff. Moreover, because FY 2025-26 still falls under the existing Form 16 rules (Form 130 applies from FY 2026-27 onwards), employers must continue to generate salary TDS certificates in the familiar two-part format for this year. Consequently, a single Excel utility that prepares Form 16 Part…
How to Create Auto-Serial Numbering That Updates Itself in Excel with Video Clips
Auto-serial numbering saves time, reduces errors, and keeps your worksheet neat, especially when rows change often. Moreover, when you build the numbering correctly, Excel updates the numbers automatically as you add or remove entries. If you manage attendance lists, invoices, customer records, or task sheets, you already know how frustrating manual renumbering can be. However, Excel gives you a smarter way to handle this job, and the SEQUENCE function makes the process simple and flexible. In addition, you can combine it with COUNTA so the numbering adjusts itself when your…
Free Download Prepare at a time 50 Employees Form 16 Part A and B in Excel for the F.Y.2025-26
What Form 16 Part A and B Contain Form 16 acts as a TDS certificate that your organisation issues to each salaried employee, and it summarises the tax deducted and deposited on salary income. Therefore, you must understand both Part A and Part B clearly before you design any Excel utility. Part A of Form 16 captures employer TAN, PAN, employee PAN, period of employment and the quarter‑wise TDS deducted and deposited, and the department generates it from the TRACES portal based on Form 24Q data. In contrast, Part B…
Understanding the Automatic Relief Calculator u/s 89(1) for FY 2026-27 with New Form 39 As per Income Tax Act 2025
Taxpayers often face a higher tax burden when they receive salary arrears or advance payments in a single financial year. Consequently, this lump-sum income can push an individual into a higher tax bracket than intended. To address this, the Income Tax Act provides a specific mechanism for relief under Section 89(1). For the Financial Year 2026-27, a significant change has occurred. The government introduced the Income Tax Rules, 2026, which replaced the traditional Form 10E with a new form, Form 39. While the core calculation logic remains similar, you must now…
Understanding the Automatic Relief Calculator u/s 89(1) for FY 2026-27 with New Form 39 As per Income Tax Act 2025
Taxpayers often face a higher tax burden when they receive salary arrears or advance payments in a single financial year. Consequently, this lump-sum income can push an individual into a higher tax bracket than intended. To address this, the Income Tax Act provides a specific mechanism for relief under Section 89(1). For the Financial Year 2026-27, a significant change has occurred. The government introduced the Income Tax Rules, 2026, which replaced the traditional Form 10E with a new form, Form 39. While the core calculation logic remains similar, you must now…
Free Download Automatic Income Tax Form 16 in Excel, which can prepare at a time 50 Employees Form 16 for F.Y.2025-26
Understanding Form 16 To begin with, you should clarify that Form 16 is the TDS certificate that an employer issues annually to a salaried employee, summarizing salary income and tax deducted at source for the financial year. Moreover, you can explain that employees primarily use this document while filing their income tax return because it consolidates taxable income, TDS, and eligible deductions in one place. Furthermore, you may highlight that this certificate serves as official proof that the employer has deducted and deposited tax with the government on the employee’s…
Automatic Form 16 Part B in Excel, which can prepare a lump 50-employee Form 16 for FY 2025-26
Streamline Tax Compliance with Automatic Form 16 Part B in Excel Employers and tax professionals now rely on automated Excel tools to generate Form 16 Part B for up to 50 employees simultaneously for FY 2025-26, saving hours of manual work. Consequently, this innovation ensures accuracy and compliance with the latest Income Tax rules. What is Form 16 Part B? Form 16 Part B serves as the critical tax computation certificate that employers issue to salaried employees. Specifically, it details salary income, allowable deductions, exemptions, and Tax Deducted at Source…
Download Automated Income Tax Form 16 Part B in Excel for AY 2026-27
Download the Excel-based automated income tax form 16, part B, for FY 2025-26