ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
WORK SHEET FOR INCOME TAX CALCULATION FOR SALARIED EMPLOYEES & PENSIONERS FOR ASSESSMENT YEAR 2023-24 AS PER EXISTING &NEW OPTION SCHEMES
2
INCOME TAX STATEMENT CUM WORK SHEET FOR THE FINANCIAL YEAR 2022-23 (ALL AGE GROUP Upto 60, 60-80 & Above 80)
3
NAME OF EMPLOYEE :Krishna das NPPEN /
Pensioncode		123456
4
DESIGNATION &
NAME OF OFFICE :		Das Vas,CherukaraPAN :AGEPK3173A
5
TAN of
Deductor :
6
729007040060400PARTICULARS OF SALARY / PENSION DRAWNAGE IF >= 60
7
 MONTHEARNINGSDEDUCTIONS SAME MONTH
SALARY ?		NO
8
PAYDAHRASP/HTA/
CCA		OtherP FSLIFBSGISLICNPSINCOME
TAX		TOTAL DEDUCTONSTOTAL EARNINGS
9
123456789101112131415
10
3/202250000350020000000000050050055500
11
4/202250000350020000000000050050055500
12
5/202250000350020000000000050050055500
13
6/202250000350020000000000050050055500
14
7/202250000350020000000000050050055500
15
8/202250000350020000000000050050055500
16
9/202250000350020000000000050050055500
17
10/202250000350020000000000050050055500
18
11/202250000350020000000000050050055500
19
12/202250000350020000000000050050055500
20
1/202350000350020000000000050050055500
21
2/2023500003500200000000000055500
22
DA Arrto PF00000000
23
DA Arr cash00000000
24
PRArrtoPF00000000
25
PRArr cash00000000
26
PRA IntPF00000000
27
PRA Intcash00000000
28
Salary Arr2000000000 020000
29
EL surrender00000000
30
FA/Bonus/Ex10000000001000
31
Total62100042000240000000000055005500687000
32
1- (a)Gross Salary Income (includes Pay, DA, HRA, CCA, IR,DA/PR Arrear,OT, SEL, FA/Bonus etc.)687000
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 excess salary refunded to be excluded from salary income0
37
1- Total Salary Income (a+b+c+d)687000
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.0642000
43
3- Deduct: Allowance to the extent exempt u/s 100
44
4- Balance (1-2-3)687000
45
5- Deduct:
46
(a)Standard deduction - u/s 16 (ia) 50000
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)637000
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) ബാങ്കു പലിശയടക്കമുള്ള മറ്റുവരുമാനങ്ങള്‍325000
52
9- Any other TDS or TCS paid (ഡി.ഡി.ഒ മുഖാന്തിരമല്ലാതെ മറ്റുവരുമാനങ്ങളില്‍ നിന്നു പിടിച്ചിട്ടുള്ള നികുതി)0
53
10- Gross Total Income (6-7+8)962000
54
11- (a)80D-Health Insurance & Checkup - Mediclaim (Family Max.50000 / 75000 / 100000 as the case of Sr.Citi)-ref rule0
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)10000
65
(l)80TTB-Deduction for Income from any bank/PO FD Interest for senior citizens (Max. 50000)0
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 1110000
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)802000
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)		72900
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)72900
90
17-Less: Rebate for income upto 5 Lakhs u/s 87A0
91
18-Total Tax Payable (16-17)72900
92
19-Health and Education Cess [@4% of (18)]2916
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)75816
95
22-Total Taxable income (1+8-O66) നികുതി വിധേയ വരുമാനം (NEW REGIME)1012000
96
23-Tax on Total Income. (ALL category- 250000 വരെ 0 ,250001 to 500000 വരെ 5%,500001 to 750000 വരെ 10%,750001 to 1000000 വരെ 15%,1000001to1250000വരെ 20% ,1250001to1500000വരെ 25% ,1500000മേല്‍ 30%) (NEW REGIME)77400
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)77400
99
26Less: Rebate for income upto 5 Lakhs u/s 87A0
100
27Total Tax Payable (25-26)77400