Employee Schedule Spreadsheet, Weekly Shift Planner, Labor Cost Calculator, Timesheet, Employee Scheduling, Excel Google Sheets

Employee Schedule Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Schedule your team in minutes and know your labor cost before the week starts. This Employee Shift Schedule turns simple shift codes into hours, overtime and pay for every employee. Perfect for restaurants, cafes and bars.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/wcdgPpYsB0U

✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition.

★ WHAT'S INCLUDED ★
• Clickable Start Here cover page with quick-start steps and a color key
• Labor Dashboard: staff scheduled, hours, weekly labor cost, budget left, labor % of sales, overtime hours and pay, average cost per hour, coverage shortfalls, time-off clashes, availability clashes, short rest, over max hours, time off to decide, on leave today and estimated month labor cost (16 KPI tiles)
• Dashboard tables: coverage for each day of the week, who is working today with shift times, alerts & to-dos, and labor cost by role
• 4 dashboard charts: hours and staff per day, labor cost by role, labor cost vs budget for all 6 weeks, and where this week's labor cost goes
• Monthly Rota: a 6-week grid for up to 50 employees. Pick a shift code from the drop-down and the cell colors itself. Hours per week, month hours, days worked and leave hours calculate automatically, plus daily staff, hours, wages and coverage rows
• Weekly Schedule: view any of the 6 weeks with shift times, hours, max hours, overtime, leave hours, estimated cost and an alert for each person (time-off clash, outside availability, short rest, over max, under min, too many days, overtime)
• Timesheet: regular, overtime and paid leave hours and pay, employer taxes & benefits, total cost and % of max hours for every employee
• Monthly Summary: hours and overtime for every week of the rota per person, 6-week cost, estimated month hours and cost, weeks over max
• Coverage: staff needed per day (AM, PM, night) vs scheduled, shortfall alerts for the week and for every day of the rota, with chart
• Labor Budget: weekly sales forecast, budget, labor cost, labor % vs target, status, 2 charts and a what-if planner (pay raise, fewer hours, less overtime, extra sales)
• Time Off log (100 rows): type, dates, status (pending, approved, denied), days, shifts already in the rota, clash alerts and PTO used
• Availability: Available, AM only, PM only or Not available for each weekday, preferred hours and clashes this week
• Staff View: pick a name for a printable 6-week schedule with shift times, weekly hours, PTO left and upcoming time off
• Employees (50 rows): role, department, type, hourly rate, min / max hours, start date, PTO days, contact info, hours and cost this week and month
• Setup: up to 20 shift codes (start, end, unpaid break, overnight shifts handled), weekly and daily overtime rules, overtime multiplier, employer taxes %, weekly labor budget, target labor %, minimum rest hours, roles, departments and time-off types
• Sample data version + blank ready-to-use version

★ PERFECT FOR ★
✓ Restaurants, cafes and bars
✓ Retail stores, salons and gyms
✓ Small businesses, clinics and care teams

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Purchase and download the .xlsx file instantly
2. Add employees and their rates
3. Set up your shift codes
4. Fill in the week and see hours and cost instantly

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
This is a digital download. No physical item will be shipped. Check your local labor laws for overtime rules. Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.