Daily attendance sheet template (Excel)
A ready daily sheet in Excel: enter each employee's check-in and check-out and pick a status, and the sheet works out late minutes against the shift start, hours worked, and a day summary of who was present, late or absent. Free, no signup.
Filling this in every morning?
Dawmly records each employee's check-in and check-out from their phone with the time and location, and shows who is in, late or absent on the Today screen. Free for up to 3 employees, no card needed.
Start freeNext step: Mobile attendance app · Monthly sheet · Lateness deduction calculator
What's in the file
- The daily sheet: 30 rows with name, job title, check-in, check-out, a status list (present, late, absent, leave, off-site), notes and signature.
- Automatic sums: late minutes against the shift start, and hours worked from check-in to check-out, even across midnight.
- Day summary: a count of each status and the total late minutes and hours, plus a how-to sheet.
How to use the daily attendance sheet
- Enter the company name and date, and set the shift start and end in the shaded cells.
- Type the employee names once, then copy the sheet for each new day.
- Enter check-in and check-out as 09:15 and pick a status from the list.
- Check the summary under the sheet, and carry absences and late days over to the monthly sheet or the payroll sheet.
Daily or monthly sheet?
The daily sheet suits you when you need the real check-in and check-out times each day, to work out lateness and hours. The monthly attendance sheet gives you the whole month with quick codes. Many companies use both: the daily one to record, the monthly one for payroll.
When daily entry becomes a chore, or you need proof of where an employee was when they clocked in, it is time for an attendance app that each employee uses from their phone.