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.
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.
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.
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.
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.
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.
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.
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.
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.
Here is a preview of how shift assignments look inside the template:
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 ActsOvertime 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 SafetyMandatory 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 provisionsMost 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.
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.
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.
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.
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.
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.
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.
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.
| 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 |
Download the free shift schedule template and plan your entire week in 15 minutes.
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.
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.