Free Hospitality Template
Hotel Pre-Opening Checklist & Excel Spreadsheet
Track every milestone from T-6 months to launch day across 11 operational workstreams—and download the ready-to-use Excel (.XLS) or Google Sheets template.
Hotel Pre-Opening Critical Path Tracker
Update task statuses right in your browser or download the formatted Excel spreadsheet (.xls) and CSV template for Microsoft Excel or Google Sheets.
| ID | Phase | Department | Pre-Opening Milestone & Notes | Owner | Priority | Status |
|---|---|---|---|---|---|---|
| PROP-01 | T-6 to T-3 Months | Property & Legal | Obtain hotel operating permits, CAC registration, state tourism board registration & liquor license Ensure state hospitality & signage permits are filed early | Owner / Legal | Critical | |
| PROP-02 | T-90 to T-60 Days | Property & Legal | Complete guest room fit-out, reception desk, restaurant/bar, kitchen commissioning & laundry room Room-by-room snagging & contractor handover list | Project Manager | Critical | |
| PROP-03 | T-90 to T-60 Days | Property & Legal | Test fire safety systems, extinguishers, smoke detectors, CCTV & access control doors Document fire certification and emergency exits | Chief Engineer / Security | Critical | |
| PROP-04 | T-90 to T-60 Days | Property & Legal | Install property-wide Wi-Fi access points & verify coverage in every guest room and public area Separate guest Wi-Fi VLAN from operations/POS network | IT Lead | High | |
| SOP-01 | T-90 to T-60 Days | Operating Model & SOPs | Document end-to-end Guest Journey SOPs (Booking → Arrival → Check-In → Stay Requests → Checkout) Define system owner and escalation path for each step | General Manager | Critical | |
| SOP-02 | T-90 to T-60 Days | Operating Model & SOPs | Define inter-departmental handoff SOPs (Front Desk ↔ Housekeeping ↔ Maintenance ↔ F&B ↔ Accounts) Eliminate WhatsApp/paper relay bottlenecks | General Manager | High | |
| HR-01 | T-90 to T-60 Days | Staffing & Training | Hire core leadership (General Manager, Front Office Lead, Accountant, Head Housekeeper, Chief Engineer) Hire department heads before frontline staff | Owner / HR | Critical | |
| HR-02 | T-30 Days | Staffing & Training | Complete frontline recruitment (Receptionists, Room Attendants, Waitstaff, Kitchen, Security) Verify references, guarantors & shift rosters | General Manager / HR | Critical | |
| HR-03 | T-30 Days | Staffing & Training | Train all staff on PMS, POS, housekeeping app workflows & role-based system permissions Run live scenario drills (early arrival, room change, disputed charge) | General Manager / IT | Critical | |
| TECH-01 | T-90 to T-60 Days | Technology & PMS | Deploy connected Property Management System (Oriald PMS) with room categories, numbers & rate plans Verify offline-resilient check-in & folio billing | IT Lead / GM | Critical | |
| TECH-02 | T-30 Days | Technology & PMS | Configure Restaurant & Bar POS outlets and link direct room-charge posting to guest folios Test kitchen order tickets & bar inventory tracking | IT Lead / F&B Manager | Critical | |
| TECH-03 | T-30 Days | Technology & PMS | Set up electronic RFID keycard locks & integrate room access/occupancy telemetry with PMS Stock spare lock batteries & encoder at reception | IT Lead / Chief Engineer | High | |
| COMM-01 | T-90 to T-60 Days | Reservations & Commercial | Launch hotel website, Google Business Profile, professional room photography & direct booking engine Ensure rate parity and clear cancellation/deposit policies | Commercial / Marketing | Critical | |
| COMM-02 | T-30 Days | Reservations & Commercial | Set up room rate tiers (Standard, Corporate, Weekend, Promotional) & minimum CPOR rate floor Never price rooms below Cost Per Occupied Room (CPOR) | General Manager / Owner | High | |
| FO-01 | T-30 Days | Front Office & Guest | Configure QR-based Guest Smartphone Portal in rooms (Wi-Fi codes, live bill view, room service & chat) Place QR standees in every room before soft opening | Front Office Manager | High | |
| FO-02 | T-14 Days (Mock Launch) | Front Office & Guest | Test complete guest arrival, ID capture, deposit collection, room assignment & shift handover report Target <3 minutes per guest check-in | Front Office Manager | Critical | |
| HK-01 | T-30 Days | Housekeeping & Rooms | Procure par stock of bed linens, towels, bath amenities, cleaning chemicals & housekeeping trolleys Minimum 3 par sets of linen per bed recommended | Executive Housekeeper | Critical | |
| HK-02 | T-14 Days (Mock Launch) | Housekeeping & Rooms | Test real-time room lifecycle in PMS (Occupied → Checked Out → Dirty → Cleaning → Inspected → Ready) Supervisor must verify room inspection checklist before Ready status | Executive Housekeeper | Critical | |
| MAINT-01 | T-30 Days | Maintenance & Facilities | Commission & test all room split ACs, water heaters, plumbing pressure, TVs, and intercoms Log serial numbers and preventive maintenance schedule | Chief Engineer | Critical | |
| MAINT-02 | T-14 Days (Mock Launch) | Maintenance & Facilities | Set up digital fault reporting workflow (Issue logged → Priority assigned → Repaired → Verified) Prevent reactive maintenance surprises for paying guests | Chief Engineer | High | |
| NRG-01 | T-30 Days | Energy & Power | Test backup diesel generators, ATS changeover panels, inverter/solar banks & fuel tank gauges Establish daily diesel log and generator runtime tracking | Chief Engineer | Critical | |
| NRG-02 | T-14 Days (Mock Launch) | Energy & Power | Configure vacant-room AC & water heater auto-shutoff / standby controls linked to checkout status Eliminate 25-40% power waste in unoccupied rooms | Chief Engineer / IT | High | |
| FIN-01 | T-30 Days | Finance & Controls | Set up dedicated corporate bank accounts, POS card terminals, transfer verification & cash float rules Prohibit personal staff accounts for guest transfers | Accountant / Owner | Critical | |
| FIN-02 | T-14 Days (Mock Launch) | Finance & Controls | Establish daily cashier shift handover reconciliation (Cash, POS, Bank Transfers vs PMS Folios) Enforce approval rules for discounts, voids, and refunds | Accountant | Critical | |
| LAUNCH-01 | T-14 Days (Mock Launch) | Mock Opening & Launch | Run full Mock Opening simulation (test reservations, check-in, F&B room charges, checkout & night audit) Fix every workflow bottleneck discovered during trial stays | General Manager | Critical | |
| LAUNCH-02 | T-7 Days to Launch | Mock Opening & Launch | Execute final 100-point room readiness inspection, lock opening week rosters & conduct all-hands briefing Confirm owner dashboard & daily KPI reporting are live | General Manager / Owner | Critical |
How to Use This Hotel Pre-Opening Excel Template
Opening a hotel is an operational project, not just a construction handover. Without a structured critical-path spreadsheet, critical dependencies—such as configuring your Property Management System (PMS), linking restaurant POS room charges, testing generator changeover panels, and running mock guest simulations—often get pushed into opening week.
You can update task statuses directly in the interactive table above to calculate your live readiness percentage, or click Download Excel (.XLS) to save a formatted spreadsheet with your custom statuses included.
