ABCDEFGHIJKLMNOPQRSTUVWXYZ
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 2025-2026 (AY-2026-2027)
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
2a
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 in february 2026
21
22
நண்பர்களே வணக்கம்
23
வருமான வரி 2025-26 எளிய கணக்கீட்டு படிவம் இணைத்துள்ளேன். ஒரு Excel Sheet இல் 24 பணியாளர்களுக்கு கணக்கீடு செய்யலாம். மிக குறைந்த உள்ளீடுகள் போதுமானது.
24
இந்த ஆண்டு 80CCD (1b) பிரிவில் பணியாளர் தனியே NPS Tier 1 account இல் முதலீடு செய்து இருந்தால் மட்டுமே உள்ளீடு செய்யும் வகையில் மாற்றப்பட்டுள்ளது. CPS இல் உள்ள கூடுதல் தொகையினை அதுவாக எடுத்து வராது.
25
Input Sheet இல் பதிவுகள் மேற்கொண்டால் – அந்தந்த தனித்தனி S2, S3, S4…. Sheet இல் கணக்கீடுகள் வந்துவிடும்.
26
INPUT SHEET - One time entry – common to all Employees
27
Sl. No.FieldLocationInput
28
1TANC2Enter your office TAN
29
2School/office NameF2GTRPS BEEMARAPATTI
30
3DDO DesignationC3HB401
31
4DDO NameF3
32
5HRAC6Select your HRA grade
33
6Profession TaxF61250
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.FieldLocationInput
39
1PANB11BXRPA3057L
40
2 NameC11R.ARUN
41
3DesignationD11Second grade teacher
42
4MAR2025-PAYE1155100
43
5Increment MonthF11October
44
6HRAG11AUTOMATIC CALCULATION
45
7CCAH11
46
8CPSI118430
47
9GPFJ11
48
10NHISK11
49
11SPFL1170
50
12IT +CESSM11Enter the IT, IT cess amount
51
(in individual sheet you can make any change in it- no problem)
52
13P.L.IN11
53
14RENT / MONTHO11
54
15Home Loan IntP11Enter the home loan interest amount
55
16Home Loan PrinciQ11Enter the home loan principle amount
56
17Tuition FeesR11Enter tuition fee amount (max 2 children)
57
18ULIP / FDS11Unit Linked Insurance policy or Fixed Deposit or SIP or MF investment under sec 80c
58
19
59
20Physically Challenged (80U)U11Select the percentage below 40% no deduction. 40-79% =750000 above 80%125000
60
21OLD REGIME TAXV11This year Total tax will appear for you reference
61
22NEW REGIME W11
62
23MINIMUM RENTY11minimum 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 …04.04.2025
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