Posted on 8 March 2026
Free Employee Attendance Sheet Template in Excel, Word, PDF
- Marks one status code per employee per day, with weekly offs and holidays filling themselves in.
- Calculates days worked, paid days and attendance % automatically in the Excel version, with half days counted as 0.5.
- Runs on your pay cycle, whether that’s a calendar month or the 16th to the 15th.
- Prints as a monthly register, daily sign-in sheet or signed employee card, with a Hindi PDF included.
An employee attendance sheet records daily attendance and absence reasons, then totals present days, leave and paid days to support accurate payroll.
What it is
One page with every employee down the side and every day across the top. One code goes in each box, and the totals tell you who worked, who was off and how many days to pay.
When you need it
From your first hire. Payroll asks how many days someone gets paid for, and "I think she was off that Tuesday" is not an answer.
What's inside
A monthly register, a time log, a monthly summary, a daily headcount, absence patterns, an employee card and a printable register.
Formats
Excel, Google Sheets, Word, PDF and a Hindi PDF.
Want to see it filled in first?
Make your own copy of the filled sample in Google Sheets.
What Is the Employee Attendance Sheet?
Payday is on Friday. Daniel says he worked the 14th. His manager says he didn't.
Who is right?
Without a record, whoever argues longer. An employee attendance sheet settles it. It holds one status for each person on each date, then turns those marks into worked days, paid days and an attendance percentage.
People call it many things. A staff attendance sheet in an office. A worker attendance sheet or labour attendance sheet on a site. An attendance register in a school or a factory. A manual attendance sheet when it lives on a clipboard. The job never changes.
P, A, SL, WO
per employee
worked vs due
your pay rules
one checked number
That last box is what makes the sheet matter. Nobody opens an attendance record for fun. They open it because money is about to move.
Attendance Sheet vs Register vs Muster Roll vs Timesheet
Four names, and they don't all mean the same thing. Here is how they differ in practice.
| Record | The question it answers | What it usually holds | Where you will hear it |
|---|---|---|---|
| Attendance sheet | Was this person at work, and if not, why? | A status per day, with totals | Offices, shops, HR teams |
| Attendance register | Same question, kept as the formal record | A status per day, often with signatures and a sign-off | Schools, factories, public offices |
| Muster roll | Who was on the roll and present each day? | Employee details, daily attendance, days worked, overtime | India, labour sites, contractors |
| Timesheet | How many hours, and on what? | Clock times, hours, sometimes projects | Hourly staff, billable work |
An attendance sheet tells you who showed up. A timesheet tells you for how long.
Paying by the hour across a two-week cycle? Our bi-weekly timesheet fits better. Need a simple day-by-day log rather than a monthly record? Try the attendance tracker.
Which Attendance Format Fits Your Team?
The right layout depends on who is marking it and what they do with it afterward.
| If your situation is... | Use this | Where to find it |
|---|---|---|
| Salaried staff on fixed days, paid monthly | Monthly attendance sheet for employees | Monthly Register in Excel, or page 1 of the Word file |
| Shift crews or a site where people change daily | Daily attendance sheet with sign-in and sign-out | Page 2 of the Word and PDF files |
| Daily-wage or contract workers | Labour attendance sheet | Monthly Register with Site / Shift filled in, plus the Time Log |
| Anyone who needs a signature against every day | Employee attendance card | Employee Card in Excel, or page 3 of the Word file |
| No computer on site | Manual attendance sheet | Paper Register, or the employee attendance sheet PDF |
| A staff attendance register format in Hindi | कर्मचारी उपस्थिति पत्रक | The Hindi PDF |
| You want the monthly attendance sheet in Word format to edit | Word file | Change the columns, add your logo, print |
What Does The Employee Attendance Sheet Contain?
You can cram attendance into a name column and thirty boxes. It just won't survive its first payroll question. A useful employee attendance sheet needs these fields.
| Field | Why It Matters |
|---|---|
| Employee ID and name | Two Ahmeds, one payroll. The ID tells them apart. |
| Designation and department | Lets you compare teams, and shows who was covering what. |
| Site or shift | Essential when one business runs a warehouse, a night shift and a shop. |
| Cycle start and end | Your pay period may not begin on the 1st. |
| Daily status code | The record itself. One code, one day, one person. |
| Weekly offs and holidays | They keep days off out of your attendance percentage. |
| Time in, time out and break | Needed when pay or overtime depends on hours. |
| Late minutes and overtime | A late arrival and a full day are not the same thing to a manager. |
| Scheduled days and days worked | The two numbers behind your attendance percentage. |
| Paid days | The number payroll actually needs. |
| Reason or notes | A shift swap today is forgotten by next month. Write it down. |
| Signature and sign-off | Turns a list into a record that both sides accepted. |
Watch the paid days field most closely. Someone can work 17 days and still be paid for 31, once weekly offs, holidays and paid leave are counted. Attendance and pay are two different answers, and a sheet that gives you only one leaves you doing the other on a calculator.
What the Enerpize Employee Attendance Sheet Includes
We kept asking one thing while building this: what would payroll ask next? That question gave us every sheet in the workbook. This employee attendance sheet in Excel runs on formulas only, with no macros, so it opens in Excel and Google Sheets without a security warning. It holds up to 50 employees and 600 time log lines per file.
A Register That Knows Your Calendar
Pick a cycle and the dates and weekdays fill in. Tell it which days are off, and those columns mark themselves. Friday and Saturday off? Done. Paying from the 16th to the 15th? Set the start day to 16 and the whole register moves with you. Each monthly attendance sheet for employees starts this way, with no dates to retype.

