Record who was present, late, absent or on approved leave for each day of the month, then see each person's attendance rate and late share. Print a landscape month grid or download a CSV, without signing up.
ONE MONTH, ONE SHEETNo account needed
Edit the fictional team. Your sheet stays in this tab if you refresh; download or print what you want to keep. Nothing is uploaded. This is an attendance summary, not a timekeeping or payroll record.
Step 1 of 3Month and team
Changing the month fits every row to its number of days. A shorter month drops the extra days at the end, and new days start as not recorded.
Step 2 of 3Employees
Add everyone whose attendance you track this month. Keep notes to facts such as approved leave dates; leave out reasons for absence and health details.
Employee 1
This employee is already first.
Employee 2
Employee 3
Employee 4
Employee 5
This employee is already last.
Step 3 of 3Record days
Choose a day, then a status for each person. Late means arriving after the agreed start time. Use approved leave for time off agreed in advance, and not scheduled for days the person was not due to work.
This is the first day of the month.
Everyone already has a status for this day.
Attendance preview
Employee attendance · Meadow Corner
October 2026
PPresent
LLate
AAbsent
VApproved leave
ONot scheduled
–Not recorded
Weekend
Daily status for each employee. Codes: P present, L late, A absent, V approved leave, O not scheduled, – not recorded.
Employee
1Th
2Fr
3Sa
4Su
5Mo
6Tu
7We
8Th
9Fr
10Sa
11Su
12Mo
13Tu
14We
15Th
16Fr
17Sa
18Su
19Mo
20Tu
21We
22Th
23Fr
24Sa
25Su
26Mo
27Tu
28We
29Th
30Fr
31Sa
Sam Taylor
P
P
O
O
P
P
P
P
P
O
O
P
P
L
P
P
O
O
P
P
P
V
V
O
O
P
P
P
P
P
O
Jordan Lee
P
P
P
P
O
O
P
P
L
P
P
O
O
P
P
A
P
P
O
O
P
P
P
L
P
O
O
P
P
P
–
Priya Shah
O
P
O
O
P
O
P
O
P
O
O
P
O
P
O
P
O
O
A
O
P
O
P
O
O
P
O
P
O
P
O
Alex Morgan
P
P
P
P
O
O
O
P
P
P
P
O
O
O
V
V
V
V
O
O
O
P
P
P
P
O
O
O
L
P
P
Casey Brooks
O
O
P
P
O
O
O
O
O
A
P
O
O
O
O
O
P
P
O
O
O
O
O
P
L
O
O
O
O
O
P
Monthly summary
Employee
Present
Late
Absent
Approved leave
Not scheduled
Not recorded
Attendance rate
Late share
Sam TaylorShift lead
19
1
0
2
9
0
100.0%
5.0%
Jordan LeeSales assistant
19
2
1
0
8
1
95.5%
9.5%
Priya ShahStock assistant
12
0
1
0
18
0
92.3%
0.0%
Alex MorganSales assistant
14
1
0
4
12
0
100.0%
6.7%
Casey BrooksWeekend cover
7
1
1
0
22
0
88.9%
12.5%
All employees
71
5
3
6
69
1
96.2%
6.6%
Notes
Sam Taylor: Approved leave on 22 and 23 October.
Jordan Lee: 31 October still to be recorded.
Alex Morgan: Approved leave from 15 to 18 October.
Attendance rate = (present + late) ÷ (present + late + absent). Late share = late ÷ (present + late). Approved leave and days not scheduled are not absences. A dash in the rates means there is nothing to divide by yet.
An attendance summary, not a timekeeping or payroll record. Rules on attendance and records vary by place; this is not legal advice. For US employers, see the federal recordkeeping rules under the FLSA (29 CFR part 516).
Print tip: the printout uses a landscape page so a full month of columns fits.
Keep a month of employee attendance tracking on one sheet. This free attendance tracker records each person as present, late, absent, on approved leave or not scheduled for every day of the month. It then totals each status and works out an attendance rate and a late share for each employee and the whole team. Print the month grid with its summary, or download a CSV or text copy.
Name the sheet, add the business if you like, and choose the month and year. The grid gets one column for each day of that month, so February has 28 or 29 days.
Add each employee with an optional role and notes. You can track up to 30 people on one sheet and move rows up or down to match your team list.
Open the Record days step and choose a day with the Previous and Next buttons or the day list.
For each person, choose Present, Late, Absent, Approved leave, Not scheduled or Not recorded. Every status can be set from the keyboard.
Use Mark everyone not yet recorded today as present to fill a normal day quickly, then change the exceptions. Mark weekends as not scheduled fills Saturdays and Sundays that have no status yet.
Check the month grid and the summary table in the preview, then print or download the sheet.
Changing the month fits every row to the new number of days. A shorter month drops the extra days at the end, and added days start as not recorded.
How the summary is worked out
Each employee's row counts the days in each status. Two rates follow from those counts:
Attendance rate = (present + late) ÷ (present + late + absent). A late arrival counts as attended.
Late share = late ÷ (present + late), the part of attended days that started late.
Approved leave and days not scheduled are not absences, so they do not lower the attendance rate. When a rate has nothing to divide by, such as a month with no scheduled days yet, the summary shows a dash instead of a percentage. The totals row works out its rates from the team's combined counts.
In the fictional sample for October 2026, Jordan was present 19 days, late 2 and absent 1. The attendance rate is 21 ÷ 22 = 95.5%, and the late share is 2 ÷ 21 = 9.5%.
Keep fair, consistent attendance records
An attendance record is only useful if everyone is recorded the same way.
Define late before you start. Agree what counts as late, such as arriving after the scheduled start time, and apply it to everyone.
Record approved leave separately. Time off agreed in advance is not an absence. Mark it as approved leave so the summary does not treat it as a missed shift. The time off request form keeps a record of each request and decision.
Record facts, not reasons. Note that someone was absent, not why. Leave health details and personal circumstances out of the sheet and its notes.
Fill in every day. A day left as not recorded is counted separately, so gaps are easy to spot before you rely on the totals.
Review regularly. Look at the summary each week or month, and talk to the person before drawing conclusions from a pattern.
Keep it private. Share the sheet only with the people who need it, and store printed copies securely. GOV.UK explains the basics of data protection for a business.
This sheet is an attendance summary, not a timekeeping or payroll record, and it does not replace one. Rules on attendance, leave and employee records vary by country and state, and this page is not legal advice. In the United States, the federal recordkeeping rules in 29 CFR part 516 list the records employers must keep under the Fair Labor Standards Act. For help with frequent gaps in cover, read how to avoid being short-staffed.
Print or download the sheet
Print / PDF prints the month grid, the summary table and any notes. The printout uses a landscape page so all 31 day columns fit, with weekends lightly shaded and a code letter in every cell, so it reads in black and white.
Download CSV gives one row per employee with the monthly counts and rates first, then a column for each day of the month, and a totals row at the end. A day not recorded is an empty cell. The file opens in Excel or Google Sheets. If you came looking for an attendance tracker Excel file, save the CSV as a workbook and add a sheet for each month. Download text gives a plain summary and the daily codes to paste into an email or document.
The draft stays in this browser tab if you refresh. Download or print each month before you start the next one.
Frequently asked questions
Can I track attendance without an account?
Yes. The tracker opens with an editable sample and works without a login or email address. Nothing you type is uploaded.
What is the difference between absent and not scheduled?
Absent means the person was due to work and did not come in. Not scheduled means they were not due to work that day, so it does not count against the attendance rate.
Does a late arrival count as attendance?
Yes. Late days count toward the attendance rate, and the late share shows how many of the attended days started late.
Can I convert attendance into hours or pay?
No. The tracker records a status for each day, not times. Use the timesheet calculator for hours, and the hours to decimal converter when payroll needs decimal hours.