FMLA Tracker Template (Excel)

  • Excel

Last reviewed:

Track Family and Medical Leave Act leave in hours. Enter the start of your 12-month period, the entitlement and the usual weekly hours, then log each day or block of leave: the sheet totals the hours used inside the period and shows the hours and weeks left.

Download the free template

Free to use and edit for your business. No sign-up needed to use the calculators on this site.

What the tracker does

  • Converts the entitlement to hours: workweeks × usual weekly hours (12 × 40 = 480 hours).
  • Counts only leave dated inside the 12-month period you set, and flags rows outside it.
  • Works for continuous, intermittent and reduced-schedule leave, with a reason for each entry.
  • Explains the four 12-month methods employers can use (29 CFR 825.200(b)).

To plan a block of leave, use the FMLA leave calculator: it gives the end date, the return-to-work date and the federal holidays during the leave.

Frequently asked questions

How do I track intermittent FMLA leave?

Log each absence in hours. FMLA leave is counted against the entitlement in hours based on your usual workweek, so 4 hours off in a 40-hour week uses 1/10 of a week.

Which 12-month period should I use?

The one your employer chose: calendar year, a fixed leave year, 12 months forward from first use, or a rolling 12 months backward. Ask HR if you are not sure.

Is the template free?

Yes. Download and use it at no cost. It is a tracking aid, not legal advice.