Leaves - Payroll

hi,
i have to calculate leaves and integrate it with the payroll process. please tell how to go about it, if possible, on an excel sheet.
thanks and regards
Alankrita

Dear Member,
can u explain more then I understand what you exactly want to know.
Regards,
Nirav

Dear All,
I wanted to know that, as per shop & commercial establishment act, how much leaves employees can get ?
Please reply

Dear Member,
it is depend upon your company management,how many leave approved for the year. in any act not mention how much leave is giving to employee.

Hi,
Please visit the following
https://www.citehr.com/187240-leave-policy.html#831433
https://www.citehr.com/50711-how-cal...ata-basis.html
https://www.citehr.com/301320-leave-policy.html
https://www.citehr.com/342919-leave-policy.html

The leave entitlement as per Shops and Commercial Establishment Act varies from state to state who have made their own rules.
Normally an employee who has worked for 240 days during a calendar year is entitled for annual leave(Earned Leave) with wages calculated
@1day for every 20 days of work to be availed during the subsequent calendar year.
With regard to National and Festival Leave it is 8 days while in case of CL it varies between 7 and 12 days.
bk mohanty
Cypress Management Associates
9937822563

Dear Member,
i would like to know that after we calculate leaves, how we integrate it with salary calculation.
Regards
Alankrita

Dear All,
My problem is, in our company policy we are receiving 24 leaves (earned), we are calculated on PAYABLE DAYS (attended days + weekly off + holidays +leaves) of previous year. means, when i take unpaid leaves it deduct from my salary as well as from my next years earned leaves. we get aforementioned earned leaves at the end of the every year.
Please guide me, is it a right way to calculate leaves.
Regards,
Aditya

What I have understood from your notings, for the calculation of earned leave your company takes in to consideration the physical attendance days,weekly offs,paid holidays and paid leaves which I consider to be fine.But I fail to understand that how come the unpaid leaves can be adjusted against accrued earned leave.
Pl brief me little more so that I will be able to ease out your concern
regards
bk mohanty
Director
Cypress Management Associates

Dear Nirav,
I appreciate your help. My company is launching an HRMS and I have to give the payroll process as format. That is why i need to show the integration of leaves taken by an employee with his/her salary. And I have to prepare everything from the scratch. Right now i don't have a format to send you as an example.
Regards
Alankrita