7 Signs Your Hotel Is Running on a Shadow Spreadsheet
Most hotels have one: the master spreadsheet only one person can open. Here's a 7-point checklist to see how deep it runs, and what to do about it.
Every hotel has one. It doesn't have an official name, it's just "the spreadsheet." The one that started as a quick fix two years ago and quietly became load-bearing. Nobody signed off on it. Nobody designed it. It just grew, tab by tab, until half the property's decisions run through it.
This isn't a critique of whoever built it, usually a revenue manager or GM doing the only thing they could with the tools they had. It's just worth knowing when it's happened.
A shadow spreadsheet is any manually-built file (usually Excel) that quietly does the job your PMS, RMS, or reporting tools were supposed to do. It's not officially owned, documented, or backed up, but the hotel depends on it daily.
Here's a quick, honest checklist for how to spot one. Most hotels will recognise at least four of these:
1. Only One Person Knows How to Open It
Not "how to read it", how to open it. Which tab feeds which formula, why one column is hidden, what the colour coding means. If that person is out sick, the report doesn't happen that day.
2. It Gets Emailed Around Every Friday
Weekly, manual, and by the time it lands, it's already describing last week.
3. You Built It Because the System Couldn't
Every hotel has a report their PMS or RMS simply won't produce natively, so someone built a workaround in Excel instead. The system still works fine. It just doesn't do this one thing.
4. Decisions Wait a Day for the Data to Catch Up
This is the one that costs money quietly. Not a crisis, just a rate that should have moved yesterday, moving today instead.
5. You Find Money by Accident, Not by Design
The spreadsheet catches what it catches. It doesn't go looking. Which means the leaks it finds tend to be the ones somebody happened to notice.
6. Two Systems, Two Numbers, No One's Sure Which Is Right
Every hotel running more than one property, or more than one revenue source, has hit this: the RMS says one thing, the spreadsheet someone built to sanity-check it says another, and reconciling the two becomes its own weekly task.
7. The Work Happens, and Nothing Happens Because of It
This is the quiet one. The report gets pulled, formatted, sent, and then sits there.
So, What's Your Shadow Spreadsheet Score?
- 0–2: You're in reasonably good shape, or you haven't looked closely yet.
- 3–5: Normal. Most hotels live here. Worth knowing where the single points of failure are.
- 6–7: The spreadsheet isn't a workaround anymore. It's infrastructure, and it's running on one person's memory.
None of this means anyone did anything wrong. It means the systems hotels are given were never built to talk to each other, and someone stepped up to bridge the gap by hand. That's not a staffing problem. It's a tooling one.
Otel connects to the systems you already run, Opera, IDeaS, Excel, and does the stitching automatically, so the report that used to live in one person's head lives somewhere everyone can see it. No rip-and-replace. No new system to learn.
Worth 15 minutes to see what Otel catches for your property? Talk to our team.
Continue reading
Related articles
AI and the Hotel Revenue Manager: An Honest Career Guide for 2026
From an AI company: what junior revenue managers should focus on to stay indispensable as AI takes over the routine work. Practical, honest, specific.
Paul Ryan·6 Aug 2026
Why Hotel Revenue Teams Lose Hours Every Morning - And How AI Fixes It
Hotel revenue data exists - the problem is finding it. Discover how Otel AI connects your systems and delivers intelligent, actionable briefings straight to your inbox.
Paul Ryan·4 Jun 2026
How Manual Reporting Is Costing Your Hotel Revenue Every Morning
Discover how manual data gathering delays pricing decisions and costs your hotel revenue. See how The Alex Hotel gained +8.6% RevPAR with Otel AI's Flows.
Paul Ryan·28 Apr 2026