Leave Exhaustion Analysis Worksheet

This worksheet is used when an employee’s protected leave is close to running out and HR needs a clear record of the remaining entitlement, the exhaustion date, and the next action. It helps connect leave tracking to ADA review and return-to-work planning in one place. The template is designed to document the calculation and the communication steps, not to replace a leave policy or legal review.

Use it when the employee’s leave balance is approaching zero, when the leave period is being recalculated, or when the leave type changes and the remaining entitlement needs to be confirmed. It is also useful before a return-to-work conversation if the employee may need an accommodation after FMLA ends. If leave is not close to exhaustion, this worksheet is usually unnecessary.

HR leave administrators, employee relations staff, or a benefits specialist typically complete it, with input from the employee’s manager only where appropriate. The reviewer should be someone who can verify the leave calculation and coordinate the next steps without collecting unnecessary PII. If your process includes legal or accommodations review, those roles can be referenced in the notes or routed separately.

No. This worksheet flags whether an ADA review is needed and records the reason, but it does not gather the full accommodation request details. If the employee may need an accommodation, route them to your separate ADA intake or interactive process form. Keeping the two forms separate supports data minimization and avoids collecting more PII than needed.

Document the basis for the calculation, such as the leave type, entitlement period, hours used, and how the remaining timeframe was projected. Include the date you expect entitlement to end and any assumptions that affect the estimate, such as intermittent leave patterns or schedule changes. Clear analysis notes help create an audit trail if the calculation is later reviewed.

The worksheet creates a handoff point for deciding whether the employee can return, needs an extension under another policy, or should be reviewed for accommodation options. It captures the next step action and any accommodation types to consider, which makes the transition from leave administration to return-to-work planning more orderly. That reduces missed follow-up and inconsistent communication.

Yes. You can rename the leave type field options, adjust the entitlement period, and add conditional logic for state leave, company leave, or intermittent schedules. If your organization uses different review paths for medical, parental, or personal leave, customize the next-step action list so the worksheet matches your process.

This worksheet pairs well with HRIS leave records, case management tools, and task routing for ADA or return-to-work follow-up. You can also connect it to notifications so the reviewer, employee, or accommodations team receives the right handoff at the right time. The key is to keep the calculation source and the communication record aligned.

Common mistakes include marking every field required, using free-text where a date picker or numeric input is more accurate, and failing to document the calculation basis. Another pitfall is skipping the employee notification step or collecting provider consent without explaining why it is needed. The worksheet works best when it is specific, minimal, and tied to a clear follow-up action.