Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementAttendance & LeaveLeave & Vacation Tracker

SpreadsheetAttendance & LeaveFree

Leave & Vacation Tracker

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

Shown with sample data

Colour

Leave & Vacation Tracker

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

Off today
1
Pending requests
2
Annual leave used
34%
Taken and booked, of total entitlement
Sick days this year
3
Annual leave remaining
  • Amara Okafor27
  • Mei Tanaka24
  • Priya Shah18
  • Daniel Brooks14
  • Grace Kim10
  • Lucas Silva8
Leave days by month
  • Mar5
  • Jun10
  • Jul10
  • Aug25
  • Nov1
  • Dec15

How to use it

  1. 1Set each person's annual allowance and carry-over on the Balances sheet.
  2. 2List public holidays for the year on the Holidays sheet.
  3. 3Log every request on the Requests sheet with type, first and last day, and set Approved.
  4. 4Check Remaining (after booked and pending leave) before approving anything new.

In this workbook

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

About this template

Know everyone's leave balance without digging through emails. Log each request with first and last day and the tracker counts working days for you, skipping weekends and the public holidays you list. Balances show allowance, carry-over, leave taken, leave booked for the future, pending requests and what is left, and you can see who is off today and how much leave falls in each month for planning cover.

Who it’s for

  • Small teams managing PTO
  • Managers approving holidays and planning cover
  • Year-end leave reconciliation

What’s included

  • Balances sheet: Allowance, leave taken and booked, and what is left for each person.
  • Requests sheet: Every leave request with working days and approval.
  • By month sheet: Leave starting in each month, to plan cover for busy periods.
  • Holidays sheet: Public holidays that do not count as leave.

How to use it

  1. 1Set each person's annual allowance and carry-over on the Balances sheet.
  2. 2List public holidays for the year on the Holidays sheet.
  3. 3Log every request on the Requests sheet with type, first and last day, and set Approved.
  4. 4Check Remaining (after booked and pending leave) before approving anything new.

Tips

  • Approve requests in the order they arrive and note who covers.
  • Remind people with large balances in the autumn so leave is not lost.
  • Half days: enter the same first and last day and change Days to 0.5.

Questions

How are days counted?

Working days (Monday to Friday) between the first and last day, excluding the holidays on the Holidays sheet.

What is the difference between taken and booked?

Taken is approved leave that has started; booked is approved leave still in the future. Both reduce the balance.

Related searchesleave trackerpto trackervacation trackerannual leaveholiday plannerabsence management

Details

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

Download a copy

Downloads need a free account.

SpreadsheetAttendance & LeaveFree

Leave & Vacation Tracker

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

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
4
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More attendance & leave templates

View all
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
Monthly Attendance Sheet

Attendance rate

95%

Sick days

4

1256789
Amara OkaforPPPPRPP
Daniel BrooksPPPPPPP
Mei TanakaRRPPRRR
Lucas SilvaRRRRRLL
SpreadsheetAttendance & Leave

Monthly Attendance Sheet

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

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