ABCDEAIAJAKALAMANAOAPAQAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBO
1
2
Income Tax for the Financial Year 2023-24
designed by Ch Nagendra Rao,SA(Maths), Cell : 9440297273 / 7013554134
3
1.We have to fill up the items in the Green colour boxes using "TAB" button
2.Fillup Employee ID NO, then click "Submit" button compulsory. Dates should be in the form of MM/DD/YYYY
3.Read the fields carefully and click on "Yes" or "No" buttons which is applicable to you.
4.At the end of this sheet please click "Submit" button compulsory
5.In "house rent receipt" sheet; Door No, place, Address should be noted manually.
4
1Employee ID NO (ID given by the Treasury ) :0549611
5
Name of the Teacher/EmployeeCH NAGENDRA RAO
6
DesignSA
7
Sex (Male=M, Female=F)M
8
Official AddressSchool NameMPUP SCHOOL
9
VillageSIDHARDHA NAGAR
10
MandalNUZVID
11
DistrictKRISHNA
12
PAN Number of the Teacher/ EmployeeAIFXXXXXXJ
13
2For tax calculationAgeBelow 60 Years
21
Income Tax Regime optedOld Tax Regime
22
3Pay change Due to from (mm/dd/yyyy)pay
23
Pay as on 01-03-202383000
24
Annual Grade Increment01-06-202385240
25
Not Applicable0
26
Not Applicable0
27
Not Applicable0
28
4PP / FP / HMA / Spl Allowance for handling higher subjects
29
PPs+FP200
30
HMA / Spl Allowance for handling higher subjects as on01-03-2023
31
If HMA changes after 1-3-2022, date and HMA
32
5DA arrears drawn
33
DA arrears taken From
(MM/DD/YYYY)		TO
(MM/DD/YYYY)
34
DA arrears ( 22.75% )01-01-202230-06-2023
35
DA arrears taken (26.39% )01-07-202231-10-2023
36
6HRA
37
HRA as on 01-03-202312
38
If HRA changes after 1-3-2023, date and HRA %
39
7Other Allowances and SL
40
Whether CCA applicableNot Applicable
41
Whether PHC Allowance applicable, if yes % of disabilityNoabove 40%
42
No of ELs Surrendered during the year 2023-240
43
Surrender Leave MonthJune-2023
44
8whether Loss of Pay or Half Pay Leave during this year
50
FOR HRA EXEMPTION
51
9whether you have own house Property Not Applicable
52
Rent Paid per month (if living in own house rent paid = 0)#VALUE!
57
10Income from other sources such as Interests on Savings A/C s etc.
58
11whether PRC-2015, AAS or Promotion Arrears etc drawn during the year
69
12DEDUCTIONS
70
Note : we can change the Deduction mode by selecting the required deduction under section 80C in the GREEN colour rows
71
DEDUCTIONS Under Chapter VI A..U/s. 80C
72
EHS Contribution per month300
73
LIC (Monthly Salary Deduction)
74
LIC per year paid by hand
75
APGLI subscription per month3000
76
GIS120
77
PF6000
78
Payment of Tuition fee towards 2 children
79
Repayment of HBA instalments. (Principle Amount)
80
Conttribution to Public Provident fund
81
Investment in Equity Linked Saving Scheme
82
Contribution to Pension fund of LIC or any other insurer U/s. 80 CCC
83
Rajiv Gandhi Equity Savings Scheme (50% of amount invested and is Max. up to Rs.25000/-) U/s 80CCG
84
13Deductions change, if any
85
DeductionfromAmount (rs)
86
APGLI
87
GIS
88
ZPPF/GPF
89
14OTHER DEDUCTIONS UNDER CHAPTER VI A.
90
Medical Insurance premium U/S. 80 D
91
Treatment of Handicapped Dependent U/S. 80 DD
92
Expenditure on Medical Treatment of Dependent U/S. 80 DDB
93
Interest Paid on Education Loan (No Max limit) U/S 80 E
94
Donation to Charitable institution U/S. 80 G
95
Maintenance of Totally Blind or P.H. U/S. 80 U0
96
Interest earned on Savings Bank Account U/S. 80 TTA (Up to Rs.10000)
97
15whether Income Tax already Paid if any
98
MonthTax Amount
99
March-202312000
100
April-202312000
101
May-202312000
102
June-202312000
103
July-202312000
104
August-202312000
105
September-202312000
106
October-202312000
107
November-202312000
108
December-2023
109
January-2024
110
February-2024
111
16DDOs Particulars
112
Name of Tax deductor (DDO)B VENKATESWARLU
113
Father's Name of DDO
114
Designation of the DDOMANDAL EDUCATIONAL OFFICER
115
Address of the DDONUZVID
116
Pan No of the DDOAMFPB4977A
117
Tan No of the DDOHYDM05389G
124
17Tax payable Now :#VALUE!
125
Note: 1)Medical Insurance premium U/S. 80-D
(up to 25000/- for family members and parents,
Insurance Rs.50000/-and Medical expenditure Rs.50000/- in case of senior citizen)
2)Treatment of Handicapped Dependent U/S.80-DD
(Rs.75000 for above 40% disability (OR) Rs.125000 for above 80% disability)
3)Expenditure on Medical Treatment for himself or Dependent U/S.80-DDB
(Rs.40000 or Actual expenditure whichever is less , Rs.60000 if the dependent is above 60 years and above, Rs.80000 if the dependent is 80 years and above )
4)Maintenance of Totally Blind or P.H.C U/S.80-U
(40% and above disability up to Rs.75000 & more than 80% disability up to Rs.125000 for self)
126
AAS software
127
128
129
130
131
132