தமிழ்த்துகள் it calculator 2023-24

	A	B	C	D
1	I am K.Selvakumar HM GHSS M.SUBBULAPURAM MADURAI DIST 625702.
2	With my little knowledge I developed this excel sheet - to calculate the Income tax for the financial year 2023-2024 (AY-2024-2025)
3
4	in a single file you can calcuate - Income Tax details for 24 employees.
5	if more than 24 employees - kindly copy and use another file
6
7	minimum entries required
8	made the entries in the "INPUT" sheet
9	single input for TAN, SCHOOL/OFFICE NAME, DDO, DDO NAME, profession tax amout
10	select your area HRA grade city		C6
11
12	s1 first one is model sheet, it was protected, you can't change or alter the first one (its my personal data- for reference/model )
13
14	any other arrear - s.g. arrear you can manually enter the amount in respective columns
15
16	s2 to s25 all sheets are unprotected, you can change or edit or modify any column/row
17	in indivdual sheets , three pages printable area, first two old regime third one new regime.
18	don't alter or change or delete the extra column/outer column , it was related with the prog calculation.
19
20	Abstract sheet single page print out for entire school - to easy to enter in IFHRMS
21
22	நண்பர்களே வணக்கம்
23		வருமான வரி 2023-24 எளிய கணக்கீட்டு படிவம் இணைத்துள்ளேன். ஒரு Excel Sheet இல் 24 பணியாளர்களுக்கு கணக்கீடு செய்யலாம். மிக குறைந்த உள்ளீடுகள் போதுமானது.
24
25	Input Sheet இல் பதிவுகள் மேற்கொண்டால் – அந்தந்த தனித்தனி S2, S3, S4…. Sheet இல் கணக்கீடுகள் வந்துவிடும்.
26	INPUT SHEET - One time entry – common to all Employees
27	Sl. No.	Field	Location	Input
28	1	TAN	C2	Enter your office TAN
29	2	School/office Name	F2	Enter your office name
30	3	DDO Designation	C3	Enter DDO Designation
31	4	DDO Name	F3	Enter DDO Name
32	5	HRA	C6	Select your HRA grade
33	6	Profession Tax	F6	Enter Single Prof Tax amount
34
35	INPUT SHEET – Individual entry (S2-S25)
36	S1- is model and for your reference – you can’t enter or modify it.
37	Kindly use from S2.
38	Sl. No.	Field	Location	Input
39	1	PAN	B11	Enter PAN
40	2	Name	C11	Enter the Name
41	3	Designation	D11	Enter Designation
42	4	MAR2023-PAY	E11	Enter MARCH2023 PAY
43	5	Increment Month	F11	Select the Increment month
44	6	HRA	G11	AUTOMATIC CALCULATION
45	7	CCA	H11	Enter CCA amount
46	8	CPS	I11	If in CPS SELECT yes if in GPF Select No
47	9	GPF	J11	ENTER GPF subscription amount
48	10	NHIS	K11	Select yes or No
49	11	SPF	L11	Select Nil or 50 or 70
50	12	IT +CESS	M11	Enter the IT, IT cess amount
51	12	IT +CESS	M11	(in individual sheet you can make any change in it- no problem)
52	13	P.L.I	N11	Enter the PLI amount if it salary deduction
53	14	RENT / MONTH	O11	If you want to deduct HRA enter the rent amount . for your ref. check the last column Y – minimum HRA to be filled to deduct :HRA received
54	15	Home Loan Int	P11	Enter the home loan interest amount
55	16	Home Loan Princi	Q11	Enter the home loan principle amount
56	17	Tuition Fees	R11	Enter tuition fee amount (max 2 children)
57	18	ULIP / FD	S11	Unit Linked Insurance policy or Fixed Deposit or SIP or MF investment under sec 80c
58	19	CMRF-DONATION	T11	Enter the Number of days - donation
59	20	Physically Challenged (80U)	U11	Select the percentage below 40% no deduction. 40-79% =750000 above 80%125000
60	21	OLD REGIME TAX	V11	This year Total tax will appear for you reference
61	22	NEW REGIME	W11	This year Total tax will appear for you reference
62	23	MINIMUM RENT	Y11	minimum rent amount to be filled in coloumn o11
63	Like this you can enter the individual employees particulars in INPUT sheet s3..s4..s5…upto s25…
64	Thanks …
65	Selva7pc@gmail.com
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