• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2401
  • Last Modified:

Employee Leave Management

Hi,

I would like have Expert advice on how to capture employees Medical Leave (MC), Emergency Leave (EL) and Annual Leave (AL) effectively. I tried to find an Excel template in Net but couldnt find a proper one. If Expert has a sample template please share with me.
0
Theva
Asked:
Theva
  • 2
  • 2
1 Solution
 
Tiras25Commented:
There are many payroll software programs that could do this. The function you seek is integrated into the payroll software.

Are you not aware of this or is purchasing such software a hardship?

If so, I can see how you could keep track of this in an Excel spreadsheet easily, but you would probably have to make your own.
0
 
ThevaAuthor Commented:
Hi Tiras 25,

Thanks for your feedback, yes I do aware such product like People Soft, but believe me, its too expensive. At present I prefer to use excel template. Last year I've created an excel sheet to capture this, but its not really helpful to track this. I've attached the excel sheet that I've used last year. Hope you can give me some idea how revive this template and tracks the MC,ML and AL more effectively.  
Monthly-Tracking-2009-3.xls
0
 
Tiras25Commented:
By googling employee absence calendar, I found this paper form, good for at-a-glance assessment of employee attendance -

http://www.aboutnata.org/assets/2009%20absentee%20calendar.pdf 

And here is a Microsoft excel template for 2010, I didn't open it but it may help you get started -

http://office.microsoft.com/en-ca/templates/TC103524781033.aspx?pid=CT101172751033
0
 
ThevaAuthor Commented:
Thanks a lot Tiras
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now