Employee Shift Schedule Template & PTO Tracker | Excel Weekly Staff Schedule

Build next week's staff schedule in minutes - and always know who has PTO left.

This employee shift schedule template is an Excel workbook: pick a shift code for each person and day, and it works out paid hours, labour cost and daily coverage, while a PTO log keeps every employee's vacation, sick and personal days balanced.

WHAT'S INCLUDED

• Staff list (20 employees): role, hourly rate, yearly PTO allowance and days carried over• Shift Codes (15): start and end time, unpaid break and paid hours (overnight shifts supported), plus OFF and PTO codes• Weekly Schedule: type the week start date, choose shifts from drop-downs; hours per day, total hours, labour cost per person, people working each day; over 40 hours flagged red• PTO Log (300 rows): start date, employee, type (vacation, sick, personal, unpaid), days, approved / pending / no• PTO Balance: allowance, carried over, used by type and remaining days per employee (2 days or fewer flagged)• Dashboard: scheduled hours, weekly labour cost, employees, PTO days used, pending requests, hours-by-employee and PTO charts

BEST FOR

Small business owners and managers of cafes, restaurants, retail shops, salons, clinics and small teams who schedule hourly staff.

HOW IT WORKS

1. Add your staff and shift codes2. Fill the Weekly Schedule with drop-downs3. Log time off in PTO Log - balances update automatically

IMPORTANT

A planning tool, not payroll or legal/HR advice - check local labour rules for overtime and leave.

FORMAT / DELIVERY

• Microsoft Excel (.xlsx) - also opens in Google Sheets and LibreOffice• Sample data included so you can see how it works• Instant digital download - no physical item is shipped

FAQ

What exactly do I get?

Employee shift schedule template for Excel: weekly roster with shift codes, hours and labour cost, plus PTO log and PTO balances.

What do I need to use it?

Microsoft Excel on Windows or Mac (Excel 2016 or newer, or Microsoft 365). It also opens in free Google Sheets, though Excel is recommended.

How do I get it?

It is an instant digital download: right after payment you get the file on the page and by email. No physical item is shipped.

What if it is not right for me?

Contact me through my Payhip store within 30 days and I will refund you - no hard feelings.

I have a question

Use the contact link on my Payhip store page and I will help.