Skip to content
Monthly Employee Attendance cover: a sample sheet with hours worked, shifts logged and late arrivals and a bar chart, beside the Dashboard and Clock log tabs

Monthly Employee Attendance

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

The Monthly Employee Attendance workbook is for office managers and team leads who track when shifts start and finish. The Clock log tab gives each shift its own row with the employee, date, clock-in and clock-out times, and a status. Hours worked calculate from the two times. The Dashboard shows shifts, hours, late arrivals and the on-time rate, with breakdowns by person and by status.

For each new month, save a copy and empty the Clock log rows. Use the three status words exactly as spelled in the list, On time, Late or Left early, so the counts stay correct. Enter times in 24-hour format, such as 17:30 for 5:30 pm. A night shift crossing midnight needs splitting across two rows, or its hours will show as negative.

Useful for

  • Record shift times for a small team
  • Count late arrivals for each month
  • Check hours before payroll runs

What's included

  • 3 tabs: Dashboard, Clock log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Clock log: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Clock log tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How are hours worked calculated?

The Hours column takes the clock-out time, subtracts the clock-in time and multiplies by 24, so 9:00 to 17:30 gives 8.5 hours. The result is rounded to two decimal places. Unpaid breaks are not taken off automatically, so subtract them in the times you enter or in the formula.

Who decides whether someone is late?

You do. The status is a dropdown you set for each row, because start times and grace periods differ between workplaces. Choose On time, Late or Left early when you enter the row, following the rule your business already uses.

Can I record absences here too?

A shift with no clock-in is not counted as an absence by this sheet. Keep a separate leave record, or add a note on the row. A day-by-day attendance grid suits absence codes better, because it shows every day of the month at a glance.

  • #attendance-tracker
  • #employee-attendance-monthly
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More attendance tracker templates

See all 8

Also in Human resources

All human resources templates
Get this template

Preparing your template…