Form 16 Part B serves as a critical document for salaried employees in India, detailing salary breakdowns, exemptions, and deductions for accurate ITR filing. Employers prepare it one by one for each employee using Excel templates, ensuring compliance with Income Tax rules for FY 2025-26 (AY 2026-27).
Understanding Form 16 Part B
Employers issue Form 16 under Section 203 of the Income Tax Act, 1961. Specifically, Part B provides a detailed annexure to Part A, covering gross salary components like basic pay, HRA, and allowances. Moreover, it lists exemptions under Section 10, such as house rent allowance and leave travel allowance. Consequently, employees rely on it to compute taxable income precisely. For instance, it also includes Chapter VI-A deductions like 80C investments and standard deductions under old or new regimes.
Additionally, for FY 2025-26, templates accommodate updated slabs: the new regime offers lower rates without most exemptions, while the old regime allows full deductions. Therefore, Excel formats often feature dual calculations. In fact, this helps users compare tax liabilities seamlessly. Besides, accuracy prevents notices from the tax department during scrutiny.
Reliable Sources for Download
Start by visiting trusted sites like ArthikDisha or tax portals for free Excel templates tailored to AY 2026-27. First, search "Form 16 Part B Excel FY 2025-26" on Google to locate options. Next, avoid official Income Tax sites, as they provide PDFs via TRACES, not editable Excel. Instead, third-party utilities from sites like arthikdisha.com offer pre-formatted sheets with formulas.
Furthermore, Pranab Banerjee's resources provide automated versions for bulk or single preparation. Download directly from verified links to ensure virus-free files. After that, verify the template includes FY 2025-26 slabs, such as 30% tax above ₹15 lakh in the new regime. Thus, preparation becomes straightforward for tax consultants handling Kolkata-based clients.[user-information]
Step-by-Step Download Process
Begin the process by opening your browser and navigating to arthikdisha.com/free-download-form-16-excel-format-ay-2026-27. Then, scroll to the download section at the bottom of the page. Subsequently, select the Excel link for Part B (or full Form 16, as Part B integrates within). For example, click "Download Form 16 Excel Format AY 2026-27" to save the ZIP file.
Unzip the file immediately after download. Importantly, check for sheets labelled "Part B," "Salary Details," or "Employee Master." If the macros prompt appears, enable them for auto-calculations. Meanwhile, save a copy in your Excel folder, preferably on a secure drive. This method ensures you obtain a plagiarism-free, functional template every time.
Preparing Employee Data One by One
First, open the downloaded Excel workbook. Consequently, locate the "Employee Master" or "Part B Input" sheet. Next, enter personal details: employee's name, PAN, designation, and FY 2025-26 period (01-Apr-2025 to 31-Mar-2026). After that, input the monthly salary breakup cumulatively—basic pay, dearness allowance (DA), HRA, medical allowance, and special allowances.
Moreover, add perquisites like company car value or rent-free accommodation under "Value of Perquisites." Then, list Section 10 exemptions: actual HRA received minus 50% of basic (metro) or 40% (non-metro), supported by rent receipts. Subsequently, include professional tax paid. Because formulas link cells, gross salary auto-sums. For instance, if the basic is ₹5 lakh annually, the HRA exemption calculates instantly.
Continue by detailing Chapter VI-A deductions: 80C (PF, PPF up to ₹1.5 lakh), 80D (health insurance), and 80G (donations). Also, apply standard deduction—₹75,000 new regime or ₹50,000 old. Therefore, taxable income is derived automatically. Meanwhile, cross-verify with payroll records for one employee before proceeding to the next.
Auto-Calculating Tax and TDS
Once data entry is complete, Excel triggers tax slab computations. Specifically, for the new regime: 0% up to ₹3 lakh, 5% ₹3-7 lakh, escalating to 30% above ₹15 lakh, post-rebate u/s 87A. In contrast, the old regime factors exemptions fully. Additionally, formulas deduct TDS already paid quarterly.
Review the "Tax Computation" sheet next. For example, if gross salary totals ₹12 lakh with ₹2 lakh deductions, tax payable shows precisely. Then, adjust if arrears relief applies under Section 89. Because transitions like "furthermore" guide your review, errors drop significantly. Finally, ensure TDS matches the Part A summary.
Generating and Verifying Part B
Navigate to the "Form 16 Part B" output sheet after calculations. Importantly, it populates fields like "Gross Salary," "Less: Exemptions," and "Tax Deducted." Print or export to PDF via File > Save As > PDF. Subsequently, sign digitally if issuing officially.
Verify compliance by checking against the AIS (Annual Information Statement) on the e-filing portal. Moreover, for multiple employees, duplicate the sheet one by one—copy inputs, paste values, and recalculate. Thus, bulk preparation remains efficient yet personalised. In addition, save versions for audits.
Common Errors and Fixes
Frequently, users mismatch HRA exemptions without rent proof—fix by entering the actual least of three values. Similarly, ignore new regime slabs in old templates; always download FY-specific files. Besides, formula errors arise from disabled macros—reenable via the Developer tab.
Additionally, PAN entry mistakes trigger mismatches—use uppercase consistently. Therefore, double-check totals against Form 26AS. Because SEO-optimised tools like these aid tax pros in Kolkata, preparation speeds up. Finally, update for Budget 2026 changes if announced.
Best Practices for FY 2025-26
Employers should prepare one by one for accuracy, starting with high-salary staff first, and backup originals. Next, use password protection on sheets. After that, email PDFs securely via WordPress SMTP setups, aligning with your tech habits.[user-information]
Furthermore, integrate with Excel tax calculators for arrears. Consequently, clients appreciate detailed breakdowns. In summary—wait, no, instead note: this process empowers tax consultants to deliver error-free Form 16 Part B. Always cite sources during client demos for credibility.
Download and Prepare One by One Form 16 Part B in Excel for FY 2025-26
[caption id="attachment_7197" align="aligncenter" width="928"]
Download Automatic Form 16 Part A and B in Excel for Salaried Employees for FY 2025-26 & AY 2026-27[/caption]Key Features of this Excel Utility:-
Excel templates automate calculations for gross salary, exemptions, and deductions. First, users download free utilities from the above link. Next, they input employee-specific data like PAN and salary breakup. Consequently, formulas compute taxable income instantly under old or new regimes. Moreover, built-in slabs reflect FY 2025-26 updates, such as ₹75,000 standard deduction in the new regime.
Additionally, sheets handle HRA exemptions (the least of actual, 50% metro rent, or rent paid minus 10% salary). For instance, a ₹6 lakh basic salary triggers precise outputs. Therefore, errors drop significantly compared to manual PDFs.
Download Process
Navigate to reliable portals like https://www.pranabbanerjee.com or www.itaxsoftware.net for AY 2026-27 templates. Then, click the direct ZIP download link. After extraction, enable macros for auto-features. Importantly, verify FY labels (April 2025–March 2026). This step-by-step approach saves hours for tax pros in Kolkata handling multiple clients.
Preparation Steps
Open and Input Data. Launch Excel and access the "Employee Master" sheet. Enter name, PAN, and cumulative salary: basic, DA, HRA, allowances. Subsequently, add perquisites like a car value.
Apply Exemptions. List Section 10 reliefs—HRA, LTA, gratuity. Formulas link automatically. For example, professional tax is deducted seamlessly.
Compute Deductions. Fill Chapter VI-A: 80C (₹1.5 lakh max), 80D, NPS. Then, select the regime; tax slabs activate. In addition, arrears relief u/s 89 integrates if needed.
Generate Output. Switch to the "Part B" sheet for finalised Form 16. Finally, export PDF and verify against 26AS.
Benefits Overview
| Feature | Advantage | Time Saved |
| Auto Tax Calc | Dual regime support | 80% faster |
| One-by-One Prep | Personalized accuracy | Per employee: 10 mins |
| Exemption Formulas | HRA/80C precision | Reduces notices |
| PDF Export | Digital signing ready | Audit-compliant |
Quick Tips
Avoid old templates—update for Budget 2026 slabs. Besides, back up files before bulk use. Thus, consultants deliver error-free documents efficiently.
