Attendance Register Format — Free Excel and App
An attendance register records which employees were present, absent or on leave each day, so you can total the month for salary.
Shops, factories and offices use an attendance register to mark staff daily. A clean format makes month-end salary and leave calculation quick and avoids disputes.
Attendance Register format preview
| Date | Employee name | Employee ID | In time | Out time | Status (P/A/L) | Remarks |
|---|---|---|---|---|---|---|
| 12-Nov-2026 | Ramesh Kumar | EMP-014 | 09:05 | 18:10 | P | Late by 5 min |
The second row is a filled sample.
What each column means
Date
Example: 12-Nov-2026
Employee name
Example: Ramesh Kumar
Employee ID
Example: EMP-014
In time
Example: 09:05
Out time
Example: 18:10
Status (P/A/L)
Example: P
Remarks
Example: Late by 5 min
Please note: Rules on which records you must keep, and in what layout, can differ by state and by business type. Check the requirement that applies to you with your CA or labour consultant before adopting any format.
Attendance Register FAQs
What should an attendance register include?
At minimum the date, employee name, in and out time, and a status such as present, absent or leave. Add a remarks column for late marks.
Can I keep an attendance register in Excel?
Yes. Download the Excel format on this page. A mobile app is easier when staff are on shifts or on the field because anyone with access can mark it from a phone.
How do I total attendance for salary?
Count present days and approved leave for each employee for the month, then multiply by the daily wage or divide the monthly salary by working days.
Can attendance be marked from a phone?
Yes. In Recordbook you can mark attendance on Android or the web and share the register with supervisors using role-based permissions.
Related registers
Running a manufacturing business? See Recordbook for manufacturing · Recordbook vs Excel