ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This is k.selvakumar HM GHSS ANANDUR623401-RAMANATHAPURAM DIST.
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
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
நண்பர்களே வணக்கம்
21
வருமான வரி 2023-24 எளிய கணக்கீட்டு படிவம் இணைத்துள்ளேன். ஒரு Excel Sheet இல் 24 பணியாளர்களுக்கு கணக்கீடு செய்யலாம். மிக குறைந்த உள்ளீடுகள் போதுமானது.
22
23
Input Sheet இல் பதிவுகள் மேற்கொண்டால் – அந்தந்த தனித்தனி S2, S3, S4…. Sheet இல் கணக்கீடுகள் வந்துவிடும்.
24
INPUT SHEET - One time entry – common to all Employees
25
Sl. No.FieldLocationInput
26
1TANC2Enter your office TAN
27
2School/office NameF2Enter your office name
28
3DDO DesignationC3Enter DDO Designation
29
4DDO NameF3Enter DDO Name
30
5HRAC6Select your HRA grade
31
6Profession TaxF6Enter Single Prof Tax amount
32
33
INPUT SHEET – Individual entry (S2-S25)
34
S1- is model and for your reference – you can’t enter or modify it.
35
Kindly use from S2.
36
Sl. No.FieldLocationInput
37
1PANB11Enter PAN
38
2 NameC11Enter the Name
39
3DesignationD11Enter Designation
40
4MAR2023-PAYE11Enter MARCH2023 PAY
41
5Increment MonthF11Select the Increment month
42
6HRAG11AUTOMATIC CALCULATION
43
7CCAH11Enter CCA amount
44
8CPSI11If in CPS SELECT yes if in GPF Select No
45
9GPFJ11ENTER GPF subscription amount
46
10NHISK11Select yes or No
47
11SPFL11Select Nil or 50 or 70
48
12IT +CESSM11Enter the IT, IT cess amount
49
(in individual sheet you can make any change in it- no problem)
50
13P.L.IN11Enter the PLI amount if it salary deduction
51
14RENT / MONTHO11If 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
52
15Home Loan IntP11Enter the home loan interest amount
53
16Home Loan PrinciQ11Enter the home loan principle amount
54
17Tuition FeesR11Enter tuition fee amount (max 2 children)
55
18ULIP / FDS11Unit Linked Insurance policy or Fixed Deposit or SIP or MF investment under sec 80c
56
19Physically Challenged (80U)U11Select the percentage below 40% no deduction. 40-79% =750000 above 80%125000
57
20OLD REGIME TAXV11This year Total tax will appear for you reference
58
NEW REGIME W11
59
Like this you can enter the individual employees particulars in INPUT sheet s3..s4..s5…upto s25…
60
Thanks …
61
Selva7pc@gmail.com
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