Codes With Your Pay Rules Behind Them
Every code carries four values: worked, paid, scheduled and absence. Half day counts as 0.5 worked. Weekly off counts as paid but not scheduled. Don't agree with one? Change the value in Settings, and every total follows.
A Summary Built for Payroll
Scheduled days, days worked, leave, absences, paid days, hours, overtime and a check column, all on one row per person. It also warns you about unmarked days before you send anything to payroll.

Night Shifts That Don't Break the Math
In at 22:00, out at 06:00. Plain subtraction gives you minus 16 hours. The Time Log handles midnight, takes off the break, measures lateness against the shift and flags a day that contradicts the register. If someone clocked in on a day marked absent, you find out here.

Patterns You Can't See From One Row
Six absent days can mean one bad flu or five separate Mondays and Fridays. Those are very different conversations. Absence Patterns counts the spells, works out the Bradford Factor and shows how many absences sat right next to a weekly off. We treat it as a prompt to talk to someone, never a verdict.

One Person, One Page, One Signature
Pick a name and the Employee Card lays out that person's month, day by day, with room to sign. Paper Register follows a simple staff attendance register format for the whole team: names, dates, codes and a signature. The Word file and employee attendance sheet PDF cover the sites where nobody opens a laptop.

Attendance Codes for Your Sheet
Is "P" present or personal leave? On some sheets it is one, on others it is the other. Mix them and your totals lie without telling you. These are the 13 codes in our employee attendance register template, and you can rename any of them.
| Code | Meaning | Worked | Paid | Scheduled |
|---|---|---|---|---|
| P | Present | 1 | 1 | Yes |
| LT | Late, but worked the day | 1 | 1 | Yes |
| HD | Half day | 0.5 | 0.5 | Yes |
| WFH | Work from home | 1 | 1 | Yes |
| OD | On duty, tour or site visit | 1 | 1 | Yes |
| A | Absent | 0 | 0 | Yes |
| NS | No call, no show | 0 | 0 | Yes |
| SL | Sick leave | 0 | 1 | Yes |
| CL | Casual leave | 0 | 1 | Yes |
| PL | Paid or earned leave | 0 | 1 | Yes |
| UL | Unpaid leave (loss of pay) | 0 | 0 | Yes |
| WO | Weekly off | 0 | 1 | No |
| H | Public holiday | 0 | 1 | No |
Daily-wage staff who don't get paid for weekly offs? Set WO to 0 under Paid in your copy of the file.
Employee Attendance Sheet Example (Filled Sample)
Blank grids don't teach you much. So here is an employee attendance sheet in Excel for a whole month, marked up. Make your own copy of the filled sample here. It belongs to Cedar Street Supplies, a fictional business with 8 employees, and covers October 2026: 31 days, 9 weekend days and 2 public holidays, which leaves 20 working days.
How to Read the Sample
Open Monthly Summary and start with three people.
- Thandi Mokoena took 3 days of paid leave. She worked 17 of 20 days, so her attendance is 85%, yet she is paid for all 31 days. Attendance fell. Her pay didn't.
- Arjun Mehta had 2 half days and worked one extra Saturday. That gives him 20 days worked out of 21 scheduled, or 95.2%, with 30 paid days.
- James Carter worked 14 of 20 days, or 70%, and is paid for 26. Absence Patterns shows why that deserves a chat: 6 absence days across 5 separate spells.
Now look at Maria Santos. She was sick on Thursday, Friday and the following Monday. The weekend falls between those days, so the sheet counts one spell, not two. Then open Time Log and find Daniel Reyes on October 29. He clocked in but never clocked out, and the Check column says so.
Across the team, that is 146 days worked out of 163 scheduled, or 89.6%.
Attendance Formulas in Excel
Want to build your own employee attendance sheet in Excel, or just check ours? Here are the four formulas that matter. Each row below runs across day columns G to AK.
Count Days by Status
=COUNTIF(G7:AK7,"A")
This counts absences for one employee. COUNTIF ignores upper and lower case, but it won't forgive a stray space, so use a dropdown.
Count Days Worked, Half Days Included
=COUNTIF(G7:AK7,"P")+COUNTIF(G7:AK7,"LT")+COUNTIF(G7:AK7,"WFH")+COUNTIF(G7:AK7,"OD")+0.5*COUNTIF(G7:AK7,"HD")
Counting only "P" is the classic mistake. It drops late arrivals, remote days and half days from the total.
Calculate Attendance Percentage
Attendance % = Days Worked / Scheduled Days
Leave weekly offs and holidays out of both numbers. Someone with 18 full days and 2 half days in a 20-day month worked 19 days: 19 divided by 20 is 95%.
Calculate Hours, Night Shifts Included
=MOD(F5-E5,1)*24-G5/60
Time in is E5, time out is F5 and break minutes are G5. MOD handles the jump past midnight. In at 22:00, out at 06:00, with a 30 minute break: 7.5 hours.
How to Use The Employee Attendance Sheet
1- Complete the Business Details
Open Settings and add your business name, branch and who prepares the sheet. It shows on the register, so anyone reading a printout months later knows whose record it is.
Tip: Use one file per branch if each branch closes its own attendance.
2- Set Your Attendance Cycle
Enter the year, the month and the cycle start day. Start day 1 gives you the usual monthly attendance sheet for employees. Start day 16 runs from the 16th to the 15th. Match your payroll cutoff, not the calendar on the wall.
Tip: The start day can be anything from 1 to 28, which keeps every cycle a full month.
3- Choose Weekly Offs and Holidays
Mark your weekly off days and list the public holidays for the cycle. Those columns fill themselves in, and they stay out of your attendance percentage.
Tip: If someone works a day off, pick their code over the top. That day then counts as scheduled.
4- Check the Codes and Pay Values
Read the code table before you mark a single day. Decide what a half day pays and whether casual leave is paid in your business, then set the values.
Tip: Rename a code if your policy uses another letter. The totals keep working, but a renamed code loses its color.
5- Add Your Employees
Add the ID, name, designation, department and site or shift on Monthly Register. Spell names the same way everywhere, because the Time Log and Employee Card look people up by name.
Tip: Add your departments in Settings first so the dropdown has them.
6- Mark Attendance Every Day
Pick one code per person per day from the dropdown. A staff attendance sheet only works when someone marks it daily. Attendance marked from memory at the end of the month is a guess with nice formatting.
Tip: Keep medical details off the sheet. SL is all a shared record needs.
7- Log Times If Hours Matter
Enter time in, time out and break on Time Log. Give night staff their own shift start. A night shift belongs to the date it started.
Tip: Clear every red message in the Check column before you close the cycle.
8- Review, Sign and Send to Payroll
Read Monthly Summary, fix any unmarked days on your employee attendance sheet, then send Paid Days to your payroll template or payroll team. Save a copy for each cycle and keep it for as long as your local rules require.
Tip: Before starting a new cycle, save the file under a new name. Each month stays as its own record.
Common Attendance Sheet Mistakes
✕ Counting weekly offs as attendance
Why it matters: An employee who missed a week can still show a healthy percentage when Sundays pad the total.
Fix: Measure days worked against scheduled days only.
✕ Using attendance % as paid days
Why it matters: A person on approved leave has lower attendance but full pay. Mix the two and you underpay people.
Fix: Track paid days separately, with a clear pay value for each code.
✕ Letting everyone invent codes
Why it matters: "A", "abs" and "Absent " are three different things to COUNTIF, and two of them disappear from your totals.
Fix: Use a dropdown, and keep the legend on the sheet.
✕ Marking everything at month end
Why it matters: Memory favors whoever is asking. Mistakes surface on payday, when they cost the most goodwill.
Fix: Mark daily, and have a supervisor check weekly.
✕ Erasing paper entries
Why it matters: A rubbed-out mark looks like someone changed the record, and later you can't prove otherwise.
Fix: Strike through with a single line, then add initials and the date.
✕ Writing the illness on a shared sheet
Why it matters: Everyone with access can now read a colleague's medical news.
Fix: Use SL on the sheet, and keep any sick notes in a restricted file.
Importance of Employee Attendance Sheet
Absence sounds like a rounding error. In the US, the Bureau of Labor Statistics put the 2024 absence rate for full-time workers at 3.2%. Put simply, about 3 in every 100 full-time workers lost part of a typical week.
So what does an employee attendance sheet give you in return? Four things.
Improves Workforce Accountability and Transparency
A staff attendance sheet gives people a number they can check. When the record is open and the rules are the same for everybody, "you were absent" stops being an opinion. Ask anyone who has refereed that argument without one.
Strengthens Payroll Accuracy and Leave Management
Paid leave, unpaid leave and absence all look the same from the outside: an empty desk. Payroll treats them very differently. Separate codes keep deductions honest, and a leave tracker can handle the balances for the year.
Enables Data-Driven Workforce Planning
Daily Headcount shows which dates ran short and which departments keep falling behind. When a team is short every Monday, the problem may be the rota and not the people.
Supports Compliance and Record Retention
Many labor authorities expect records of time worked, and they can ask for them years later. Three years in some countries, five in others. A file saved per cycle is a much better answer than a search through old emails.
Spreadsheet vs Attendance Software
Should you stay on a spreadsheet? For many small teams, an employee attendance sheet in Excel is all you need. This is where the line usually falls.
| Employee attendance sheet | Attendance software | |
|---|---|---|
| Best for | Small teams, single sites, fixed hours | Several sites, shifts, remote and field staff |
| Who marks it | A supervisor, by hand | Employees clock in, and the system records it |
| Proof of presence | Signature or trust | Fingerprint, kiosk, location or photo |
| Leave requests | Paper or email, then typed in | Requested and approved in one workflow |
| Payroll | Copy paid days across | Attendance rules feed payroll |
| Limit | 50 employees per file | Grows with your team |
How Enerpize Handles Attendance
What happens when the person who marks the sheet goes on leave herself?
That is usually the day an employee attendance sheet stops being enough. Enerpize attendance management records more than 20 million attendance logs a month. Here is how those logs turn into a pay figure. The screens below show sample data.
Attendance Logs
Every sign-in lands here, from fingerprint devices, time kiosks, the employee app or the web portal. Remote staff and field crews can clock in with geofencing, IP checks and photo verification, and logs captured offline sync once the phone reconnects.

