Home/Spreadsheets/HR & Employees/Employee Attendance Point Tracker
Employee Attendance Point Tracker
An employee attendance point tracker for hourly teams: log each tardy or absence once and the points, the expiry date and the warning stage fill in by themselves. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Occurrence Log with dropdowns: points, expiry and the stage after each entry calculate themselves
- Points roll off automatically after your rolling window, 12 months by default
- Five warning stages with thresholds and notice wording you set
- A one-page Warning Notice that fills itself in, ready to print and sign
- Employee Card with one person's points, stage, next expiry and full history
- Opens in Excel and in Google Sheets
$14.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription

What it does
- Occurrence Log with dropdowns: points, expiry and the stage after each entry calculate themselves
- Points roll off automatically after your rolling window, 12 months by default
- Five warning stages with thresholds and notice wording you set
- A one-page Warning Notice that fills itself in, ready to print and sign
- Employee Card with one person's points, stage, next expiry and full history
- Dashboard with an at-risk ranking and points expiring in the next 30 days
What it looks like


Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Occurrence Log
- Warning Notice
Works in
- Microsoft Excel 2016 or later and Microsoft 365, Windows and Mac, and Excel for the web
- Google Sheets: the PDF in your download has the link that makes your own Google Sheets copy
- No macros, no add-ins, nothing to install; not built for Excel mobile or Apple Numbers
Honest scope
This is a record-keeping template, not legal or HR advice. Leave, overtime and pay rules vary by state and by employer policy; the file reports what you enter and does not decide what anyone is entitled to.
Others in HR & Employees
- Employee PTO TrackerAn employee PTO tracker for Excel: vacation, sick days and half-days for up to 200…$7.99View →

- Interactive Excel Formulas Cheat SheetAn Excel cheat sheet with 243 formulas and functions: a searchable workbook you can…$4.99View →

- Employee Schedule TemplateAn employee schedule template for small businesses: build the week's staff shifts from…$10.99View →

- Employee Leave TrackerAn employee leave tracker for small teams: set your PTO policy once, log each request…$17.99View →
