Attendance Tracker Google Sheets & Excel, Employee Absence Calendar, Yearly Tardy Log, Sick Day Record, Small Business HR

Seller's description

This attendance tracker keeps a clear record of absences and late arrivals for your team. Log each absence, tardy or day off in one line. It builds a yearly calendar for each employee. It totals days by person and by month. A REVIEW flag shows when someone reaches the limit you set. It works in Google Sheets and Excel. It is made for employers tracking staff, not for classrooms.

WHAT IT DOES
- Attendance Log: one row per event (date, employee and code from dropdowns, optional note), up to 2,000 entries. A Check column flags missing fields, unknown codes or names, and duplicate entries for the same person on the same day.
- Your own codes: up to 12 attendance codes (comes with Absent, Sick, Half-day, No call/no show, Tardy, Left early, Vacation, Personal, Bereavement, Jury duty). Each code has a type (Unplanned, Planned or Tardy) and how many days it counts as, so a half day counts as 0.5.
- Year Calendar: pick an employee to see all 12 months at a glance, colour coded by type with weekends shaded, plus unplanned days, tardies and planned days per month.
- Summary: entries per code for every employee, unplanned days, planned days, tardies and a REVIEW flag when someone reaches your alert limits (e.g. 3 unplanned days or 3 tardies). Use the whole year or type your own date range.
- Monthly: team entries per code per month, plus unplanned days and tardies per employee per month.
- Up to 50 employees. Change the year on the Settings tab to start a new year (leap years included).

WHAT YOU GET
- 1 Excel file (.xlsx): Employee-Attendance-Tracker.xlsx
- 1 PDF with your link to make your own copy in Google Sheets, plus quick-start steps
- A built-in "Start Here" tab with instructions, and sample data you can clear in a minute

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download your file. Etsy also emails you a download link.
2. Unzip it. Google Sheets: open the PDF, click the copy link and choose "Make a copy". The copy is saved to your own Google Drive.
3. Excel: open the .xlsx file in Excel 2010 or newer.
4. Follow the Start Here tab: set the year and your codes, add your employees, clear the sample entries and start logging.

GOOD TO KNOW
- This is a digital download. Nothing physical will be shipped.
- Compatible with Google Sheets (needs a free Google account) and Microsoft Excel 2010 or newer, on Windows or Mac. Not designed for Apple Numbers.
- You log exceptions only; a day with no entry counts as present. It doesn't record clock-in times.
- One entry per person per day. Duplicates are flagged, and the calendar shows the first one.
- One year per file (make a fresh copy each year).
- It doesn't calculate rolling 12-month periods, Bradford Factor scores or leave balances.
- It's a record-keeping tool, not legal or HR advice. Follow your own policy and local law (for example on protected leave) before acting on a REVIEW flag.
- Because this is a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.

HOW THIS WAS MADE
I designed this tracker with help from AI tools, which assisted with building the formulas and layout. I chose the features, and before listing it I tested every calculation against an independent check (a 30-point test plan covering half days, custom codes, date ranges, alert limits, duplicates, leap years and 50-employee / 2,000-entry capacity).