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 dashboard with attendance rate, late arrivals, overtime and charts from the demo data
Real screenshot of the dashboard with the demo data.

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

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—✓
Capacity20 employees / 900 records150 employees / 8,000 records
PDF manual and quick start—✓
Minor updates within the same major version—✓

What you get

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