Employee Schedule & Timesheet Spreadsheet, Weekly Shift Planner with Overtime | Google Sheets & Excel Template

Build the weekly shift schedule for your team, log actual hours including overnight shifts, and see overtime, labor cost and PTO balances.

What's inside

• Staff list for up to 30 employees with role, hourly rate and PTO balance
• Weekly shift grid: start and end per day, hours with an unpaid-break rule
• Staff scheduled vs. needed per day and scheduled labor cost
• Timesheet with 500 rows: clock in and out, overnight shifts, breaks, PTO and paid holidays
• Payroll Summary per two-week pay period: regular vs. overtime hours per week (threshold you set)
• PTO accrued, used and balance per employee
• Dashboard with KPI tiles and gross pay, labor cost and overtime charts

Perfect for

Small business owners, shift leads and managers of cafes, shops, salons and offices. Pay figures are gross estimates — check your state's overtime rules.

What you get

• One .xlsx file with 7 tabs that works in Microsoft Excel 2016+ and Google Sheets
• A quick-start PDF guide
• A built-in Start Here tab with step-by-step instructions and example data you can clear

How it works

1. Buy the template.
2. Get your instant download link on the order confirmation page and in your email.
3. Open the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.

Digital product — no physical item will be shipped. Personal use only.
everything4notion is not affiliated with Notion Labs, Inc., Google or Microsoft.