This is k.selvakumar HM GHSS ANANDUR623401-RAMANATHAPURAM DIST.

With my little knowledge I developed this excel sheet - to calculate the Income tax for the financial year 2022-2023 (AY-2023-2024)

in a single file you can calcuate - Income Tax details for 24 employees.

if more than 24 employees - kindly copy and use another file

minimum entries required

made the entries in the "INPUT" sheet

single input for TAN, SCHOOL/OFFICE NAME, DDO, DDO NAME, profession tax amout

select your area HRA grade city

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 )

s2 to s25 you can input the datas

for individuals fileds required is

PAN number, name, designation,

enter march 2022 pay only, select the increment month, it will automatically calculate the pay from mar2022 to feb2023.

hra also automatically appear just verify it.not need to input the hra amount

if you receive the cca amount, enter the amout manually

enter /select the other details

I included the calculation for Physically Challenged friends, (sec 80U)

in income tax please enter income tax and chess amount. If you deducted from march2021 pay

if you started the deduction from April2022 or later , just enter the amount in individual sheet- in corresponding month

DA- ARREAR automatic calculation for the period of july2022..

any other arrear - s.g. arrear you can manually enter the amount in respective columns

s2 to s25 all sheets are unprotected, you can change or edit or modify any column/row

in indivdual sheets , three pages printable area, first two old regime third one new regime.

don't alter or change or delete the extra column/outer column , it was related with the prog calculation.

if you find any difficulties please contact me through my mail id

selva7pc@gmail.com

if you noticed any mistakes or corrections, pls inform me.

with regards

selvakumar k