Template library
19 templates in this category.
Attendance Record Tracker
Track attendance for classes, clubs, organizations, and events with automated date columns and settings management.
- Pre-formatted attendance record with NAME and automatic date columns
- Automated date column generation using formulas (=C5+7 pattern)
- Customizable settings panel with checkbox controls
Class Attendance Yearly
Track student attendance by month with automatic teacher and room assignment across 12 monthly sheets.
- 12 separate monthly sheets for organized tracking
- Automatic teacher and room information pulled from master sheet
- Date-based formulas for accurate period tracking
Employee Attendance Tracker
Track daily employee attendance, leave requests, and company holidays in one integrated system.
- Calendar view for attendance visualization
- Leave tracker with automatic working day calculation
- Employee directory and leave type configuration
Employee Classification & Payroll Grading Template
Automatically classify employees by education level and tenure to determine salary grades and compensation bands.
- Automatic grade assignment by education level
- Tenure-based numeric grading (3-year, 6-year increments)
- Date-driven calculations (hire date to current date)
Employee Evaluation Form Template
Structured performance review system with objectives, success metrics, weights, and discussion documentation.
- Performance objective matrix with success metrics and weights
- Attainment scoring system with details fields
- Discussion log with timestamps and participant tracking
Employee Leave Tracker
Track employee absences and leave days month-by-month with automated day-of-week labeling.
- 12 monthly sheets (Jan–Dec) for year-round tracking
- Automatic day-of-week display (Su/M/Tu/W/T)
- Employee name roster linked across sheets
Employee Leave Tracker
Track employee absences and leave by month with day-of-week visibility and year-to-date totals.
- Month-by-month leave calendar (Jan–Dec)
- Automatic day-of-week calculation
- Year-to-date leave summary
Excel Leave Tracker 2021 For 20 Employees
Track employee leave requests and absences across your team with automated holiday recognition and monthly overviews.
- Automated holiday exclusion from leave calculations
- Monthly leave calendar view with day-of-week reference
- Support for 20+ employees
Payroll Calculator with Federal Tax Tables
Automated payroll processing with YTD tracking, tax calculations, and employee earning statements.
- Federal tax withholding calculations based on W-4 form data
- YTD payroll summary tracking across pay periods
- Individual employee earning statements (paystubs)
Payroll Register & Employee Information Template
Track employee details, daily hours, and generate accurate payroll registers with automated calculations.
- Employee information database with ID and personal details
- Daily hours tracking across pay periods
- Automated payroll calculations using formulas
Payslip Template
Generate professional payslips with year-to-date tracking and automated pay calculations.
- Company branding section
- Employee and pay period details
- Automated gross and net pay calculations
Payslip Template
Generate professional payslips with year-to-date calculations and employee pay details.
- Professional payslip layout with company branding
- Year-to-date calculations by pay period
- Employee name and pay details integration
Rotation Schedule Multiple Employees
Manage employee work rotations with built-in vacation, sick leave, and holiday tracking.
- Monthly/yearly rotation schedule view
- Days off tracking for vacation, sick leave, and personal time
- Holiday calendar integration
Salary Range Template V13
Build compliant salary structures with three flexible models: min/max, midpoint, and midpoint differential-based.
- Three calculation models (Min/Max, Midpoint, Differential)
- Automatic midpoint calculation with IF formulas
- Grade and level organization
Shift Calendar Template
Organize employee shifts across the year with automatic day-of-week and date calculations.
- Automatic date and weekday calculation
- Multiple shift pattern templates (4 shifts)
- Year-based organization for long-term planning
Staff Rotation Schedule
Automate employee shift rotations and scheduling with configurable team assignments and date-based shifts.
- Company name configuration
- Conditional employee enable/disable settings
- Automatic date-based shift assignment
Work Rotation Schedule
Track employee work rotations and shifts across weeks or months with automatic holiday exclusions.
- Multiple rotation pattern sheets for different scheduling methods
- Holiday and non-working days exclusion list
- Date calculation functions for automatic scheduling
Work Rotation Schedule
Plan staff shifts and rotations by month with holiday exclusions and automated day calculations.
- Multiple rotation calculation methods (basic, advanced, string-based)
- Holiday and non-working days database
- Auto-calculated day-of-week display
Work Shift Schedule
Organize employee work shifts by day with automated time tracking and salary budgeting.
- Daily shift assignment grid by employee and day
- Employee time card tracking with hourly data
- Automated salary budget calculations by week