Records employee vacation, sick leave, and other time off requests and balances.
Leave Tracker | ||||
This document tracks employee vacation, sick leave, and other time off balances. | ||||
Employee Information | ||||
Name: | {employeeName} | |||
Department: | {department} | |||
Position: | {position} | |||
Start Date: | {startDate} | |||
Leave Summary | ||||
Leave Type | Total Allocated | Used | Remaining | |
{#leaveSummary.leaveType} | {#leaveSummary.totalAllocated} | {#leaveSummary.used} | {#leaveSummary.remaining} | |
Detailed Leave Records | ||||
Date | Leave Type | Reason | Duration | Approved By |
{#leaveDetails.date} | {#leaveDetails.leaveType} | {#leaveDetails.reason} | {#leaveDetails.duration} | {#leaveDetails.approvedBy} |
Total Vacation Used | =SUMIFS(leaveDetails[Duration], leaveDetails[Leave Type], "Vacation") | |||
Total Sick Leave Used | =SUMIFS(leaveDetails[Duration], leaveDetails[Leave Type], "Sick") | |||
Total Time Off Used | =SUM(leaveDetails[Duration]) |
This document template includes dynamic placeholders for automated document generation with Documentero.com. Excel Template - Free download
Download Excel Template (.XLSX)Download the Leave Tracker template in .XLSX format. Customize it to suit your needs using your preferred editor (Excel, Google Sheets...).
Upload the template to Documentero - Document Generation Service, then map and configure template fields for your automated workflow.
Populate templates with your data and generate Excel (XLSX) documents using data collected from shareable web Forms, APIs, or Integrations.
DocumentDOCX
DocumentDOCX
SpreadsheetXLSX
DocumentDOCX