Hi all,
Please help me out to understand how to calculate leave balance if the attendance cycle is from 22nd of a month to 23rd of the month is it 1 leav ebefore 15 of the month and 1 after the 15th of the month.........is that so so someone taking aleave after the 15 should be considered in next months salary
From India, Gurgaon
Please help me out to understand how to calculate leave balance if the attendance cycle is from 22nd of a month to 23rd of the month is it 1 leav ebefore 15 of the month and 1 after the 15th of the month.........is that so so someone taking aleave after the 15 should be considered in next months salary
From India, Gurgaon
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
+2 Others
HI Aradhana,
if your salary cycle is e.g. from 22-10 to 21-11( It will never be 23rd of next month) and person has taken leave on 15-11 his/ser salary will be deducted in the month of november salary disbursement provided
1. He has no leaves balance( any of- Sick Leave/ Casual Leave etc.
2. He is in the probation period.
I am sure the salary disbursement will be done before 7th or 10th of Dec. for the month of November which is calculated for 22-10 to 21-11.
Hope things are clear. Also find attached Attendance sheet which you will have to alter based on your leave policy as i have put few formulae into it.
Pl feel free to contact me on any clarification required.
Rgds
Swapna
From India, Pune
12if your salary cycle is e.g. from 22-10 to 21-11( It will never be 23rd of next month) and person has taken leave on 15-11 his/ser salary will be deducted in the month of november salary disbursement provided
1. He has no leaves balance( any of- Sick Leave/ Casual Leave etc.
2. He is in the probation period.
I am sure the salary disbursement will be done before 7th or 10th of Dec. for the month of November which is calculated for 22-10 to 21-11.
Hope things are clear. Also find attached Attendance sheet which you will have to alter based on your leave policy as i have put few formulae into it.
Pl feel free to contact me on any clarification required.
Rgds
Swapna
From India, Pune
HI Aradhana,
if your salary cycle is e.g. from 22-10 to 21-11( It will never be 23rd of next month) and person has taken leave on 15-11 his/ser salary will be deducted in the month of november salary disbursement provided
1. He has no leaves balance( any of- Sick Leave/ Casual Leave etc.
2. He is in the probation period.
I am sure the salary disbursement will be done before 7th or 10th of Dec. for the month of November which is calculated for 22-10 to 21-11.
Hope things are clear. Also find attached Attendance sheet which you will have to alter based on your leave policy as i have put few formulae into it.
Pl feel free to contact me on any clarification required.
Rgds
Swapna
From India, Pune
if your salary cycle is e.g. from 22-10 to 21-11( It will never be 23rd of next month) and person has taken leave on 15-11 his/ser salary will be deducted in the month of november salary disbursement provided
1. He has no leaves balance( any of- Sick Leave/ Casual Leave etc.
2. He is in the probation period.
I am sure the salary disbursement will be done before 7th or 10th of Dec. for the month of November which is calculated for 22-10 to 21-11.
Hope things are clear. Also find attached Attendance sheet which you will have to alter based on your leave policy as i have put few formulae into it.
Pl feel free to contact me on any clarification required.
Rgds
Swapna
From India, Pune
Very useful excel sheet
will u plz tel me that how to calculate leaves if some one has taken 7 days leave in a month and there is only 18 days leave permitted to take in one whole year???
will it be calculated as leave without pay
From India, Kochi
will u plz tel me that how to calculate leaves if some one has taken 7 days leave in a month and there is only 18 days leave permitted to take in one whole year???
will it be calculated as leave without pay
From India, Kochi
sir this is k.balaji sir/madam i want information how to calcualating the materinity leaves thnking you sir, k.balaji
From India, Madras
From India, Madras
please tell me how to track leave record if leave policy as below 20 working days =1 EL (max 15 EL in a year) 40 working days =1 CL(max 7 CL in a year) please provide me excel sheet
From India, Ghaziabad
From India, Ghaziabad
Swapna you explained it very clearly.
For more HR related advice please check my YouTube Channel, I have strong believe you will find it useful. Good Luck
From India, Delhi
For more HR related advice please check my YouTube Channel, I have strong believe you will find it useful. Good Luck
From India, Delhi
Leave Balance Tracker - Final.xls