KSS PRASAD IT SOFTWARE 2024-25 FEB 2.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 02-02-2025 (Final)
6	Employee			K S S PRASAD			Basic Pay as on Jan-24												Jul-18	59890
7	Designation						Increment Month												Aug-18	59890												1st DA without SL	2nd DA without SL
8	School / Office Name						Promotion Increment												Sep-18	59890										AP & TS				S Leave		S Leave		AAS		Promotion		AP 3rd DA
9	Working Place						AAS Increment (6,12,18,24 Years)												Oct-18	59890										1st DA	2nd DA					30/15days	30/15days	1st	2nd	1st	2nd
10	Mandal						Half Pay Leave (Select No of days)												Nov-18	59890	#REF!							2240	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	59890	#REF!				A.P PRC Arrears Total	P.F		2301	Aug-20	2,379	0	2,379	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	59890					T.S PRC Arrears Monthly Cash	CPS			Sep-20	2,379	0	2,379	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	59890					A.P PRC Arrears Total	P.F			Oct-20	2,379	0	2,379	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	61450						P.F			Nov-20	2,379	0	2,379	0	0		0	0	0	0	0	0
15	Designation						APGLI	Monthly				2018-19							Apr-19	61450	#REF!					P.F			Dec-20	2,379	0	2,379	0	0		0	0	0	0	0	0
16	School / Office Name						GIS	Monthly				2019-20							May-19	61450									Jan-21	2,379	2,379	2,379	2,379	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	61450									Feb-21	2,379	2,379	2,379	2,379	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	61450									Mar-21	2,379	2,379	2,379	2,379	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	61450							-	Drawing HRA Yearly	Apr-21	2,379	2,379	2,379	2,379	0	0	0	0	0	0	0	0
20	Old Tax / New Tax						Reader Allowence					2023-24							Sep-19	61450			CMRF						May-21	2,379	2,379	2,379	2,379	0	0	0	0	0	0	0	0
21	Below 60Y / Above 60Y						C.C.Allowence												Oct-19	61450		YES	#ERROR!	#ERROR!			-	Minus 10% Salary	Jun-21	2,379	2,379	2,379	2,379	0	0	0	0	0	0	0	0
22	O.P.S / C.P.S						S.C.Allowence												Nov-19	61450		NO	#ERROR!	#ERROR!			-		Jul-21	2,379	2,379	2,379	2,379	0	0	0	0	0	0	0	0	1056	Jul-21
23	Vacation / NonVacation						Aditional.H.R.A					Income/Loss from House Property U/s 24(b)							Dec-19	61450									Aug-21	2,379	2,379	2,379	2,379	0	0	0	0	0	0	0	0	1056	Aug-21
24	Rented House / Own House						EWF	Mar-24 Employ Welfare Fund				Income/Loss from House Property U/s 24(b)							Jan-20	61450									Sep-21	2,379	2,379	2,379	2,379	0	0	0	0					1056	Sep-21
25	P.H.C Allowence						SWF	Dec-24 Sainic Welfare Fund				SELECT (YES) for Income / Loss					Let Out Property		Feb-20	61450							0		Oct-21	2,446	2,446	2,446	2,446		0	0	0					1056	Oct-21
26	Any Allowences						Child Fee Concession					Annual Rent Received from House Property				A	A
27								Old 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	61450									Nov-21	2,446	2,446	2,446	2,446		0	0	0					1056	Nov-21
30																D	D		May-20	67190							Rs		Jan-22	2,446	2,446	2,446	2,446		0	0	0					1056	Jan-22
31												INCOME	from House Property U/S 24			E	E=D-(A-(B+C))		Jun-20	67190									Feb-22	2,446	2,446	2,446	2,446		0	0	0					1056	Feb-22
32	ADVANCE TAX			Quarter		Amount	DEDUCTIONS			Sections	Amount								Jul-20	67190									Mar-22	2,446	2,446	2,446	2,446		0	0	0					1056	Mar-22
33	Mar-24	Salary	Paid in	Apr-24	Q1		Tution Fee for Two Children			80C									Aug-20	67190									Apr-22	2,446	2,446	2,446	2,446		0	0	0					1085	Apr-22
34	Apr-24	Salary	Paid in	May-24			Principle Amount of Home Loan installments			80C									Sep-20	67190									May-22	2,446	2,446	2,446	2,446		0	0	0					1085	May-22
35	May-24	Salary	Paid in	Jun-24			LIC Policies premium - Yearly			80C									Oct-20	67190									Jun-22	2,446	2,446	2,446	2,446		0	0	0					1085	Jun-22
36	Jun-24	Salary	Paid in	Jul-24	Q2				Select these	80C									Nov-20	69020									Jul-22	2,446	2,446	2,446	2,446		0	0	0					1085	Jul-22
37	Jul-24	Salary	Paid in	Aug-24						80C									Dec-20	69020									Aug-22	2,446	2,446	2,446	2,446		0	0	0					1085	Aug-22
38	Aug-24	Salary	Paid in	Sep-24						80C									Jan-21	69020									Sep-22	2,446				0	0	0	0	0	0	0	0
39	Sep-24	Salary	Paid in	Oct-24	Q3					80C									Feb-21	69020									Oct-22	2,513
40	Oct-24	Salary	Paid in	Nov-24			Any other enter here			80C																			Nov-22	2,513
41	Nov-24	Salary	Paid in	Dec-24					Select these	80E																			Dec-22	2,513
42	Dec-24	Salary	Paid in	Jan-25	Q4					80EEB																			Jan-23	2,513
43	Jan-25	Salary	Paid in	Feb-25						Sec.24																			Feb-23	2,513
44	Feb-25	Salary	Paid in	Mar-25						80D																				0
45	Total Advance Tax Amount				0					80DD
46										80G
47							Any other enter here
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