Leave Record For Small Organisations - XLS Download

Deepu
Dear All,
Please find the attached Leave record file. It will be suitable for small organisations.
Instructions for using this file
AL – Annual Leave (Privileged Leave )
CL – Casual Leave
SL – Sick Leave (Medical Leave)
CO – Compensatory off
WP – Leave With out pay
HD – Half Day
It has assumed that there are 8 Casual Leaves (CL), 7 Sick Leaves (SL) and 12 Annual Leaves (AL) (1 Annual Leave will be added every month) for the leave calendar. Also assumed that Saturdays and Sundays are holidays and compensatory off (CO) will be added if somebody present on Holidays (insert “P” if present on holidays – Compensatory off will automatically added). Half day leaves will be deducted from CL.
You can change all these parameters as per your needs.
Just enter the leaves as CL/SL/AL/CO/WP/HD in the respective date columns.
Also you can find a summary of leaves in the “Master Sheet”
Please let me know your valuble inputs so that i can improve this sheet.
Thanks & Regards
Deepu
1 Attachment(s) [Login To View]

Pramita Singh
Hi Deepu,

Can you provide me with the leave policy and explain the formula for leave calculation? How many leaves do we need to give, and how do we calculate earned leave and paid leave?

I am waiting for your response.

Regards,
Pramita
Deepu
Hi Pramita,

You can find the formula by clicking on the respective cells of the Excel sheet. Please find the attached file for the Leave Policy.

Regards,
Deepu
1 Attachment(s) [Login To View]

pankaj.sinha
Hi Deepu!

It's nice to know that you are actively participating in the CiteHR! That's a very good contribution you have given! Why don't you join us in the meeting being organized on 1st July 07 (Sun) at 11:30 AM at Nirulas CP, New Delhi! Please check the latest thread as Ms. Anupama Saini is coordinating for the same. It's nice to see that both of us from the same organization have become CiteHR members! Keep it up!

Thanks & Regards,
Pankaj Kumar Sinha
< [Login to view] >
GURGAON.
shreyasmunshi
Hi ALL EXPERTS:

CLARIFICATION SOUGHT RE PL AND SL (Annual Leave and Sick Leave) Combination.

