Free Restaurant Staff Shift Schedule Template (Excel) for India

An editable Excel template with 8 pre-built shift types, auto-overtime calculation at 2x wages, and a daily coverage summary to keep your restaurant fully staffed during every peak hour. Updated May 2026.

  • Auto-calculates overtime at 2x normal wages when any employee crosses 48 hours/week (Section 14, Factories Act 1948)
  • Coverage summary shows staff count per shift per day, so you spot understaffing before service starts
  • 8 restaurant-specific shift codes: Morning, Afternoon, Evening, Split, Night, General, Half Day, and OFF
No spam. Instant download link to your email.
Petpooja presents
Restaurant Staff Shift Schedule
For Indian Restaurants
5
Excel sheets · 48h/week limit
FY 2025-26
What's Inside

Five sheets covering every shift scheduling need.

01

Staff Master

Employee directory with 10 sample entries. Captures name, role, department (kitchen/service/bar), default shift, weekly off day, and hourly wage rate for overtime calculations.

02

Shift Types

8 pre-built restaurant shift patterns: Morning (M), Afternoon (A), Evening (E), Split (S), Night (N), General (G), Half Day (H), and OFF. Each includes start time, end time, break duration, and net working hours.

03

Weekly Schedule

Assign shifts using dropdown codes for each employee across 7 days. Total weekly hours auto-calculate. Any employee exceeding 48 hours gets flagged in red with an overtime alert.

04

Auto Overtime Tracker

Flags every employee working beyond 48 hours/week or 9 hours/day. Calculates overtime hours and cost at 2x the normal wage rate, per Section 14 of the Factories Act 1948.

05

Coverage Summary

Shows total staff count per shift per day. Spot gaps instantly: if only 2 kitchen staff are on for a Friday dinner rush, you know before the week begins, not during service.

06

Monthly Overview

Rolls up 4 weeks of data into a monthly view. Tracks total hours, overtime hours, and estimated OT cost per employee. Useful for payroll handover and labour cost forecasting.

Why This Matters

Why Shift Scheduling Is the Hardest Part of Running an Indian Restaurant

Indian restaurants have two distinct rushes every day. Lunch between 12 PM and 3 PM. Dinner between 7 PM and 11 PM. The gap in between is where most scheduling problems start.

A fine-dine restaurant in Mumbai needs full kitchen and service teams during both peaks. But keeping everyone on-site from 10 AM to midnight means 14-hour shifts, which violates the Shops & Establishments Act in most states. The legal maximum under Indian labour law is 9 hours per day and 48 hours per week.

Split shifts solve the peak-hours problem. A cook clocks in at 10 AM, works till 3 PM, takes a break, and returns at 7 PM for dinner service. But split shifts must not exceed 10.5 hours of spread-over time in most state rules. Tracking this manually across 15 to 25 staff members, seven days a week, is where errors happen.

Then there is overtime. Under Section 14 of the Factories Act 1948, overtime must be paid at twice the normal wage rate. If a waiter earning ₹300/day works even one extra hour beyond the daily limit, that hour costs ₹75 instead of ₹37.50. Multiply that across your team and a month, and untracked overtime quietly adds ₹15,000 to ₹30,000 to your payroll.

This template gives you a single sheet where every shift, every hour, and every overtime flag is visible before the week starts. You assign shifts with dropdown codes, and the formulas handle the rest: total hours, overtime alerts, coverage gaps, and monthly cost estimates.

Sample Preview

5 rows from the weekly schedule.

Here is a preview of how shift assignments look inside the template:

Ramesh K. (Head Chef): Mon M, Tue M, Wed M, Thu S, Fri S, Sat S, Sun OFF. Total: 51 hrs. OT FLAG: 3 hrs overtime at 2x rate
Priya S. (Server): Mon E, Tue E, Wed OFF, Thu E, Fri E, Sat E, Sun A. Total: 45 hrs. Within limit.
Arjun M. (Sous Chef): Mon S, Tue S, Wed S, Thu OFF, Fri M, Sat M, Sun M. Total: 48 hrs. At limit, no overtime.
Kavita D. (Bartender): Mon N, Tue N, Wed N, Thu N, Fri OFF, Sat N, Sun N. Total: 48 hrs. Night shift allowance noted.
Coverage Summary (Saturday): Kitchen: 4 staff (M+S shifts). Service: 3 staff (E shift). Bar: 2 staff (N shift). Total: 9 on duty.
... plus 5 more staff entries, full coverage grid, and monthly rollup in the complete Excel file.
Key Stats

The labour law numbers every restaurant owner must know.

48hrs/wk

Maximum working hours per week for any employee. Exceeding this without overtime pay is a violation under most state Shops & Establishments Acts.

Source: Model Shops & Establishments Act; state-specific S&E Acts
2xrate

Overtime must be paid at twice the ordinary rate of wages. Not 1.5x. Not a flat bonus. Double the hourly rate for every overtime hour worked.

Source: Section 14, Factories Act 1948; Section 59, new Labour Code on Occupational Safety
30min

Mandatory rest interval after 5 hours of continuous work. No employee can be required to work more than 5 hours straight without a break.

Source: Section 55, Factories Act 1948; state S&E Act provisions
Common Mistakes

