Shop · Small Business

Staff Rota & Wages: photo 1 of 5 from its Etsy listing
Small Business

Staff Rota & Wages

Staff Rota Template UK with Wages, Weekly Rota Spreadsheet, Minimum Wage and Holiday Tracker, Cafe Shop Salon, Excel & Google Sheets

£10 Buy on Etsy

Instant download: Etsy takes the payment and sends you the files straight away.

Plan the week's shifts and see the wage bill before you put the rota up. Type start and finish times and unpaid break minutes for up to 15 staff, and it works out each person's hours and gross pay, the hours and wage cost for each day, and what's left in your wage budget.

It checks every hourly rate against the legal minimum for that person's age band (the April 2026 rates and the April 2027 rates already announced: the week's date picks the right ones), flags long shifts without a proper break and under 18s over their limits, and keeps track of each person's holiday left.

Staff Rota & Wages: photo 2 of 5Staff Rota & Wages: photo 3 of 5Staff Rota & Wages: photo 4 of 5Staff Rota & Wages: photo 5 of 5

What's inside (5 tabs)

  • Start Here: The week, your wage budget, six live totals, day by day and the minimum wage rates
  • Staff: Each person's age band, hourly rate, usual hours, pay check and holiday left
  • Rota: The week's shifts: hours, wage cost and checks for each person and each day
  • Holiday: Holiday taken or booked, in hours
  • Guide: How it works, in plain English

What it does

  • Weekly rota for up to 15 staff: start, finish and unpaid break, including shifts past midnight
  • Hours and gross wage cost per person, per day and for the week, against your wage budget
  • Minimum wage check by age band: 21 and over, 18 to 20, under 18 and apprentice
  • April 2026 and April 2027 minimum wage rates built in, picked by the week's date
  • Break check: 20 minutes on shifts over 6 hours; under 18s 30 minutes over 4.5 hours, and their 8 hours a day and 40 a week limits
  • Holiday: 5.6 weeks of each person's usual hours (capped at 28 days), less holiday taken or booked, for each person's own holiday year
  • Busiest day, and how many staff are on each day

What you get

  • staff_rota_wages.xlsx with example data, so you can see how it works
  • staff_rota_wages_blank.xlsx: the same file, empty and ready for your own
  • A step-by-step PDF setup guide
  • A PDF with a one-click link to make your own Google Sheets copy

What you need

  • Microsoft Excel 2010 or newer (including Microsoft 365), on Mac or PC
  • OR a free Google account to use it in Google Sheets (the guide shows you how)
  • Best on a computer or tablet. Not made for Apple Numbers

Please note

  • This is a digital download. No physical item will be sent
  • Hours and gross wage cost only: no tax, National Insurance, pension or payslips. A planning tool, not legal or payroll advice. The example café and staff are made up
  • For your own business use. Please don't resell or share the file

How it's made

Designed by me, built with the help of AI tools, then checked formula by formula in two different spreadsheet programs.

Staff Rota & Wages £10
Buy on Etsy