River
Y CombinatorBacked by Y Combinator

Free template

Leave of Absence Tracking Template

A leave of absence tracker in three sheets, covering FMLA hours, notice deadlines, ADA reviews and return dates, plus guides for HR and managers.

Free download · No account needed

What you get

Pack of 6 files: 3 documents, 3 spreadsheets

Leave of Absence Tracking Template
  • Process GuideDocument
  • Interactive Process DocumentationDocument
  • Manager GuidanceDocument
  • Case RegisterSpreadsheet
  • Deadline TrackerSpreadsheet
  • Return PlanningSpreadsheet
RiverLeave of Absence Tracking Template

Case Register

Payroll says 1,377 hours. Hours actually worked say 1,242.

Marloe Logistics, fictional 240-person warehouse software company. Rosa Delgado, request dated August 10, 2026.

What is being countedIncludes paid leave?HoursVs. 1,250-hour test
Raw payroll "hours paid" totalYes1,377Clears by 127
Hours actually workedNo (excludes 5 paid weeks)1,242Short by 8

46 weeks actually worked at 27 hours a week is 1,242 hours. The other 5 of the 51 paid weeks were vacation and sick leave, which the Labor Department doesn't count toward the 1,250 hours even though payroll still paid them. The 8-hour gap decides her FMLA eligibility.

How to track and manage a leave of absence

Tracking a leave of absence means keeping one record per request, from the first conversation to the employee's return. In the US, that record answers two questions: whether the Family and Medical Leave Act (FMLA) applies, and whether the Americans with Disabilities Act (ADA) calls for an accommodation. It also holds each notice and due date, the leave used and the return plan. Get three things right above all: the hours count, the notice deadlines and what happens when leave runs out.

Keep the two laws apart. The Equal Employment Opportunity Commission (EEOC), which enforces the ADA in the workplace, says to determine an employee's rights under each statute separately1. A no under one law doesn't answer the question under the other.

A man in a dark hoodie listens across a desk as a woman in a white shirt talks, with a laptop and papers between them
Write down what was asked, in the employee's own words, the day it happens. Photo: Mina Rad on Unsplash

Log each leave request the day it arrives

A leave request doesn't need a form or the right words. The Labor Department says that when an employee first seeks leave for an FMLA reason, they need not expressly assert FMLA rights or even mention the FMLA2. The EEOC says accommodation requests can be made in plain English, without mentioning the ADA1: "I need six weeks off to get treatment for a back problem" counts.

Ask managers to pass any mention of a medical or family reason to HR the same day, without asking for a diagnosis. HR then opens one record per request:

  • The date, who heard it and the employee's own words
  • The reason: their own health, a family member's health, a new child or a military family need
  • Hire date, worksite and usual weekly hours
  • The planned start date, and any paid or unpaid leave in the 12 months before it

Check FMLA eligibility on hours actually worked

Start with coverage. The FMLA applies to private employers with 50 or more employees for at least 20 workweeks2 in the current or preceding calendar year. Public agencies and schools are covered at any size.

The three FMLA eligibility tests

TestWhat to checkEasy mistake
12 months of employmentTime employed as of the day leave starts, consecutive or notMissing an earlier stint when the break was under 7 years
1,250 hoursHours actually worked in the 12 months before leave startsUsing payroll's hours-paid total
50 employees within 75 milesYour headcount within 75 miles of the employee's worksiteAssuming 50 employees company-wide is enough

Take care with the hours. The Labor Department says the 1,250 hours include only those hours actually worked2: paid and unpaid leave, including FMLA leave, don't count. Payroll's hours-paid total includes vacation and sick pay, so it can show an employee over the line who is really short.

Count hourly staff from time records, not schedules, so overtime counts. For salaried exempt staff without hour records, the regulations say eligibility for FMLA leave is presumed3 once they have been employed 12 months.

ExampleRecounting hours for a part-time employeeAn illustrative example written for this guide.

Rosa works a steady 27 hours a week and asks for surgical leave starting August 31.

Payroll shows 1,377 hours paid in the 12 months before that date: 51 paid weeks at 27 hours, plus one unpaid week.

Five of the paid weeks were vacation or sick leave, so she worked 46 weeks, or 1,242 hours.

She is 8 hours short of 1,250 and not eligible for FMLA leave this time.

  • Both figures on file. Record payroll's total beside hours actually worked, so the gap shows.
  • A reason, not a bare no. Her eligibility notice says she is 8 hours short.
  • Not the end of it. Her request still gets an ADA review, covered below.

Track every notice and deadline

Once an employee asks, or you learn the leave may qualify, you have 5 business days to tell them whether they are eligible4, absent extenuating circumstances. If they aren't, the notice must give at least one reason, such as the hours worked.

FMLA deadlines for the tracker

