• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Tracking FMLA leave

by on
in Admin Pro Forum

Question: Does anyone have some sort of simple way/spreadsheet to track FMLA leave using the "rolling" 12-month period measured backward?  -- Cindy


Comments

Yes, I keep a spreadsheet in Excel. It shows everyone who qualifies or doesn't, when they went out, when they came back, how many days they used, what they have available. Their worksite and paytype. Then I can sort it by the "Return to Date" to see who I need to follow up on.

I currently use a spreadsheet to track FMLA usuage, etc. FMLA can be continuous or it can be intermittent. Either way, an employee is only entitled to 480 hours per year, 480 hours equate to 12 weeks. On my spreadsheet, the employee's name and pertinent information is entered at the top. All employees using FMLA have a beginning balance of 480 hours. All FMLA usage is entered by date first then the number of hours used. I have a formula that subtracts the usage from the balance and records an ending balance. This allows me to know at a glance the amount of FMLA remaining for each employee. For instance, an employee is out for 3 weeks, that employee has a beginning balance of 480, of which I record the beginning and ending date and 120 hours is subtracted, with a balance remaining of 360. If the employee uses intermittent FMLA for doctors appointment, let's say, two hours per day, twice a week, totaling 4 hours. That is then deducted from the 360 hours, resulting in 356 hours and so on. When the employee has used all 480 hours, that's it until next year. I find this extremely easier than trying to keep track using any other method. I hope this helps.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/15280/tracking-fmla-leave "

{ 29 comments… read them below or add one }

Amy January 16, 2013 at 6:11 pm

Does anyone have a FMLA spreadsheet tracker they are willing to share? Having a difficult time keeping up with FMLA and time remaining.

Reply

Debbie October 15, 2012 at 2:26 pm

can someone share spreadsheet with me?? that would be great!!! and very much appreciative

Reply

Janet Kelley July 28, 2012 at 7:18 pm

This sound like a great tracking tool. I am starting a new HR job in the next few days and the company doesn’t have a great tracking tool. I have so much to do right at the beginning of this position that this tool would be a great help. Please if you can send me a copy.

Reply

Vivien July 20, 2012 at 4:11 pm

Would also like a copy of tghe FMLA TRacking spreadsheet. Thank you so much

Reply

Vivien Winneke July 20, 2012 at 4:10 pm

Would alos like a sample of the FMLA tracking spreadsheet. Thank you so much!

Reply

Carla June 25, 2012 at 12:33 pm

Would love a copy of the spreadsheet if available. Thanks!

Reply

Nicole Martinez May 7, 2012 at 9:08 am

Hi,

I just came across this article while trying to find an FMLA spreadsheet.
Would you be willing to share this with me?

Reply

Janine Griffith January 24, 2012 at 6:30 pm

Hello. I would be interested in the spreadsheet as well to track FML time in a ‘rolling’ 12-month period measured backward. Thank you.0

Reply

Kim Emmons January 19, 2012 at 3:43 pm

Hi..I too am trying to find a FMLA tracking spreadsheet that work. Would you be able to email it to me? Looks like we are all looking for the same thing.
Thanks!

Reply

Mona Garrettson January 12, 2012 at 1:53 pm

Could you please share your FMLA spreadsheet. Due to layoffs, I recently have been given the FMLA piece of HR to handle. Keeping track of time off is a huge problem for me.

Thank you.

Reply

Sharon December 5, 2011 at 11:28 am

Please send me a copy of your spreadsheet as well, this sounds very helpful.

Thanks

Reply

Crystal September 15, 2011 at 10:42 am

Would you mind sending me your spreadsheet? It sounds like this would be very helpful to me. Thank you!

Reply

Linda July 17, 2011 at 4:31 pm

I would appreciate a copy of your FMLA spreadsheet. FMLA can be challenging!

Reply

Diane Minenn July 14, 2011 at 2:21 pm

I would love a copy of your FMLA spreadsheet as well. Tracking FMLA can be overwhelming. I’d really appreciate it!

Reply

Donalisa Johnson July 14, 2011 at 1:20 pm

I also need a copy of the FMLA tracking spreadsheet. Desperately

Reply

Mary Marinoff June 29, 2011 at 9:01 pm

May I get a copy of your FMLA spreadsheet? I recently was given this responsibility and do not have a starting base. Thank you.

Reply

Denise Lepage May 23, 2011 at 1:22 pm

It would be great is you could share your worksheet. I’m having difficulty in calculating the drop off after one year.

Reply

Natasha May 2, 2011 at 5:45 pm

May I get a copy of your FMLA spreadsheet? I recently took over this responsibility and the previous tracker has made a mess of it. Thank you!

Reply

Regina March 21, 2011 at 5:46 pm

If possible, can you please send me a copy of the spreadsheet as well?

Reply

Mel March 21, 2011 at 11:20 am

Please send me a copy and also how do you keep track of the days that go beyond the 480 or 504 hrs entitlement that do not count towards there FMLA

Reply

Joan February 24, 2011 at 12:18 pm

I would also appreciate a copy of the spreadsheet.

Reply

Annette Norton February 10, 2011 at 3:35 pm

I would like to get a copy of the FMLA tracking spreadsheet as well. Can you send to me too?

Reply

Dana February 8, 2011 at 12:46 pm

May I have a copy of the spreadsheet as well?

Reply

E. Craig February 4, 2011 at 8:44 pm

Please send me the spreadsheet as well. I would greatly appreciate it. Thanks!

Reply

E. Craig February 4, 2011 at 8:44 pm

I would like to get a copy of the FMLA tracking spreadsheet as well. Can you send to me too?

Reply

cammie elmore January 15, 2011 at 12:04 am

would very much like to get copy of the FMLA tracking spreadsheet ? my company has 400 employees and it is very overwhelming trying to keep up with FMLA. Please Help !! thank you

Reply

Marilena Mosatto November 15, 2010 at 12:21 pm

Can you send me the FMLA Tracking spreadsheet ?

Reply

Travis Bussey September 16, 2010 at 12:37 pm

I, too, am wondering if you would be willing to share your Excel spreadsheets? Especially if you have found a way for the dates to drop off after one year.

Thanks,

Reply

Michele Schaan July 7, 2010 at 1:38 pm

Would either of you be willing to share your spreadsheets??

Reply

Leave a Comment