8 shift scheduling mistakes that cost Indian restaurants real money.

01

No written shift schedule posted at the restaurant

Most state Shops & Establishments Acts require a shift roster to be displayed at the workplace. During a labour inspection, the first thing an officer asks for is the written schedule. No document means an automatic notice.

02

Exceeding 48 hours/week without overtime pay

Many restaurants run 6-day weeks with 9+ hour shifts. That is 54+ hours. Every hour beyond 48 must be compensated at 2x the normal wage per Indian salary structure and labour law rules. Ignoring this creates a wage arrears liability that compounds month after month.

03

Split shifts with more than 10.5 hours spread-over

A common setup: 10 AM to 3 PM, then 6 PM to 11 PM. That is a 13-hour spread. Most state rules cap spread-over at 10.5 hours for split shifts. Anything beyond that is a violation, even if total work hours are only 8.

04

No mandatory weekly off day for staff

Every employee is entitled to one paid day off per week under the Shops & Establishments Act. In practice, many restaurant workers go 10 to 15 days without a break. This is both a compliance risk and a retention killer.

05

Kitchen and service shifts not aligned with peak hours

Kitchen prep starts at 9 AM, but service does not begin until 12 PM. If both teams start at the same time, the kitchen is idle for 3 hours while servers are waiting for food. Stagger shifts to match actual demand curves.

06

No overtime register maintained

Section 31 of the Factories Act requires a separate overtime register (Form 10 or equivalent). Recording overtime only in the general attendance register is not sufficient. An inspector can fine you for the missing register alone.

07

Ignoring state-specific S&E Act rules

Working hour limits, spread-over caps, and overtime rules vary by state. Maharashtra allows 10 hours/day with overtime. Karnataka caps at 9 hours. Applying one state's rules across multi-city outlets is a guaranteed compliance gap.

08

Same staff doing opening and closing (fatigue risk)

Opening at 9 AM and closing at 11:30 PM is a 14.5-hour day. Even with a break, this exceeds every legal limit. It also leads to kitchen accidents, food safety errors, and high attrition. Rotate opening and closing duties across the team.

Comparison

Manual scheduling vs this template.

Aspect Manual / WhatsApp Scheduling With This Template
Shift assignment Verbal or WhatsApp messages, no record Dropdown codes per employee per day, saved in Excel
Overtime tracking Not tracked until payroll day, then estimated Auto-flagged the moment any employee crosses 48 hrs/week
Coverage visibility Manager holds it in their head Coverage summary shows staff count per shift per day
Weekly off compliance Informal, often skipped during busy weeks OFF code enforced, visible in schedule grid
Labour law compliance Discovered during inspections 48-hour cap and spread-over limits built into formulas
Monthly cost estimation Known only after payroll is processed Monthly overview sheet estimates OT cost before month ends
Time to create weekly roster 30 to 60 minutes of back-and-forth Under 15 minutes using dropdown codes

Stop scheduling shifts on WhatsApp groups.

Download the free shift schedule template and plan your entire week in 15 minutes.

FAQ

Frequently asked questions.

What is the maximum working hours per day for restaurant staff in India?
Under most state Shops & Establishments Acts, the daily limit is 9 hours of work (excluding breaks). The Factories Act 1948 also sets a 9-hour daily cap. Including overtime, the absolute maximum is typically 10 to 10.5 hours depending on the state. The weekly cap is 48 hours across all days.
How is overtime calculated for restaurant staff in India?
Overtime is paid at twice (2x) the ordinary rate of wages under Section 14 of the Factories Act 1948 and equivalent provisions in state S&E Acts. If an employee's hourly rate is ₹50, every overtime hour costs ₹100. This template auto-calculates the overtime cost based on the hourly wage you enter in the Staff Master sheet. To understand how overtime fits into overall salary and CTC calculations, see our calculator template.
Can I customize the shift types in this template?
Yes. The Shift Types sheet is fully editable. You can change start times, end times, break durations, and add new shift codes. The Weekly Schedule dropdowns will automatically reflect your changes. You can also rename shift codes to match your restaurant's internal naming convention.
Does this template work for multiple outlets?
The template is designed for a single outlet. For multiple locations, duplicate the file and maintain one per outlet. Each outlet may have different shift patterns and staffing levels. Make sure each outlet also has its own opening and closing checklist. If you manage 3 or more outlets, Petpooja Payroll offers a multi-location dashboard that handles shift scheduling across all branches from one screen.
What is a split shift and is it legal in India?
A split shift divides the workday into two parts with a long break in between. For example, 10 AM to 3 PM and 7 PM to 11 PM. Split shifts are legal in India, but most state Shops & Establishments Acts cap the total spread-over time (first clock-in to last clock-out) at 10.5 hours. In the example above, the spread is 13 hours, which would exceed the limit in most states. If your team uses split shifts, make sure PF and ESI compliance is also covered for all shift workers.

About Petpooja

Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.

Automate shift scheduling and attendance with Petpooja Payroll

Petpooja Payroll includes a flexible shift module with 24-hour and overnight shift support. Biometric and face recognition attendance that works with oily and wet fingerprints. Auto-overtime calculation, WhatsApp salary slips, and a multi-location dashboard. 30,000+ businesses already use it.

Book a Free Demo Call: +91-72280 34343