What you can do with it
Weekly rota
Start and end times for up to 40 people; overnight shifts supported.
Paid hours & overtime
Unpaid break rule, weekly overtime threshold and multiplier.
Labour cost
Per person and per day, and as a % of your sales forecast.
Coverage vs required
People on shift every hour of the week; red where you are short.
Contract checks
Over maximum hours, under contracted hours, missing times or rates.
Dashboard
Hours, cost, labour %, overtime, cover gaps and a cost-by-day chart.
See it before you buy
What's in the download
| ShiftBook-Example.xlsx | Example workbook filled with sample data, to explore first |
| ShiftBook-Blank.xlsx | Blank workbook, ready for your own data |
| README.txt | Setup and how-to guide |
| CHANGELOG.txt | Version history |
| LICENSE.txt | Licence terms |
Version 1.0.0. One ZIP file, no installer, nothing sent anywhere.
Why buy it instead of building it
Checked against an independent calculation
Before release, every formula is compared with a separate model, including edited data and deliberately bad entries.
Starts with a worked example
Open the Example workbook to see it filled in, then type your own numbers into the Blank one.
A person answers support email
Write to [email protected] and get a reply within 2 business days. If it doesn't work as described, you get a refund within 30 days.
What you need
- Microsoft Excel 2010 or later
- Tested in Microsoft Excel for Windows (Microsoft 365)
- No macros or add-ins
- Google Sheets, LibreOffice and Numbers not tested
What it doesn't do
- Does not check employment law (minimum wage, rest rules, holiday pay).
- One week per sheet; 40 staff.
- Coverage shows after-midnight hours on the shift's start day.
ShiftBook is part of the Cafe & Restaurant Kit
Get 3 products for $16.10$23 instead of $33:MenuCost, ShiftBook, StockBook.
Buy the kit for $16.10$23How buying works
- Pay onceCheckout by Polar or Gumroad. Card details never touch this site.
- Download straight awayThe download link appears after payment and arrives by email with your receipt.
- Open and use itOpen the Example workbook, then enter your own data in the Blank one.
Questions
Does it handle shifts past midnight?
Yes — type the end time (e.g. 02:00) and it counts as the next morning.
How is labour % calculated?
Labour cost for the day divided by the sales forecast you enter for that day.
What if it doesn't work for me?
Email [email protected] within 30 days of purchase. We'll try to fix the problem first; if we can't, you get a full refund through the store you bought from.
