Record daily check-ins per employee and get each person’s attendance rate and hours worked automatically.
An employee attendance tracker is a ready-made database that records each employee's daily status and check-in and check-out times, and works out the hours they worked and their attendance rate, so attendance no longer has to be totalled by hand at month end.
Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.
Category
Tables
Employees, Daily log
Fields
17
Views
grid, calendar, form, dashboard
Updated
2026-11-19
The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.
9 fields · 4 sample rows
| EmployeeText | Employee IDText | DepartmentSingle select | ShiftSingle select | AttendanceLink to another table | Days loggedCount | Days presentRollup | Hours workedRollup | Attendance rateFormula |
|---|---|---|---|---|---|---|---|---|
| Ananya Iyer | EMP-101 | Engineering | General (9–6) | 18 Nov 2026, 19 Nov 2026 | 2 | 2 | 17.80 | 100% |
| Marcus Johnson | EMP-102 | Sales | General (9–6) | 18 Nov 2026, 19 Nov 2026 | 2 | 2 | 17.25 | 100% |
| Farhan Qureshi | EMP-103 | Operations | Early (7–4) | 18 Nov 2026, 19 Nov 2026 | 2 | 1.5 | 13.67 | 75% |
| Sofia Rossi | EMP-104 | Support | Late (1–10) | 18 Nov 2026, 19 Nov 2026 | 2 | 1 | 8.92 | 50% |
8 fields · 8 sample rows
| DateDate | EmployeeLink to another table | StatusSingle select | Check inDuration | Check outDuration | HoursFormula | PresentFormula | NotesLong text |
|---|---|---|---|---|---|---|---|
| 18 Nov 2026 | Ananya Iyer | Present | 9:02 | 18:15 | 9.22 | 1 | |
| 18 Nov 2026 | Marcus Johnson | Late | 10:20 | 18:30 | 8.17 | 1 | Metro delay |
| 18 Nov 2026 | Farhan Qureshi | Present | 6:55 | 16:05 | 9.17 | 1 | |
| 18 Nov 2026 | Sofia Rossi | Absent | 0 | 0 | Unplanned — called in at 12:30 | ||
| 19 Nov 2026 | Ananya Iyer | Work from home | 9:10 | 17:45 | 8.58 | 1 | |
| 19 Nov 2026 | Marcus Johnson | Present | 8:55 | 18:00 | 9.08 | 1 | |
| 19 Nov 2026 | Farhan Qureshi | Half day | 7:00 | 11:30 | 4.50 | 0.5 | |
| 19 Nov 2026 | Sofia Rossi | Present | 13:05 | 22:00 | 8.92 | 1 |
Form view “Daily attendance” asks for: Date, Employee, Status, Check in, Check out, Notes.
The roster everyone is logged against. Shift records the expected timing, so a manager can compare it with the actual check-in and see who is regularly late.
A count and two rollups over the employee's linked daily log rows. They give the month's totals without a pivot table, and they update as soon as a new day is logged.
Days present divided by days logged, shown as a percentage. Because half days count as 0.5, a person with one half day out of two days logged shows 75 percent.
Present, Late, Half day, Work from home, Absent or On leave. Recording late arrivals and work-from-home days as their own statuses keeps them visible, while the Present formula still counts them as attended.
Times are duration fields entered in 24-hour format such as 9:05 or 18:30. The Hours formula subtracts check-in from check-out and rounds to two decimals, and returns zero when either time is missing.
Notes capture reasons such as a metro delay or a client visit. The form lets each employee log their own day from a phone, which removes the end-of-day register round.
This employee attendance tracker has two linked tables. Employees lists each person with an employee ID, department and shift (General 9 to 6, Early 7 to 4 or Late 1 to 10), and rolls up their attendance: days logged, days present, total hours worked and an attendance rate shown as a percentage. Daily log holds one row per employee per day with the date, status, check-in and check-out times and notes. Status can be Present, Late, Half day, Work from home, Absent or On leave; a formula counts Present, Late and Work from home as a full day, Half day as half and the rest as zero. Another formula works out hours from the check-in and check-out times. Views include a By day grid, an attendance calendar, an Insights dashboard and a Check in form employees can fill in themselves.
It suits small offices, shops, clinics, restaurants, agencies and field teams that mark attendance on paper registers or a WhatsApp group and then rebuild it in Excel for payroll. Shift names follow common Indian office and shop timings, and the statuses include work from home and half day, which most Indian employers need to count. Managers of hybrid teams can also use it to see who was in the office, who worked from home and who was on leave.
Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.
Edit the Shift and Department options, then replace the sample team in Employees with your staff, their IDs and their shifts.
Share the Check in form with employees or have a supervisor fill it each day: date, employee, status, check-in and check-out time in 24-hour format, and notes.
Use the By day grid or Calendar view to review the day's attendance and fix missing check-outs.
At month end, filter the Daily log by date and read each employee's Days present and Hours worked, or export the log to Excel for payroll.
Use an attendance form as a digital sign-in sheet for sessions, visits or shifts.
7 questionsEdesy SignBiometric Attendance ConsentEmployers using fingerprint or face-recognition attendance use this to inform employees and record consent, with an alternative for those who opt out.
2 signer roles · 17 fieldsEdesy FlowLeave ApprovalThe line manager approves and signs leave, sick leave asks for a medical certificate that is filed in Google Drive, and the team lead and HR countersign before payroll is informed.
9 steps · 4 rolesEdesy AgentsEmployee Attendance AgentTurns quick messages into structured employee attendance entries — dates, numbers and notes — so records stay complete and consistent.
Tracking · 2 actionsThe Present formula gives 1 for Present, Late and Work from home, 0.5 for Half day and 0 for Absent or On leave. Days present sums it, so half days reduce the attendance rate by half a day.
Hours = (Check out - Check in) / 3600, rounded to two decimals, because the times are stored as durations in seconds. For example, 9:02 to 18:15 gives 9.22 hours. If either time is blank, Hours is 0.
Not as it is: a check-out earlier than the check-in gives negative hours. For shifts that cross midnight, edit the Hours formula to add 24 hours (86,400 seconds) whenever Check out is earlier than Check in.
The Employees table totals every logged day. For one month, filter the Daily log by date and group it by employee, or export the filtered log to CSV or Excel and use it for payroll.
No. It records what employees or supervisors enter in the form or grid. If you use a biometric device that exports a CSV, you can import that file into the Daily log instead.
You can add a scheduled automation that runs every morning on Daily log rows matching a filter and posts a message to a connected Slack channel or calls a webhook.
Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.
Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.
One clean record per employee — role, contact, emergency details, documents and tenure — in a searchable staff directory.
1 table · 17 fieldsRecruitment TrackerManage open roles and every applicant against them — source, stage, interviews, ratings and expected pay — with a live hiring funnel.
2 tables · 30 fieldsCOVID-19 Quarantine TrackerLog each employee who is isolating, their test results and symptoms, and see exactly when they are cleared to return.
1 table · 14 fieldsEmployee Onboarding TemplateRun every new hire through a shared plan — before day one to the 90-day mark — with owners, due dates and live progress per person.
2 tables · 23 fieldsEmployee Referral TrackingCollect referrals from staff, move candidates through the hiring stages and keep referral bonuses straight per employee.
2 tables · 24 fieldsEmployee Schedule TemplatePlan shifts by person, role and location, with paid hours per shift and a weekly total checked against each person’s cap.
2 tables · 18 fields