HomeDownloads › Form 16 / 130 Generator

Form 16 / 130 Generator — Part B Annexure (Excel)

Format
Excel (.xlsx)
Updated
FY 2026-27
Cost
Free
In short
Enter an employee’s salary, exemptions, deductions and quarterly TDS — the tool builds the Part B annexure of the salary TDS certificate (Form 16, now Form 130) with the full old/new-regime computation, ready to print and issue.

⬇ Download Excel (.xlsx)

Who it's for

  • Employers and payroll teams issuing salary TDS certificates
  • CA firms preparing Form 16 / 130 Part B for clients
  • Anyone who wants the year-end computation in the certificate format

What's inside

  • An Inputs sheet — employee/employer details, salary u/s 17(1)–(3), exempt allowances u/s 10, Section 16, other income and Chapter VI-A, plus the TDS deducted each quarter
  • A Form 130 (Part B) sheet — the certificate annexure, numbered as the official format, filled in automatically
  • Correct old vs new regime treatment: standard deduction, Chapter VI-A (with caps), slab tax, 87A rebate and 4% cess for FY 2026-27
  • Total tax vs TDS deducted, with a shortfall / excess flag
  • Input cells open; formula cells locked & password-protected

How to use it

  1. Fill the white cells on the Inputs sheet and pick the regime
  2. Open the Form 130 (Part B) sheet — the full computation is ready
  3. Print or save it as the Part B annexure
  4. Attach Part A (downloaded from TRACES) and issue to the employee

FAQs

What does it do?
Prepares the Part B annexure of the salary TDS certificate from your inputs.

Is Form 16 now Form 130?
Yes — renumbered under the Income-tax Act 2025 from Tax Year 2026-27.

Both regimes?
Yes — pick the regime and the right computation applies.

All employees at once?
This free version is single-employee; bulk is in the Working File app.

Free · verified 30 June 2026 against the Income-tax Act 2025 / FA 2025. General information, not professional advice; verify before issuing.