Hi there, I am new to this post. I have searched to see if there was a solution already to my issue but I didn't see. I work for a company that employees over 500 employees. I take care of FMLA , family medical leaves. This is a government program with lots of regulations in case you aren't very familiar with it. This is a massive endeavor with so many employees. I have inherited this duty and right now unfortunately it is a paper process! I am desperately seeking help to make this a somewhat automatmated process. We use a rolling calendar year. Employees can use FMLA in increments of 15 minutes! Each employee has 480 hours (12 weeks) of medical leave available in a rolling calendar year. Government regulations require it be tracked and I also have to notify via certified letters when they are close to depleting leave time and let them know how much time they have used and when it will expire. What I have to do is document name, ID number, supervisor, date, medical issue (example: surgery, care of parent, birth of child, etc). Can anyone help me with a spreadsheet that can include info noted previously but also show me based on rolling calendar year how much each person has used and how much time is available and set up an automatic alert to help me keep up when they get to a certain level to sent certified letter to them?
I dont have current spreadsheet to send as I am just know working on this project. With so many employees I wasn't sure the best way to set up as it will be massive. Right now I have 200 or so employees that have or have had FMLA issues!
Any help, direction would be appreciated. I think my biggest challenge will be getting a formula set up to calculate as a rolling calendar year as I am not that great at setting that sort of thing up.
Thanks to all.
Bookmarks