Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceStore OperationsStore Staff Rota

SpreadsheetStore OperationsFree

Store Staff Rota

Next week's hours by person and day, with contract and overtime checks, staff on and labour cost each day, minimum cover alerts and labour as a share of forecast sales.

Shown with sample data

Colour

Store Staff Rota

Next week's hours by person and day, with contract and overtime checks, staff on and labour cost each day, minimum cover alerts and labour as a share of forecast sales.

Total hours
150
Labour cost
$2,622
Labour % of sales
18%
Days below minimum
1
Labour cost by day
  • Mon$343.50
  • Tue$397.50
  • Wed$410
  • Thu$403.50
  • Fri$380
  • Sat$543.50
  • Sun$144
Hours by person
  • Hannah40
  • Omar32
  • Priya24
  • Tom20
  • Leo20
  • Zoe14

How to use it

  1. 1List each person with role, hourly rate and contracted hours.
  2. 2Type the hours each person works each day (0 for a day off).
  3. 3On the Coverage sheet, set the minimum staff and forecast sales for each day.
  4. 4Fix any Below minimum day or contract warning, then share the rota a week ahead.

In this workbook

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

About this template

Build next week's rota in minutes by typing hours for each person and day. The rota totals each person's hours against their contract, flags overtime and under-hours, and prices the week at each person's rate. The daily coverage sheet counts staff on, hours and labour cost each day, warns when a day falls below the minimum number of staff you set, and compares labour with forecast sales so you can trim quiet days and strengthen busy ones.

Who it’s for

  • Shops, cafés and small restaurants
  • Part-time and hourly teams
  • Keeping labour cost in line with sales

What’s included

  • Rota sheet: Hours per person per day for next week.
  • Coverage sheet: Staff on, hours and labour cost each day against need and sales.

How to use it

  1. 1List each person with role, hourly rate and contracted hours.
  2. 2Type the hours each person works each day (0 for a day off).
  3. 3On the Coverage sheet, set the minimum staff and forecast sales for each day.
  4. 4Fix any Below minimum day or contract warning, then share the rota a week ahead.

Tips

  • Aim for labour around 15 to 20% of sales in retail; hospitality usually runs higher.
  • Schedule your strongest people on your busiest days, not just the most available.

Questions

How is overtime counted?

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

How are staff on counted?

Anyone with more than 0 hours on that day.

Related searchesstaff rotashift scheduleemployee scheduleretail schedulinglabour costcoverage

Details

Format
Spreadsheet
Category
Store Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStore OperationsFree

Store Staff Rota

Next week's hours by person and day, with contract and overtime checks, staff on and labour cost each day, minimum cover alerts and labour as a share of forecast 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
Store Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More store operations templates

View all
Retail Sales Tracker2 sheets

Net sales

$20,210

Avg transaction

$48

Conversion

24%

Net sales by day
SpreadsheetStore Operations

Retail Sales Tracker

Daily sales by channel with transactions, average basket and target progress.

10 min setupPreview
Retail Store KPI Scorecard2 sheets

Sales

$308,840

Conversion rate

14%

Average transaction value

$33

Sales by store
$148k
$130k
$31k
Riverside MallHigh StreetStation Kiosk
SpreadsheetStore Operations

Retail Store KPI Scorecard

Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.

10 min setupPreview
Daily Cash Register Reconciliation4 sheets

Takings

$18,304

Net variance

-$29

Days to investigate

2

ABCD
1DateTillClosed byOpening float
2Nov 21Omar$200.00
3Nov 31Priya$200.00
4Nov 41Omar$200.00
5Nov 51Hannah$200.00
Cash-up
SpreadsheetStore Operations

Daily Cash Register Reconciliation

Close the till every day: cash, card and voucher takings against the POS, over and short against your tolerance, the bank deposit, a denomination count and variances by cashier.

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