Hotel Housekeeping Operations Toolkit: Housekeeping SOPs, Excel and Checklists

Full description

This toolkit is for executive housekeepers, assistant housekeepers, floor supervisors and rooms division managers who need one working system for the housekeeping department. It also suits owners of small hotels who run housekeeping without a dedicated manager. You get a spreadsheet that sizes the team and tracks quality and cost, a written SOP manual, printable forms and a ready training plan for new room attendants.

Save with a bundle: this template is also in the Hotel Rooms, Guest Experience & Spa Bundle, 16 templates for $39 instead of $112. All 141 templates are in the All-Access Hospitality Template Library for $79.

What is inside

1. Housekeeping_Model.xlsx (13 tabs, 3,349 formulas, 3 native charts)

• Start Here: tab guide, five-step setup, colour legend.
• Dashboard: 21 live measures across productivity, quality, stock, cost and control, with 3 charts.
• Settings: wage rates, shift length, room mix, credit minutes for 8 room statuses, thresholds, attendant list.
• Staffing_Model: attendants needed at 11 occupancy levels, and a 7-day staffing check with short or over flags.
• Productivity_Log: daily utilisation, rooms per attendant and labour cost per occupied room (14 sample days).
• Daily_Assignment: room board for 96 sample rooms, credit minutes and load per attendant.
• Linen_Par: 12 linen items with par, counts by location, variance, discard rate and cost to reach par.
• Consumables_Cost: 24 amenity, chemical and paper items against a standard cost per occupied room.
• Inspections: 10 weighted criteria scored 0 to 5, pass or fail, pass rate (40 sample inspections).
• Deep_Clean: cycle schedule for 40 rooms and 14 areas with overdue and due-soon flags.
• Lost_Found: log with status, days held and a hold-period review flag (25 sample items).
• Minibar_Restock: 12 items, a restock log (60 sample lines), revenue, margin and charges not posted.
• Lists: drop-down sources.

2. HK_SOP_Manual.docx (36 pages)

• 39 SOPs with 337 steps in one format: purpose, trigger, time target, equipment, steps, standards, safety, records.
• Covers room cleaning by status, turndown, bed making, bathrooms, DND, public areas, linen and laundry, chemicals, keys, lost and found, bed bugs, biohazards, emergencies, deep cleans.
• Roles, room status codes, service standards, escalation matrix, glossary.

3. HK_Checklists.pdf and HK_Checklists.docx (10 pages, 8 forms)

• Room checklist, public area checklist, supervisor inspection form, deep-clean sheet, trolley par checklist, key issue log, DND and welfare log, lost and found slip.

4. HK_Training_Plan.docx (12 pages)

• 10-day onboarding plan with daily schedule, 19-skill sign-off matrix, time ramp, 30-question quiz with answer key, review forms and a 30-60-90 day follow-up.

Also included: README.txt and the license terms.

How it works

1. Open Housekeeping_Model.xlsx. On Settings, enter your shift hours, wage rates, room mix and credit minutes.
2. Use Staffing_Model to set headcount from forecast occupancy, then fill Daily_Assignment each morning.
3. Log results in Productivity_Log, Inspections, Linen_Par, Consumables_Cost, Deep_Clean, Lost_Found and Minibar_Restock.
4. Read the Dashboard. Fix the items flagged red or amber.
5. Edit the manual, print the forms and run the training plan with new attendants.

Details

• Formats: XLSX (Excel 2010 or later), DOCX, PDF. English. A4 page size.
• Software: Excel or a compatible spreadsheet app, a word processor that opens DOCX, any PDF reader.
• Delivery: instant digital download. No physical item is shipped.
• Currency is a text label you edit. All money cells are plain numbers.

Good to know

• All names, numbers, rates, dates and examples are illustrative samples. Replace them with your own data.
• Wages, on-costs, chemical rules, lost property periods and work-at-height rules depend on your location. Cells and text that touch these say "Verify local requirements".
• This is a working tool, not legal, safety or employment advice.
• Single-user license: for your own property or team. Do not redistribute.

FAQ

Which software do I need? Excel 2010 or later for the model, any word processor for the DOCX files, and any PDF reader for the forms.

Does it work in Google Sheets? The formulas use standard functions, so the file opens and calculates in Google Sheets. Check the three charts and the drop-downs after import, as small display differences can occur.

Can I edit everything? Yes. Blue cells are inputs, yellow cells are key assumptions, and the Word files are fully editable. Replace [bracketed] fields with your own details.

Is this a physical product or a refundable item? It is a digital download. Nothing is shipped. Refund rules follow the store policy for digital products, so check it before you buy.

Who is it for? Executive housekeepers, rooms division managers, floor supervisors, and owners of small hotels or serviced apartments with in-house housekeeping.

Are the credit minutes official standards? No. They are illustrative defaults. Time your own rooms and enter your standards on the Settings tab.