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 works like a detailed salary statement because it shows the complete salary breakup, exemptions, and Chapter VI‑A deductions that you, as an employer, compute and issue along with Part A.
Why Use Excel for 50 Employees in FY 2025-26
Because Form 16 for FY 2025-26 must reach employees by 15 June 2026, you need a fast and accurate method to generate all certificates well before the deadline. Consequently, preparing each Form 16 manually for 50 employees will waste time, increase fatigue and multiply the risk of typing mistakes.
On the other hand, when you prepare at a time 50 Employees Form 16 Part A and B in Excel for the F.Y.2025-26, you centralise all calculations, standardise headings, and, additionally, ensure consistent logic for exemptions and deductions. In practice, many payroll teams prefer Excel‑based utilities or templates because these tools allow row‑wise entry for multiple employees and then generate Form 16 in bulk with a single click or a few controlled steps.
Step 1: Gather and Validate All Employee Data
First, compile a clean employee master sheet that includes name, PAN, designation, joining date, and whether the employee opted for the old or new tax regime. Next, bring in annual salary figures such as basic pay, HRA, special allowance, bonus, perquisites, and any other taxable components for FY 2025-26 from your payroll register.
After that, capture exemptions (for example, HRA, LTA) and deductions under Chapter VI‑A, like 80C, 80CCD(1B) and 80D in separate columns so that your formulas remain transparent and audit‑friendly. Additionally, you should verify TAN, employer PAN and employee PAN against TRACES and Form 24Q data because any mismatch will trigger correction work later and may even delay issuing Form 16.
Step 2: Design the Core Excel Structure
Start by creating a workbook with at least four sheets, namely “Employee_Data”, “Computation”, “PartB_Template”, and “Output_PDF” (or “Print_View”), so that you separate raw data, calculations and final layout. Then, in the “Employee_Data” sheet, store one row per employee, and, additionally, freeze the header row so that you can scroll comfortably while reviewing 50 records.
In the “Computation” sheet, link each column to “Employee_Data” using VLOOKUP, XLOOKUP, or INDEX‑MATCH so that any change in master data immediately flows into the tax calculation. Moreover, use step‑wise formulas: compute gross salary, then subtract exemptions, then apply standard deduction, and finally calculate total income and tax as per the regime. Because you keep everything formula‑driven, you can later add more employees or change slabs without rewriting the entire model.
Step 3: Build a Dynamic Part B Template
Now, create a formatted “PartB_Template” sheet that visually matches the notified Part B structure, including sections for salary, exemptions and deductions. Here, you should reference the “Computation” sheet so that each cell pulls the correct amount using a selected Employee ID, and thus the template becomes dynamic.
Furthermore, insert a drop‑down list for Employee Code or PAN by using Data Validation so that whenever you change the selected employee, the template instantly refreshes with the right figures. In addition, set up conditional formatting for negative or blank values so that you catch anomalies before you generate 50 copies together. Because this template mirrors the legal format, you simplify review by management, auditors and even employees.
Step 4: Map TRACES Part A with Excel Part B
Since TRACES already provides Part A in PDF or text format, you only need to merge that official Part A with your Excel‑generated Part B for each employee. Many Excel‑based Form 16 utilities either read TRACES data files or simply merge Part A PDFs with Part B PDFs in one batch, and you can design a similar workflow or adopt a ready‑made tool.
However, before you merge, compare TDS totals in your “Computation” sheet with the TDS figures appearing in Form 26AS or Part A so that you avoid salary‑tax mismatches between both parts. Consequently, you maintain consistency across Form 24Q, Form 26AS, Part A and Part B, which, in turn, reduces queries during employee ITR filing.
Step 5: Automate Bulk Generation for 50 Employees
After you test the template for one employee, you can move towards bulk generation for all 50 employees. In many Excel solutions, a simple macro or controlled print area loop creates individual Part B PDFs for each row in the employee table, and then, another utility merges them with TRACES Part A in a single run.
Even if you do not write VBA, you can still use features like “Print Entire Workbook”, “Page Break Preview”, and carefully defined page ranges to export multiple employees’ Part B in one operation, and later, combine them with Part A using an external PDF merger. Therefore, you save significant time, and you maintain uniform fonts, alignments and signatures across all 50 Form 16 certificates.
Step 6: Review, Sign and Distribute Form 16
Before you sign, filter your “Employee_Data” sheet to check for any records with missing PAN, zero tax with a high salary, or inconsistent deduction patterns. Additionally, reconcile gross salary and total TDS with your audited payroll totals so that you catch any formula or data import errors promptly.
Subsequently, generate final PDFs and sign them either digitally or manually, depending on your organisation’s policy and the tools you use, since several Excel‑based Form 16 utilities support bulk digital signatures. Finally, email the signed Form 16 to employees or upload it to your HR portal well before 15 June 2026 so that employees get enough time to file their ITR for AY 2026‑27.
Best Practices for a Robust Excel Form 16 Utility
Firstly, always lock formula cells and protect the “Computation” and “PartB_Template” sheets with a password so that users cannot accidentally overwrite formulas. Secondly, document your assumptions, such as tax regime defaults, surcharge thresholds and cess rate in a separate “Parameters” sheet, and, additionally, highlight them whenever the law changes.
Thirdly, retain a version‑controlled copy of the FY 2025-26 workbook for future assessments, and store it along with Form 24Q acknowledgements, TRACES download logs and payroll summaries. In this way, you not only prepare at a time 50 Employees Form 16 Part A and B in Excel for the F.Y.2025-26 efficiently, but also build a repeatable, compliant and scalable process that will serve you in every subsequent financial year.
Download and prepare at a time 50 Employees Form 16 Part A and B in Excel for the F.Y.2025-26
