income-tax-calculator-2021-22-ay-2022-23-final-2.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	KENDRIYA VIDYALAYA : …																											YES
2	Address ……….																											NO
3	ANNUAL INCOME STATEMENT FROM						4/1/2021		to	3/31/2022				Assesment Year			2022-23											900
4	Pay particulars in respect of Shri/Smt./Kum.																					PAN NO						1800
5	Basic Pay in March				42300		Month of Increment			July	43600			Pay Level							6	TAN NO of employer						3600
6	Choose relevant option above the column→							9	1800		YES		NO	NO														7200
7	S.No	Month	TO Days	P Days	Pay Band	D.A @	D.A	HRA	Transp. Allow.	DA Transp. Allow.	NPS (KVS Cont.)	Special Pay Allow.	CPF (MS)	P.C.	Other Allowances	Grand Total	Income Tax	Prof. Tax	NPS (KVS Cont.)	NPS (Emp. Cont.)	P.C.	KVS EWS	CPF (MS)	GPF/ CPF	Oth. Rec	Total Deduct.	Net Salary	0
8	1	March	31	31	42300	17	7191	3384	1800	306	4949	0	0	0		59930			4949	4949	0	60	0		0	9958	49972	9
9	2	April	30	30	42300	17	7191	3384	1800	306	4949	0	0	0		59930			4949	4949	0	60	0		0	9958	49972	18
10	3	May	31	31	42300	17	7191	3384	1800	306	4949	0	0	0		59930			4949	4949	0	60	0		0	9958	49972	27
11	4	June	30	30	42300	17	7191	3384	1800	306	4949	0	0	0		59930			4949	4949	0	60	0		0	9958	49972	JAN
12	5	July	31	31	43600	31	13516	3924	1800	558	5582	0	0	0		68980			5582	5712	0	60	0		0	11354	57626	July
13	6	Aug.	31	31	43600	31	13516	3924	1800	558	5582	0	0	0		68980			5582	5712	0	60	0		0	11354	57626
14	7	Sep.	30	30	43600	31	13516	3924	1800	558	5582	0	0	0		68980			5582	5712	0	60	0		0	11354	57626	3384
15	8	Oct.	31	31	43600	31	13516	3924	1800	558	7996	0	0	0		71394			7996	5712	0	60	0		4212	17980	53414	6768
16	9	Nov.	30	30	43600	31	13516	7848	1800	558	7996	0	0	0		75318	3000		7996	5712	0	60	0		0	16768	58550	10152
17	10	Dec.	31	31	43600	31	13516	7848	1800	558	7996	0	0	0		75318	6000		7996	5712	0	60	0		0	19768	55550
18	11	Jan.	31	31	43600	31	13516	7848	1800	558	7996	0	0	0		75318			7996	5712	0	60	0		0	13768	61550
19	12	Feb.	28	28	43600	31	13516	7848	1800	558	66889	0	0	0		134211			66889	5712	0	60	0		0	72661	61550
20	TOTAL				518000		136892	60624	21600	5688	135415	0	0	0	0	878219	9000	0	135415	65492	0	720	0	0	4212	214839	663380
21
22	Children Education Allowance							Gross Salary					884312					Other Arrears 1			6093	Other Arrears 2
23							Less allowances Under Section 10							HRA CALCULATION				(c)Are you resident of Delhi,Mumbai,Kolkata or Chennai							NO		261957
24	SAVINGS UPTO 150000 UNDER 80C						Pensionary Contribution				0		Actual amount of HR paid					(b)Rent paid in excess of 10% of the salary									6,511
25		Other Saving					(i)Other allowances							72,000				(a) Actual amount of HRA received							65489		60624
26	1	GPF/CPF			0		(ii)Exemption in HRA				6,511							Are you Handicapped→				19,200	21,600		YES
27	2	MUTUAL FUND			6000		(iii)Trans Allow.				21,600				1	Income from Salary					884,312		Tax				0	0
28	3	NPS (Emp. Contribution)			15,492		(iv)P.Tax				0				2	Less allowances Under Section 10					28,111
29	4	LIC					TOTAL				28,111				3	Examption under rules(80E,80U,80CCD ii)					310,415		Health &Education Cess				0
30	5	Tutions Fees					(i) Rebate CEA								4	SAVINGS UPTO 150000 UNDER 80C					125,492
31	6	Home Load P					(ii) Standard deduction				50,000				5	Taxable Income					420,294		Tax payable				0
32	7	PLI			38000		(iii) Mediclaim u/s 80D				0					Range	Amount		Tax
33	8	PPF			66000		(iv)Housing/Edu loan interest 80E/80EE				0					5%	170,294		8,515				Tax deducted at source				9,000
34		TOTAL			125492		(v) NPS Employer cont. 80CCD (ii)				135,415					20%	0		0
35							(vi)Physically Challenged 80U				75,000					30%	0		0				Balance tax/refund				-9,000
36							(vii) NPS 80CCD 1(B)				50,000
37							TOTAL				310,415					Tax rebate UNDER 87A				8,515
38
40
41
42		PLEASE FILL			Yello		BACKGROUNDED CELLS
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101