Employee Attendance Tracker

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

Human Resources

Tables

Employees, Daily log

Fields

17

Views

grid, calendar, form, dashboard

Updated

2026-11-19

Tables, columns and sample rows

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.

Employees

9 fields · 4 sample rows

  • Team (Grid)
EmployeeTextEmployee IDTextDepartmentSingle selectShiftSingle selectAttendanceLink to another tableDays loggedCountDays presentRollupHours workedRollupAttendance rateFormula
Ananya IyerEMP-101EngineeringGeneral (9–6)18 Nov 2026, 19 Nov 20262217.80100%
Marcus JohnsonEMP-102SalesGeneral (9–6)18 Nov 2026, 19 Nov 20262217.25100%
Farhan QureshiEMP-103OperationsEarly (7–4)18 Nov 2026, 19 Nov 202621.513.6775%
Sofia RossiEMP-104SupportLate (1–10)18 Nov 2026, 19 Nov 2026218.9250%
Field details
Employee · Text
Employee ID · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Shift · Single select
General (9–6), Early (7–4), Late (1–10)
Attendance · Link to another table
Links to Daily log
Days logged · Count
Days present · Rollup
sum of Present via Attendance
Hours worked · Rollup
sum of Hours via Attendance
Attendance rate · Formula
IF({Days logged} > 0, {Days present} / {Days logged}, BLANK())

Daily log

8 fields · 8 sample rows

  • By day (Grid)
  • Calendar (Calendar)
  • Check in (Form)
  • Insights (Dashboard)
DateDateEmployeeLink to another tableStatusSingle selectCheck inDurationCheck outDurationHoursFormulaPresentFormulaNotesLong text
18 Nov 2026Ananya IyerPresent9:0218:159.221
18 Nov 2026Marcus JohnsonLate10:2018:308.171Metro delay
18 Nov 2026Farhan QureshiPresent6:5516:059.171
18 Nov 2026Sofia RossiAbsent00Unplanned — called in at 12:30
19 Nov 2026Ananya IyerWork from home9:1017:458.581
19 Nov 2026Marcus JohnsonPresent8:5518:009.081
19 Nov 2026Farhan QureshiHalf day7:0011:304.500.5
19 Nov 2026Sofia RossiPresent13:0522:008.921
Field details
Date · Date
Employee · Link to another table
Links to Employees
Status · Single select
Present, Late, Half day, Work from home, Absent, On leave
Check in · Duration
Check out · Duration
Hours · Formula
IF(AND({Check in}, {Check out}), ROUND(({Check out} - {Check in}) / 3600, 2), 0)
Present · Formula
IF(OR({Status} = 'Present', {Status} = 'Late', {Status} = 'Work from home'), 1, IF({Status} = 'Half day', 0.5, 0))
Notes · Long text

Form view “Daily attendance” asks for: Date, Employee, Status, Check in, Check out, Notes.

Why each part of the base is there

Employees: Employee ID, Department and Shift

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.

Days logged, Days present and Hours worked

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.

Attendance rate

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.

Daily log: Status

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.

Check in, Check out and Hours

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 and the Check in form

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.

About the Employee Attendance Tracker template

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.

Who it is for

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.

How to use it

  1. 1

    Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.

  2. 2

    Edit the Shift and Department options, then replace the sample team in Employees with your staff, their IDs and their shifts.

  3. 3

    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.

  4. 4

    Use the By day grid or Calendar view to review the day's attendance and fix missing check-outs.

  5. 5

    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.

Connected templates in other Edesy apps

Employee Attendance Tracker: frequently asked questions

The 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.

About the app

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.

Related templates