StepWhen it's dueNotes
Eligibility notice5 business days after the request, or after you learn the leave may qualifyOral or written; the optional Form WH-381 works
Rights and responsibilities noticeWith the eligibility noticeWritten; covers certification, paid leave and benefits
Medical certificationAllow at least 15 calendar days after you askExplain what happens if it isn't returned
Designation notice5 business days after you have enough informationWritten; says how much leave will count, if known

Then track the balance. The regulations allow four ways to measure the 12-month leave year5, such as the calendar year or a rolling year counted back from each use. Pick one, use it for everyone, and log intermittent leave in hours.

Open an ADA review at the same time

The ADA covers employers with 15 or more employees and has no minimum tenure or hours. The EEOC says an employer must consider providing unpaid leave6 as a reasonable accommodation for a disability, unless it would cause undue hardship. That holds even if the employee doesn't qualify under the employer's leave policy or has used up their FMLA leave.

The EEOC also says leave requested for a medical condition must be treated as a request for reasonable accommodation6, so open an ADA record beside the FMLA one. If the FMLA or your policy covers the leave, grant it that way. If not, start the interactive process promptly: talk through why the employee needs leave, whether it is one block or intermittent, and when it will end. Record each option, the decision and why.

Pregnancy has its own law. The Pregnant Workers Fairness Act, in force since June 27, 2023, applies to employers with 15 or more employees. They must accommodate known limitations related to pregnancy, childbirth or related medical conditions7, absent undue hardship, and can't force leave when another accommodation would let the employee keep working.

Plan the return before leave runs out

