Preparing salary tax certificates for 50 employees can become a challenging task for any employer, accountant, payroll executive, or tax consultant. However, an automatic Excel-based income tax preparation system can make this process faster, simpler, and more organised. From Tax Year 2026-27, employers must follow the new provisions of the Income-tax Act, 2025, which came into effect on 1 April 2026. Consequently, Form 130 replaces the earlier salary TDS certificate, Form 16, for the new tax framework.
Introduction to Form 130 Under the Income-tax Act, 2025
Preparing salary tax certificates for 50 employees can become a challenging task for any employer, accountant, payroll executive, or tax consultant. However, an automatic Excel-based income tax preparation system can make this process faster, simpler, and more organised. From Tax Year 2026-27, employers must follow the new provisions of the Income-tax Act, 2025, which came into effect on 1 April 2026. Consequently, Form 130 replaces the earlier salary TDS certificate, Form 16, for the new tax framework.
Therefore, employers should update their payroll procedures and use the prescribed new form rather than relying on outdated formats. In addition, preparing certificates for 50 employees together can reduce repetitive data entry, minimise calculation errors, and improve payroll management. With the right Excel software, you can enter employee details once, calculate taxable salary, verify TDS deductions, and organise employee-wise information efficiently. As a result, your organisation can save valuable time while maintaining accurate salary tax records.
What Is Form 130 (Earlier Form 16)?
Form 130 is the annual certificate for tax deducted at source from salary under the Income-tax Act, 2025. Under Section 395(4)(b), read with the relevant salary TDS provisions, an employer provides this certificate to employees whose salary attracts TDS under Section 392. Moreover, it records important information about salary payments, taxable income, tax deductions, and tax deposited with the Government. Employees can use this certificate to verify their salary TDS details and claim the appropriate tax credit when filing their income tax returns. Similarly, employers can use the certificate to maintain transparent salary tax documentation. However, Form 130 is not simply a renamed document with no procedural changes. It follows the Income-tax Rules, 2026 and has a prescribed structure. Therefore, employers should understand its requirements before preparing certificates for multiple employees.
Important Changes for Tax Year 2026-27
The transition from the Income-tax Act, 1961, to the Income-tax Act, 2025, introduces a new compliance framework. For example, employers must use the applicable provisions and forms for salary payments made during Tax Year 2026-27. Additionally, the new framework introduces Form 138 for quarterly salary TDS reporting and Form 130 for the annual salary TDS certificate. Consequently, payroll teams should maintain updated employee information and reconcile salary TDS records throughout the year. The due date for issuing Form 130 for Tax Year 2026-27 is 15 June 2027, according to the published transition guidance. Thus, employers should prepare their records well before the deadline instead of waiting until the last moment.
Form 130 and Its Three Parts
The prescribed Form 130 contains three principal parts. Part A records employer and employee identification details, including PAN, TAN, contact information, tax year, and employment period. Part B provides a summary reconciliation of salary payments and tax deducted at source. Meanwhile, Part C contains detailed annexures covering income computation and relevant tax information. For salary cases, Annexure I includes gross salary, exemptions, deductions, taxable income, tax payable, eligible relief, and TDS/TCS details. Therefore, employers must verify all three parts carefully before issuing certificates.
Why Prepare Form 130 for 50 Employees Together?
Preparing 50 individual certificates manually requires considerable time and attention. Nevertheless, an automatic Excel payroll system can simplify this work by keeping employee information in a common database. Instead of calculating each employee's salary and tax separately, you can organise the records in one workbook and generate employee-wise calculations. Furthermore, the system can help standardise salary components, deductions, exemptions, and tax calculations. As a result, payroll executives can reduce repetitive work and focus more on verification. However, bulk preparation does not remove the employer's responsibility to check every employee's details. Each certificate must contain accurate information relating to the individual employee. Therefore, a batch of 50 should be treated as 50 separate tax records managed through one organised process.
Employee Data Required for Form 130
Before preparing Form 130 for 50 employees, collect the necessary payroll and tax information. Accurate source data is the foundation of reliable tax certificates. Therefore, maintain a separate employee database containing the following details:
· Employee name, PAN and employee identification number.
· Employer name, PAN and TAN.
· Monthly basic salary and applicable allowances.
· House Rent Allowance (HRA) and other exemptions.
· Eligible deductions and tax-saving investments.
· Other taxable salary components and perquisites.
· Monthly TDS deducted and deposited.
· Tax regime and applicable tax computation details.
Additionally, reconcile these records with quarterly TDS statements. Otherwise, incorrect employee information may create discrepancies during certificate generation.
Step-by-Step Process to Prepare 50 Employees' Form 130
You can use automatic Excel Software to organise calculations for all 50 employees. Download the Excel Software from the below given link. Next, enter salary information and applicable deductions for each employee. Then, calculate annual gross salary, exemptions, taxable income and estimated tax liability using the applicable provisions of the Income-tax Act, 2025. After that, compare calculated TDS with the actual deductions and deposited amounts. Similarly, verify PAN, TAN and employee identification details before finalising the records.
Verify Salary and TDS Information
Verification is essential because even a small mistake can affect an employee's tax credit. Therefore, compare payroll records with bank payments, salary registers and quarterly TDS statements. In addition, check whether the employer has deposited the deducted tax correctly. If you identify an error, correct the relevant TDS statement and complete the applicable compliance process before generating the certificate.
Use Excel Software
An automatic Excel-based system can help you manage 50 employees through a common workbook. For example, you can maintain employee-wise salary sheets, calculate taxable income, generate tax summaries and prepare reconciliation reports. However, remember one important legal requirement: Excel-generated certificates are not valid substitutes for official Form 130. The employer must file the quarterly TDS statement in Form 138 and obtain processing of the statement. Subsequently, the employer must sign and issue the certificate to the employee.
Benefits of Automatic Form 130 Preparation
Automatic Excel software offers several practical advantages. Firstly, it reduces repetitive calculations. Secondly, it helps maintain consistent employee records. Thirdly, it allows employers to prepare salary and tax summaries for multiple employees together. Additionally, it makes reconciliation easier and reduces manual data-entry errors. Consequently, payroll professionals can manage larger employee databases without preparing every calculation from scratch. Nevertheless, always verify the final figures against official records before completing statutory procedures.
Important Compliance Checks
Before issuing Form 130, check the following points:
1. Verify employee PAN and employer TAN.
2. Reconcile salary payments and TDS deductions.
3. Confirm that quarterly Form 138 statements have been filed and processed.
4. Check the taxable income and applicable deductions.
5. Download the official certificate from TRACES.
6. Sign and distribute the certificate to the respective employees.
Important deadline: Employers must issue Form 130 for Tax Year 2026-27 by 15 June 2027.
Conclusion
Preparing Form 130 for 50 employees at once can become much easier with an organised Excel payroll system. Although automatic software helps calculate salary, exemptions, deductions and tax liability, employers must follow the official TRACES procedure to obtain legally valid certificates. Therefore, maintain accurate employee records, reconcile TDS statements and complete every compliance requirement on time. Ultimately, a combination of automatic Excel calculations and proper statutory verification can make bulk Form 130 preparation more efficient, accurate and convenient for FY 2026-27.
Frequently Asked Questions (FAQs)
1. What is Form 130 under the Income-tax Act, 2025?
Under the Income-tax Act, 2025, employers issue Form 130 instead of Form 16 for salary TDS reporting.
2. Can I prepare Form 130 for 50 employees at once?
You can organise employee-wise salary calculations and reconciliation for 50 employees together using Excel software. However, official certificates must be downloaded individually through the prescribed TRACES process.
3. What is the due date for Form 130 for Tax Year 2026-27?
The employer must issue Form 130 by 15 June 2027.
4. Can an employer issue an Excel-generated Form 130?
No. An independently prepared Excel certificate is not a legally valid Form 130. The official certificate must be downloaded from TRACES after processing the applicable quarterly Form 138 statements.
5. Which details are required to prepare Form 130?
You need the employee PAN, employer TAN, salary details, exemptions, deductions, taxable income, TDS deductions and deposited tax information.
Features of this Excel Utility are:-
✅ Complete Guide to Prepare Form 130 (Earlier Form 16) for 50 Employees at a Time
✅ Updated as per Income-tax Act, 2025 and Budget 2026 Provisions
✅ Bulk Preparation of Form 130 for FY 2026-27 Using Excel Utility
✅ Automatic Salary, TDS, and Tax Liability Calculation
✅ Employee-Wise Form 130 Generation from a Single Database
✅ Supports Preparation of Up to 50 Employees Simultaneously
✅ Step-by-Step Process for Accurate Form 130 Preparation
✅ Covers Part A, Part B, and Part C of Form 130
✅ Automatic Exemption, Deduction, and Tax Computation Features
✅ Built-in TDS Reconciliation with Quarterly Form 138 Returns
✅ Helps Reduce Manual Errors in Salary TDS Certificates
✅ Ideal for DDOs, Accountants, Payroll Managers, and Tax Practitioners
✅ PAN, TAN, Salary, and TDS Verification Checklist Included
✅ Saves Time Through Automated Payroll and Tax Processing
✅ Ensures Compliance with Section 392 and Section 395(4)(b)
✅ Covers the Official Form 130 Issuance Deadline of 15 June 2027
✅ Easy-to-Use Excel-Based Solution for Form 130 Preparation
✅ Simplifies Annual Salary TDS Certificate Management
✅ Suitable for Government, PSU, and Private Sector Employers
✅ Accurate, Fast, and Compliance-Oriented Form 130 Preparation for FY 2026-27
Posts
