Free FMLA Tracker Template (Excel + Forms)
Free FMLA tracker templates: an Excel workbook, an intermittent leave tracker, a printable log, an eligibility worksheet, and a notice checklist.
FMLA Tracker Templates
Five free FMLA tracking templates: a seven-sheet Excel workbook, a dedicated intermittent leave tracker, a printable pay-period log, an eligibility worksheet, and a notice deadline checklist. Entitlement is calculated from each employee's actual weekly schedule rather than a flat 480 hours. XLSX and DOCX, no signup.
An FMLA tracker is the record of how much protected leave each employee has used and how much is left. It sounds like bookkeeping until someone takes leave four hours at a time across seven months, and the question of whether they have three weeks or three days remaining has to be answered from a pile of timesheets. The employer carries the burden of counting correctly, which is why the tracker matters more than it looks.
There are five templates here: a seven-sheet Excel workbook, a dedicated intermittent leave tracker, a printable log for teams that record absences on paper, an eligibility worksheet, and a notice deadline checklist. The spreadsheets download as XLSX and the forms as Word documents, free and without an email. The tracker pairs with your FMLA policy, which is where the leave year method and the certification rules should be written down.
What an FMLA Tracker Does
A tracker answers four questions on demand: is this employee eligible, what is their entitlement, how much have they used inside the applicable 12-month period, and what deadline is coming next. Most small businesses run this in a spreadsheet, which is fine as long as the arithmetic underneath it is right.
The reason it needs structure rather than a note in a calendar is that leave rarely arrives as a clean block. Continuous leave for a surgery is easy to count. Intermittent leave for a chronic condition, taken as late arrivals and half days across months, is where balances drift and where a wrong answer denies someone protected time they were still owed. For the underlying rules the tracker implements, the FMLA overview covers the framework.
Which Template Should You Use?
Start with the main workbook, which handles most situations. Add the intermittent tracker if anyone takes leave in partial days, the printable log if absences get recorded on the floor, and run the eligibility worksheet before any of them.
5 Free FMLA Tracker Templates
Download everything as one bundle, or take individual files. The two spreadsheets come as XLSX workbooks with the sheets already laid out and sample rows showing how the entitlement math works; the three forms come as editable Word documents.
Template 1: FMLA Tracker Workbook
Seven sheets: employee setup with entitlement derived from the actual weekly schedule, a daily leave log, a balance summary, a rolling twelve-month lookback, certification and notice dates, a state overlay, and instructions.
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Employee Name | Employee ID | Department | Manager | Date of Hire | Months of Service | Hours Worked Prior 12 Mo | Normal Hours Per Week | Eligible (12 Mo + 1250 Hrs) | Entitlement Hours (Hrs/Wk x 12) | Military Caregiver (Hrs/Wk x 26) | Notes |
| 2 | Sample, Dana | E-1041 | Operations | R. Vance | 03/14/2023 | 40 | 1980 | 40 | Yes | 480 | 1040 | Standard full-time schedule |
| 3 | Sample, Marco | E-1052 | Warehouse | R. Vance | 08/02/2024 | 23 | 2340 | 45 | Yes | 540 | 1170 | Regular 45-hour schedule, not 480 |
| 4 | Sample, Priya | E-1063 | Front Desk | L. Okafor | 01/09/2025 | 18 | 1120 | 24 | No | 0 | 0 | Under 1,250 hours, recheck at next request |
| 5 | Sample, Chen | E-1074 | Service | L. Okafor | 06/21/2021 | 61 | 1664 | 32 | Yes | 384 | 832 | Part-time 32-hour schedule |
| 6 | ||||||||||||
| 7 | ||||||||||||
| 8 | ||||||||||||
| 9 |
Template 2: Intermittent FMLA Tracker
A separate workbook for partial absences, recording scheduled hours against hours actually worked so a four-hour absence counts as four hours, with a column flagging anything outside the certified frequency.
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Date | Employee Name | Scheduled Start | Scheduled End | Scheduled Hours | Hours Actually Worked | FMLA Hours Used | Fraction of Workweek | Reason Code | Certification On File | Within Certified Frequency | Notes |
| 2 | 04/13/2026 | Sample, Marco | 07:00 | 16:00 | 9 | 5 | 4 | 0.089 | Family care | Yes | Yes | Left for a scheduled appointment |
| 3 | 04/21/2026 | Sample, Marco | 07:00 | 16:00 | 9 | 0 | 9 | 0.200 | Family care | Yes | Yes | Full shift missed, flare-up |
| 4 | 04/28/2026 | Sample, Marco | 07:00 | 16:00 | 9 | 6 | 3 | 0.067 | Family care | Yes | Yes | Late arrival |
| 5 | 05/06/2026 | Sample, Marco | 07:00 | 16:00 | 9 | 0 | 9 | 0.200 | Family care | Yes | No | Exceeds certified frequency, recertification requested |
| 6 | ||||||||||||
| 7 | ||||||||||||
| 8 | ||||||||||||
| 9 |
Template 3: Printable Intermittent Leave Log
A per-pay-period sheet a supervisor completes by hand and the employee signs, for teams that record absences on the floor rather than in a spreadsheet. The totals feed into the tracker afterward.
Template 4: FMLA Eligibility Worksheet
Five steps covering employer coverage, employee eligibility, whether the reason qualifies, the entitlement calculation in hours, and the state leave overlay. Complete it at each new request.
Template 5: FMLA Notice and Deadline Checklist
The notice and certification deadlines from the request through return to work, so the eligibility notice, the certification window, and the designation notice do not slip past unnoticed.
Why 480 Hours Is the Wrong Default
The entitlement is stated in workweeks: 12 workweeks of leave in a 12-month period, and 26 workweeks in a single 12-month period for military caregiver leave. Nothing in that is denominated in hours. Employers are permitted to convert to an hourly figure for tracking convenience, but the conversion has to use the employee's total normally scheduled hours, not a standard assumption.
That makes the entitlement a per-employee number rather than a company-wide constant. The table below shows what the same 12 workweeks come to across different schedules.
| Normal schedule | 12-workweek entitlement | 26-workweek military caregiver | What a flat 480 cap does |
|---|---|---|---|
| 24 hours per week | 288 hours | 624 hours | Gives 192 hours more than owed |
| 32 hours per week | 384 hours | 832 hours | Gives 96 hours more than owed |
| 40 hours per week | 480 hours | 1,040 hours | Correct for this schedule only |
| 45 hours per week | 540 hours | 1,170 hours | Cuts the entitlement short by 60 hours |
| 50 hours per week | 600 hours | 1,300 hours | Cuts the entitlement short by 120 hours |
Two refinements are worth knowing. Where a schedule varies so much that the hours cannot be determined, an employer may use a weekly average based on the 12 months before the leave. And mandatory overtime hours the employee misses for a qualifying reason may be counted as leave, while voluntary overtime hours they choose not to work may not.
What to Track
A workable tracker covers four groups: who the employee is and whether they qualify, what their entitlement comes to, what they have actually used, and where the paperwork stands.
The field that does the most work is normal scheduled hours per week, because the entitlement, the remaining balance, and the fraction of a workweek consumed by any partial absence all derive from it. Get that column right and the rest follows; leave it blank and the tracker quietly reverts to guessing.
The Four Leave Year Methods
Twelve workweeks in a 12-month period raises an obvious question: which 12 months? Employers choose from four methods, apply the choice consistently to everyone, and generally must give advance notice before switching.
| Method | How the window is set | Trade-off |
|---|---|---|
| Calendar year | January 1 through December 31, resetting each year | Simplest to administer, but allows 12 weeks in December followed by 12 more in January |
| Fixed 12-month period | Any consistent window, such as a fiscal year or hire anniversary | Predictable, with the same stacking issue at the rollover point |
| Measured forward | Runs 12 months from the employee's first use of leave | Personal to each employee, so the reset date differs across the team |
| Rolling backward | Looks back 12 months from each date leave is used | Prevents stacking and is generally preferred, but the hardest to calculate manually |
The one option that is not available is leaving it undecided. An employer that has not selected a method must apply whichever 12-month period is most beneficial to the employee, worked out case by case, which makes consistent tracking impossible. Write the chosen method into your FMLA policy so the tracker and the policy agree.
Tracking Intermittent Leave
Intermittent leave is where trackers fail, because the unit of measurement stops being a day. An employee with a chronic condition might miss two hours on Tuesday, a full shift the following week, and arrive late twice the week after. Each of those is a different fraction of the entitlement.
Only the leave actually taken counts. The calculation is the hours missed divided by the hours the employee would have worked that week, which means the same two-hour absence consumes a different share depending on the schedule. Recording it correctly requires two numbers per day rather than one: what the employee was scheduled to work, and what they actually worked. The difference is the leave used, and rounding it up to a full day both overstates usage and pushes the employee toward an exhaustion date they should not have reached.
The second thing to track alongside hours is the frequency and duration on the medical certification. When absences start falling outside what was certified, that is information, not grounds for action on its own: it is the signal to consider requesting recertification, which may generally be sought every six months in connection with an absence. When the balance does run out, the FMLA exhaustion letter is the document for telling the employee.
Under 50 Employees? Read This First
Federal FMLA reaches private employers with 50 or more employees in 20 or more workweeks of the current or previous calendar year, and separately requires the individual employee to work at a site with 50 or more employees within 75 miles. A business with 25 people is therefore usually outside federal FMLA, and many owners reasonably conclude the rules do not apply to them.
That conclusion is getting less safe every year. A growing number of states run paid family and medical leave programs, and their coverage thresholds are far lower than the federal one, with several covering essentially every employer in the state. Where small employers get relief, it is typically from the employer share of the premium rather than from participation itself, meaning a ten-person business may still have to withhold, remit, and hold the job open. Several states also have job-protection statutes separate from wage replacement.
Four Tracking Mistakes
These four account for most of what goes wrong, and each of them is built into templates you can download today.
All four share a shape: the tracker produces a confident number that is wrong, and nobody notices until an employee is denied leave they were entitled to or granted leave they were not. Working through the eligibility worksheet at each request and deriving the entitlement from the schedule handles the first two; choosing a leave year method and checking your state handles the rest.
Set Up, Log, and Store
A tracker earns its keep through routine: set the employee up once, log leave as it happens, watch the notice dates, and store the records where they belong.
The spreadsheets above work on their own, and for a business handling a couple of leaves a year they are enough. FirstHR stores the leave file against the employee profile with access controls, keeps medical documentation separate from the personnel file, captures acknowledgments with e-signature, and holds the certification and notice dates with reminders. FirstHR is an onboarding and HR platform, not a leave administrator and not a law firm: it does not calculate entitlements, adjudicate leave requests, or file state claims, so pair it with a qualified professional for those decisions. Applicant tracking is coming soon to FirstHR.
Frequently Asked Questions
What is an FMLA tracker?
An FMLA tracker is the record an employer keeps of how much protected leave each eligible employee has used and how much remains. In practice it is usually a spreadsheet with a row per employee holding their eligibility facts and entitlement, and a log with a row per day of leave taken. A good tracker answers four questions at any moment: is this employee eligible, how much leave are they entitled to, how much have they used in the applicable 12-month period, and what notice or certification deadline is coming up. Tracking matters because the employer, not the employee, carries the burden of counting leave correctly, and because the calculation is easy to get wrong once leave is taken in partial days rather than continuous blocks. This is general information, not legal advice.
How many hours of FMLA leave does an employee get?
It depends on their schedule, and this is the single most misunderstood part of tracking. The entitlement is 12 workweeks in a 12-month period, not a fixed number of hours. Converting to hours for tracking purposes is allowed, but the conversion has to be based on the employee's own total normally scheduled hours. An employee who normally works 40 hours a week is entitled to 480 hours; one scheduled for 50 hours is entitled to 600; one scheduled for 32 hours is entitled to 384. The 480 figure that appears hard-coded in many templates is only correct for a 40-hour schedule. Military caregiver leave carries a larger entitlement of 26 workweeks in a single 12-month period, calculated the same way against the actual schedule. This is general information, not legal advice.
Who is eligible for FMLA leave?
Three conditions have to be met together. The employer must be covered, which for a private-sector business means employing 50 or more employees in 20 or more workweeks in the current or previous calendar year. The employee must have worked for the employer for at least 12 months, which do not have to be consecutive, and must have worked at least 1,250 hours during the 12 months immediately before the leave starts. And the employee must work at a location where the employer has at least 50 employees within 75 miles. If any one of the three fails, the employee is not eligible for federal FMLA leave. Eligibility should be checked at the time of each request rather than assumed from a previous year, because the hours-worked figure moves. This is general information, not legal advice.
How do you track intermittent FMLA leave?
Record each partial absence on the day it happens, capturing the hours the employee was scheduled to work and the hours they actually worked. The difference is the leave used, and only that amount may be counted against the entitlement. An employee who leaves four hours into a nine-hour shift has used four hours, not a full day. Expressed as a fraction of the workweek, the calculation is the hours missed divided by the hours the employee would otherwise have worked, so the same absence consumes a different share of the entitlement depending on the schedule. Alongside the hours, track the frequency and duration stated on the medical certification, so you can see when absences fall outside what was certified, which is a signal to consider recertification rather than to act immediately. This is general information, not legal advice.
What are the four ways to measure the FMLA leave year?
An employer may use the calendar year; any fixed 12-month period such as a fiscal year or an employee's anniversary year; a 12-month period measured forward from the date of the employee's first use of leave; or a rolling 12-month period measured backward from each date leave is used. Whichever is chosen must be applied consistently and uniformly to all employees, and changing methods generally requires advance notice to everyone. The rolling backward method is the one most employers prefer because it prevents an employee stacking 12 weeks at the end of one year against 12 weeks at the start of the next, though it is the hardest to calculate by hand. The important point is to choose deliberately: an employer that has not selected a method must apply whichever period is most beneficial to the employee. This is general information, not legal advice.
Does FMLA apply to a business with fewer than 50 employees?
Federal FMLA generally does not, but that is not the end of the analysis, and stopping there is a common and expensive mistake. Federal coverage requires 50 or more employees in 20 or more workweeks of the current or previous calendar year, with the separate 50-within-75-miles condition applying at the employee level. A business with 25 people is therefore usually outside federal FMLA. However, a growing number of states operate paid family and medical leave programs with much lower or no employer-size thresholds, and in several of them essentially every employer participates, with relief for small employers applying to the employer share of premiums rather than to coverage. Some states also have separate job-protection statutes. Check the rules for each state where you have employees rather than relying on the federal threshold. This is general information, not legal advice.
Can I keep FMLA records in the personnel file?
No, and this is worth getting right from the first request. Records relating to medical certifications, diagnoses, and medical histories are confidential medical records and must be maintained in files separate from the usual personnel file, with access limited to those who need it. That includes the certification form, notes about the condition, and anything else revealing medical information. The practical implication for a tracker is that the workbook itself often contains leave reasons and certification dates, so it should be stored with restricted access rather than in a shared folder everyone can open. Keep records long enough to satisfy the applicable retention rules, and longer where a claim or audit is pending. This is general information, not legal advice.
When do I have to send FMLA notices?
Two notices matter most for tracking purposes, and both run on short clocks. When an employee requests leave, or when you first learn that leave may be for a qualifying reason, you generally have five business days to provide the eligibility notice together with the rights and responsibilities information. Once you have enough information to determine whether the leave qualifies, you generally have five business days to provide the designation notice telling the employee whether the leave will count against their entitlement, and where possible how much will be counted. If you require a medical certification, the employee must generally be given at least 15 calendar days to return it. Missing these deadlines is a distinct problem from miscounting hours, which is why the checklist on this page tracks them separately. This is general information, not legal advice.