How to Maintain a Worker Daily Attendance Sheet With Sample Format

For a factory, workshop, shop or building site, the worker daily attendance sheet is the record behind every salary. When it is clear and filled on time, payday is calm. When it is messy, you get arguments about missing days, overtime and half days. This guide explains what a good sheet contains, gives a sample format you can copy, shows the marking codes to agree on, and explains how to move from paper to a digital record. It also covers how an employee daily attendance sheet and a company attendance sheet differ from a worker sheet.
What Is a Worker Daily Attendance Sheet?
A worker daily attendance sheet is a page that records who came to work on a given day, at what time they started and finished, how many hours they worked and what their status was. One sheet usually covers one day, one shift or one site. At the end of the month, the daily sheets are added up to give each worker's total days and overtime.
You will see several names for the same idea. A daily attendance sheet is the general term. An employee daily attendance sheet is usually used for office staff, where the list is short and the hours are fixed. A company attendance sheet covers all staff of the business, often in a monthly grid. A worker sheet is built for larger crews, shifts, daily wages and overtime, so it needs a few more columns and a stricter routine.
Why Keeping the Sheet Properly Matters
The first reason is pay. If your workers are paid by the day or by the hour, the sheet is the only proof of what is owed. A missing entry becomes a dispute, and a wrong entry becomes a loss for either side. The second reason is the law. Section 50 of the Code on Wages, 2019 requires employers to keep a register of persons employed, a muster roll and wages, and the rules under the labour codes describe an attendance register-cum-muster roll. The central rules, notified in May 2026, allow these registers to be kept in electronic form. Reports also mention that wage, overtime and attendance records should be kept for years, and the exact period and format can differ by state, so confirm them with your labour consultant.
The third reason is control. When hours are written down every day, you can see overtime building up, spot workers who are often late and plan shifts with real numbers instead of guesses.
What to Include in a Daily Attendance Sheet

A good sheet is simple enough for a supervisor to fill in a minute and complete enough to calculate pay. Start with the date, the shift and the site or department at the top. Then add one row for each worker with a serial number, the worker's name and a worker ID. The ID matters because two workers can share a first name.
Next come the in-time and out-time, and a break column if breaks are unpaid. The total hours column is calculated from these. An overtime column shows the hours beyond the normal shift. A status column holds a short code such as P for present or A for absent. Finally, add a remarks column and a space for the supervisor's signature. For contract labour, add the contractor's name. For piece-rate work, add the quantity done. Resist adding more than this, because every extra column is another chance for a blank cell.
Sample Worker Daily Attendance Sheet
The table below shows a sample sheet for one day. It assumes a normal shift of 8 working hours with a 1-hour unpaid lunch break, so total hours are the time between in and out minus the break.
Sr | Worker name | Worker ID | In | Out | Hours | Overtime | Status |
|---|---|---|---|---|---|---|---|
1 | Ramesh K | W-101 | 09:00 | 18:00 | 8 | 0 | P |
2 | Sunita D | W-102 | 09:00 | 20:00 | 10 | 2 | P |
3 | Imran S | W-103 | 09:30 | 18:30 | 8 | 0 | L |
4 | Pooja M | W-104 | none | none | 0 | 0 | A |
5 | Deepak R | W-105 | 09:00 | 13:00 | 4 | 0 | HD |
P means present, L means late, A means absent and HD means half day. The same layout works as an employee daily attendance sheet for an office, and a month of these pages can be combined into a company attendance sheet.
How to Fill the Sheet Every Day
The habit matters more than the format. Ask one supervisor per shift to own the sheet and mark attendance at the start of the shift, while the workers are in front of them. Write the real in-time and out-time instead of rounding to the nearest hour, because rounding adds up to real money over a month. At the end of the shift, fill the hours and overtime, and sign the page.
If a worker forgets to mark an exit, write a note in the remarks column and confirm the time with the worker the same day. When you must correct an entry, strike it with a single line and write the new value with your initials, instead of overwriting it. Hand the sheets to HR or the accounts team the next morning, so that nothing stays on a desk for a week. At month end, total each worker's days, overtime and leave in one summary page.
Marking Codes and Rules to Agree First
Before the first sheet is printed, agree on a short list of codes and tell every supervisor. A common set is P for present, A for absent, L for late, HD for half day, WO for weekly off, PH for a public holiday and PL for paid leave. Then fix the rules behind them. How many minutes of grace do you allow before a worker is marked late? How many hours make a half day? From which hour does overtime start, and how is it paid?
These rules should be written once and applied to everyone in the same way. For the limits on hours and the overtime formula, see our guide on employee working hours in India, which explains how daily and weekly limits are counted.
Paper, Excel or App: Which Works for You?

A paper sheet costs almost nothing and needs no training, which is why many small units still use it. The problems are handwriting, lost pages and totals added by hand. An Excel sheet fixes part of this. You can add a formula that calculates hours from the in and out times, a drop-down list for status codes so nobody types a random letter, and locked cells for formulas. Keep one sheet per month and one row per worker, and save a backup copy each day. The weak point of Excel is that the entry is still manual, and anyone with access can change a cell without a trace.
An attendance app removes the manual entry. Workers mark their own attendance, and the time is recorded by the system. A QR code attendance system, for example, lets workers scan a code at the gate with a phone, so the sheet fills itself. If your attendance data also feeds billing, job costing or payroll that someone still types by hand, business automation can connect those steps so the same number is not entered twice.
Common Mistakes With Daily Attendance Sheets
The most common mistake is filling the sheet at the end of the week or month from memory. Entries become guesses, and workers notice. The second is using a different format for each supervisor, which makes totals impossible to compare. The third is unclear codes, where one supervisor writes L for late and another writes L for leave. The fourth is allowing one worker to mark attendance for another. The fifth is forgetting weekly offs and public holidays, which leads to wrong pay calculations. The last is losing old sheets, so keep records in a safe place for the period your rules ask for, in paper or electronic form.
From Attendance Sheet to Digital Attendance with Attendi
Attendi replaces the paper sheet with a digital record that does the daily work for you. Employee management keeps every worker's details and ID in one place. Workers can check in with QR attendance, and face capture and field work attendance are available on the higher plans for teams that work at different sites. Custom settings let you define working hours, shifts, late rules, holidays and weekly offs once, so codes like L, HD and WO are applied automatically.
Leave management links approved leave to attendance, so a leave day is not counted as absent. Every check-in feeds your attendance reports and leave management, which give daily and monthly totals for each worker, including working hours and overtime, ready for payroll. Attendi comes with a 15-day free trial when you sign up at attendi.in, so you can run a week of digital attendance next to your paper sheet and compare the two before you switch.
Final Thoughts
A worker daily attendance sheet does not need to be complicated, but it must be consistent. Keep the columns few, agree on the codes, mark attendance at the start of the shift, record real times and keep the old sheets safe. Use Excel if you want a low-cost step up from paper, and move to a QR or app-based system when manual entry starts to cost more than it saves. Whichever route you choose, a clean daily record is the best protection for your workers' pay and your own.