ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Form 16 Excel Format FY 2025-26 (AY 2026-27)
2
Prepared by HR Calcy (www.hrcalcy.in). Free to use.
3
4
What this workbook does
5
1. "Part B" computes the salary and tax figures of Form 16 Part B (Annexure-I) for FY 2025-26, under the new or old tax regime.
6
2. "Part A" summarises quarter-wise salary paid, TDS deducted and TDS deposited, for checking against Form 26AS.
7
8
How to use
9
- Fill only the yellow cells (blue text). All other cells are formulas.
10
- Choose the tax regime (New or Old) and the age category in Part B.
11
- Example values are filled in (gross salary Rs 15,00,000, new regime, tax Rs 97,500). Replace them with your own.
12
- Column C is what you enter; column D is the amount allowed under the chosen regime.
13
14
Rules built in (FY 2025-26, Income-tax Act, 1961)
15
- New regime slabs: 0-4 lakh nil, 4-8 lakh 5%, 8-12 lakh 10%, 12-16 lakh 15%, 16-20 lakh 20%, 20-24 lakh 25%, above 24 lakh 30% (Section 115BAC).
16
- Old regime slabs: nil up to Rs 2.5 lakh (Rs 3 lakh for 60-79 years, Rs 5 lakh for 80+), 5% up to Rs 5 lakh, 20% up to Rs 10 lakh, 30% above.
17
- Standard deduction: Rs 75,000 (new) / Rs 50,000 (old). Professional tax, HRA, LTA, home loan interest and most Chapter VI-A deductions only in the old regime.
18
- Section 87A rebate: new regime up to Rs 60,000 if income is up to Rs 12 lakh, with marginal relief just above Rs 12 lakh; old regime up to Rs 12,500 if income is up to Rs 5 lakh.
19
- Surcharge 10% / 15% / 25% / 37% above Rs 50 lakh / 1 crore / 2 crore / 5 crore (new regime capped at 25%), with marginal relief. Health and education cess 4%.
20
- Taxable income and tax are rounded to the nearest Rs 10 (Sections 288A and 288B).
21
22
Important
23
- A valid Form 16 Part A must be generated by the employer from the TRACES portal (www.tdscpc.gov.in) and signed. This sheet does not replace it.
24
- Part B is issued and signed by the employer. Employees can use this sheet to check their Form 16 before filing the ITR.
25
- From tax year 2026-27 (salary from 1 April 2026), Form 16 is replaced by Form 130 under the Income-tax Act, 2025.
26
- Special cases not covered: arrears relief workings (enter Section 89 relief directly), let-out property, capital gains, special-rate income.
27
- General information, not tax advice. Guide: https://www.hrcalcy.in/2025/02/form-16-meaning-importance-how-to-download.html
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100