Pre-built with role-based sections, automatic shift hour calculations, labor cost totals, and a Prime Cost summary. Works in Excel and Google Sheets — no signup required.
Excel & Google Sheets compatibleYour full roster with role, position, hourly rate, and weekly hours target. Color-coded by role (FOH, BOH, Bar, Management) with dropdown validation.
Mon–Sun grid with In/Out/Hrs sub-columns per day, organized by role section. Shift hours auto-calculate — including overnight shifts.
Financial summary connecting the schedule to your prime cost. Enter Net Sales and COGS — labor auto-populates from the schedule.
Click the download button above. Open in Excel, or import into Google Sheets (File → Import → Upload → Keep current format).
Replace the sample employees with your team on the Staff List tab. Set each person’s role, position, and hourly rate.
Enter shift times (e.g., 9:00 AM, 5:00 PM) in the gold cells. Hours, costs, and subtotals calculate automatically.
Switch to the Summary tab, enter your weekly Net Sales and COGS. Your prime cost percentage appears instantly with a status label.
Sideworks gives you everything in this template — plus drag-and-drop scheduling, real-time labor cost tracking, shift swaps, and prime cost alerts. All from your phone.
Yes. All formulas use standard spreadsheet functions compatible with both Excel and Google Sheets. To import: open Google Sheets, go to File → Import → Upload, select the .xlsx file, and choose “Keep current format.”
The template uses a MOD-based formula that correctly handles overnight shifts. For example, a shift from 10:00 PM to 6:00 AM will correctly calculate as 8 hours. Enter times in standard format and the formula handles the rest.
Yes. Each role section includes 3 blank rows. To add more, insert rows within a section (before the subtotal row) and copy the formulas from an existing employee row. Update the Staff List tab to match.
The Summary tab pulls total labor cost from each role section, lets you enter Net Sales and COGS, and automatically calculates your prime cost percentage. Color-coded status bands show whether you’re in the healthy range (≤60%) or need to take action (>70%).
No. The download is completely free and ungated. No email, no account, no strings attached.