ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
WORK SHEET FOR INCOME TAX CALCULATION FOR SALARIED EMPLOYEES & PENSIONERS FOR ASSESSMENT YEAR 2023-24 AS PER EXISTING &NEW OPTION SCHEMES
2
ANTICIPATORY 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 :NamePEN /
Pensioncode		123456
4
DESIGNATION &
NAME OF OFFICE :		AddressPAN :ABCDE1234F
5
TAN of
Deductor :
6
000PARTICULARS 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/202200120000000000001200
11
4/202200120000000000001200
12
5/202200120000000000001200
13
6/202200120000000000001200
14
7/202200120000000000001200
15
8/202200120000000000001200
16
9/202200120000000000001200
17
10/202200120000000000001200
18
11/202200120000000000001200
19
12/202200120000000000001200
20
1/202300120000000000001200
21
2/20230012000000000001200
22
DA Arrto PF00000000
23
DA Arr cash00000000
24
PRArrtoPF00000000
25
PRArr cash00000000
26
PRA IntPF00000000
27
PRA Intcash00000000
28
Salary Arr000000 00
29
EL surrender00000000
30
FA/Bonus/Ex27500000002750
31
Total2750014400000000000017150
32
1- (a)Gross Salary Income (includes Pay, DA, HRA, CCA, IR,DA/PR Arrear,OT, SEL, FA/Bonus etc.)17150
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
1- Total Salary Income (a+b+c+d)17150
37
2- Deduct: HRA in the case of persons who actually incur expenditure by way of rent:
38
(I)Actual HRA received during the year
39
(II)Actual rent paid in excess of 1/10th of the salary.
40
(III)50% of Pay +DA ( in metros) & 40% elsewhere
41
(I) to (III) whichever is least is exempted.00
42
3- Deduct: Allowance to the extent exempt u/s 100
43
4- Balance (1-2-3)17150
44
5- Deduct:
45
(a)Standard deduction - u/s 16 (ia) 50000
46
(b)Entertainment Allowance - u/s 16 (ii)0
47
(c)Professional Tax - u/s 16 (iii)2500
48
6- Net salary income (4-5)-35350
49
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
50
8- Any other income (Business, Capital gains,Bank Interest or Other Sources) ബാങ്കു പലിശയടക്കമുള്ള മറ്റുവരുമാനങ്ങള്‍0
51
9- Any other TDS or TCS paid (ഡി.ഡി.ഒ മുഖാന്തിരമല്ലാതെ മറ്റുവരുമാനങ്ങളില്‍ നിന്നു പിടിച്ചിട്ടുള്ള നികുതി)0
52
10- Gross Total Income (6-7+8)-35350
53
11- (a)80D-Health Insurance & Checkup - Mediclaim (Family Max.50000 / 75000 / 100000 as the case of Sr.Citi)-ref rule0
54
(b)80DD-Expense on treatment of mentally or physically handicapped dependants(max 125000-ref rule)0
55
(c)80DDB-Expenditure incurred on medical treatment of self / dependant for specified (see list) deceases.(max40000/100000sr.cit)0
56
(d)80E-Interest paid for educational loan taken for higher education of self/dependent children(no limit) 0
57
(e)80EE-New House purchase loan after 2016-17 Interest bal 2017-18 (see conditions)0
58
(f)80CCG-Notified Equity Saving scheme-Rajiv Gandhi Equity Saving(see Limit)0
59
(g)80U-For Employee with disability (Rs75000 or If >80% disability 1.25L)0
60
(h)80G-Donations to relief Funds and charitable institutions Including CMDRF - (see conditions) 0
61
(I)80GGC-Donations made to any Political party-incash 2000 only (see conditions) 0
62
(j)80GG-for individuals who do not own a residential house & do not receive HRA (see conditions&Limit) 0
63
(k)80TTA-Deduction for Income from any bank/PO SB Interest (Max. 10000)0
64
(l)80TTB-Deduction for Income from any bank/PO FD Interest for senior citizens (Max. 50000)0
65
(m)80 CCD(1B) Employee's Contribution to NPS (Max. 50000 Addl – see conditions)0
66
(n)80 CCD(2) Employer's Contribution to NPS (Max. 10% of PAY+DA-see conditions)0
67
Deduct:Total of 110
68
12(1) Sec. 80C
69
(a)Life Insurance Premia of self, spouse and children (salary deduction)0
70
(b)Contribution towards GPF/KASEPF0
71
(c)Contribution towards SLI,GIS,FBS,PLIC,(salary deduction)0
72
(d)Contribution made ULIP,UTI,LIC ( other than salary deduction)0
73
(e)Tax saver in scheduled bank / Post Office for a period of not less than 5 years0
74
(f)Purchase of NSC / tax saving units of Mutual Fund / UTI0
75
(g)Contribution to any deposit scheme or pension fund setup by NHB0
76
(h)Tution fees for the full time education of any two children.0
77
(I)Principal part of HBA Repayment & stamp duty paid for purchase of property0
78
(j)Subscription to equity shares , debentures of an eligible issue.0
79
(k)Subcription to eligible units of mutual fund,Infrastructure bonds ICICI,IDBI etc.,0
80
(l)Any other deduction Ch VIA/80C0
81
(m)0
82
2- (n)80CCC-Payment for annuity plan of the LIC or any other insurer.0XNPNP1NP2tot
83
3- (o)80CCD(1)-Contribution of employee to PPF/NPS (see conditions)0015000000
84
Deduction (Maximum Rs. 150000) : Total of 100000
85
13-Total Taxable income (10-11-12) നികുതി വിധേയ വരുമാനം (OLD REGIME)0
86
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)		0
87
15-Add: Surcharge:Total income if exceeds 50 L 10%, if exceeds1Cr 15%, if exceeds 2Cr 25% & 37% if exceeds Rs. 5 Cr.0
88
16-Income Tax and Surcharge payable.(14+15)0
89
17-Less: Rebate for income upto 5 Lakhs u/s 87A0
90
18-Total Tax Payable (16-17)0
91
19-Health and Education Cess [@4% of (18)]0
92
20-Less: Relief for arrears of salary u/s 89(1) [Use form 10E]0
93
21-Income Tax Payable on existing scheme option (18+19-20) ആകെ അടക്കേണ്ട ഇന്‍കം ടാക്സ് സംഖ്യ (OLD REGIME)0
94
22-Total Taxable income (1+8-O66) നികുതി വിധേയ വരുമാനം (NEW REGIME)17150
95
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)0
96
24Add: Surcharge:Total income if exceeds 50 L 10%, if exceeds1Cr 15%, if exceeds 2Cr 25% & 37% if exceeds Rs. 5 Cr.0
97
25Income Tax and Surcharge payable.(23+24)0
98
26Less: Rebate for income upto 5 Lakhs u/s 87A0
99
27Total Tax Payable (25-26)0
100
28Health and Education Cess [@4% of (27)]0