IT-2026-27 KSK V2 08.11.26.xls

	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 Tax year 2026-2027 (period from 01.04.26 to 31.03.27)
3	SLS	calculation included
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
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 , Single page printable area 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 in february 2027
21
22	நண்பர்களே வணக்கம்
23		வருமான வரி 2026-27 எளிய கணக்கீட்டு படிவம் இணைத்துள்ளேன். ஒரு 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
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	MAR2026-PAY	E11	Enter MARCH2026 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	Conveyance Allowa	I11	If Physically challanged and getting con all
47	9	Other Allowance	J11	ENTER if any other allowances
48	10	Personal Pay	K11	enter personal pay amount
49	11	SLS MONTH	L11	Select SLS MONTH
50	12	This Year Tax amount	M11	This year Total tax will appear for you reference
51	Like this you can enter the individual employees particulars in INPUT sheet s3..s4..s5…upto s25…
52	Thanks …			08.11.26
53	Selva7pc@gmail.com
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