Skip to main content
Dawmly

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 free

Next step: Mobile attendance app · Monthly sheet · Lateness deduction calculator

What's in the file

How to use the daily attendance sheet

  1. Enter the company name and date, and set the shift start and end in the shaded cells.
  2. Type the employee names once, then copy the sheet for each new day.
  3. Enter check-in and check-out as 09:15 and pick a status from the list.
  4. 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.

Frequently asked questions

Is the daily attendance sheet free?

Yes, completely free with no signup. It works in Excel, Google Sheets and LibreOffice.

How does it work out late minutes?

It subtracts the shift start from the check-in time and turns the difference into minutes, and counts nothing when someone arrives early. Change the shift start at the top to match your company.

Does it handle night shifts?

Yes. When check-out is after midnight the hours are still right, so a 10 pm to 6 am shift counts as 8 hours.

How do I turn late minutes into a pay deduction?

Use the free lateness deduction calculator. It works out the rate per minute and applies the deduction cap in Egypt's labor law.

Keep reading