Home/Free tools/Attendance Points Calculator
Attendance Points Calculator
Active attendance points are the sum of every occurrence still inside your rolling window. Each one counts from its date until the same date 12 months later (or whatever window you set) and stops counting on that date. Compare the total with your warning steps to see where an employee stands and the date they drop back below it.
Free, no account, no email required · runs in your browser · nothing you type leaves the page.
Count one employee's active points
Pre-filled with the workbook's default policy and four sample occurrences. Change any date, type or point value.
| Value | |
|---|---|
| Current step | Final written warning (from 8 points) |
| Points to the next step | 1.5 more reaches Termination review |
| Next points to expire | 2 on Jan 10, 2027 |
| Points expiring in the next 30 days | 0 |
| Drops below this step on | Jan 10, 2027 (down to 6.5) |
| Every active point gone by | Aug 1, 2027 |
| Date | Type | Points | Expires on | Status |
|---|---|---|---|---|
| Jan 10, 2026 | Absence — called in | 2 | Jan 10, 2027 | Active |
| Mar 3, 2026 | Absence — called in | 2 | Mar 3, 2027 | Active |
| May 5, 2026 | Tardy (<15 min) | 0.5 | May 5, 2027 | Active |
| Aug 1, 2026 | Absence — no call no show | 4 | Aug 1, 2027 | Active |
How it's calculated
The calculator uses the same rules as the Employee Attendance Point Tracker workbook, one employee at a time:
- Points per entry: each occurrence takes the value set for its type. The defaults are a tardy under 15 minutes 0.5, a tardy of 15 minutes or more 1, an early out 1, an absence called in 2, a no call no show 4, leaving without notice 3, a missed punch 0.25 and late from break 0.5.
- Expiry date:
expires on = the occurrence date + the rolling window in months, the same day of the month. A 31 January entry with a one-month window expires on 28 February (29 in a leap year), because there is no 31 February. - Active: an entry counts when
date ≤ as-of dateandexpires on > as-of date. On the expiry date itself the point no longer counts. An entry dated after the as-of date is not counted yet. - Active points =
max(0, sum of active points − credit), where the credit is 1 point if it is switched on, the person has at least one active entry and their last occurrence was at least the set number of days before the as-of date. - Step: the highest step whose starting points the total has reached
(
active points ≥ threshold). Defaults: verbal warning at 4, written at 6, final written at 8, termination review at 10.
The date the total drops below the current step is found by walking forward through the upcoming expiry dates (and the credit date, if it applies) and taking the first one where the total falls under the step's starting points. It assumes nothing new is logged.
Worked example
The calculator opens on one employee with four entries, counted as of 7 October 2026 with a 12-month window:
- 10 January 2026, absence called in: 2 points, expires 10 January 2027
- 3 March 2026, absence called in: 2 points, expires 3 March 2027
- 5 May 2026, tardy under 15 minutes: 0.5 points, expires 5 May 2027
- 1 August 2026, no call no show: 4 points, expires 1 August 2027
All four are still inside the window, so the total is 2 + 2 + 0.5 + 4 = 8.5 points. That has passed the final written warning step at 8 but not the termination review step at 10, so the employee is 1.5 points from the last step.
Nothing expires in the next 30 days. The first 2 points drop off on 10 January 2027, taking the total to 6.5: below the final written step, back to written warning. On 3 March 2027 it falls to 4.5 (verbal warning). On 5 May 2027 the half-point tardy goes, leaving exactly 4, which is still verbal warning, because a step applies from its starting points upward. Only on 1 August 2027 does the total return to zero.
That last detail is where hand counting usually goes wrong. A supervisor who sees "a point came off" can easily assume the warning came off with it. Whether it did depends on the exact total against the exact threshold, and on the exact expiry date.
Common questions
How does a rolling 12-month attendance point system work?
Each occurrence counts for 12 months from its own date and then drops off by itself. There is no single reset day: every entry has its own expiry date, so an employee's total can go down on any date of the year. Here a point dated 10 January 2026 stops counting on 10 January 2027.
Does a point expire on the anniversary date or the day after?
In this calculator and the workbook behind it, a point counts up to the day before its expiry date and no longer counts on the expiry date itself. Some policies count the anniversary day as well. If yours does, the totals here will change one day earlier than your policy says.
What about a calendar-year reset instead of a rolling window?
This calculator follows the workbook, which uses a rolling window you set in months. A calendar-year policy wipes everyone back to zero on 1 January, which is simpler but means a December no call no show can disappear a few weeks later. To estimate a calendar-year total, add up the entries dated this year by hand.
Can good attendance take points off?
If your policy allows it, switch on the good-attendance credit. After the set number of days with no new occurrence (90 by default) it takes 1 point off the total. It is a single point, not a point for every clean stretch, and it goes away again as soon as a new occurrence is logged.
Why does someone stay at the same step after a point expires?
Steps start at a set number of points and apply from that number upward. If an employee is at 4.5 points and the verbal step starts at 4, losing half a point leaves them at exactly 4, still on verbal warning.
How many points should each type of occurrence be worth?
There is no standard. The defaults here (absence 2, no call no show 4, short tardy 0.5) are a common pattern, not a rule. Whatever values you choose, write them into the policy and apply them to everyone the same way.
Is anything I type saved or sent anywhere?
No. The calculation runs in your browser. Nothing is stored or transmitted, so there is no need to type a real name.
Honest scope
This is a counting tool, not legal or HR advice. It tells you what your own point rules produce for one person on one date. It does not tell you whether those rules are lawful where you operate, or whether a warning is the right response.
Attendance policies vary a great deal. Many absences should never be pointed at all: protected medical or family leave, disability-related absences, jury duty, military leave and anything covered by a local sick-leave law, for example. Check your local rules and take those out before you count. Apply your written policy the same way to every employee, and keep the record of how each total was reached.
The calculator handles one employee and up to eight occurrences. It does not track a team, keep a history, or produce warning notices; the workbook below does those things.
Related free calculators
- PTO Accrual Calculator (Per Hour Worked)PTO accrual per hour worked is annual PTO hours ÷ (weekly hours × 52): 80 hours a year on a 40-hour week is 0.0385 per hour worked, or 3.08 hours per 80-hour biweekly paycheck, paused at the cap.
- Overtime CalculatorOvertime under the federal FLSA rule is every hour over 40 in a work week at 1.5 times the hourly rate. Enter a rate and daily hours to get regular, overtime and double-time hours and gross pay, with an optional California-style daily rule.
- SLP Progress Statement BuilderTurns a baseline, current score, target and condition into a written IEP or therapy progress statement that reports both raw score and progress toward criterion.