ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
BEST OPTION AND INCOME TAX CALCULATION FOR ALL CATEGORY SALARIED EMPLOYEES & PENSIONERS FOR ASSESSMENT YEAR 2025-26
2
INCOME TAX STATEMENT CUM WORK SHEET FOR THE FINANCIAL YEAR 2024-25 (ALL AGE GROUP Upto 60, 60-80 & Above 80)
3
NAME OF EMPLOYEE :Krishna dasPEN /
Pensioncode
4
DESIGNATION &
NAME OF OFFICE :
RetiredPAN :
5
TAN of
Deductor :
6
525005000040000PARTICULARS OF SALARY / PENSION DRAWNAGE IF >= 60
7
EARNINGSDEDUCTIONS SAME MONTH
SALARY ?
YES
8
MONTHPAYDAHRASP/HTA/
CCA
OtherP FSLIFBSGISLICNPSINCOME
TAX
TOTAL DEDUCTONSTOTAL EARNINGS
9
123456789101112131415
10
4/20244000000000000000040000
11
5/20244000000000000000040000
12
6/20244000000000000000040000
13
7/20244000000000000000040000
14
8/20244000000000000000040000
15
9/20244000000000000000040000
16
10/20244000000000000000040000
17
11/20244000000000000000040000
18
12/20244000000000000000040000
19
1/20254000000000000000040000
20
2/20254000000000000000040000
21
3/2025400000000000000040000
22
DA Arrto PF00000000
23
DA Arr cash00000000
24
PRArrtoPF00000000
25
PRArr cash00000000
26
PRA IntPF00000000
27
PRA Intcash00000000
28
IF Pension Benefits add000000 00
29
Any additions to Salary00000000
30
FA/Bonus/Ex10000000001000
31
Total481000000000000000481000
32
1- (a)Gross Salary Income (includes Pay, DA, HRA, CCA, IR,DA/PR Arrear,OT, SEL, FA/Bonus etc.)481000
33
(b)Employer's Contribution to NPS0
34
(c)Perquisite - u/s 17(2) 0
35
(d)Profits in lieu of salary - u/s 17(3) if any0
36
(e)Any amount (excess salary refunded/DCRG/Commutation/Terminal SEL/Pension benefits etc.,) to be excluded from salary income0
37
1- Total Salary Income (a+b+c+d)481000
38
2- Deduct: HRA in the case of persons who actually incur expenditure by way of rent:
39
(I)Actual HRA received during the year
40
(II)Actual rent paid in excess of 1/10th of the salary.
41
(III)50% of Pay +DA ( in metros) & 40% elsewhere
42
(I) to (III) whichever is least is exempted.0480000
43
3- Deduct: Allowance to the extent exempt u/s 100
44
4- Balance (1-2-3)481000
45
5- Deduct:
46
(a)Standard deduction - u/s 16 (ia) New regime 75000 ,IF Old regime 5000075000
47
(b)Entertainment Allowance - u/s 16 (ii)0
48
(c)Professional Tax - u/s 16 (iii)0
49
6- Net salary income (4-5)406000
50
7- Interest on HBA Deducted as loss in Income from House Property .(Max. Rs.30000 before1-4-99 or 2 Lakh Sec.24(b) 0
51
8- Any other income (Business, Capital gains,Bank Interest or Other Sources) ബാങ്കു പലിശയടക്കമുള്ള മറ്റുവരുമാനങ്ങള്‍500000
52
9- Any other TDS or TCS paid (ഡി.ഡി.ഒ മുഖാന്തിരമല്ലാതെ മറ്റുവരുമാനങ്ങളില്‍ നിന്നു പിടിച്ചിട്ടുള്ള നികുതി)50000
53
10- Gross Total Income (6-7+8)906000
54
11- (a)80D-Health Insurance & Checkup - Mediclaim (Family Max.50000 / 75000 / 100000 as the case of Sr.Citi)-ref rule6000
55
(b)80DD-Expense on treatment of mentally or physically handicapped dependants(max 125000-ref rule)0
56
(c)80DDB-Expenditure incurred on medical treatment of self / dependant for specified (see list) deceases.(max40000/100000sr.cit)0
57
(d)80E-Interest paid for educational loan taken for higher education of self/dependent children(no limit) 0
58
(e)80EE-New House purchase loan after 2016-17 Interest bal 2017-18 (see conditions)0
59
(f)80CCG-Notified Equity Saving scheme-Rajiv Gandhi Equity Saving(see Limit)0
60
(g)80U-For Employee with disability (Rs75000 or If >80% disability 1.25L)0
61
(h)80G-Donations to relief Funds and charitable institutions Including CMDRF - (see conditions) 0
62
(I)80GGC-Donations made to any Political party-incash 2000 only (see conditions) 0
63
(j)80GG-for individuals who do not own a residential house & do not receive HRA (see conditions&Limit) 0
64
(k)80TTA-Deduction for Income from any bank/PO SB Interest (Max. 10000)0
65
(l)80TTB-Deduction for Income from any bank/PO FD Interest for senior citizens (Max. 50000)50000
66
(m)80 CCD(1B) Employee's Contribution to NPS (Max. 50000 Addl – see conditions)0
67
(n)80 CCD(2) Employer's Contribution to NPS (Max. 10% of PAY+DA-see conditions)0
68
Deduct:Total of 1156000
69
12(1) Sec. 80C
70
(a)Life Insurance Premia of self, spouse and children (salary deduction)0
71
(b)Contribution towards GPF/KASEPF0
72
(c)Contribution towards SLI,GIS,FBS,PLIC,(salary deduction)0
73
(d)Contribution made ULIP,UTI,LIC ( other than salary deduction)0
74
(e)Tax saver in scheduled bank / Post Office for a period of not less than 5 years0
75
(f)Purchase of NSC / tax saving units of Mutual Fund / UTI0
76
(g)Contribution to any deposit scheme or pension fund setup by NHB0
77
(h)Tution fees for the full time education of any two children.0
78
(I)Principal part of HBA Repayment & stamp duty paid for purchase of property0
79
(j)Subscription to equity shares , debentures of an eligible issue.0
80
(k)Subcription to eligible units of mutual fund,Infrastructure bonds ICICI,IDBI etc.,0
81
(l)Any other deduction Ch VIA/80C150000
82
(m)0
83
2- (n)80CCC-Payment for annuity plan of the LIC or any other insurer.0XNPNP1NP2tot
84
3- (o)80CCD(1)-Contribution of employee to PPF/NPS (see conditions)015000000150000
85
Deduction (Maximum Rs. 150000) : Total of 10150000150000150000150000
86
13-Total Taxable income (10-11-12) നികുതി വിധേയ വരുമാനം (OLD REGIME)700000
87
14-Tax on Total Income. (Below 60 yrs- 250000 വരെ 0 ,250001 to 500000 വരെ 5%,500001 to 1000000 വരെ 20%,1000000 മേല്‍ 30%)
(60y & Above - 300000 വരെ 0 ,300001 to 500000 വരെ 5%,500001 to 1000000 വരെ 20%,1000000 മേല്‍ 30%)
(80y & Above - 500000 വരെ 0 ,500001 to 1000000 വരെ 20%,1000000 മേല്‍ 30%) (OLD REGIME)
52500
88
15-Add: Surcharge:Total income if exceeds 50 L 10%, if exceeds1Cr 15%, if exceeds 2Cr 25% & 37% if exceeds Rs. 5 Cr.0
89
16-Income Tax and Surcharge payable.(14+15)52500
90
17-Less: Rebate for income upto 5 Lakhs u/s 87A (OLD REGIME) max 125000
91
18-Total Tax Payable (16-17)52500
92
19-Health and Education Cess [@4% of (18)]2100
93
20-Less: Relief for arrears of salary u/s 89(1) [Use form 10E]0
94
21-Income Tax Payable on existing scheme option (18+19-20) ആകെ അടക്കേണ്ട ഇന്‍കം ടാക്സ് സംഖ്യ (OLD REGIME)54600
95
22-Total Taxable income (1+8-O66) നികുതി വിധേയ വരുമാനം (NEW REGIME)906000
96
23-Tax on Total Income. (ALL category- 300000 വരെ 0 ,300001 to 700000 വരെ 5%,700001 to 1000000 വരെ 10%,1000001 to 1200000 വരെ 15%,1200001to1500000വരെ 20% ,1500000മേല്‍ 30%) (NEW REGIME)40600
97
24Add: Surcharge:Total income if exceeds 50 L 10%, if exceeds1Cr 15%, if exceeds 2Cr 25% & 37% if exceeds Rs. 5 Cr.0
98
25Income Tax and Surcharge payable.(23+24)40600
99
26Less: Rebate for income upto 7 Lakhs u/s 87A(NEW REGIME) max250000
100
Marginal Rebate 87A (NEW PROVISION)-1654000