Staff Rota with Optional Tips spreadsheet for Excel and Google Sheets
Staff Rota with Optional Tips – dashboard
Staff Rota with Optional Tips – wall rota
Staff Rota with Optional Tips – rota
Staff Rota with Optional Tips – tips optional
Staff Rota with Optional Tips – staff
Staff Rota with Optional Tips – whats included

Staff Rota with Optional Tips — Rota, Wage Cost & Tips Share Spreadsheet for Hospitality

£29.99

Build your hospitality bundle

Tick the sheets you want. The discount is worked out here and added in your basket automatically.

Any 3 – 15% offAny 5 – 25% off10 or more – 40% off
  • £29.99
  • £29.99
  • £29.99
  • £29.99
  • £24.99
  • £24.99
  • £24.99
  • £19.99
  • £19.99
  • £19.99
  • £19.99

Plan the rota, see the wage bill and share the tips, all in one sheet. Plan your staff rota for 1 week, 2 weeks or a month. Works in Excel & Google Sheets. No macros, no subscription. Instant download: blank sheet, filled-in DEMO and a full PDF guide.

Digital download, available immediately. By buying, including with Google Pay or Amazon Pay, you agree to immediate access and that your 14-day right to cancel ends once your download is available. See our Terms and Refund Policy.

Category:
RestaurantsPubsCafésBarsHotelsTea roomsGastropubsBistrosTakeawaysFood trucks
Instant downloadLink straight after checkout and by email
Excel or Google SheetsMac, PC, Chromebook. No macros
Start Here guide built inPlain-English steps for every tab
Secure checkoutCard, Apple Pay and Google Pay

Sound familiar?

The rota is done. Nobody knows what it costs.

  • The rota on a whiteboard, photographed and sent round
  • Wages only add up on payday
  • Someone double-booked, or on a 14-hour shift
  • Tips shared out with a calculator

That’s not a you problem. It’s a missing-system problem.

Why managers love it

Type the shifts. The wage bill works itself out.

  • 1 week, 2 weeks or a month
  • Wage cost and % of sales against your target
  • Holiday, sick and training from a drop-down
  • A wall rota that prints itself
  • Tips shared by hours if you want it
  • Clash and long-shift warnings

Know before the week starts

Wages as a % of sales, every rota.

Example from the sample rota included in the file.

488Paid hours
£6,701Wage cost
18.0%Of sales, target 30%

How it fits together

Plan it once. The rest updates itself.

  1. StaffRates and contracted hours
  2. RotaStart and finish times
  3. Wage costHours and holiday pay
  4. Wall rotaReady to print
  5. TipsShared by hours
Staff rota dashboard with wage cost and wages as % of sales

The dashboard

Your wage bill before the week starts.

Paid hours, wage cost, holiday and sickness, tips and anything to check.

Staff40On one rota
Rota length1–4Weeks
Checks6Run on every rota
Monthly fees£0One payment, yours to keep

What’s inside

7 tabs, one file. Click through them.

Dashboard

Paid hours, wage cost, wages as % of sales against your target, holiday and sick days, tips shared and anything to check.

Printable wall rota for the staff noticeboard

Wall rota

The rota, without the group chat.

  • Prints by itself from your rota
  • Days off, holiday and sickness marked
  • Splits neatly across A4 pages
Tips shared by hours worked

Tips (optional)

Share tips fairly.

  • Hours come from the rota
  • You choose who shares tips
  • Optional card-fee deduction line

Before and after

From guessing to knowing.

Without it

  • Rota on a whiteboard
  • Wages found out on payday
  • Clashes spotted on the day
  • Tips shared with a calculator

With the sheet

  • A rota in one file
  • Wage cost and % of sales up front
  • Clashes and long shifts flagged
  • Tips shared by hours automatically

What you get

Everything in one download.

The rota workbookReady for your team
A filled-in DEMO copySee it working before you add your own
Full PDF user guideSet-up, every tab and the rules explained
Colour themesPick one to match your venue
Works everywhereExcel or Google Sheets, Mac or PC
Help if you’re stuckMessage me any time and I’ll help you set up

Up and running before service

Four steps.

  1. Buy and downloadThe link arrives straight away
  2. Open itIn Excel, or upload it to Google Sheets
  3. Check the DEMO and guideThen fill in your blank copy
  4. Start using itEverything else works itself out

Made for

  • Independent restaurants, pubs, cafés and hotels in the UK
  • Owners, managers and head chefs who do the admin themselves
  • Anyone who’d rather not pay monthly for software

Not for

  • Payroll, tax or National Insurance
  • Clocking in and out
  • Large chains with their own systems

A record-keeping spreadsheet, not legal, tax or accounting advice. Wage figures are estimates; check working-time, rest-break and tips rules for your staff.

Before you buy

Questions

Do I have to use the tips part?

