IT AY 2024-25 Ver 24.1.xlsm

	B	E	K	L	N	O	P	Q	S	U	V	W	Z
1
2	Income Tax Calculation for AY 2024-25 (FY 2023-24)
3					Version 24.1
4					Version 24.1
5
6
7
8
9
10	Enter the following Data :
11	Name
12
13	Designation
14
15	PAN
16
17	School / Office NAME
18
19	School / Office TAN
22			Super Senior Citizen								To clarify doubts, if any, Scan QR - Join WA Group.
25	Date of Birth					dd-mm-yyyy					To clarify doubts, if any, Scan QR - Join WA Group.
26
27
28		LEVEL in Pay Matrix
29													FALSE
30		BASIC Pay for Mar-2023
31										TRUE		FALSE
32		Increment Month								FALSE	FALSE	TRUE
34					₹				SPF	₹		70
35
36	Personal Pay for Mar-2023								Conv	₹		0
37	PF Scheme
38
39
40				0			0
42
45		Monthly House Rent PAID			₹	0		0				.
46										TRUE
47		Professional Tax Paid			₹	0
48
49		Interest on Housing Loan u/s 24 (b)			₹	0		Max. ₨2,00,000
50
51		Repayment of Housing Loan (Principal)			₹	0		No Limits but bound to the limit u/s 80 C
54
55
56		Permanent Disabilty (Self)
57		Permanent Disabilty (Dependant)
58
59
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257