Salary Processing - Xl Worksheet - Xls Download

Hi,
Is there any body who can help me to process salary through XL.
if you have such a xl tool please provide.
Regards
Udhay Attvar

hi udhay i am sending salary processing plz let me know is it ok for u
Regards
Kavita

Hi Udhay
I have enlcosed a format, surely will hep u upto some extent.
Regards,
Revathi

Thanks Revathi,
This data will he more helpful, if it calculates IT/ESI/PT details automatically.
I want to process for 200 employees, hence i can't prepare individual it worksheet for all 200 cases. Is there any way out.

Hi uday
Would like to clarify few things
There is a row hidden, i suppose it is 19th, just unhide it and then c. the no is 30 that is for months calculation.( jan, Feb...............)
In order to use the sheet u have to calculate the LWP's of every employee for the particular month and put that in LWP's field respective to each employee ( which is by default 0)
( If the LWP is ZERO, it shows that full salary is paid without any deduction in respect of leave)
Further, For Income Tax, u have to consider the annual package and have to make a separate sheet for those who are covere under IT Act.
If you have further query, write to me at [Login to view]
Regards,
Revathi

Dear Sushma
Thanks a lot for your prompt reply and it is very useful to me
even i am searching the same thing
Now i am plan to implement this pay slip for our employees
Thanks
Kumar

Hi Udhay
I m also attaching a file I think it'll also help u to some extent.
Regards
Sushma

Hi sushma& Reavthy,
Thanks for your input
It is really helpful to construct my salary register.
With the help of Revathi's and yours input i have constructed a salary register up to PF/ESI/PT deduction. Still i need to search for IT calculation
I have a IT calculation worksheets, If i need to calculate IT liability for 100 employees, this will take lot of time. Is there any other way to do it?
Udhay Attvar

Hi Udhay,
Please go through this format. This will definetly give you some idea .
Thanks and Regards
Anuradha Singh

Thanks Anuradha
You r input won't help me much. I almost on the verge of completing the Salary processing XL sheet.
As revathi and Sushma said, i am developing a separate sheet which will project the IT individually.
Thanks for all those who contributed and given inputs for this discusstion
:D