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
From India, Madras
From India, Madras
hi udhay i am sending salary processing plz let me know is it ok for u Regards Kavita
From India, Mumbai
13From India, Mumbai
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.
From India, Madras
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.
From India, Madras
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
Regards,
Revathi
From India
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
Regards,
Revathi
From India
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
From India, Bangalore
From India, Bangalore
Hi Udhay I m also attaching a file I think it’ll also help u to some extent. Regards Sushma
From China, Beijing
From China, Beijing
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
From India, Madras
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
From India, Madras
Hi Udhay, Please go through this format. This will definetly give you some idea . Thanks and Regards Anuradha Singh
From India, Gurgaon
From India, Gurgaon
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
From India, Madras
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
From India, Madras
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Circular No 1-2018 Processing of income-tax returns under section 143(1) of the Income-tax Act .pdf
Salary-Note.doc
SALARY SHEET CALCULATION.xls