639042079251631191.xls

	C	D	E	F	G	H	J	K	N	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: 2025-26 (A.Y : 2026-27)												modified on 17-01-2026
6
7	Employee						Basic Pay as on Jan-25													Jul-18	66330
8	Designation						Increment Month													Aug-18	66330	#REF!											1st DA without SL	2nd DA without SL
9	School / Office Name						Promotion Increment													Sep-18	66330	#REF!									AP & TS				S Leave		S Leave		AAS		Promotion		AP 3rd DA
10	Working Place						AAS Increment (6,12,18,24 Years)													Oct-18	66330										1st DA	2nd DA					30/15days	30/15days	1st	2nd	1st	2nd
11	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
12	District						Surrender leave (2025-26)													Dec-18	66330	#REF!				A.P PRC Arrears Total	P.F		2558	Aug-20	2,650	0	2,650	0	0		0	0	0	0	0	0
13	PAN No.						P.Pay + F.P.Pay						Financial Year	Year wise Arrears	Taxable Income	Tax Relief			#REF!	Jan-19	66330	#REF!				T.S PRC Arrears Monthly Cash	CPS			Sep-20	2,650	0	2,650	0	0		0	0	0	0	0	0
14	Emp Treasury ID						HRA	Monthly		If Change			Financial Year	Year wise Arrears	Taxable Income	Tax Relief			#REF!	Feb-19	66330					A.P PRC Arrears Total	P.F			Oct-20	2,650	0	2,650	0	0		0	0	0	0	0	0
15	DDO Name						ZPPF	/ GPPF/ Class IV GPF					2017-18			Enter Taxable Income here according to their Fin. Years				Mar-19	67990						P.F			Nov-20	2,650	0	2,650	0	0		0	0	0	0	0	0
16	Designation						APGLI	Monthly					2018-19							Apr-19	67990	#REF!					P.F			Dec-20	2,650	0	2,650	0	0		0	0	0	0	0	0
17	School / Office Name						GIS	Monthly					2019-20							May-19	67990	#REF!								Jan-21	2,650	-27,165	2,650	-27,165	0	0	0	0	0	0	0	0
18	Working Place						LIC	Salary Paid Monthly					2020-21				For result, go to Anex-II and Form-16 in Serial No-8.			Jun-19	67990									Feb-21	2,650	-27,165	2,650	-27,165	0	0	0	0	0	0	0	0
19	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	67990									Mar-21	2,650	-27,165	2,650	-27,165	0	0	0	0	0	0	0	0
20	D.D.O. PAN No						Employ	Health Insurance Monthly					2022-23				Print Form No.10E, Annexure-1 pages and attached with FORM-16			Aug-19	67990							#REF!	Drawing HRA Yearly	Apr-21	2,650	-27,165	2,650	-27,165	0	0	0	0	0	0	0	0
21	Old Tax / New Tax						Reader Allowence						2023-24							Sep-19	67990			CMRF						May-21	2,650	-27,165	2,650	-27,165	0	0	0	0	0	0	0	0
22	Below 60Y / Above 60Y						C.C.Allowence						2024-25							Oct-19	67990		YES	#ERROR!	#ERROR!				Minus 10% Salary	Jun-21	2,650	-27,165	2,650	-27,165	0	0	0	0	0	0	0	0
23	O.P.S / C.P.S						S.C.Allowence						2024-26							Nov-19	67990		NO	#ERROR!	#ERROR!			#REF!		Jul-21	2,650	-27,165	2,650	-27,165	0	0	0	0	0	0	0	0	1175	Jul-21
24	Vacation / NonVacation						Aditional.H.R.A						Income/Loss from House Property U/s 24(b)							Dec-19	67990									Aug-21	2,650	-27,165	2,650	-27,165	0	0	0	0	0	0	0	0	1175	Aug-21
25	Rented House / Own House						EWF	Mar-25 Employ Welfare Fund					Income/Loss from House Property U/s 24(b)							Jan-20	67990									Sep-21	2,650	-27,165	2,650	-27,165	0	0	0	0					1175	Sep-21
26	P.H.C Allowence						SWF	Dec-25 Sainic Welfare Fund					SELECT (YES) for Income / Loss					Let Out Property		Feb-20	67990							0		Oct-21	2,650	-27,165	2,650	-27,165		0	0	0					1175	Oct-21
27	Any Allowences						Child Fee Concession						Annual Rent Received from House Property				A	A
28								New Tax regime					Enter Muncipal Tax Paid on House Property				B	B
29							#REF!		#REF!				As Rebate (30% of Income as Maintenance)				C	C=(A-B) x 30%		Mar-20	67990									Nov-21	2,722	-27,897	2,722	-27,897		0	0	0					1175	Nov-21
31																	D	D		May-20	74770							Rs		Jan-22	2,722	-27,897	2,722	-27,897		0	0	0					1175	Jan-22
32													INCOME	from House Property U/S 24			E	E=D-(A-(B+C))		Jun-20	74770									Feb-22	2,722	-27,897	2,722	-27,897		0	0	0					1175	Feb-22
33	ADVANCE TAX			Quarter		Amount	DEDUCTIONS				Sections	Amount	Sections and their Limits							Jul-20	74770									Mar-22	2,722	-27,897	2,722	-27,897		0	0	0					1175	Mar-22
34	Mar-25	Salary	Paid in	Apr-25	Q1		Tution Fee for Two Children				80C									Aug-20	74770									Apr-22	2,722	-27,897	2,722	-27,897		0	0	0					1175	Apr-22
35	Apr-25	Salary	Paid in	May-25			Principle Amount of Home Loan installments				80C									Sep-20	74770									May-22	2,722	-27,897	2,722	-27,897		0	0	0					1206	May-22
36	May-25	Salary	Paid in	Jun-25			LIC Policies premium - Yearly				80C									Oct-20	74770									Jun-22	2,722	-27,897	2,722	-27,897		0	0	0					1206	Jun-22
37	Jun-25	Salary	Paid in	Jul-25	Q2						80C									Nov-20	74770									Jul-22	2,722	-27,897	2,722	-27,897		0	0	0					1206	Jul-22
38	Jul-25	Salary	Paid in	Aug-25							80C									Dec-20	76730									Aug-22	2,722	-27,897	2,722	-27,897		0	0	0					1206	Aug-22
39	Aug-25	Salary	Paid in	Sep-25							80C									Jan-21	76730									Sep-22	2,722				0	0	0	0	0	0	0	0
40	Sep-25	Salary	Paid in	Oct-25	Q3						80C									Feb-21	76730									Oct-22	2,722
41	Oct-25	Salary	Paid in	Nov-25			Any other enter here				80C																			Nov-22	2,793
42	Nov-25	Salary	Paid in	Dec-25							80E																			Dec-22	2,793
43	Dec-25	Salary	Paid in	Jan-26	Q4						80EEB																			Jan-23	2,793
44	Jan-26	Salary	Paid in	Feb-26							Sec.24																			Feb-23	2,793
45	Feb-26	Salary	Paid in	Mar-26							80D																				0
46	Total Advance Tax Amount				0						80DD
47											80G
48							Any other enter here
49											80 TTA
50							Income from Pension / Family Pension				57(iia)
51	K.S.S.PRASAD,TENALI,GUNTUR						If any Problem find, Please notice through WHATSAPP						9297201205
52
53
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