FMLA, PML and PFL: How to Track Complex Leave Without Excel

July 9, 2026 • 21 min read •

By Kate Vodopian

Some leave is simple.

An employee books five days of holiday. The manager approves it. The balance goes down.

FMLA, Paid Medical Leave and Paid Family Leave are different.

They can involve medical needs, family care, job protection, wage replacement, rolling time windows, part-day absence and return-to-work planning.

They can also run at the same time as sick leave, PTO or unpaid leave.

That is why they need close supervision.

A spreadsheet can store dates. But it is much harder to track a rolling 12-month window, intermittent leave, different employee limits, sensitive notes and leave types that may overlap.

This guide explains what FMLA, Paid Medical Leave and Paid Family Leave mean, how they work, and how small businesses can model them in TimeOff.Management.

This article is general information, not legal advice. Employers should always check the rules that apply in their state, country and company policy.

What does FMLA mean?

FMLA stands for the Family and Medical Leave Act.

It is a US federal law that gives eligible employees job-protected, unpaid leave for certain family and medical reasons.

Under FMLA, eligible employees can usually take up to 12 workweeks of leave in a 12-month period.

This can be used for reasons such as:

• the employee’s own serious health condition
• caring for a spouse, child or parent with a serious health condition
• bonding with a new child
• adoption or foster placement
• certain military family reasons

Eligible employees may also be able to take up to 26 workweeks in a single 12-month period to care for a covered servicemember with a serious injury or illness.

You can read the official overview on the US Department of Labor FMLA page.

Why FMLA is hard to track

FMLA does not always happen in one clean block.

An employee may take:

• 12 full weeks
• a few days at a time
• a reduced work schedule
• two hours for treatment
• one day for a flare-up
• intermittent leave over many months

Only the leave actually taken should be counted.

That means one employee may have many small FMLA absences linked to the same case.

This is where Excel starts to struggle.

What does Paid Medical Leave mean?

Paid Medical Leave, often shortened to PML, usually means paid time away from work when an employee cannot work because of their own serious health condition.

PML is not one single federal rule.

It may come from:

• a state paid leave programme
• an employer policy
• short-term disability cover
• a wider paid family and medical leave scheme

For example, Washington’s Paid Family and Medical Leave programme says paid medical leave is for the employee’s own serious health condition. Workers can usually take up to 12 weeks of medical or family leave, up to 16 weeks when medical and family leave are combined in the same claim year, and up to 18 weeks in some pregnancy-related cases.

You can read more on the official Washington Paid Family and Medical Leave guide.

The simple way to think about PML is this:

Paid Medical Leave is about the employee’s own medical need.

It is not always the same as normal sick leave.

It may also overlap with FMLA, PTO, company sick pay or unpaid leave.

What does Paid Family Leave mean?

Paid Family Leave, often shortened to PFL, gives an employee wage replacement while they are away for family reasons.

Common reasons include:

• bonding with a new child
• caring for a seriously ill family member
• supporting a family member in the military

California is a useful example.

California Paid Family Leave provides benefit payments for up to 8 weeks in a 12-month period for eligible care, bonding or military assist claims.

California also makes an important point: PFL provides benefit payments, but it does not itself provide job protection. Other laws, such as FMLA or the California Family Rights Act, may provide job protection.

You can read more on the official California Paid Family Leave page.

This is the key point for small businesses:

Paid leave and job-protected leave are not always the same thing.

An employee may be paid under PFL while also being job-protected under FMLA.

Or they may receive pay under a state programme but need a separate law or company policy for job protection.

FMLA vs Paid Medical Leave vs Paid Family Leave

Here is the simple difference.

The hard part is that one absence can use more than one leave type.

For example, an employee gives birth.

Their recovery may be covered by Paid Medical Leave. Their bonding time may be covered by Paid Family Leave. Some or all of the same period may also count against FMLA if the employee is eligible.

That means the business may need to track:

• job protection
• paid benefit leave
• PTO top-up
• unpaid leave
• return-to-work date
• remaining balance
• documents and notes
• privacy settings

This should not be managed from memory.

Why rolling leave windows are hard in Excel

FMLA is often tracked over a 12-month period.

The US Department of Labor allows employers to use different methods to define the FMLA leave year.

These include:

• the calendar year
• a fixed 12-month period
• a 12-month period measured forward from the first FMLA leave date
• a rolling 12-month period measured backward from the date leave is used

The rolling method is usually the hardest to track.

Learn more from the Department of Labor’s FMLA 12-month period fact sheet.

A simple rolling-window example

Imagine an employee works 40 hours per week.

Their 12-week FMLA entitlement may equal 480 hours.

They have already used:

If they ask for more FMLA leave in September, the business must look back 12 months from the new leave date.

It cannot just check the calendar year.

Every new request needs a fresh calculation.

As old leave drops out of the rolling window, the available balance changes again.

This is why a normal spreadsheet is risky.

A copied formula can break. A hidden row can change the answer. A manager may approve a request without seeing a related absence from six months ago.

Why intermittent leave is even harder

Intermittent leave means the employee does not take one long block of absence.

They take leave when they need it.

That might be:

• two hours for treatment
• half a day for recovery
• every Friday for medical appointments
• one day when symptoms flare up
• a reduced work schedule for several weeks

The Department of Labor explains that FMLA leave may need to be calculated using the employee’s actual workweek.

A 40-hour employee and a 30-hour employee do not have the same hourly entitlement.

See the FMLA leave calculation fact sheet.

This matters because FMLA, Paid Medical Leave and Paid Family Leave may need to be tracked in hours, not just days.

That is not easy in Excel.

Why small businesses need managed leave tracking

FMLA, Paid Medical Leave and Paid Family Leave are not normal holiday requests.

They should be treated as managed leave types.

Managed leave means the request is not just approved or declined.

It is reviewed.

Before approval, the business may need to check:

• Is the employee eligible?
• Which law or company policy applies?
• Is the leave paid, unpaid or both?
• Is the job protected?
• Does the leave run at the same time as another leave type?
• Has the employee already used leave in the rolling window?
• Does the policy have one combined limit or separate limits?
• Is the leave continuous or intermittent?
• Should it be tracked in days or hours?
• Who needs to approve it?
• What should stay private?
• What is the expected return date?

This is why FMLA-style leave should sit under HR, owner or senior manager review.

It should not be approved in the same way as a normal holiday.

How TimeOff.Management helps

TimeOff.Management helps small businesses manage holidays, PTO, sick leave, approvals and staff availability in one flexible system.

For complex leave, it can help you create a clearer managed leave process.

You can use TimeOff.Management to:

• create custom leave types
• set leave type limits in days
• set different limits for different employees
• track leave in days, half-days or hours
• manage approvals
• keep sensitive leave details private
• record comments and notes
• review absence history in reports
• keep old records for future reference

This gives small businesses a better process than a shared spreadsheet.

But it is important to be clear about what TimeOff.Management does and does not do.

TimeOff.Management helps you manage the process.

It does not replace HR review, legal advice or policy checks.

1. Create clear leave types

Do not track FMLA, Paid Medical Leave and Paid Family Leave as one generic sick leave type.

Create clear leave types instead.

TimeOff.Management supports custom leave types, allowance effects, annual limits, booking rules and approval settings.

You can read more in the TimeOff.Management leave types guide.

The key benefit is clarity.

FMLA can track job protection. Paid Medical Leave or Paid Family Leave can track paid leave. PTO Top-Up can track normal paid time off used during the same absence.

One real-life absence may need more than one record.

That is better than mixing everything into one spreadsheet row.

2. Choose the right setup for combined PML and PFL limits

Some paid leave rules do not give separate limits for medical leave and family leave.

Instead, they apply one combined limit across both.

Washington is a good example. Its paid leave programme has separate family and medical leave reasons, but also a combined limit when more than one qualifying event happens in the same claim year.

That matters when you set up leave types.

TimeOff.Management can track a limit for each leave type.

It does not automatically link two different leave types under one shared combined cap.

So if Paid Medical Leave and Paid Family Leave share one legal or company limit, you have two practical setup options.

Option A: Use one combined leave type

This is usually the safest setup when the combined cap is the key rule.

Create one leave type:

Paid Family and Medical Leave

Then use comments or admin notes to record the reason.

For example:

Reason: Medical recovery
Reason: Family care
Reason: Bonding
Reason: Pregnancy-related medical leave

This keeps the limit in one place.

It also reduces the risk of one person using too much leave across two separate leave types.

Option B: Use separate PML and PFL leave types

This can work well when reporting by reason is more important.

Create separate leave types:

Paid Medical Leave
Paid Family Leave

Each leave type can have its own limit.

But if the law or policy has a combined cap, HR or the business owner should review the combined usage before approving more leave.

Use reports and comments to check related records.

This is still much better than Excel because the dates, leave types, approval status, comments and absence history are all kept in one system.

3. Keep FMLA separate from paid leave

FMLA should usually be separate from Paid Medical Leave and Paid Family Leave.

That is because FMLA is mainly about job protection.

Paid Medical Leave and Paid Family Leave are about wage replacement or paid benefit leave.

They may run at the same time, but they are not the same thing.

A simple setup could look like this:

This keeps the legal leave record separate from the pay record.

That is important because paid leave and job protection do not always come from the same rule.

4. Set different limits for different employees

Complex leave limits may depend on the employee’s normal working pattern.

For example, an employee who works 40 hours per week may have a different hourly equivalent from an employee who works 30 hours per week.

A simple example:

TimeOff.Management does not automatically calculate or prorate complex FMLA, PML or PFL leave-type limits from the employee’s schedule.

Instead, admins can set different limits for different users in days.

That means HR, the owner or another authorised person should calculate the correct limit first.

Then the admin can enter the right limit for that employee.

You can read more in the individual limits for leave types guide.

This keeps the process controlled.

It also helps small businesses avoid spreadsheet formulas that are easy to copy wrong.

5. Understand what employee schedules do

Employee schedules still matter.

In TimeOff.Management, an employee schedule affects which days count as working days and how leave is deducted when the employee books time off.

For example, if a part-time employee only works Monday to Wednesday and books Monday to Friday off, TimeOff.Management can count only the employee’s working days.

You can read more in the employee schedule guide.

But this is different from automatically setting a legal leave limit.

A schedule can help calculate how much absence is used when leave is booked.

It does not automatically decide the employee’s FMLA, PML or PFL entitlement.

That limit should be reviewed and set by an authorised person.

6. Track complex leave in hours where needed

FMLA-style leave is often easier to manage in hours.

This is especially true when leave is intermittent.

For example, an employee may take:

• two hours for treatment
• half a day for recovery
• one day for a flare-up
• a reduced schedule for several weeks
• recurring appointments over many months

TimeOff.Management supports booking leave in hours, half-days or days.

That gives small businesses more flexibility than a spreadsheet built only around full days.

It is also useful for part-time workers, phased returns and reduced schedules.

7. Use approvals for close supervision

FMLA, Paid Medical Leave and Paid Family Leave should not be auto-approved like a normal holiday.

A good process is:

1. The employee submits the request.
2. The manager checks team cover.
3. HR, the owner or an authorised person checks the rule.
4. The request is approved, declined or sent back for more information.
5. The remaining entitlement is checked before each new request.

TimeOff.Management supports flexible approval setup, including department approvers, direct supervisors, secondary approvers and two-tier approval policy options.

You can read more in the leave approvers guide.

This helps keep complex leave under control.

It also stops managers approving sensitive requests without checking the policy detail.

8. Keep sensitive leave private

The team may need to know that someone is away.

They do not need to know why.

Medical and family leave details should be kept private.

TimeOff.Management allows companies to hide or obfuscate leave-type details in Team View. Employees can see that a colleague is absent, while admins and supervisors can still see full details where their permissions allow it.

You can read more in the leave types guide and the Team View guide.

This is useful for:

• medical leave
• family care leave
• pregnancy-related leave
• disability-related leave
• unpaid protected leave
• sensitive personal situations

Good leave management is not only about balances.

It is also about trust.

9. Use reports before approving more leave

Reports are one of the most important parts of managed leave tracking.

Before approving a new FMLA, PML or PFL request, HR or the business owner should check the employee’s past usage.

This is especially important when:

• the leave is intermittent
• the policy uses a rolling window
• two leave types may share one combined cap
• the employee has a user-specific limit
• the employee has already used related leave
• the absence is part of a longer case

TimeOff.Management reports can help admins and managers review allowance, PTO usage, employee absence records, leave types, request status, approvers and comments.

You can read more in the reports guide.

This gives the business a clearer record than a shared spreadsheet.

It also helps avoid decisions based on memory.

Example setup 1: One combined paid family and medical leave limit

Use this when PML and PFL share one combined cap.

This setup is simple.

It keeps the combined PML and PFL limit in one place.

Use comments or admin notes to record whether the leave is for medical recovery, family care, bonding or another approved reason.

Example setup 2: Separate PML and PFL leave types with managed review

Use this when you want clearer reporting by reason.

This setup gives better reporting by leave reason.

But it needs close supervision.

If the policy has a combined PML and PFL cap, HR or the business owner should review both leave types before approving more leave.

TimeOff.Management will not automatically combine the two limits into one shared cap.

What TimeOff.Management can do

TimeOff.Management can help small businesses:

• create supervised leave types
• track absence in days, half-days or hours
• set limits for individual leave types
• set different leave type limits for different employees
• keep sensitive leave details private
• use approvals for close supervision
• review leave history in reports
• record comments and approval history
• keep absence data in one place

This makes complex leave easier to manage.

It also gives owners, managers and HR a better record than Excel.

What TimeOff.Management does not do

It is just as important to be clear about what the system does not do.

TimeOff.Management does not:

• automatically link two different leave types under one shared combined cap
• automatically deduct one absence from several legal leave balances
• automatically calculate every federal or state entitlement
• automatically decide whether an employee is eligible
• automatically prorate complex leave-type limits from the employee schedule
• replace HR review or legal advice

For complex leave, this is not a weakness.

It is the reason these leave types should be managed carefully.

TimeOff.Management gives small businesses the structure to manage the process. The final checks should still be made by an authorised person.

Why this is better than Excel

Excel can work for simple holiday tracking.

It is not a good place to manage complex protected leave.

Here is why.

The goal is not to remove human judgement.

The goal is to give HR, owners and managers a better place to make the right decision.

What small businesses should check before approval

Before approving FMLA, Paid Medical Leave or Paid Family Leave, check:

• What leave type is being requested?
• Is the employee eligible?
• Is the leave paid, unpaid or job-protected?
• Does it overlap with another leave type?
• Is there a combined cap?
• Has related leave already been used?
• Is the limit correct for this employee?
• Is the leave being tracked in the right unit?
• Are sensitive details hidden?
• Who needs to approve it?
• Is there a return-to-work plan?
• Are notes and records clear enough for future review?

This is what managed leave tracking is for.

It gives small businesses control without making the process too heavy.

FAQ

Is FMLA the same as Paid Family Leave?

No.

FMLA usually gives eligible employees unpaid, job-protected leave.

Paid Family Leave gives wage replacement for family reasons.

Paid Family Leave may not always provide job protection by itself.

Can FMLA and Paid Family Leave run at the same time?

Yes, they can in many cases.

For example, an employee may use FMLA for job protection while receiving Paid Family Leave payments for bonding with a new child or caring for a family member.

Always check the rules that apply to the employee.

Can FMLA and Paid Medical Leave run at the same time?

Yes, they can.

For example, an employee may use FMLA for job protection while receiving Paid Medical Leave for their own serious health condition.

This is why the absence may need more than one leave record.

Can Paid Medical Leave and Paid Family Leave share one limit?

Yes, some policies and state programmes use a combined limit.

In that case, it is usually safer to create one combined leave type in TimeOff.Management called Paid Family and Medical Leave.

If you keep PML and PFL as separate leave types, HR or the business owner should review the combined usage before approving more time.

Does TimeOff.Management automatically combine PML and PFL limits?

No.

TimeOff.Management can track limits for individual leave types.

It does not automatically link two different leave types under one shared combined cap.

For combined limits, use one combined leave type or manage the combined review through reports and approval checks.

Does TimeOff.Management automatically prorate FMLA, PML or PFL limits from the employee schedule?

No.

Admins can set different limits for different users.

The correct legal or policy limit should be calculated by HR, the owner or another authorised person, then entered for the employee.

Does the employee schedule still matter?

Yes.

The employee schedule helps TimeOff.Management work out which days count as working days and how much leave is used when someone books time off.

But it does not automatically set complex legal leave caps.

Should FMLA-style leave be tracked in days or hours?

It often works better in hours, especially for intermittent leave and part-time employees.

A 40-hour employee and a 30-hour employee may have different hourly equivalents.

How can TimeOff.Management help?

TimeOff.Management helps you set up separate or combined leave types, set user-specific limits, track leave in hours or days, add approval control, keep sensitive leave private and report on absence history.

That gives small businesses a cleaner way to manage complex leave than a shared spreadsheet.

Final thoughts

FMLA, Paid Medical Leave and Paid Family Leave are some of the hardest leave types for small businesses to manage.

They can involve rolling windows, partial days, state rules, federal rules, job protection, paid benefits, medical information, user-specific limits and linked real-life cases.

Excel can work for simple holiday tracking.

It is not a good place to supervise complex protected leave.

TimeOff.Management helps small businesses move this process into one clear system. Employees can request leave. Managers can plan cover. HR or owners can review sensitive cases. Reports give the business a cleaner record of what happened.

TimeOff.Management does not replace HR review.

It gives HR, owners and managers a better way to manage the process.

The result is simple:

• less guesswork
• fewer spreadsheet errors
• better records
• better privacy
• more confidence when complex leave requests arrive

Need a simpler way to track FMLA, Paid Medical Leave and Paid Family Leave? TimeOff.Management helps small businesses manage complex leave without spreadsheet chaos.

Start your free trial or learn more about TimeOff.Management features.

Official sources and further reading

• US Department of Labor: Family and Medical Leave Act
• US Department of Labor: FMLA 12-month period fact sheet
• US Department of Labor: FMLA leave calculation fact sheet
• California EDD: Paid Family Leave
• Washington Paid Family and Medical Leave
• Paid Leave Oregon
• TimeOff.Management leave types guide
• TimeOff.Management individual limits for leave types
• TimeOff.Management employee schedule guide
• TimeOff.Management approvers guide
• TimeOff.Management reports guide