Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementAttendance & LeaveEmployee Shift Schedule

SpreadsheetAttendance & LeaveFree

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.

Shown with sample data

Colour

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.

Scheduled hours
218.5
Labour cost
$3,773
Labour % of sales
28%
Short-staffed days
1
Labour cost by day
  • Mon$472.50
  • Tue$596.25
  • Wed$600
  • Thu$540
  • Fri$476.25
  • Sat$600
  • Sun$487.50
Hours by team member
  • Jess Lane37.5
  • Arun Das37.5
  • Tom Hale37.5
  • Sam Ortiz37.5
  • Kim Lee30
  • Rosa Diaz23.5
  • Nia Brown15

How to use it

  1. 1Set up your shift types on the Shifts sheet with start, end and paid hours.
  2. 2On the Rota sheet, add each person's role, hourly rate and contracted hours, then pick a shift for every day.
  3. 3On Coverage, type how many openers and closers you need each day and the forecast sales.
  4. 4Fix any Short-staffed day or Over contract flag, then share the rota at least a week ahead.

In this workbook

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

About this template

Build the weekly rota in minutes by picking a shift for each person and day from a drop-down. Shift times and paid hours come from your shift list, so weekly hours, overtime over 40 hours and labour cost calculate for you, with a check against each person's contracted hours. The coverage sheet counts openers, mid shifts and closers each day against what you need, flags short-staffed days, and compares labour cost with forecast sales.

Who it’s for

  • Cafés, shops, restaurants and clinics
  • Part-time and hourly teams
  • Keeping labour cost in line with sales

What’s included

  • Rota sheet: Each person's shift for every day, with hours and cost.
  • Coverage sheet: Openers, closers and labour cost each day against need and sales.
  • Shifts sheet: Your shift types with times and paid hours.

How to use it

  1. 1Set up your shift types on the Shifts sheet with start, end and paid hours.
  2. 2On the Rota sheet, add each person's role, hourly rate and contracted hours, then pick a shift for every day.
  3. 3On Coverage, type how many openers and closers you need each day and the forecast sales.
  4. 4Fix any Short-staffed day or Over contract flag, then share the rota at least a week ahead.

Tips

  • Aim to keep labour around 25 to 35% of sales in food service.
  • Use Leave rather than Off for approved holiday so it is easy to see why someone is not on.

Questions

How is overtime worked out?

Hours over 40 in the week are paid at 1.5 times the hourly rate. Change the rule in the Labour cost column to match your local law.

Can I change shift times?

Yes. Edit the Shifts sheet and every hour and cost on the rota updates.

Related searchesshift schedulestaff rotarosterschedulinglabour costcoverage planner

Details

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

Download a copy

Downloads need a free account.

SpreadsheetAttendance & LeaveFree

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.

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
3
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
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