Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementAttendance & LeaveMonthly Attendance Sheet

SpreadsheetAttendance & LeaveFree

Monthly Attendance Sheet

A month-at-a-glance register with present, remote, sick, absent and leave codes, attendance rates, absence flags and daily coverage.

Shown with sample data

Colour

Monthly Attendance Sheet

A month-at-a-glance register with present, remote, sick, absent and leave codes, attendance rates, absence flags and daily coverage.

Attendance rate
95%
Present days of days due
Sick days
4
Unplanned absences
4
People to talk to
1
Attendance rate by employee
  • Amara Okafor100%
  • Daniel Brooks100%
  • Sofia Rossi100%
  • Omar Haddad97.7%
  • Lucas Silva97.1%
  • Mei Tanaka95.5%
  • Grace Kim86.4%
  • Tom Becker81.8%
People in the office each day
Thu 1Fri 30

Latest: 7

How to use it

  1. 1List employees and their team.
  2. 2Mark each working day: P present, R remote, HD half day, S sick, A unplanned absence, L approved leave, PH public holiday.
  3. 3Leave future days blank; rates only count days that have a code.
  4. 4At month end, check the Flag column and the By day sheet, then copy the sheet for next month and change the day headers.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A clear monthly register: one row per person and a column for every working day, marked with a short code from a drop-down. Each person's days present, remote, sick, unplanned absence and leave are counted for you, with an attendance rate that excludes approved leave and public holidays and a flag when absences need a conversation. A daily sheet shows how many people were in, remote or off each day.

Who it’s for

  • Shift teams, shops and small offices
  • Payroll preparation at month end
  • Spotting absence patterns early

What’s included

  • October 2026 sheet: Daily attendance codes for each employee.
  • By day sheet: Who was in, remote or off on each working day.

How to use it

  1. 1List employees and their team.
  2. 2Mark each working day: P present, R remote, HD half day, S sick, A unplanned absence, L approved leave, PH public holiday.
  3. 3Leave future days blank; rates only count days that have a code.
  4. 4At month end, check the Flag column and the By day sheet, then copy the sheet for next month and change the day headers.

Tips

  • Use L only for approved leave so it does not count against attendance.
  • A pattern of single-day absences matters more than one longer illness: talk early and kindly.

Questions

How is the attendance rate worked out?

Days present (half days count as 0.5) divided by the days the person was due to work: every coded day except approved leave and public holidays.

When does the flag appear?

Watch after 2 days of sickness or unplanned absence in the month, Review after 4 or more, or after 2 or more unplanned absences.

Related searchesattendance sheetemployee attendanceabsence trackingattendance registersick daysbradford factor

Details

Format
Spreadsheet
Category
Attendance & Leave
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAttendance & LeaveFree

Monthly Attendance Sheet

A month-at-a-glance register with present, remote, sick, absent and leave codes, attendance rates, absence flags and daily coverage.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Attendance & Leave
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More attendance & leave templates

View all
Leave & Vacation Tracker4 sheets

Off today

1

Pending requests

2

Annual leave used

34%

Annual leave remaining
27
24
18
14
10
Amara OkaforMei TanakaPriya ShahDaniel BrooksGrace Kim
SpreadsheetAttendance & Leave

Leave & Vacation Tracker

Leave requests counted in working days (skipping weekends and holidays), with balances, bookings, who is off and monthly totals.

10 min setupPreview
Employee Shift Schedule

Scheduled hours

218.5

Labour cost

$3,773

MonTueWedThuFriSatSun
Jess LaneOpenOpenOpenOpenOpenOffOff
Arun DasMidOpenOffClosClosOpenOff
Kim LeeOffClosClosOffOffClosOpen
Rosa DiazShorShorShorOffShorMidOff
SpreadsheetAttendance & Leave

Employee Shift Schedule

Build the weekly rota from shift codes, with hours, overtime and labour cost per person, opener and closer coverage each day, and labour as a share of sales.

10 min setupPreview

Leave Request Form

Employees request time off with dates, leave type and cover arrangements.

Full name *

Work email *

Manager *

Request leave
FormAttendance & Leave

Leave Request Form

Employees request time off with dates, leave type and cover arrangements.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