Attendance Days
Logs become days. Each employee's sign-in, sign-out and total working hours appear against their shift, with lateness and early departures worked out using your own rules for grace periods and clock-in windows.

Attendance Permissions
Leave and attendance requests come in through the employee app or web portal, then go through single or multi-level approval. Nobody is hunting through a chat thread to find out who agreed to what.

Attendance Sheets
Days roll up into a sheet for the period, with present days and actual working hours for each person. Shifts, leaves and attendance flags then sync with Enerpize payroll, so the figures your payroll team reviews come from the same record your managers approved.

Attendance Records in India
India sends this page more readers than any other country, and its rulebook has just changed.
Section 50 of the Code on Wages, 2019 requires employers to keep a register of employees, muster rolls and wages. According to Acuity Law's guide, the central rules effective from May 8, 2026 set Form IX as the attendance and muster roll, allow paper or electronic records, and require 5 years of retention from the last entry. A first offense can bring a fine of up to Rs. 10,000.
One catch. Those central rules apply directly only where the central government is the appropriate government, such as railways, mines and banks. For an ordinary office or shop, state rules apply, and states use their own forms.
What to add for Indian businesses:
- Fill in employee ID, designation and shift, plus place of work or department.
- Use OD for tours and assignments outside the workplace, and keep overtime hours in the Time Log.
- Add CL, PL and loss of pay to match your leave policy. The codes are already there.
Practical note for Indian businesses: this file is a working record and not a statutory form, so compare it with the form your state prescribes. If your team prefers कर्मचारी उपस्थिति पत्रक to an English sheet, the Hindi PDF is in the downloads.
Attendance Records in the United States
Federal law is relaxed about the form and strict about the facts. The Department of Labor's Fact Sheet 21 says the FLSA requires no particular form and lets you use any timekeeping method, as long as it is complete and accurate.
For employees the FLSA covers, you need the hours worked each day and the total for each workweek. Payroll records stay for 3 years. Time cards and other records behind your wage calculations stay for 2.
What to add for US businesses:
- Fill in the Time Log for non-exempt staff, because a status code alone doesn't show hours.
- Note the day and time your workweek starts.
- Rename PL to PTO if that is what your policy calls it.
Practical note for US businesses: the Overtime column counts hours over your daily standard. Federal overtime usually depends on hours over 40 in a workweek, so total the week before you pay it. State rules can add more.
Attendance Records in the Philippines
Here, paper is taken seriously. Under Book III, Rule X of the Omnibus Rules, time records carry the employee's signature or thumbmark for each daily entry, entries in time books and daily time records are made in ink, records stay in or about the workplace, and they are preserved for at least 3 years from the last entry.
What to add for Philippine businesses:
- Print the Employee Card or the daily attendance sheet page, and have each person sign every day.
- Keep overtime hours visible so they can be checked against pay.
- Store the signed copies at the workplace.
Practical note for Philippine businesses: use the Excel file for the totals and the signed sheet as the record behind them. Ask your adviser or DOLE office before relying on digital records alone.
Attendance Records in South Africa
A missing record here is hard to explain. Section 31 of the Basic Conditions of Employment Act requires a record of each employee's name and occupation, time worked and pay, kept for 3 years from the last entry. It also forbids false entries.
Some sectors go further. In wholesale and retail, Sectoral Determination 9 calls for an attendance register, manual or automated, at the workplace. It records start and finish times, breaks, overtime, total hours and the employee's signature.
What to add for South African businesses:
- Fill in designation for every employee, along with the Time Log.
- Print the Employee Card for signatures if your sector needs them.
- Keep pay records with each cycle's file.
Practical note for South African businesses: check for a sectoral determination or bargaining council agreement in your industry first. It may ask for more than the Act does.
Who Can Use an Employee Attendance Sheet?
HR Managers and Human Resource Departments
An employee attendance sheet gives you one record for leave, lateness and absence, plus a pattern view that turns "I feel like he's always off" into something you can actually discuss.
Operations Managers and Team Leaders
Daily Headcount tells you who you really had on each date. That beats finding out at 9:15 that the morning shift is short again.
Small Business Owners and Entrepreneurs
You probably know who was in today. Do you know who was in on the 12th of last month? Whether you run a workshop or a retail store, a staff attendance sheet remembers so you don't have to.
Finance and Payroll Administrators
An employee attendance sheet hands you paid days as one figure per person, with unpaid days beside it. Fewer questions to chase, and fewer corrections to next month's payslips.
Construction Sites and Labour Contractors
Crews change, phones die and signal disappears. A labour attendance sheet on a clipboard still works, and the sign-in page gives you a time and a signature for each worker. A worker attendance sheet like this one also shows the contractor exactly which days you are paying for.
Remote and Hybrid Teams
On a staff attendance sheet, WFH and OD keep people at home or on the road from looking absent. Marks show availability, and you don't have to watch anyone's screen to get them.
Attendance Sheet Glossary
| Term | What it means |
|---|---|
| Attendance cycle | The dates one sheet covers, usually matching your pay period. |
| Scheduled days | Days the employee was due at work, without weekly offs and holidays. |
| Paid days | Days the employee gets paid for, including paid leave and any paid offs. |
| Loss of pay (LOP) | Days deducted from pay, usually for unpaid absence. |
| Weekly off | A regular rest day. It differs by business and country. |
| Muster roll | A register of workers with their daily attendance, common in India. |
| Absence spell | One unbroken run of absence. A weekend in the middle doesn't end it. |
| Bradford Factor | Spells x Spells x Absence Days. Five 1-day spells score 125, while one 5-day spell scores 5. |
Key Takeaways
- An employee attendance sheet records one status per person per day, then totals worked days, paid days and attendance percentage.
- Attendance and pay are separate answers. In our sample, an employee worked 17 of 20 days and was still paid for all 31.
- Calculate attendance as days worked divided by scheduled days, and leave weekly offs and holidays out of both.
- Count half days as 0.5 and include late, remote and on-duty days, or COUNTIF will understate the total.
- Set your cycle to match payroll. A 16th to 15th month needs a different sheet from a calendar month.
- Use MOD for night shifts, because plain subtraction turns 22:00 to 06:00 into minus 16 hours.
- Retention differs: 5 years under India's central wage rules, 3 years in the Philippines and South Africa, and 2 to 3 years in the US depending on the record.
- Use absence patterns to start a conversation, and keep medical details off shared sheets.
Frequently Asked Questions
What should an employee attendance sheet include?
At a minimum: employee name or ID, the dates covered and one status per day. Add department, shift, time in and out, break time, totals, paid days and a signature if your payroll or local rules call for them.
How do I make an employee attendance sheet in Excel?
Put names in the first columns and dates across the top. Add a dropdown of status codes with data validation, color the codes with conditional formatting, then total each code with COUNTIF. Or download our file, which already does all of it.
What is the formula for attendance in Excel?
Use =COUNTIF(range,"P") to count one status. To count days worked, add every worked code together and count half days as 0.5. Attendance percentage is days worked divided by scheduled days.
How do I calculate attendance percentage?
Divide days worked by scheduled days, then multiply by 100. An employee who worked 19 of 20 scheduled days has 95% attendance. Leave weekly offs and holidays out of both numbers.
What is the difference between an attendance sheet and a timesheet?
An attendance sheet records whether someone was at work and why not. A timesheet records how many hours they worked, often against tasks or projects. Our Time Log adds clock times when you need both.
Should I use a daily, weekly or monthly attendance format?
Use a monthly attendance sheet for employees on fixed schedules and monthly pay. Use a daily attendance sheet for shift crews and sites where people change. A weekly format suits weekly payroll, and our daily sign-in page covers each day of it.
Can I use a paper attendance register?
In many places, yes, and some rules expect signed entries. Check what your country and sector require. Our employee attendance sheet PDF and Paper Register are built for printing and signing, or you can edit the monthly attendance sheet in Word format first.
How long should I keep attendance records?
It depends on where you operate. India's central wage rules say 5 years from the last entry. The Philippines and South Africa say 3 years. In the US, keep payroll records for 3 years and time cards for 2. Local rules can differ.
About the Author
Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.
Disclaimer
This template and the information on this page are for general guidance only and are not legal, payroll or HR advice. Labor and record-keeping rules differ by country, state and sector and change over time, so confirm your requirements with a qualified adviser or your labor authority.
