● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Payroll & HR›Employee Attendance Tracker Spreadsheet
Employee Attendance Tracker Spreadsheet hero preview showing the attendance workbook
PAYROLL & HR

Employee Attendance Tracker Spreadsheet

Mid-month, someone asks who was out last Tuesday, and the answer is buried in chats and memory. This employee attendance tracker fixes that with one code per person per day, while totals, percentages and pattern alerts quietly build themselves in the background.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

A daily record you can trust at month end

The whole system rests on one small habit. Each working day you mark a single code per person: present, late, absent, sick, leave, work from home or a day off, chosen from a dropdown in each cell. That is the entire daily job. From those codes, the row totals count themselves, and each person gains an attendance percentage and a count of days logged, so the monthly picture is always forming without extra admin.

The Monthly Summary turns the grid into one clean line per person, showing present, late, absent, sick, leave and work from home days side by side. Pattern Alerts then watches for what a busy manager can miss: three or more lates, three or more absences, back to back absences and absences that keep landing on Mondays or Fridays. A flag is presented as a prompt to check and talk, not as a verdict, and the tab says what to check first.

Leave balances are kept deliberately small, showing annual leave and sick leave used and left, taken straight from the daily codes. It does not handle requests or approvals, because this is a record of what actually happened each day, which is a different job. For each employee you can also open a one page report card, pick their name and print or save the card, with their figures and alert level filled in automatically.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link to your own Google Sheets copy
  • BLANK Excel workbook, clean and ready for your own team
  • EXAMPLE Excel workbook with demo data for 12 employees in October 2026
  • Quick Start Guide PDF covering setup in Excel and Google Sheets in about five minutes
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel and in Google Sheets
  • No macros and no add-ons, just formulas
  • Records attendance only, it does not calculate pay or hours
  • Alert levels for lates and absences can be changed on Start Here
  • For small business planning, not pay, tax or legal advice

Questions about this template

The things buyers ask us most.

What do the attendance codes mean?

Each day uses one short code per person. P means present, L means late, A means absent, S means sick, V means leave, H means a holiday, W means work from home and O means an off day. The full legend sits on the Settings and Lists tab, and every day cell has a dropdown with the codes, so marking the grid stays quick and consistent.

How is attendance percent worked out?

It counts present, late and work from home days out of all logged working days. Holidays and off days do not count against anyone. In the example data, one employee was present 19 days out of 22 logged days, which works out to 86.4 percent. The figure is calculated for each person automatically as you mark the daily grid through the month.

What counts as a pattern worth flagging?

The Pattern Alerts tab flags three or more lates in the month, three or more absences, two absent days in a row, or absences falling on Mondays or Fridays more than once. You can change the late and absence thresholds on the Start Here tab and the whole workbook follows. A flag is a prompt to check the facts and have a conversation, not proof of a problem.

Does this track hours, pay or leave requests?

No, and it is clear about that on purpose. This workbook records daily attendance only, so it does not calculate pay, overtime or hours worked, and its small Leave Balances tab only shows leave used and left from the daily codes. It does not take or approve leave requests. Those jobs belong to payroll and time off tools, which keeps this record simple and reliable.

More in Payroll & HR

All templates in this category →

Three more workbooks from the same shelf.

Hiring Tracker Spreadsheet

Roles, candidates, interview scorecards and offers in one tracker, with stalled flags built in.

$7.50 $3.00
View on Etsy
Employee Schedule Planner Spreadsheet

Log shifts once and get weekly rotas, double booking flags, coverage checks and labor costs.

$7.50 $3.00
View on Etsy
CPD Hours Spreadsheet

Log CPD activities once and let the tracker count hours, pace and progress.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00