Earned Leave / Leave with Wages / Encashment Leave Register - XLS Download

Please find the enclosed file regarding the Leave with Wages Register. Please review it, as I believe it will be very useful for you.

Thank you.
Regards.

Earned Leave Rules in the Forging Industry

I am Sushil, and I am working in a Forging Industry where 15 Earned Leaves (EL) per year are adjusted in lieu of absences.

My question is: what are the rules for Earned Leave? Can we adjust an employee's absences in place of EL within the year or not? If we adjust an employee's absences in the current month, then their one-day absence will be calculated at a rate of 30 or 31 days. However, if we grant EL at the end of the year, it will be calculated by dividing 26 into their wages.

Please reply to me.

Thank you.

Is a person entitled to EL who is working on a retainer basis? He has been regularly attending the office for the last two and a half years. If entitled, can he ask for leave encashment?

Suanivaku

Dear All,

Good morning.

First, I would like to thank all members who liked this Excel file. I have now enclosed the updated Excel File for your use. You can download it and be free from manual work. If you have any doubts, feel free to call me on my cell phone.

Regards,
Abhishek Singh
Sr. Executive-HR
Mobile No. +91-8950-113355

Dear Sir,

Please send me the unprotected sheet and also help me in the following matter. I would like to know how to calculate the wages every month in leave details such as January, February, and so on. In your sheet, I noticed that the basic wage is listed as Rs18500 for the 1st employee, but for the month of January, it was listed as 18000, and so forth.

Thanks & regards,

Raj Kamal Guchhait
HR Manager
Pascal Switchcare India Pvt. Ltd.

Kindly assist me with a leave register template on an Excel sheet indicating annual leave, casual leave, sick leave, off-duty, and week off for use in a large manufacturing plant.

Please share the unprotected sheet of Form B and Form 15 leave register.

[Email Removed For Privacy Reasons]

Thanks & Regards,

Pradeep Verma
HR Manager