Hotel Staff Roster
Plan a week of morning (M), evening (E), night (N) shifts and weekly offs (O) for front office, housekeeping, F&B and maintenance, with automatic counts of shifts and offs per person.
Preview
| Department | Employee | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Shifts | Offs |
|---|---|---|---|---|---|---|---|---|---|---|
| Front office | Neha | M | M | E | E | O | N | N | auto | auto |
| Front office | Vikram | E | E | O | M | M | M | E | auto | auto |
| Housekeeping | Sunita | M | M | M | O | M | M | M | auto | auto |
| F&B | Arjun | E | O | E | E | E | E | M | auto | auto |
How to use this template
- Avoid a night shift followed by a morning shift the next day.
- Plan housekeeping strength from forecast departures, not just occupancy.
Template FAQ
Is the Hotel Staff Roster free to download?
Yes. The .xlsx file is free with no sign-up. It opens in Excel, Google Sheets and LibreOffice.
What columns does the Hotel Staff Roster include?
Department, Employee, Mon, Tue, Wed, Thu, Fri, Sat, Sun, Shifts, Offs.
Which columns are calculated automatically?
Shifts, Offs are filled by formulas, so you only enter the other columns. Formulas stay visible so you can audit or change them.
When should I move from this spreadsheet to Hotel & Hospitality ERP?
Use the spreadsheet while one person maintains it. Move to hotel management software when several people need to update it, you need approvals and history, or the numbers must post to GST accounting and reports automatically.
Related tools and templates
RevPAR, ADR & Occupancy Calculator
Free RevPAR calculator for Indian hotels: work out occupancy rate, ADR (average daily rate) and RevPAR from rooms, room-nights sold and room revenue — with formula and worked example.
Use calculator → Free toolSalary Calculator
Free in-hand salary calculator for India: convert annual CTC to monthly take-home after PF, ESI, professional tax and income tax (new regime FY 2025-26).
Use calculator → Free toolGST Calculator
Free GST calculator: add GST to a price or extract GST from an inclusive amount at 5%, 18% or 40%, with CGST/SGST or IGST split.
Use calculator → TemplateEmployee Joining Checklist
Free employee onboarding checklist for Indian companies: documents, PAN, Aadhaar, UAN, ESI, bank details, offer letter, policies, assets and payroll setup.
Download →