Employee Attendance Tracker, Google Sheets and Excel, Occurrences and Points System (Digital Download)

This employee attendance tracker logs every absence, late arrival, and early departure on your team, and adds up each person's occurrences and points under the policy you set.

An occurrence counts each missed shift as 1 and each late arrival or early departure as 0.5, while vacation, holidays, protected leave, and approved unpaid time count 0, and a step is an action your policy takes when a person's points reach a total you set.

How to use it:
1. Open Employee Attendance Tracker Google Sheets Access.pdf to make your Google Sheets copy, or open Employee Attendance Tracker.xlsx in Excel.
2. Enter the first day of your attendance year and your Months Before a Point Rolls Off on the Start Here tab.
3. Enter the points your policy gives each code and the total at which your policy takes each step, up to four, on the Start Here tab.
4. Type each employee's name and start date on the Employees tab, and pick each name once on the Year Grid tab.
5. Log each absence, late arrival, and early departure on the Attendance Log tab with the date, the employee, the code, and the hours missed.
6. Pick Protected leave for any absence the law protects, so it never counts as an occurrence or a point.
7. Read each person's occurrences, Current Points, and Step Reached on the Employees tab, and their points by month on the Year Grid tab.

What you get: a five tab workbook for Google Sheets and Excel with room for 40 employees and 500 rows, a quick start PDF in US Letter and A4 with a worked example and twelve printable monthly log pages, and a Google Sheets access PDF with the link.

The ten codes: Absent, no notice; Absent, notice given; No call no show; Late in; Early out; Sick; Vacation or PTO; Holiday; Protected leave; Unpaid, approved.

The workbook ships blank, with ten codes and no preset point values or step totals, so those numbers come from your own written policy.

This spreadsheet is general education, not legal or human resources advice, and it does not know your situation, so talk with a licensed professional about decisions on discipline, leave entitlement, or an employee's rights at work.

This is a digital download, and no physical item ships.

All sales are final.