Dear Frnds, Please can any one guide me regarding EL calculation, Thanks in advance,
From India, Bangalore
From India, Bangalore
Dear Meetca,
I will provide you the process that i follow for leave calculation in our company, hope this will be of use to you.
Leave Calculation:
For Ex: 1 if a new employee joins on June 1st 2009 as trainee/ probation then the leave calculation is as follows: (For Trainee / Probation only SL will be credited)
SL Leave Calculation:
Total SL credit for the calendar year
-------------------------------------------------------------- * Months remaining in the calendar year
Total number of months in the calendar year
As per the above example:
As per the formula the calculation is as follows:
7
--- * 7 = 4.08
12
Example: 2 if a new employee joins on 1st January 2009 on probation the employee gets confirmed on July 1st 2009 so CL calculation is as follows:
For CL the leave calculation is as follows:
Total CL credit for the calendar year
-------------------------------------------------------------- * Months remaining in the calendar year
Total number of months in the calendar year
CL Calculation:
Calculation as per formula is as follows:
7
------- * 6 = 3.5
12
Therefore 3.5days of CL will be credited as on July 1st for the entire year and if the calculated value results more than 3.5 such as 3.6/ 3.7/ 3.8………then the leave will be rounded up and credited as 4days.
Confirmed employee EL calculation:
Example: 3 if a new employee joins on 1st January 2009 on probation the employee gets confirmed on July 1st 2009 so EL calculation is as follows:
For EL the leave calculation is as follows:
Total EL credit for the calendar year
-------------------------------------------------------------- * Months remaining in the calendar year
Total number of months in the calendar year
EL Calculation:
Therefore the calculation as per formula is as follows:
8
------- * 6 = 4.0
12
Therefore 4days of EL will be credited as on July 1st for the entire year if the calculated value results more than 4.5 such as 4.6/ 4.7/ 4.8………then the leave will be rounded up and credited as 5days.
From India, Madras
46I will provide you the process that i follow for leave calculation in our company, hope this will be of use to you.
Leave Calculation:
- As per leave policy the leave year for computing all types of leave will be from 1st January – 31st December. Based on the need / reason and length of leave, the following categories of leave can be availed: CL, SL and EL
- For a permanent employee CL: 7days, SL:7days and EL:8days will be credited on the 1st – January of the calendar year.
- For employees falling under Training and Probation period full SL: 7days will be credited on the 1st January of the calendar year irrespective of the date of completion of their training or Probation period.
- After completion of Probation period the balance CL and EL will be credited to the employee based on the following leave calculations. Refer Leave policy to understand the leave procedure.
- As per leave policy the leave year for computing all types of leave will be from 1st January – 31st December. Based on the need / reason and length of leave, the following categories of leave can be availed: CL, SL and EL
For Ex: 1 if a new employee joins on June 1st 2009 as trainee/ probation then the leave calculation is as follows: (For Trainee / Probation only SL will be credited)
SL Leave Calculation:
Total SL credit for the calendar year
-------------------------------------------------------------- * Months remaining in the calendar year
Total number of months in the calendar year
As per the above example:
- Total SL credit for the calendar year = 7days
- Total number of months in the calendar year = 12months
- Months remaining in the calendar year = 7months(As employee joined on June 1st so June 1st – Dec 31st = 7months, June month will be considered only when employee joins on or before 15th of that particular month or else the count starts from next month)
As per the formula the calculation is as follows:
7
--- * 7 = 4.08
12
- Therefore 4days of SL will be credited to the new employee. Thus new employee joining as trainee / probation will get 4days as SL for the entire year
- If the calculated leave results 4.50 then four and a half days leave will be credited and if it calculated leave results more than 4.5 such as 4.55/4.6/4.7……then the leave will be rounded up and credited as 5days.
- If a new employee joins as Trainee on 1st January 2009 then SL – 7days will be credited to the employee as per the above formula and this leave credit is for the entire year and it doesn’t mean that when the employee enters into probation on the month of July again leave has to be credited because both trainee and probation employee will be eligible for SL only. Only after the completion of probation period CL and EL will be credited.
- If a new employee joins on 1st January 2009 on Probation then SL – 7days will be credited for the entire year and as on July 1st if the employee gets confirmed CL and EL will be credited and the leave calculation is as follows :
Example: 2 if a new employee joins on 1st January 2009 on probation the employee gets confirmed on July 1st 2009 so CL calculation is as follows:
For CL the leave calculation is as follows:
Total CL credit for the calendar year
-------------------------------------------------------------- * Months remaining in the calendar year
Total number of months in the calendar year
CL Calculation:
- Total CL credit for the calendar year = 7days
- Total number of months in the calendar year = 12months
- Months remaining in the calendar year = 6months(As employee gets confirmed on July 1st so July 1st – Dec31st = 6months, July month will be considered only when employee confirmation is on or before 15th of that particular month or else the count starts from next month)
Calculation as per formula is as follows:
7
------- * 6 = 3.5
12
Therefore 3.5days of CL will be credited as on July 1st for the entire year and if the calculated value results more than 3.5 such as 3.6/ 3.7/ 3.8………then the leave will be rounded up and credited as 4days.
Confirmed employee EL calculation:
Example: 3 if a new employee joins on 1st January 2009 on probation the employee gets confirmed on July 1st 2009 so EL calculation is as follows:
For EL the leave calculation is as follows:
Total EL credit for the calendar year
-------------------------------------------------------------- * Months remaining in the calendar year
Total number of months in the calendar year
EL Calculation:
- Total EL credit for the calendar year = 8days
- Total number of months in the calendar year = 12months
- Months remaining in the calendar year = 6months(As employee got confirmed on July 1st so July 1st – Dec31st = 6months, July month will be considered only when employee confirmation is on or before 15th of that particular month or else the count starts from next month)
- Total EL credit for the calendar year = 8days
Therefore the calculation as per formula is as follows:
8
------- * 6 = 4.0
12
Therefore 4days of EL will be credited as on July 1st for the entire year if the calculated value results more than 4.5 such as 4.6/ 4.7/ 4.8………then the leave will be rounded up and credited as 5days.
From India, Madras
Dear All,
HI.. My company is near Mumbai. Every employee who joins, has to serve a 1 year Probation. After the completion of which he /she is entitled to CL - 14 Days, EL - 30 Days, and Sick Leaves - 7 Days , from 1st January. One of our employees has completed 1 year probation in 18/03/2014 with his Loss Pay Days being 20 Days.
The basic formula we follow for Earned Leaves is (30/360) * (No. of Days from date of Joining - LOP)
Now I have to determine his leaves for 1st Jan onwards.
Please help.
From India, Bhilai
HI.. My company is near Mumbai. Every employee who joins, has to serve a 1 year Probation. After the completion of which he /she is entitled to CL - 14 Days, EL - 30 Days, and Sick Leaves - 7 Days , from 1st January. One of our employees has completed 1 year probation in 18/03/2014 with his Loss Pay Days being 20 Days.
The basic formula we follow for Earned Leaves is (30/360) * (No. of Days from date of Joining - LOP)
Now I have to determine his leaves for 1st Jan onwards.
Please help.
From India, Bhilai
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.
Please provide the following information - Employee validation.doc
Flexible Resources provide Interim Services, Resources.pdf