Employee Attendance Tracker — Excel & Google Sheets Dashboard

About this product

Track daily team attendance in a clean 31-day monthly register and let the Dashboard calculate presence rates, absence totals, PTO and sick days automatically. Works in both Microsoft Excel and Google Sheets.

What's included

• Employees tab — set up names and departments once for up to 12 employees
• Monthly Register — 31-day grid color-coded by status (Present, Absent, PTO, Sick leave)
• Per-employee automatic totals — Present, Absent, PTO and Sick days plus % presence
• Automatic Dashboard — team average presence, total absence days, best & most-missed attendance
• Visual status distribution bar chart of % presence by employee
• Works in Microsoft Excel and Google Sheets — no macros or add-ons needed

How it works

1. Download the .xlsx spreadsheet immediately after purchase
2. Open it directly in Excel or upload to Google Sheets (File → Import → Upload)
3. Enter your team's names and departments on the Employees tab
4. Mark each day in the Monthly Register — the Dashboard and charts update automatically

Questions