Original IT 02-02-2024.xlsm

	A	C	D	E	F	J	K	L	M	N	O	P	Q	R	S
1	Income Tax Calculation (2023 - 2024)							If any Changes In below Enter your Amount in Suitable Month and Click Enter Button
2
3
4		Given Option for		Type of Service (GPF/CPS)		Advance Tax		Basic Pay	PP & FP	GPF	TSGLI	GIS	HRA	CCA	DA
5		Full Name of Employee	Bairy Ramesh	CPS (PRAN) A/c No.	12345/EDN	Mar-23		92050		11048	3000	60	13	0	20.02
6		Father Name	Mallaiah	Monthly Subscription	4000	Apr-23		92050		11048	3000	60	13	0	20.02
7		Designation	School Assistant (Maths)	TSGLIF A/C No	123456	May-23	5000	92050		11048	3000	60	13	0	20.02
8		Place of working	ZPHS Nasupur	TSGLI Monthly Deduction	3000	Jun-23	5000	92050		11299	3000	60	13	0	22.75
9		Mandal	Sircilla	GIS		Jul-23	5000	94470		11596	3000	60	13.00	0	22.75
10		District	Rajanna Sircilla	Education Fee Concession		Aug-23	5000	94470		11596	3000	60	13	0	22.75
11		Gender		CCA	0	Sep-23	5000	94470		11596	3000	60	13	0	22.75
12		Employee ID(Treasury)	1234567	if CCA Changed		Oct-23	5000	96890		11893	3000	60	13	0	22.75
13		PAN Number	ZXCVFD	New CCA	0	Nov-23	5000	96890		11893	3000	60	13	0	22.75
14		Age		Effect From		Dec-23	15000	96890		11893	3000	60	13	0	22.75
15		Basic Pay on Jan-2023		Total PRC Arrears per Month	2350	Jan-24	15000	96890		11893	3000	60	13	0	22.75
16		Taken Promotion		PRC - CPS Installment	1	Feb-24	30576	96890		11893	3000	60	13	0	22.75
17		Type of Fixation	Not Aappicable	DA Arrears @ 20.02%	29784
18		Date of Promotion		DA Arrears @ 22.75%	42349		4
19		Increment Month		Employee Welfare Fund	20		FR 22a(i) Intial Fixation
20		Awarded AAS during this Fin. Year		Sainik Welfare Fund	100		FR 22B Fixation on Promotion Date
21		If Yes, Monitory benefit effect from		Status of House			FR 22b Fixation on Increment Date
22		S L Claimed in the Month		House Ownder Name	V.Kumar		Not Aappicable
23		No of SL Days Claimed		H.No.	12-5-1/1/A
24		HRA		Street / Village	Ramnagar
25		Changed HRA		Mandal	Sircilla
26		New HRA		District	Rajanna Sircilla
27		Effect from		PAN Number of Owner	XYZW1234A
28		TS_SP	570	Interest on Saving Account U/s 80 TTA	15000
29		Green Fund	300	Income from capital Gains
30		PHC Allowance		Income from House Property/ Rent Recieved
31		PHC Status		Income from other sources		Next
32		PP & FP		House Rent Paid	24600
33		Place	Sircilla	Date	12.02.2024
34
35
36
37
38
39
40
41
42
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