OP-009 · Version 1.0.0
Attendance Tracker: employee attendance in Excel
Daily attendance with hours worked, late arrivals, overtime, absences and vacation balance, no macros.

Attendance Tracker is an Excel workbook to track your team's attendance without installing software.
Add one row per person and day: the workbook calculates hours worked net of the break, late arrivals by grace period, overtime by each person's agreed hours and the vacation balance.
The dashboard shows the period's attendance rate and flags people at the late-arrival limit or with negative vacation.
Features
- Hours worked with break deduction and night shifts.
- Late arrivals with configurable grace.
- Overtime based on each person's agreed hours.
- Attendance rate and vacation balance.
- Reports by month, department and type with charts.
- Checks for duplicate days and dates outside employment.
- Includes demo, PDF manual and quick start. No macros.
Who it is for
Small businesses, shops, offices and teams of up to 150 people that track attendance on paper or scattered spreadsheets today.
What it does not include
It does not connect to time clocks, does not calculate payroll and does not replace any legal attendance record required in your country.
Editions
| FREE (demo) | PRO | |
|---|---|---|
| Workbook with sample data | ✓ | ✓ |
| Empty template for your business | — | ✓ |
| Capacity | 20 employees / 900 records | 150 employees / 8,000 records |
| PDF manual and quick start | — | ✓ |
| Minor updates within the same major version | — | ✓ |
What you get
- Attendance_Tracker_Demo_EN.xlsx
- Attendance_Tracker_EN.xlsx
- CHANGELOG.txt
- LICENSE.txt
- Quick_Start_EN.pdf
- README.txt
- User_Manual_EN.pdf
Requirements
Excel 2016 or later, Microsoft 365 or LibreOffice Calc 7.6+. Windows, macOS or Linux.
Questions about this product
Does it replace a legal attendance record?
No. It is an internal control tool; check what your country's law requires.
How many employees does it hold?
The PRO edition holds 150 employees and 8,000 daily records. The demo holds 20 employees.
Does it handle night shifts?
Yes, hours are calculated even when time out is after midnight.
Does it calculate payroll?
No. It provides hours and overtime for you or your accountant to use.
Version history
1.0.0 · 2026-11-16
- First release: employees, daily log, hours with break and night shifts, late arrivals with grace, overtime, attendance rate, vacation balance, dashboard and reports.