As allowed by the Company rules, an employee has 32 days of PL to his credit and 27 days of fully paid Sick Leave to his credit. He proceeds on 32 days PL, duly applied for and sanctioned. After 16 days, he informs the company by fax, email, and a letter through courier that he has fallen ill and he cannot continue enjoying his PL; he says he has SL to his credit and so from the 17th day of his leave of absence, he should be considered to be on Sick Leave and not PL. (He is entitled to 30 days of Sick Leave WITHOUT PAY (unpaid sick leave beyond his accumulated Sick Leave). He reports for duty on the 74th day of his proceeding on leave (PL 16, Paid SL 27, and unpaid SL 30) and says his unavailed PL of 16 days should remain to his credit on the leave record card for future use. (He did submit initial and final Medical reports.

What should be the legally right thing to do? (My personal view is that sick leave is meant for sickness; and should be allowed; but this is a strange case.)

Shreyas
Aru
Hi Deepu,

Good job. This is very helpful for small companies where the staff count is below 100. Keep it up.

Harini
vandana reddy
Hi,

please check if useful....

Leave Rules

Purpose of this document:

This document is aimed to bring in clarity on the existing leave rules and make necessary modifications / inclusions wherever necessary.

Applicability:

 To all full-time associates of XXXX Ltd.

 This document supercedes all the previous releases about Leave rules of XXXX Ltd and shall come in to force from the date of release.

 Changes to this policy will need expressed approval of Executive Vice President – HR & CA.

Type of Leaves:

1. Casual Leave

2. Privilege Leave

3. Maternity Leave

4. ESI Leave

5. Special Sick Leave

6. Education Leave

7. Leave on Loss of Pay

General Guidelines:

 Associate should obtain prior approval of leave from his/her immediate superior.

 Where prior approval could not be obtained due to exigencies, the same has to be obtained with in a reasonable time.

 Associates availing Special Sick Leave or Educational Leave will have to submit necessary documents in proof along with leave application. Immediate superior after considering the genuineness of the issue has to make recommendation to Head of the Group / SBU / Dept. The same shall be sanctioned by the Head of the Group / SBU /Dept and Dy. General Manager HR jointly.

 Year is to be reckoned as 1st Jan – 31st Dec.

 Clubbing of different types of leaves is allowed.

1. Casual Leave:

Eligibility:

 All Full-time associates of XXX Limited

 Eligibility starts from Date of Joining.

Quantum of Leave:

 12 days per year.

 Associates joining us on any date other than 1st Jan would be eligible for CL on pro-rata basis.

Others:

 Intervening Paid Holidays / Weekly Off during the CL’s period will not be counted as CL. In other words, an employee who avails CL on Saturday and on Monday will be debited with only 2 days CL in his credit and Sunday will not be considered as CL.

 Unavailed CLs cannot be carried forward to next calendar year.

 Unavailed CLs cannot be encashed.

2. Privilege Leave:

Eligibility:

 All Full-time associates of XXX Limited

 Eligibility starts on completion of 1 year of service with the company.

Quantum of Leave:

 20 days per year.

 Immediately on completion of 1-year service, an associate's leave account will be credited with 20 PLs and thereafter will be regularized to calendar year.

Availing Privilege Leave:

 It is mandatory for every associate to avail at least 10 days (at least one instance 5 consecutive working days) of PL in a year. This provision is brought in to encourage people to take break from the work schedule and also to give the other team members a chance to exhibit their abilities.

 While carrying forward un availed PL, irrespective of the fact whether an associate availed 10 days PL or not, short fall (if any) for 10 PL shall be deducted from the balance.

 This mandatory clause shall not be applicable to those associates who are on on-site assignment for minimum period of three months in that calendar year and on return they did not have minimum three months time to avail 10 PL.

 Intervening Paid Holidays/Weekly Off during the period will be counted as PL.

Encashment of PL:

Voluntary Encashment:

• All associates are entitled to encash PL over and above 20 days once in a calendar year subject to minimum of 7 days.

Automatic Encashment:

 For associates in and up to PM Level - PL balance in excess of 45 days in an associate's account will be automatically encashed.

 For associates in and above AGM Level - PL balance in excess of 90 days in an associate's account will be automatically encashed.



Rate of Encashment:

 Basic pay as on previous 31st December divided by 30 days multiplied by the number of Privilege leave to be encashed.

Payment:

Voluntary Encashment:

• Duly filled and signed Application for voluntary encashment should be submitted in the month of March to HR and the payment shall be made along with April month salary.



Automatic Encashment:

 HRD Dept. will take stock of all associates' PL balance as on 31st Dec and will process automatic encashment along with April salary every year.

3. Maternity Leave:

Eligibility:

 All Full-time female associates who are not covered under ESI Act.

 Eligibility starts after 6 months from date of joining.

Quantum of Leave:

 12 weeks

 All 12 weeks have to be utilized at once and the expected Date of delivery should fall during the period of leave.

 It is advisable to plan the leave in such a way that

 Leave period starts at least 3 weeks prior to Dt. Of delivery and

 Leave period ends at least 3 weeks after Dt. Of delivery

 In case of miscarriage, associate will be eligible for an additional 4 weeks leave.

 Associates having two or more than two children shall not be eligible for maternity benefit.

4. ESI Leave:

Eligibility:

 All associates who are covered under ESI Act.

 Eligibility starts from Date of joining of an associate.

Pay while on ESI Leave

 An employee who has availed ESI leave will be paid for that period by the ESI, as per ESI Act. No salary will be paid by IEL during ESI leave.

 For further details regarding the benefits that can be availed, please contact Mr. Parthasarathy, in HRD.

Other formalities:

 Associate who has availed ESI Leave has to submit all necessary documents in proof of treatment undergone by authorized ESI personnel.

5. Special Sick Leave:

As a goodwill gesture, it has been decided to extend Special Sick Leave to all associates (who are not covered under ESI) who were affected by serious diseases (to be read as those which are non recurring) or accident.

Sanction of leave is discretionary and the authority to sanction lie with Head of SBU & Dy. GM - HR.

Quantum of Leave:

 12 days per year

6. Education Leave:

To encourage continuous learning and acquisition of knowledge in their relevant function / skill, It has been decided to extend Education Leave to all associates.

Eligibility:

 Only full-time and confirmed associates are eligible.

Quantum of Leave:

 15 days for calendar year.

 This leave can only be availed for attending the classes (in case of distance learning) and / or writing the examinations relating to the course. (The Leave period should match with the date of examination / classes)

Indicative list of academic programs that can be pursued:

LoB / Dept Designations Degrees permissible for Educational Leave

CSD DET, GET, JCE, CE, SCE, TL, GL, PPE, PPL AMIE, BE, B.TECH, ME, M.TECH, PhD

PE, PL, SPE, SPL, SI, SSI, APM, PM, CM AMIE, BE, B.TECH, ME, M.TECH, MBA, PhD

PSD Trainee, Jr. Conslt, Conslt, Sr. Conslt BE, ME. M.SC(Remote Science, Geology, Geography Only), PhD

PL, APM, PM BE, ME. M.SC(Remote Science, Geology, Geography Only), MBA, PhD

SWD&S SWE, SSWE, TL, SQAE, SSQAE BE, B.TECH, ME, M.TECH, PhD

PL, APM, PM BE, B.TECH, ME, M.TECH, MBA, PhD

ENGG DE,SDE, TL BE, B.TECH, ME, M.TECH, PhD

PL, APM, PM, Consultant, Sr. Consultant BE, B.TECH, ME, M.TECH, MBA, PhD

Sys Admn All positions BE, B. Tech (ECE, E&E, Systems), PhD

MKTG,HR,

F&A, Admn All positions MBA, CA, CWA, CFA, PhD



7. Leave on Loss of Pay:

 Leave granted on extraordinary grounds without salary to an associate who does not have any leave to his / her credit. This is allowed only once in a year up to a maximum of 10 days.

 Leave on Loss of Pay may be granted only in genuine cases where the sanctioning authority is convinced with the reasons given for the leave.

8. Unauthorized Absence:

The following absences shall be treated as unauthorized absence:

 Absence for which no leave application has been submitted for sanction of leave.

 Any absence for which leave application has been submitted (irrespective of the type of leave), but not sanctioned by the authorized person.

Unauthorized Absence constitutes a major misconduct and attracts disciplinary action.
Anupama Saini
Dear User,

Thank you for your feedback. It is wonderful to hear that you found the sheet very useful. However, it appears that you were unable to locate the master sheet.

If you require further assistance or if there was a specific issue in finding the master sheet, please feel free to reach out.

Best regards,
Anupama Saini
Deepu
Hi Anupama,

The master sheet is the last sheet in the workbook, which summarizes all the leave taken by an employee.

Regards,
Deepu
Anupama Saini
Deepu,

Are you talking about the November month sheet as the master sheet...???

Anu
Deepu
No, Anu, there are a total of 13 sheets in the workbook: January to December (12 sheets) and an additional sheet named 'Master Sheet'. I think you need to shrink your sheet tabs in Excel or click on the arrow for the last sheet at the bottom left of the Excel sheet.

Thanks & Regards,
Deepu
Dintis
Hi Deepu,

You have done a great job by posting your files. If I had to create such a file, it would have required a lot of thinking and time. Your dedication and willingness to share your hard work are highly appreciated. It greatly benefits startup companies like ours, which do not have a separate HR department at the moment.

Such gestures of sharing inspire us to contribute our knowledge for the betterment of society, allowing everyone to benefit. Keep up the good work and continue motivating us to share!

Best regards,
Dintis
alifazil
Sir, it is a good one, but needed for 2008. Our company has a 30-day annual leave policy, exceeding this will result in LOP (Loss of Pay). I have a team of 24 people and am finding it difficult to maintain and send the reports to payroll. Please help.
AKHILAA.S
Good one, but I have a doubt regarding the number of leaves to be given. Can we provide a total of 10 days per year without any classification of leave? Our company is a small software company.

Please help me.
dorcky
Hi Deepu!

I know you posted this last year already, but I just started keeping records for the employees. Please let me know how to use this sheet. When I type in 1 under the date column, nothing happens. Please help me understand how this works.

Thanks,
Dorcas
wingman
Hi Deepu,

Could you please advise me on where I can change the amount of leave days? For instance, my workplace offers 5 weeks of leave per year and 14 sick days. Also, is this in VB code? I am wondering if I am able to modify the names of the leave types.

Thank you so much,

Juan
juan@bigblock.com
mansiranavde
Hi all,

Here I have a query: After completing the probation period, should the leaves of the probation period be added to your leave entitlement for that year? Also, please tell me if the pay is cut for the days absent during the probation period, should it be reimbursed or adjusted after confirmation?

Thanks & Regards,
MANSI
Janike_Ratnapola
Hi all,

Can someone suggest a way for me to create a report on staff leave or a leave report for an organization with 270 staff?
RANAIKRAM
Dear Deepu,

Please help me. I have asked a question about leave balance in detail. Please check the attached file and send me your kind answer. My email address is [insert email address], and I am waiting for your reply.

Thanks,
Muhammad Akram Khan
1 Attachment(s) [Login To View]

gangapuram
Dear All,

I am going to be promoted as an HR Manager in my company. Therefore, I need all HR forms that could be useful for an HR Manager. Please send all HR forms.

Regards,
Gangapuram
PoojaVS
Hi Deepu,

I know this is probably an old post, but I'm at a new job and I need some help. As a part of my duties, I have to handle HR and keep records of leave days. I'm not great with Excel, and I'm from East Africa, so leave days, sick leave, and other types of leave are not the same as in India. Is there any way you can help me?
sm dmu
Dear Mr. Deepu,

Hi, this is John here. Kindly provide me with an .xls format of leave record data with the following topics for 20 employees:

- CL (Casual Leave) -------------- 7
- SL (Sick Leave) -------------- 7
- PL (Paid Leave) -------------- 2 PL added automatically every month from the end of the 3rd month onward, and at the end, i.e., the 12th month, 3 PL will be added, totaling 21 PL.
- C/Off (Compensatory Off) ----------- When working on weekends and holidays (1 comp off will be added automatically)
- Absent --------- As and when required
- Present -------- As applicable
- Any other Leave --------- As applicable

Moreover, holidays can be adjusted as per requirements, which will be reflected by indicating the column color.

The sheet should be structured in a way that I am maintaining the record monthly, with a separate sheet for each employee. It should automatically create a summary for each employee at the end of the year.

Thanks & Regards,

John
Kanha111
Dear Deepu,

How do I indicate an absence on the monthly leave sheet?

Thanks & regards,
Kan Singh Rathore
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute