Free tool · leave and payroll · runs on your device
Leave tracker and payroll handoff
Add leave cases and weekly leave hours. The tracker totals hours by pay code for each pay period and flags what needs action. It builds the payroll handoff, with a deductions note on each line.
Many employees, one pay period at a time
Leave tracker
Payroll data only. Do not enter diagnoses, medical details or Social Security numbers. Store only what payroll needs: dates, hours, leave type, status and pay source.
The tracker runs in this page, and reloading clears it. Nothing is stored or sent unless you press Save to my account, which keeps a copy in your free P.A.Y. account. Download the Excel file to keep your own copy.
Paste cases from a spreadsheet
Copy rows from Excel or Google Sheets, one case per row, tab separated. Use these columns, in this order or as headers:
- Employee
- Leave type
- Start
- Expected end
- Status
- Schedule
- Pay source
- Top-up %
- Hourly rate
- Weekly hours
- Request date
- Counts as FMLA
Fix the settings marked above to see flags, balances and the handoff.
Cases
| Case | Employee | Leave type | Dates | Status | Schedule | Pay source | Actions |
|---|
Weekly leave hours
| Week start or date | Case | Hours | Pay source | Pay code | Actions |
|---|
Flags
FMLA balances (rolling 12 months)
| Employee | Cases | Entitlement | Used in the last 12 months | Available | Status |
|---|
Leave hours by pay period and pay code
Payroll handoff
Pick the pay period to hand to payroll.
| Employee | Case | Pay code | Hours | Rate | Wages | Top-up | Deductions note |
|---|
Download or print
How the tracker works
Pay codes
Each leave hour gets a pay code from its pay source. Distinct codes keep taxes and W-2 boxes right. Rename the codes in the settings.
| Code | Pay source | What payroll does |
|---|---|---|
| LVPD | Employer paid | Hours times the rate, as wages. The employee may choose, or the employer may require, accrued paid leave in place of unpaid FMLA leave (DOL Employer's Guide). |
| LVST | State benefit | Memo hours, no wages. An employer cannot force PTO while a state benefit is paid during FMLA. A top-up needs state law to permit it and the employee to agree (DOL opinion letter). |
| TPSP | Insurer or TPA | Memo hours, no wages. STD and LTD benefits are sick pay for federal payroll tax, whoever pays them (IRS Pub 15-A). |
| LVUN | Unpaid | Memo hours. Collect the employee's share of premiums. During FMLA leave, a share more than 30 days late can end coverage, with written notice at least 15 days ahead (29 CFR 825.212). |
| TOPUP | Top-up | Hours times the rate times the top-up percent, paid by the employer on top of a state or insurer benefit. |
Flags
| Flag | Rule |
|---|---|
| FMLA balance low or used up | 12 workweeks times normal weekly hours, minus FMLA-tagged hours in the 12 months before the as-of date (29 CFR 825.200). Used up: check ADA accommodation needs before any job action (EEOC). |
| Designation notice due | Within five business days of having enough information, absent extenuating circumstances (DOL Fact Sheet 28D). Blank information date: counted from the request date. |
| Certification due | The employee must provide it within 15 calendar days after the employer asks (DOL Employer's Guide). |
| Return-to-work date passed | The expected end date passed and the status is not returned, closed or denied. After FMLA leave, the employee gets the same or an equivalent job (29 CFR 825.214). |
| Denied case with hours | A denied case still has leave hours. Fix the pay codes before payroll closes. |
Tracker conventions: business days are Monday to Friday minus the holidays you enter. A request on a weekend or holiday starts counting from the next business day. The regulation does not say which days are business days, so set your own calendar. Each time entry counts on its date.
The handoff
For the pay period you pick, the handoff has one line per case and pay source. Each line shows the employee, case, leave type, FMLA, pay code, hours and rate. It also shows the wages, the top-up code, percent and amount, and a deductions note. Wages and top-up need an hourly rate on the case.
Worked example (fictional)
The example loads 5 cases for 4 employees, paid every two weeks, as of November 9, 2026. For the Oct 25 to Nov 7, 2026 pay period the handoff shows:
- LVUN: 80 hours
- TPSP: 80 hours
- LVST: 80 hours, plus $752.40 top-up
- LVPD: 5.5 hours, $132.00 in wages
The bonding case's top-up is 80 hours times $28.50 times 33%, or $752.40. The tracker also flags a low FMLA balance of 54 hours, an overdue designation notice and a return date that passed.
Payroll practices the tracker follows
- Tag every program. One absence often counts under several at once, such as FMLA plus state PFL plus STD. Use the FMLA box on each case.
- Job protection and pay are separate questions. FMLA gives unpaid, job-protected leave (DOL). PFL, DBL and STD pay but may not protect the job on their own.
- Health coverage. Group health coverage continues during FMLA leave on the same terms, and the employee keeps paying their share (DOL Fact Sheet 28A).
- Third-party sick pay. A carrier that is not your agent is liable for the employee's Social Security and Medicare tax. Income tax withholding there is voluntary, through Form W-4S (IRS Pub 15-A). Log each carrier notice and reconcile it to Form 941 and the W-2.
- Military leave. The employee may keep health coverage for up to 24 months, at no more than 102% of the full premium (DOL VETS). The employee may ask to use accrued vacation, but the employer may not require it (20 CFR 1002.153).
- Privacy. Medical certifications and histories stay in separate confidential files (29 CFR 825.500). A pay code can say FMLA or STD without a diagnosis.
- On return. Restore the same or equivalent pay rate, and restart deductions and benefits the same day.
Frequently asked questions
What should a leave tracker hold?
Only what payroll needs: dates, hours, leave type, status and pay source. Medical certifications and histories belong in separate confidential files (29 CFR 825.500). Never enter a diagnosis or a Social Security number.
When is the FMLA designation notice due?
Within five business days of having enough information, absent extenuating circumstances (DOL Fact Sheet 28D). The tracker counts five business days from the date you enter. Missing notices may count as interference (29 CFR 825.300).
How long does an employee have to return a medical certification?
The employee must provide it within 15 calendar days after the employer asks (DOL Employer's Guide). The tracker flags certifications still missing after that.
Can payroll top up a state benefit with PTO?
Only where state law permits and the employee agrees. An employer cannot force PTO while a state benefit is paid during FMLA (DOL opinion letter). Check that the top-up does not reduce the state benefit.
How does payroll handle STD paid by an insurer?
The IRS treats short- and long-term disability benefits as sick pay (IRS Pub 15-A). A carrier that is not your agent is liable for the employee's Social Security and Medicare tax. Keep its notices for Form 941 and W-2 reporting.
Is the tracker saved anywhere?
Only if you choose. With a free profile, press Save to my account to keep a copy in your account and load it next week. Otherwise it lives only in this browser tab, and reloading clears it. You can delete a saved copy at any time. Back to the tracker.
More leave guides and tools
- Leave of absence hubEvery P.A.Y. leave guide and tool in one place.
- FMLA guideCoverage, eligibility, notices and the four 12-month methods.
- State paid leave programsContribution rates, wage caps and benefits by state.
- Leave and payrollTaxes on disability and leave benefits, third-party sick pay and W-2 reporting.
- FMLA balance calculatorDay-level FMLA balances under each 12-month method.
- New York PFL and DBL calculatorThe eight-week average and the 2026 weekly benefit.
- Employee change impact checkerWhat HR, payroll and benefits each need to do for a change.
- PTO payout calculatorUnused vacation times the rate, with state payout rules.
- State payroll lawsFinal pay deadlines and official agencies for all 50 states and DC.
- HRIS and payroll integration guideData flows, testing and who owns what between HR and payroll.
Official sources
Each rule and figure on this page was checked on these official pages on November 9, 2026.
- Family and Medical Leave Act (DOL Wage and Hour Division)
- 29 CFR 825.200, Amount of leave (eCFR)
- 29 CFR 825.300, Employer notice requirements (eCFR)
- 29 CFR 825.500, Recordkeeping requirements (eCFR)
- 29 CFR 825.212, Failure to pay premiums (eCFR)
- 29 CFR 825.214, Employee right to reinstatement (eCFR)
- DOL Fact Sheet #28D: Employer Notification Requirements (March 2025)
- DOL Fact Sheet #28A: Employee Protections under the FMLA (March 2025)
- The Employer's Guide to the Family and Medical Leave Act (DOL WHD)
- DOL Opinion Letter FMLA2025-01-A (January 14, 2025)
- IRS Publication 15-A (2026), Employer's Supplemental Tax Guide, section 6 Sick Pay Reporting
- A Guide to USERRA (DOL VETS Pocket Guide)
- 20 CFR 1002.153, use of paid leave during service (eCFR)
- EEOC: Employer-Provided Leave and the Americans with Disabilities Act (May 9, 2016)
Free Excel template
The same rules in a spreadsheet with working formulas, ready to fill in and keep. Free with your P.A.Y. profile.