The Labor Department says employees returning from FMLA leave get the same job, or one that is nearly identical2. If you require a fitness-for-duty certification (a doctor's note that they can work), you must give notice of that requirement with the designation notice4. If your employee handbook clearly says when one is needed, that notice can be oral.

Treat the day leave runs out as a decision point, not an end date. The EEOC says an employer may have to grant leave beyond its maximum6 as an accommodation unless that causes undue hardship. It adds that a "100%" healed rule violates the ADA when the employee could do the job with or without a reasonable accommodation, absent undue hardship.

There is a limit: when an employee can't say whether or when they will return, the EEOC treats that indefinite leave as an undue hardship. About a week before leave ends, ask whether they can come back and what they will need. If your end-of-leave letter says return or be terminated, add a line inviting a request for more time.

Give any temporary accommodation, like a reduced schedule, a written review date. If ending employment still looks likely, work through an employee termination checklist that tests the timing against recent leave and accommodation requests.

When to call an employment lawyer

Get advice before you deny leave, refuse an accommodation as an undue hardship, or end someone's employment during or after leave. State and city laws can give employees more. This guide summarizes US federal rules and isn't legal advice.

Close the file without loose ends

After the employee returns, don't hold the leave against them in attendance records or performance reviews. The Labor Department gives counting FMLA leave against employees in points-based attendance policies2 as an example of prohibited retaliation. If someone says they were punished for taking leave, look into it with a workplace investigation.

Before you close a leave file

  • FMLA eligibility rests on hours actually worked, with payroll's total beside it
  • Every notice went out on time, and any no gives a reason
  • Any medical request has an ADA record: options, decision and reason
  • Any temporary accommodation has a review date
  • Medical certifications sit in a separate, confidential file
  • The file will be kept for at least 3 years3

To skip the setup, start from the template on this page: a case register, deadline tracker and return plan with four sample cases. Open it in River and it works out hours actually worked from the schedule and leave you describe before calling anyone eligible.

How to use this template

The files work on their own. Log each request in the Case Register, put its due dates in the Deadline Tracker and plan each return in Return Planning. The three guides cover the process, the accommodation record and what managers should say, and the sheets come filled in with four made-up cases to show how they work.

Choose Edit with AI and River asks for a current request or a short list of open cases. For each, it wants the reason, hire date, weekly hours and every week of leave in the past 12 months. It works out hours actually worked before saying anything about FMLA eligibility, and opens an ADA review for any medical reason. A case where leave is nearly used up while a medical restriction remains goes first.

  1. Download it or open it in River

    Download the three Word documents and three CSV sheets with no signup, or open them in River with Edit with AI.

  2. Log each request

    Add a row to the Case Register: request date, reason, tenure, and hours actually worked beside payroll's total.

  3. Check FMLA and the ADA separately

    Count hours actually worked for the FMLA, and open an ADA review for any medical reason, or ask River to do both.

  4. Track notices and the return

    Put each notice date in the Deadline Tracker, then plan the return in Return Planning with a review date.

What's in the template

Two separate checks per case, and a file that stays open after leave runs outThe register runs the FMLA and ADA checks independently; the return plan keeps a restriction visible instead of closing the file the day the leave is used up.
Leave of Absence Tracking Template
RiverCase Register

Case Register

Illustrative. Marloe Logistics, fictional warehouse software company.

EmployeeReasonTenureHours workedFMLAADA opened
Rosa DelgadoOwn health condition16.0 mo1,242Ineligible (hours)Yes
Devon LingOwn health condition38.4 mo1,920EligibleYes, at exhaustion
Priya AnandBonding leave39.0 mo1,960EligibleNo
Marcus WhitfieldChronic migraines7.0 moN/AIneligible (tenure)Yes

Two different reasons rule out FMLA leave, hours for Rosa, tenure for Marcus, and both still open an ADA row on the same day, because neither reason has any bearing on whether the ADA applies.

RiverReturn Planning

Return Planning

What happens as each case approaches or reaches the end of its leave bank.

EmployeeLeave bankRestriction on fileAccommodationReview date
Rosa DelgadoADA unpaid leavePost-surgical recovery12 weeks unpaid leaveNov 23, 2026
Devon LingFMLA, exhausted Jun 2910-lb lift limit, 20 hrs/wk3-week modified dutyJul 20, 2026
Marcus WhitfieldNone (ineligible)Flexible start, 2 days/wkUnder reviewPending documentation

Devon's row is the one a strict 12-week leave limit would have closed on June 29. Instead it stayed open 21 more days against a stated review date, then closed on a documented return to full duty.

  • Case Register sheetOne row per request: tenure, payroll hours beside hours actually worked, the FMLA result and the ADA review.
  • Deadline Tracker sheetEach case's notice and documentation due dates, worked out from its request date, with current status.
  • Return Planning sheetWhich leave each case is using, any restriction still on file, the accommodation, its review date and the outcome.
  • Process GuideIntake to return in four steps, with worked cases on counting hours and on leave running out.
  • Interactive Process DocumentationWhat to record in each accommodation conversation: the request, documents asked for, options, decision and review date.
  • Manager GuidanceWhat a manager should do when an employee first mentions a medical need, and what never to say.

Common questions

What should a leave of absence tracker include?

Start with one row per request: the date, the reason, the hire date and hours actually worked in the 12 months before leave starts. Record the FMLA answer with its reason, and whether an ADA review is open. Then add each notice and its due date, leave used, any work restriction, and a return or review date.

Does paid time off count toward the FMLA's 1,250 hours?

No. The Labor Department counts only hours actually worked, so paid and unpaid leave are left out, including earlier FMLA leave. That is why payroll's hours-paid total, which includes vacation and sick days, can overstate the count. Count the 12 months back from the day leave is due to start, not the day the employee asked.

Can an employee who isn't eligible for FMLA still get leave?

Yes, in some cases. At employers with 15 or more employees, the ADA can require unpaid leave as a reasonable accommodation for a disability, unless it would cause undue hardship. The EEOC says this applies even when the employee doesn't qualify under your leave policy. Pregnancy-related limits fall under the Pregnant Workers Fairness Act, and many states add leave laws of their own.

What happens when an employee's FMLA leave runs out?

Their FMLA job protection ends for that 12-month period, but the case shouldn't close automatically. If the employee has a disability and needs more time or a work restriction, the EEOC's position is that you may have to provide it unless that causes undue hardship. Ask what they need, record the options, and get legal advice before ending employment.

How long do employers have to send FMLA notices?

Five business days for the eligibility notice, counted from the request or from when you learn the leave may qualify, absent extenuating circumstances. The rights and responsibilities notice goes with it. Once you have enough information to decide, such as a completed medical certification, the written designation notice is due within 5 business days.

Is this leave of absence tracking template free?

Yes. Download the three Word documents and three CSV sheets with no signup. The sheets come filled in with four made-up cases, so you can see how each one works before replacing them with your own. Edit with AI opens the same template in a free River workspace.

What does Edit with AI do?

It opens the template in a free River workspace. River asks for a current leave request or a short list of open cases, with each reason, hire date, weekly hours and recent leave. It works out hours actually worked before judging FMLA eligibility, opens an ADA review for medical reasons, and builds the three sheets. Legal decisions stay with you.

Sources

  1. U.S. Equal Employment Opportunity Commission. “Enforcement Guidance on Reasonable Accommodation and Undue Hardship under the ADA.” eeoc.gov (opens in a new tab)

  2. U.S. Department of Labor. “FMLA Frequently Asked Questions.” dol.gov (opens in a new tab)

  3. eCFR. “29 CFR 825.500 — Recordkeeping requirements.” ecfr.gov (opens in a new tab)

  4. eCFR. “29 CFR 825.300 — Employer notice requirements.” ecfr.gov (opens in a new tab)

  5. eCFR. “29 CFR 825.200 — Amount of leave.” ecfr.gov (opens in a new tab)

  6. U.S. Equal Employment Opportunity Commission. “Employer-Provided Leave and the Americans with Disabilities Act.” eeoc.gov (opens in a new tab)

  7. U.S. Equal Employment Opportunity Commission. “What You Should Know About the Pregnant Workers Fairness Act.” eeoc.gov (opens in a new tab)

Written by

Chandler Supple

Co-founder & CEO, River

Chandler has spent the last six years working in AI, building tools for millions of users and Fortune 100 companies. In 2025, he co-founded River to build a new kind of operating system for AI agents.

Reviewed by

Brian Joseff, Co-founder, River