No, it’s optional. Set Use tips? to No in Settings and the Tips tab stays out of the way.

Does it work out holiday pay and employer costs?

It works out hours, holiday hours and an estimated wage cost from hourly rates. You can add an on-cost uplift % in Settings. It is a planning tool, not a payroll system, so it does not calculate tax, National Insurance or pension.

Can I do night shifts?

Yes. Overnight shifts such as 22:00 to 06:00 are worked out correctly.

Do I need Microsoft Excel?

No. It works in Microsoft Excel, or free in Google Sheets.

Is it a subscription?

No. It is a one-off payment and the file is yours to keep. There are no monthly fees.

I'm not good with spreadsheets. Is this for me?

Yes. You type into the yellow boxes and everything else works itself out. There are no formulas to write, and the How to use tab walks you through it.

Can I see it before I buy?

Yes. Look through the screenshots above. Your download includes a filled-in DEMO copy and a full PDF guide as well as the blank spreadsheet, so you can see exactly how it works before adding your own.

Does it work on a Mac, iPad or phone?

Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app, but a computer is easier for setting it up.

Can I get a refund?

Because it is an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.

How do I get my file?

It is an instant digital download. You will get a download link straight after checkout, and by email.

What if I get stuck?

Message me any time and I will help you get set up.

Ready when you are

Plan the week, know the cost.

£29.99 once. Download it now and build next week’s rota.

Buy now, instant download

More spreadsheets for restaurants, pubs & cafés →

Full product details, tabs list and notes

Description

Sound familiar?

  • The rota lives on a whiteboard, so nobody knows what it costs until payday.
  • Someone is double-booked or works a 14-hour shift and you only spot it on the day.
  • Sharing tips fairly by hours means an evening with a calculator.

What the Staff Rota with Optional Tips does

Plan your staff rota for 1 week, 2 weeks or a month. Type each person's start and finish times, or pick Holiday, Sick and so on, and it works out hours, holiday pay, wage cost and wages as a % of sales. It flags double-booked names, very long shifts and anything it can't read. The Wall Rota tab is a tidy version for the staff noticeboard, and the optional Tips tab shares tips by hours worked.

What’s inside

  • How to use – step-by-step instructions and what the colours mean
  • Settings – your business name, lists for the drop-downs and a colour theme picker
  • Dashboard – paid hours, wage cost, wages as % of sales against your target, holiday and sick days, tips shared and anything to check
  • Rota – start, finish and break for every person, every day
  • Wall Rota – a clean printable rota for the noticeboard
  • Tips – tips shared fairly by hours worked
  • Staff – hourly rates, contracted hours, days worked and who shares tips

Format

  • Your blank spreadsheet (.xlsx, UK edition), ready for your business
  • A filled-in DEMO copy, so you can see every tab working before you start
  • A full PDF user guide: set-up, every tab explained, a daily routine, the rules that apply and answers to common questions
  • Works in Microsoft Excel (Windows and Mac) and Google Sheets
  • No macros, nothing to install, no subscription
  • Yellow boxes are for you to fill in; pale green boxes work themselves out

How it works

  1. Buy and download the file straight away.
  2. Open it in Excel, or upload it to Google Sheets.
  3. Open the DEMO and the PDF guide to see how it works, then fill in Settings on your blank copy and start typing your own.

Please note

This is a digital product — nothing will be posted. It is a record-keeping template, not legal, tax or food safety advice. For use in your own business only — please don’t resell or share the file.

Questions before you buy? Message me any time — happy to help!

Staff Rota with Optional Tips FAQ

Do I have to use the tips part?

No, it's optional. Set Use tips? to No in Settings and the Tips tab stays out of the way.

Does it work out holiday pay and employer costs?

It works out hours, holiday hours and an estimated wage cost from hourly rates. You can add an on-cost uplift % in Settings. It is a planning tool, not a payroll system, so it does not calculate tax, National Insurance or pension.

Can I do night shifts?

Yes. Overnight shifts such as 22:00 to 06:00 are worked out correctly.

Do I need Microsoft Excel?

No. It works in Microsoft Excel, or free in Google Sheets.

Is it a subscription?

No. It is a one-off payment and the file is yours to keep. There are no monthly fees.

I'm not good with spreadsheets. Is this for me?

Yes. You type into the yellow boxes and everything else works itself out. There are no formulas to write, and the How to use tab walks you through it.

Can I see it before I buy?

Yes. Look through the screenshots above. Your download includes a filled-in DEMO copy and a full PDF guide as well as the blank spreadsheet, so you can see exactly how it works before adding your own.

Does it work on a Mac, iPad or phone?

Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app, but a computer is easier for setting it up.

Can I get a refund?

Because it is an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.

How do I get my file?

It is an instant digital download. You will get a download link straight after checkout, and by email.

What if I get stuck?

Message me any time and I will help you get set up.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related products