FMLA & Leave Tracker for US Employers

Overview

Keep your FMLA leave records in one Excel workbook. Enter your employees and their leave once, and the tracker checks eligibility, adds up the hours, and shows who has leave left. Built for HR teams, small employers and managers.

What It Does

• Checks each employee against the three federal FMLA eligibility tests: 12 months of service, 1,250 hours worked, and a worksite with 50 or more employees within 75 miles
• Tracks leave against the 12-workweek entitlement for the 12-month period you choose: calendar year, fixed period, employee anniversary, or rolling backward
• Handles continuous, intermittent and reduced-schedule leave
• Shows hours used, hours and weeks remaining, and a clear status for every employee (OK, Low balance, Exhausted, Not eligible)
• One-page manager summary, plus a simple PTO tracker
• Room for up to 100 employees and 500 leave entries

See It in Action

Screenshots from the included example file (the names and dates are made up).

What You Get

• FMLA-Leave-Tracker.xlsx: the blank workbook for your real records
• FMLA-Leave-Tracker-EXAMPLE.xlsx: the same workbook filled with made-up data, so you can see how it works
• Quick-Start Guide (PDF): step-by-step instructions with screenshots, worked examples and troubleshooting

Easy to Use

Works in Microsoft Excel 2010 or newer on Windows or Mac. No macros, no add-ins and no internet connection needed. Your data stays on your own computer. Most people are set up in about 10 minutes.

Who It's For

• HR managers and HR generalists at employers with 50 or more employees
• Small business owners and office managers who run leave without an HR system
• Consultants and payroll teams who support clients (one license per organization)

Good to Know

• Covers federal FMLA rules only. It does not include state or local leave laws, key-employee rules, notices or medical certifications, or the forward-measured 12-month method.
• It is a record-keeping tool. It does not decide whether an absence qualifies for FMLA leave.
• Built and tested for Excel. We have not tested Google Sheets and do not recommend it.

Frequently Asked Questions

Does it work on Mac?
Yes, in Microsoft Excel for Mac.

Do I need macros or add-ins?
No. The workbook has no macros.

Does it cover state leave laws?
No. It models federal FMLA only. Check your state's rules.

Is my data sent to you?
No. The workbook runs on your computer, and we never receive what you enter.

What if I damage the file?
Keep the original download as a backup and work in a copy. You can download the files again from your purchase receipt.

Is this legal advice?
No. Talk to your own counsel about how the law applies to you.

How to Get It

Click Buy Now to open our secure checkout, powered by Stripe. Once your payment is complete, your download is delivered right away. If you have any trouble accessing your files, email marketing@grctrainingonline.com.

Refund Policy

This is a digital product. Refund requests must be made within 4 days of purchase, and a 30% refund charge applies. Please review our Refund Policy before purchasing.

Important Notice

General information, not legal advice. This workbook and guide are record-keeping aids. They do not create an attorney-client relationship and do not replace advice from your own counsel, your written policies, or the rules of the U.S. Department of Labor. FMLA rules, state and local leave laws, and your own policies can change or differ from what is shown here.

No guarantee of results. The workbook is provided “as is”, without any warranty. Its results depend on the information you enter. You are responsible for checking every result and for your organization's compliance. GRC Training Online and Genial Software Solutions Inc. are not liable for decisions made using this workbook or guide.

Not affiliated. GRC Training Online is not affiliated with or endorsed by the U.S. Department of Labor or any government agency.

License. One license per organization. Please do not resell, share publicly or redistribute.

← Back to the Digital Library