Attendance Point System Tracker

Manage attendance points for your entire team in one Excel workbook. Set your no-fault policy, record each occurrence, and see each employee's active points, current stage, and whether they have reached a discipline step. Points expire automatically after your rolling window, and protected absences count as zero.

Your attendance records in one workbook

Start on the Point Policy tab. Enter your point values, As of date, rolling window, and thresholds for verbal, written, final, and termination review. Record each occurrence on a separate row with its date, a type selected from the dropdown, and a protected flag. The workbook automatically calculates the points, checks whether the occurrence falls within your window, and determines the points counted. Employee Summary shows each person's active points, current stage, points until the next step, and On track or Action needed status. It also counts how many employees have reached a step. The Benchmark tab includes BLS absence rates, common point values, and protected-leave types you must never count. It opens with a worked example so you can see the calculations before entering your own information.

Keep protected absences out of the point total

A no-fault policy gives you a consistent way to manage attendance. The same unprotected occurrence receives the same points, employees do not have to justify every absence, and discipline rests on a documented record applied consistently across the team. Points expire after your rolling window, giving employees a chance to improve their attendance record. The workbook uses a protected flag to exclude legally protected absences. The FAQ below explains which absences require special attention.

Built for

• Owners and operations managers overseeing attendance for hourly teams who want one consistent, documented system.
• HR generalists responsible for applying point policies consistently and maintaining the records behind warnings and termination decisions.
• Managers who want to see which employees have reached a discipline step, who is approaching one, and the points behind each result.

To calculate the dollar cost of absences by department against a national benchmark, see the Absenteeism Cost Calculator. For disciplinary write-ups, conversation scripts, and final-pay steps related to a high-point record, see the Discipline and Termination Decision Kit.

Before you buy

What format is it, and can I edit it?

You receive one Excel workbook that also works in Google Sheets. The download is five files: the workbook, a Start Here, the two-page Attendance Point System Quick Reference, the product license, and a short guide to using it in Google Sheets. Every point value, threshold, and formula is editable. Insert rows to add occurrences or employees, and duplicate the file for a second location. Your download link appears immediately after checkout, and the same link is emailed on your receipt.

What does the paid workbook do that a free calculator does not?

The workbook keeps your team's attendance history in one place. Each occurrence has a date, points expire automatically after your rolling window, and protected leave counts as zero. Every employee's active points, current stage, and On track or Action needed status appear in the team summary. Open formulas and a sourced benchmark tab let you adapt the policy to your operation and maintain the records supporting warnings. The browser calculator scores one employee. This workbook tracks the entire roster and preserves the attendance record.

Which absences must receive zero points?

Time off protected by law cannot add points, even under a no-fault policy. This includes qualifying leave under the FMLA, an ADA accommodation, the Pregnant Workers Fairness Act, workers’ compensation, military duty under USERRA, jury duty, and state or local protected-leave or paid-sick-leave laws. Mark those occurrences as protected so they count zero. Confirm which protections apply under federal, state, and local law before assigning points or taking disciplinary action.

What is the refund policy?

Digital products are covered by a 30-day money-back guarantee. To request a refund, email support@truestephr.com or reply to your receipt within 30 days of purchase. Questions? Email support@truestephr.com.

The workbook calculates attendance points based on the information you enter. You determine whether an occurrence is protected and whether discipline is appropriate, applying your policy consistently and considering applicable federal, state, and local law.

How the download works

Your files arrive as a single ZIP download, best opened on a computer. Save it, extract it (right-click and select Extract All on Windows, or double-click on a Mac), then open the Start Here file first. PDFs open in any reader, and editable files work in Microsoft Excel or free equivalents, including LibreOffice and Google Sheets. No other software is needed. Step-by-step help for every device is at truestephr.com/pages/download-help.

Scope

This tracker provides general HR information, not legal advice. Have qualified counsel review the facts and next steps when discipline, separation, or complaints involving harassment, discrimination, retaliation, or safety require legal review.