KSSP IT 2024-25 (FINAL).xls

	C	D	E	F	G	H	J	K	O	P	Q	S	T	U	V	X	Y	Z	AR	AS	AX	AZ	BA	BB	BD	BE	BN	BO	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CL	CM
2
3
4	PART-A						PART-B					PART-C
5	INCOME TAX CALCULATION : Financial Year: 2024-25 (A.Y : 2025-26)											modified on 07-01-2025 (Final)
6	Employee			K S S PRASAD			Basic Pay as on Jan-24												Jul-18	61450
7	Designation						Increment Month												Aug-18	61450												1st DA without SL	2nd DA without SL
8	School / Office Name						Promotion Increment												Sep-18	61450										AP & TS				S Leave		S Leave		AAS		Promotion		AP 3rd DA
9	Working Place						AAS Increment (6,12,18,24 Years)												Oct-18	61450										1st DA	2nd DA					30/15days	30/15days	1st	2nd	1st	2nd
10	Mandal						Half Pay Leave (Select No of days)												Nov-18	61450	#REF!							2362	Jul-20	0	0	0	0	0		0	0	0	0	0	0
11	District						Surrender leave (2024-25)					Enter Taxable Income below for Tax Relief							Dec-18	61450	#REF!				A.P PRC Arrears Total	P.F		2362	Aug-20	2,513	0	2,513	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			#REF!	Jan-19	61450					T.S PRC Arrears Monthly Cash	CPS			Sep-20	2,513	0	2,513	0	0		0	0	0	0	0	0
13	Emp Treasury ID						HRA	Monthly	If Change			Financial Year	Year wise Arrears	Taxable Income	Tax Relief			#REF!	Feb-19	61450					A.P PRC Arrears Total	P.F			Oct-20	2,513	0	2,513	0	0		0	0	0	0	0	0
14	DDO Name						ZPPF	/ GPPF/ Class IV GPF				2017-18			Enter Taxable Income here according to their Fin. Years				Mar-19	63010						P.F			Nov-20	2,513	0	2,513	0	0		0	0	0	0	0	0
15	Designation						APGLI	Monthly				2018-19							Apr-19	63010	#REF!					P.F			Dec-20	2,513	0	2,513	0	0		0	0	0	0	0	0
16	School / Office Name						GIS	Monthly				2019-20							May-19	63010									Jan-21	2,513	2,512	2,513	2,512	0	0	0	0	0	0	0	0
17	Working Place						LIC	Salary Paid Monthly				2020-21				For result, go to Anex-II and Form-16 in Serial No-8.			Jun-19	63010									Feb-21	2,513	2,512	2,513	2,512	0	0	0	0	0	0	0	0
18	D.D.O. TAN No						H.M	Allowence				2021-22				For result, go to Anex-II and Form-16 in Serial No-8.			Jul-19	63010									Mar-21	2,513	2,512	2,513	2,512	0	0	0	0	0	0	0	0
19	D.D.O. PAN No						Employ	Salary Health Insurance				2022-23				Print Form No.10E, Annexure-1 pages and attached with FORM-16			Aug-19	63010							-	Drawing HRA Yearly	Apr-21	2,513	2,512	2,513	2,512	0	0	0	0	0	0	0	0
20	Old Tax / New Tax						Reader Allowence					2023-24							Sep-19	63010			CMRF						May-21	2,513	2,512	2,513	2,512	0	0	0	0	0	0	0	0
21	Below 60Y / Above 60Y						C.C.Allowence												Oct-19	63010		YES	#ERROR!	#ERROR!			-	Minus 10% Salary	Jun-21	2,513	2,512	2,513	2,512	0	0	0	0	0	0	0	0
22	O.P.S / C.P.S						S.C.Allowence												Nov-19	63010		NO	#ERROR!	#ERROR!			-		Jul-21	2,513	2,512	2,513	2,512	0	0	0	0	0	0	0	0	1085	Jul-21
23	Vacation / NonVacation						Aditional.H.R.A					Income/Loss from House Property U/s 24(b)							Dec-19	63010									Aug-21	2,513	2,512	2,513	2,512	0	0	0	0	0	0	0	0	1114	Aug-21
24	Rented House / Own House						EWF	Mar-24 Employ Welfare Fund				Income/Loss from House Property U/s 24(b)							Jan-20	63010									Sep-21	2,513	2,512	2,513	2,512	0	0	0	0					1114	Sep-21
25	P.H.C Allowence						SWF	Dec-24 Sainic Welfare Fund				SELECT (YES) for Income / Loss					Let Out Property		Feb-20	63010							0		Oct-21	2,513	2,512	2,513	2,512		0	0	0					1114	Oct-21
26	Any Allowences						Child Fee Concession					Annual Rent Received from House Property				A	A
27								New Tax regime				Enter Muncipal Tax Paid on House Property				B	B
28						-	#REF!					As Rebate (30% of Income as Maintenance)				C	C=(A-B) x 30%		Mar-20	63010									Nov-21	2,513	2,512	2,513	2,512		0	0	0					1114	Nov-21
30																D	D		May-20	70850							Rs		Jan-22	2,513	2,512	2,513	2,512		0	0	0					1114	Jan-22
31												INCOME	from House Property U/S 24			E	E=D-(A-(B+C))		Jun-20	70850									Feb-22	2,579	2,579	2,579	2,579		0	0	0					1114	Feb-22
32	ADVANCE TAX			Quarter		Amount	DEDUCTIONS			Sections	Amount								Jul-20	70850									Mar-22	2,579	2,579	2,579	2,579		0	0	0					1114	Mar-22
33	Mar-24	Salary	Paid in	Apr-24	Q1		Tution Fee for Two Children			80C									Aug-20	70850									Apr-22	2,579	2,579	2,579	2,579		0	0	0					1114	Apr-22
34	Apr-24	Salary	Paid in	May-24			Principle Amount of Home Loan installments			80C									Sep-20	70850									May-22	2,579	2,579	2,579	2,579		0	0	0					1114	May-22
35	May-24	Salary	Paid in	Jun-24			LIC Policies premium - Yearly			80C									Oct-20	70850									Jun-22	2,579	2,579	2,579	2,579		0	0	0					1114	Jun-22
36	Jun-24	Salary	Paid in	Jul-24	Q2				Select these	80C									Nov-20	70850									Jul-22	2,579	2,579	2,579	2,579		0	0	0					1114	Jul-22
37	Jul-24	Salary	Paid in	Aug-24						80C									Dec-20	70850									Aug-22	2,579	2,579	2,579	2,579		0	0	0					1145	Aug-22
38	Aug-24	Salary	Paid in	Sep-24						80C									Jan-21	70850									Sep-22	2,579				0	0	0	0	0	0	0	0
39	Sep-24	Salary	Paid in	Oct-24	Q3					80C									Feb-21	70850									Oct-22	2,579
40	Oct-24	Salary	Paid in	Nov-24			Any other enter here			80C																			Nov-22	2,579
41	Nov-24	Salary	Paid in	Dec-24					Select these	80E																			Dec-22	2,579
42	Dec-24	Salary	Paid in	Jan-25	Q4					80EEB																			Jan-23	2,579
43	Jan-25	Salary	Paid in	Feb-25						Sec.24																			Feb-23	2,650
44	Feb-25	Salary	Paid in	Mar-25						80D																				0
45	Total Advance Tax Amount				0					80DD
46										80G
48									Select	80 TTA
49							Income from Pension / Family Pension		Select	57(iia)
50	K.S.S.PRASAD,TENALI,GUNTUR
51
52
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
173
174