You want to know at month-end how many days each employee was absent, took sick leave or arrived late, and what percentage of days that is, without counting boxes by hand. The free employee attendance sheet does that: you mark one code per day and the counts and percentages appear beside each name. The template and its page are in Arabic.
The problem it solves
An attendance book gives you scattered marks, and counting them per employee at month-end takes time and invites mistakes. It is harder still to tell absence, sick leave and lateness apart.
How the sheet works
- In Employees write each person's number, name and job.
- In Attendance pick a code for each employee each day: P present, A absent, S sick leave, L late. Leave the cell empty on weekends and holidays so it is not counted.
- Beside each name you get attendance, absence, sick leave and lateness, then the absence % and the sick-leave %.
- The monthly summary shows totals, overall percentages and the five employees with most absences.
How the numbers are worked out
- Attendance = present + late, because a late employee did attend.
- Lateness is the number of days marked late, with no percentage.
- Absence % = absent days / days recorded for the employee; sick-leave % = sick days / days recorded. An empty cell is not counted.
Quick example from the sample data
Names are sample data, not real people; October 2026 has 20 working days:
- Karim Adel: absent 3 of 20 days, so his absence rate is 15%, the highest in the sample.
- Heba Samir: 3 sick-leave days, so 15% sick leave and no absences.
- Nadia Fathy: late 4 times, shown as 4 with no percentage, and she attended all 20 days.
- Mohamed Ali: 2 days absent (10%), 1 sick day (5%), late once, attended 17 days.
In total: 8 absent days, 6 sick-leave days and 7 late arrivals over 160 recorded days.
Using the online version
The sheet page opens on this example. Type in the white cells and the counts and percentages update instantly; import your own xlsx, export your work, or download the original Excel file. Your data stays in your browser and is not sent to the server. More templates are in the templates list.
When it is not enough
It holds 60 employees, one person edits at a time, and it does not import fingerprint-clock data. To turn absences and overtime into pay, use the payroll and attendance sheet. If you need an attendance app with per-manager logins and a fingerprint link, Softwiro can build one your way.
FAQ
Is lateness counted as absence? No. A late employee is present and is counted in the lateness column only.
How is the percentage worked out? Absent (or sick) days divided by the days recorded for the employee.
How do I start a new month? Save a copy of the file, change the month date and clear the codes.