KSS Prasad IT Final 27th Dec.xls

	C	E	F	G	H	J	K	N	O	P	Q	S	T	U	V	W	X	Y	Z	AE	AF	AV	AX	AY	AZ	BB	BC	BL	BM	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CJ	CK
2	This File Updated on 27th December							This is FINAL
3
4	PART-A					PART-B						PART-C
5	INCOME TAX : Financial Year: 2023-24 (Assesment Year : 2024-25)											D.A Arrears
6	Employee		K S S PRASAD			Basic Pay as on Jan-23														Jul-18	66330
7	Designation					AG Increment Month														Aug-18	66330	#REF!											1st DA without SL	2nd DA without SL
8	School / OfficeName					Promotion Increment														Sep-18	66330	#REF!									AP & TS				S Leave		S Leave		AAS		Promotion		AP 3rd DA
9	Working Place					AAS Increment (6,12,18,24 Years)														Oct-18	66330										1st DA	2nd DA					30/15days	30/15days	1st	2nd	1st	2nd
10	Mandal					Half Pay Leave (Select No of days)														Nov-18	66330	#REF!							2492	Jul-20	0	0	0	0	0		0	0	0	0	0	0
11	District					Surrender leave (2023-24)						Enter Taxable Income below for Tax Relief								Dec-18	66330	#REF!				A.P PRC Arrears Total	P.F		2492	Aug-20	1,987	0	1,987	0	0		0	0	0	0	0	0
12	PAN No.					P.Pay+F.P.Pay						Financial Year	Year wise Arrears	Taxable Income	Tax Relief				No Relief	Jan-19	66330	#REF!				T.S PRC Arrears Monthly Cash	CPS			Sep-20	1,987	0	1,987	0	0		0	0	0	0	0	0
13	Emp Treasury ID					HRA	Monthly		I f C h a n g e			Financial Year	Year wise Arrears	Taxable Income	Tax Relief				No Relief	Feb-19	66330					A.P PRC Arrears Total	P.F			Oct-20	1,987	0	1,987	0	0		0	0	0	0	0	0
14	DDO Name					ZPPF	/ GPPF/ Class IV GPF					2014-15				Enter Taxable Income here according to their Fin. Years				Mar-19	67990						P.F			Nov-20	1,987	0	1,987	0	0		0	0	0	0	0	0
15	Designation					APGLI	Monthly					2015-16								Apr-19	67990	#REF!					P.F			Dec-20	1,987	0	1,987	0	0		0	0	0	0	0	0
16	School / Office Name					GIS	Monthly					2016-17								May-19	67990									Jan-21	1,987	2,651	1,987	2,651	0	0	0	0	0	0	0	0
17	Working Place					LIC	Salary Paid Monthly					2017-18				For result, go to Anex-II and Form-16 in Serial No-8.				Jun-19	67990									Feb-21	1,987	2,651	1,987	2,651	0	0	0	0	0	0	0	0
18	D.D.O. TAN No					H.M	Allowence					2018-19								Jul-19	67990									Mar-21	1,987	2,651	1,987	2,651	0	0	0	0	0	0	0	0
19	D.D.O. PAN No					Employ	Salary Health Insurance					2019-20								Aug-19	67990							#REF!	Drawing HRA Yearly	Apr-21	1,987	2,651	1,987	2,651	0	0	0	0	0	0	0	0
20	Old Tax , New Tax					EWF	Employ Welfare Fund		Reader Allow…			2020-21						Print Form No.10E, Annexure-1 pages and attached with FORM-16		Sep-19	67990			CMRF						May-21	1,987	2,651	1,987	2,651	0	0	0	0	0	0	0	0
21	Below 60Y / Above 60Y					SWF	Sainic Welfare Fund		C.C.Allowence			2021-22			Print Form No.10E, Annexure-1 pages and attached with FORM-16					Oct-19	67990		YES	#ERROR!	#ERROR!			#REF!	Minus 10% Salary	Jun-21	1,987	2,651	1,987	2,651	0	0	0	0	0	0	0	0
22	O.P.S / C.P.S					Child Fee Concession			S.C.Allowence			2022-23								Nov-19	67990		NO	#ERROR!	#ERROR!			#REF!		Jul-21	1,987	2,651	1,987	2,651	0	0	0	0	0	0	0	0	1175	Jul-21
23	Vacation / NonVacation					(Health Dept) Allowences			Aditional.H.R.A			Income/Loss from House Property under section 24								Dec-19	67990									Aug-21	1,987	2,651	1,987	2,651	0	0	0	0	0	0	0	0	1175	Aug-21
24	Rented House / Own House								Select			SELECT (YES) for Income / Loss Property								Jan-20	67990									Sep-21	1,987	2,651	1,987	2,651	0	0	0	0					1175	Sep-21
25	P.H.C Allowence								Select			Annual Rent Received from House Property					A	A		Feb-20	67990							0		Oct-21	1,987	2,651	1,987	2,651		0	0	0					1175	Oct-21
26	Monthly Rent Paid by You				#REF!	#REF!						Enter Muncipal Tax Paid on House Property					B	B		Mar-20	67990									Nov-21	1,987	2,651	1,987	2,651		0	0	0					1175	Nov-21
27	Monthly Rent Paid by You				#REF!	#REF!						As Rebate (30% of Income as Maintenance)					C	C=(A-B) x 30%		Apr-20	74770									Dec-21	1,987	2,651	1,987	2,651		0	0	0					1175	Dec-21
28	#REF!																D	D		May-20	74770							Rs		Jan-22	2,041	2,722	2,041	2,722		0	0	0					1175	Jan-22
29	#REF!											INCOME	from House Property U/S 24				E	E=D-(A-(B+C))		Jun-20	74770									Feb-22	2,041	2,722	2,041	2,722		0	0	0					1175	Feb-22
30	ADVANCE TAX			Quarter	Amount	DEDUCTIONS				Sections	Amount									Jul-20	74770									Mar-22	2,041	2,722	2,041	2,722		0	0	0					1175	Mar-22
31	Mar-23	Paid in	Apr-23	Q1		Tution Fee for Two Children				80C										Aug-20	74770									Apr-22	2,041	2,722	2,041	2,722		0	0	0					1175	Apr-22
32	Apr-23	Paid in	May-23			Principle Amount of Home Loan installments				80C										Sep-20	74770									May-22	2,041	2,722	2,041	2,722		0	0	0					1175	May-22
33	May-23	Paid in	Jun-23			LIC Policies premium - Yearly				80C										Oct-20	74770									Jun-22	2,041	2,722	2,041	2,722		0	0	0					1175	Jun-22
34	Jun-23	Paid in	Jul-23	Q2					Select these	80C										Nov-20	74770									Jul-22	2,041	2,722	2,041	2,722		0	0	0					1175	Jul-22
35	Jul-23	Paid in	Aug-23							80C										Dec-20	74770									Aug-22	2,041	2,722	2,041	2,722		0	0	0					1175	Aug-22
36	Aug-23	Paid in	Sep-23							80C										Jan-21	74770									Sep-22	2,041				0	0	0	0	0	0	0	0
37	Sep-23	Paid in	Oct-23	Q3						80C										Feb-21	74770									Oct-22	2,041
38	Oct-23	Paid in	Nov-23			Any other enter here				80C																				Nov-22	2,041
39	Nov-23	Paid in	Dec-23			Select these				80E																				Dec-22	2,041
40	Dec-23	Paid in	Jan-24	Q4						80CCD(1B)																				Jan-23	2,041
41	Jan-24	Paid in	Feb-24							Sec.24																				Feb-23	2,041
42	Feb-24	Paid in	Mar-24							80D																					0
43	Total Advance Tax Amount				0					80U
44										80G
45						Any other enter here
46	K.S.S.PRASAD,TENALI,GUNTUR					kssp2010@gmail.com
47
48
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172