tracker template · Free download
FMLA Leave Tracker (Spreadsheet + Hours Calculator)
FMLA tracking spreadsheet with notice deadlines, the four 12-month methods, intermittent leave in hours (40h vs 32h examples) and a sample policy clause.
Sign in with Google below to download the PDF and CSV straight away.
Get your free download
Sign in with Google to unlock the PDF and CSV instantly. No form to fill in.
Free. By continuing you agree to our terms and privacy policy. We record your email and this download; marketing emails only if you tick the box.
What you get
- A CSV leave tracker with realistic rows: request date, WH-381 and WH-382 dates, certification due date, leave type, hours used and hours remaining
- An hours-based entitlement method for intermittent and reduced-schedule leave, with a 40-hour and a 32-hour worked example
- The notice clocks from 29 CFR 825.300 and 825.305 turned into dated examples
- The four permitted 12-month methods compared on one employee
- A per-employee intermittent leave log, the DOL form list, state leave overlaps and a paste-ready FMLA policy clause
Template preview
A preview of the structure. Download the PDF or CSV for the complete, ready-to-use version.
FMLA leave tracker
One row per leave case. Entitlement hours = normal weekly hours x 12 (x 26 for military caregiver leave). Examples assume the rolling-backward 12-month method; military caregiver leave always uses a single 12-month period starting on the first day of that leave.
| Employee (ID) | Hrs/wk | Reason and leave type | 2026 dates: request / WH-381 / cert due / WH-382 | Hours used | Hours left | Status |
|---|---|---|---|---|---|---|
| Dana Ruiz (1042) | 40 | Own serious health condition (surgery); continuous | 03-02 / 03-04 / 03-19 / 03-18 | 240 | 240 | Returned 2026-05-04 |
| Marcus Lee (1107) | 32 | Care for parent; intermittent | 05-11 / 05-13 / 05-28 / 05-27 | 38 | 346 | Active |
| Priya Nair (1150) | 40 | Bonding with newborn; reduced schedule 20 h/wk x 8 wks | 06-15 / 06-17 / not required / 06-19 | 160 | 320 | Active |
| Tom Okafor (1201) | 40 | Own serious health condition; continuous | 08-24 / 08-26 / 09-10 / pending | 0 | 480 | Awaiting certification |
Tracker setup
- Employer name and FEIN
- Covered employer?— Private: 50+ employees in 20+ workweeks this or last year; public agencies and schools: any size
- 12-month method (one for all employees)— Calendar year / fixed year / forward from first leave / rolling backward
- Smallest leave increment used for other leave— e.g. 15 minutes; FMLA increments can be no larger, and never over 1 hour
Eligibility check before you open a case
- Employee has worked for the company at least 12 months (need not be consecutive; breaks of 7+ years usually do not count)
- Employee worked at least 1,250 hours in the 12 months before leave starts (hours actually worked, not PTO or holidays)
- Employee works at a site where the company has 50+ employees within 75 miles
- Reason qualifies: own serious health condition, care for spouse, child or parent with a serious health condition, birth or placement and bonding within 12 months, qualifying military exigency, or military caregiver leave
Notice and certification clocks, with dates
Example: the employee tells her manager on Monday, 2 March 2026 that she needs surgery.
| Step | Clock | Example date | Rule |
|---|---|---|---|
| Employer learns leave may be FMLA-qualifying | Day 0 | Mon 2026-03-02 | |
| Eligibility notice + rights and responsibilities notice (WH-381) | Within 5 business days | No later than Mon 2026-03-09 (sent Wed 03-04) | 29 CFR 825.300(b)-(c) |
| Certification returned (WH-380-E) | At least 15 calendar days after you request it | Due Thu 2026-03-19 if requested 03-04 | 29 CFR 825.305(b) |
| Incomplete or insufficient certification | Tell employee in writing what is missing; allow 7 calendar days to cure | e.g. notice 03-17 -> cure by 03-24 | 29 CFR 825.305(c) |
The four 12-month methods (29 CFR 825.200)
Same employee, 40 h/week, took 6 weeks (240 h) from 2 March 2026 and asks on 1 December 2026 for more leave.
| Method | How the year is measured | Hours available on 1 Dec 2026 | Watch-out |
|---|---|---|---|
| Calendar year | Jan 1 - Dec 31 | 240 now; full 480 again on 1 Jan 2027 | Employee can stack 12 weeks in Dec and 12 more in Jan |
| Fixed year (e.g. fiscal year or hire anniversary) | Any fixed 12 months | Depends on the date the fixed year resets | Same stacking risk at the reset date |
| Forward from first FMLA leave | 12 months starting 2 Mar 2026 | 240 until 1 Mar 2027 | New period starts only when the next leave begins after the year ends |
| Rolling backward | Look back 12 months from each day of leave | 240; the 240 h used in Mar-Apr 2026 come back day by day from Mar 2027 | Most work to track; stops stacking |
This is a preview — the full template continues in the download.
Sign in above to download the full template.
How to use this template
- 1
Fix your 12-month method
Pick one of the four methods in 29 CFR 825.200 and apply it to everyone. Write it in the tracker setup and in your handbook. If you never chose one, you must use whichever is most favorable to each employee.
- 2
Open a row the day you learn of the need
Log the request date as the day you learned the absence may qualify, even if it came in a hallway conversation. The 5-business-day clock for the eligibility notice starts then.
- 3
Convert entitlement into hours
Multiply the employee's normal weekly hours by 12 (or 26 for military caregiver leave). That is the hours bank. Deduct actual FMLA hours taken, in increments no larger than your smallest increment for other leave and never more than one hour.
- 4
Update weekly
Enter intermittent absences from the leave log into the tracker every week, recheck hours remaining, and flag anyone under 40 hours so you can send the required notices before entitlement runs out.
- 5
Keep records three years
Keep the tracker, notices and leave dates for at least three years (29 CFR 825.500). Store medical certifications in a separate confidential file.
Frequently asked questions
How do you track FMLA leave in a spreadsheet?
Give each leave case a row with the request date, reason, leave type, notice dates, certification due date and your 12-month method. Convert entitlement to hours (normal weekly hours x 12) and subtract every FMLA hour taken, then show hours remaining. Keep a separate daily log for intermittent leave and reconcile it into the main tracker weekly.
How many hours is 12 weeks of FMLA?
It depends on the employee's normal schedule. For a 40-hour week it is 480 hours; for a 32-hour week it is 384 hours; for a 20-hour week it is 240 hours. The entitlement is 12 workweeks, so the hours bank equals weekly hours x 12. If mandatory overtime is part of the normal schedule, those hours count too.
How is intermittent FMLA leave calculated?
As a proportion of the employee's actual workweek. Divide FMLA hours taken by the hours the employee would normally have worked. Someone on 40 hours who misses 8 hours has used one-fifth of a week; someone on 32 hours who misses 8 hours has used one-quarter. Track in the smallest increment you use for other leave, never more than one hour.
Which 12-month method is best for FMLA?
Most employers choose the rolling-backward method because it stops employees stacking 12 weeks at the end of one year and 12 more at the start of the next. It takes more tracking, which a spreadsheet handles. Apply the same method to all employees and give 60 days' notice before changing it.
How long do you have to keep FMLA records?
At least three years under 29 CFR 825.500. That includes leave dates and hours, copies of notices given and received, policy documents, and records of benefit premiums and disputes. Medical certifications must be kept confidential and separate from the regular personnel file.
Does a small employer need an FMLA policy?
Private employers with fewer than 50 employees in 20 or more workweeks are not covered by the FMLA, so a federal FMLA policy is not required. State laws may still apply: California's CFRA covers employers with 5 or more employees, and New York Paid Family Leave covers most private employers of any size.