Leave Records Format in Excel For Staff
The Attached Leave Record Format in Excel Will Help You in Maintaining The Leaves of Employees Annually.
Employee Name | Emp.Code | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days |
abc | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days | |
DOJ | 26.Apr.10 | April | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 |
Company | xyz | May | 31 | 28.5 | 0 | 1 | 1 | 0 | 0 | 1.5 | 1.5 | 0 | 0 | 2.5 | 31 |
June | 30 | 29 | 0 | 1 | 1 | 0 | 0 | 1.5 | 0 | 1.5 | 0 | 1 | 30 | ||
July | 31 | 29 | 0 | 1 | 1 | 0 | 1.5 | 1.5 | 1 | 2 | 0 | 2 | 31 | ||
August | 31 | 29.5 | 0 | 1 | 1 | 0 | 2 | 1.5 | 0.5 | 3 | 0 | 1.5 | 31 | ||
September | 30 | 20 | 0 | 1 | 1 | 0 | 3 | 1 | 4 | 0 | 5 | 10 | 25 | ||
October | 31 | 29 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 2 | 31 | ||
November | 0 | 0 | 0 | 0 | 0 | ||||||||||
December | 0 | 0 | 0 | 0 | 0 | ||||||||||
January | 0 | 0 | 0 | 0 | 0 | ||||||||||
February | 0 | 0 | 0 | 0 | 0 | ||||||||||
March | 0 | 0 | 0 | 0 | 0 | ||||||||||
Employee Name | Emp.Code | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days |
abc | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days | |
DOJ | 13.May.10 | April | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Company | xyz | May | 18 | 15.5 | 0 | 1 | 0 | 1 | 1.5 | 0 | 0 | 1.5 | 2.5 | 2.5 | 15.5 |
June | 30 | 28 | 1 | 1 | 0 | 2 | 1.5 | 1.5 | 0 | 3 | 2 | 2 | 28 | ||
July | 31 | 29.5 | 1 | 1 | 0 | 2 | 3 | 1.5 | 0 | 4.5 | 1.5 | 1.5 | 29.5 | ||
August | 31 | 29 | 2 | 1 | 0 | 3 | 4.5 | 1.5 | 0 | 6 | 2 | 2 | 29 | ||
September | 30 | 28 | 3 | 1 | 0 | 4 | 6 | 1.5 | 0 | 7.5 | 2 | 2 | 28 | ||
October | 31 | 31 | 4 | 1 | 0 | 5 | 7.5 | 1 | 0 | 8.5 | 0 | 0 | 31 | ||
November | 0 | 0 | 0 | 0 | 0 | ||||||||||
December | 0 | 0 | 0 | 0 | 0 | ||||||||||
January | 0 | 0 | 0 | 0 | 0 | ||||||||||
February | 0 | 0 | 0 | 0 | 0 | ||||||||||
March | 0 | 0 | 0 | 0 | 0 | ||||||||||
Employee Name | Emp.Code | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days |
abc | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days | |
DOJ | 1.August.10 | April | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Company | xyz | May | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
June | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
July | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
August | 31 | 31 | 0 | 1 | 0 | 1 | 0 | 1.5 | 0 | 1.5 | 0 | 0 | 31 | ||
September | 30 | 30 | 1 | 1 | 0 | 2 | 1.5 | 1.5 | 0 | 3 | 0 | 0 | 30 | ||
October | 31 | 30 | 2 | 1 | 1 | 2 | 3 | 1 | 0 | 4 | 0 | 1 | 31 | ||
November | 0 | 0 | 0 | 0 | 0 | ||||||||||
December | 0 | 0 | 0 | 0 | 0 | ||||||||||
January | 0 | 0 | 0 | 0 | 0 | ||||||||||
February | 0 | 0 | 0 | 0 | 0 | ||||||||||
March | 0 | 0 | 0 | 0 | 0 | ||||||||||
Employee Name | Emp.Code | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days |
abc | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days | |
DOJ | 16.August.10 | April | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Company | xyz | May | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
June | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
July | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
August | 16 | 16 | 0 | 0.5 | 0 | 0.5 | 0 | 0.5 | 0 | 0.5 | 0 | 0 | 16 | ||
September | 30 | 30 | 0.5 | 1 | 0 | 1.5 | 0.5 | 1 | 0 | 1.5 | 0 | 0 | 30 | ||
October | 31 | 30 | 1.5 | 1 | 1 | 1.5 | 1.5 | 1 | 0 | 2.5 | 0 | 1 | 31 | ||
November | 0 | 0 | 0 | 0 | 0 | ||||||||||
December | 0 | 0 | 0 | 0 | 0 | ||||||||||
January | 0 | 0 | 0 | 0 | 0 | ||||||||||
February | 0 | 0 | 0 | 0 | 0 | ||||||||||
March | 0 | 0 | 0 | 0 | 0 | ||||||||||
Employee Name | Emp.Code | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days |
abc | OOO6 | Month | Total Days | Present Days | OB | CR | Taken | CB | OB | CR | Taken | CB | LWP | Leaves Taken | Paid Days |
DOJ | 08.October.10 | October | 31 | 24 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 30 |
Company | xyz | November | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
December | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
January | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
February | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
March | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Leave Register Template In Excel
Use the attached excel template to maintain the leave register manually.
Leave Balance – Master Data | Actual Leave Eligible | Balance Leave | Apr-12 | May-12 | Jun-12 | Jul-12 | Aug-12 | Sep-12 | Oct-12 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SL. NO | EMP CODE | NAME | LOCATION | SITTING LOCATION | D.O.J | CASUAL LEAVE | SICK KEAVE | Privilege Leave | CASUAL LEAVE | SICK KEAVE | Privilege Leave | WORKING DAYS | CL GIVEN | SL GIVEN | PL GIVEN | Actual Leave Taken | LOP | PAID LEAVE | Total Days Worked | Days to be processed | WORKING DAYS | CL GIVEN | SL GIVEN | PL GIVEN | Actual Leave Taken | LOP | PAID LEAVE | Total Days Worked | Days to be processed | WORKING DAYS | CL GIVEN | SL GIVEN | PL GIVEN | Actual Leave Taken | LOP | PAID LEAVE | Total Days Worked | Days to be processed | WORKING DAYS | CL GIVEN | SL GIVEN | PL GIVEN | Actual Leave Taken | LOP | PAID LEAVE | Total Days Worked | Days to be processed | WORKING DAYS | CL GIVEN | SL GIVEN | PL GIVEN | Actual Leave Taken | LOP | PAID LEAVE | Total Days Worked | Days to be processed | WORKING DAYS | CL GIVEN | SL GIVEN | PL GIVEN | Actual Leave Taken | LOP | PAID LEAVE | Total Days Worked | Days to be processed | WORKING DAYS | CL GIVEN | SL GIVEN | PL GIVEN | Actual Leave Taken | LOP | PAID LEAVE | Total Days Worked | Days to be processed |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Click Here To Download Leave Management
Search Sample Formats:
Categories: HR Tags: Leave, Management
Leave Application Form
I have Attached Leave Application Form
Date:__________________
Name:_____________________________Employee Code:______________Division:__________________
Leave Applied From To No. of Days
Leave Code* Purpose_______________________________________________________
Leave Address: | |
PIN: |
|
Leave Contact: | Signature of the Employee |
Leave sanctioned From To No. of Days
Recommended Sanctioned Personnel Department
|
||||||||||
|
|
|||||||||
|
||||||||||
|
||||||||||
Note*: CL EL ESI SL LOP
Click Here To Download Leave Application Form
Other Related Post to Permission Letters
Paternity Leave Application for Central Government Employees
Request Copyright Permission Letter
How to Write a Letter to My Boss for Permission
Police Permission Letter for Official Event
Sample Copyright Permission Letter
Sample Request Letter for Permission to Interview
Sample Employee Termination Letter for Theft
Half Day Leave Application for Employees
Format of Half Day Leave Application Email
Categories: HR Tags: Application, Form, Leave
Leave card Format
I have Attached Leave card Format
Leave Card | |||||||||
Name of the Employee : | Department : | ||||||||
Code No : | DOJ : | ||||||||
Designation: Superviser | Doc : | ||||||||
Opening Balance | CL | 0 | |||||||
PL | 87 | ||||||||
Month | No.Of leaves Entitle | Dates of Leave | No.Of days leave Enjoyed | Total Balance Leave | Remarks | ||||
CL | PL | CL | PL | CL | PL | CL | PL | ||
April-07 | 0 | 87 | 0 | 6th to 10th,30th | 0 | 6 | 0 | 81 | |
May-07 | 0 | 0 | 0 | 14th to 25th | 0 | 12 | 0 | 69 | |
Jun-07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 69 | |
Jul-07 | 0 | 0 | 0 | 23rd to 25th | 0 | 3 | 0 | 66 | |
Aug-07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 66 | |
Sep-07 | 0 | 0 | 0 | 4th, 10th, 13th (1/2day), 17th to 21st | 0 | 7 | 0 | 59 | |
Oct.2007 | 0 | 0 | 0 | 1st, 2nd, 3rd (1/2), 22nd to 24th | 0 | 5.5 | 0 | 53.5 | |
Nov.2007 | 0 | 0 | 0 | 12th, 19th | 0 | 2 | 0 | 51.5 | |
Dec.2007 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51.5 | |
Jan.2008 | 0 | 0 | 0 | 2nd, 3rd (1/2 day) | 0 | 1.5 | 0 | 50 | |
Feb.2008 | 0 | 0 | 0 | 25thto 30th | 0 | 6 | 0 | 44 | |
Mar.2008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44 | |
Closing Balance as on 31st March, 2008 | CL | 0 | |||||||
PL | 44 |
Categories: Leave format Tags: Format, Leave
Request for Leave of Absence
Dear xxxxxxxxxxxxx
As you may have heard, I am getting married on the 27th of April, 1986. It is with this in mind that I am requesting a thirty (30) day leave of absence.
My fiancé is able to combine a business trip to Europe with our honeymoon, and I would hate to miss this rare opportunity.
I will be back at my desk, with my full attention to the sales department, as always, on the 28th of May, 1986.
If you need any additional information, please contact me at extension 234, in the sales department.
Bereavement leave policy
Sample bereavement leave policy
1. Definition of bereavement leave
Bereavement leave (also called as compassionate leave) is leave to assist employees when there is a death in an employee’s immediate family or household.
Members of the immediate family are defined as the employee’s spouse, and a child, adopted child, ex-foster child, parent, grandparent ex-nuptial child, stepchild, grandchild or sibling of the employee or employee’s spouse.
2. General bereavement leave policy
Compassionate leave is paid leave taken by an employee for the purposes of spending time with a family member/member of employee’s household, who has a personal illness, or injury, that poses a serious threat to his/her life, or after the death of a family member/member of the employee’s household.
Each employee is entitled to a period of two days paid compassionate leave for each occasion where a family member has died or the employee needs to spend time with a seriously ill family member
Each application for compassionate leave will be assessed individually by management.
3. Additional policy
An employee take additional unpaid bereavement leave only with the agreement of the employer.
An employee could also take unpaid leave on the death of a person who is not a member of the employee’s immediate family or household – but only with the employer’s agreement.
Categories: HR Policies Tags: Bereavement, Leave, Policy
Categories: Leave format Tags: Card, Format, Leave
Attendance and Leave Management Format
Please find attached Attendance and Leave Management Format.
Categories: HR Tags: Attendance, Format, Leave, Management