CASE STUDY

Building a Housekeeping App In-House Rather Than Buying One

47 bedrooms · 26 changeovers a day · 12 housekeepers and 2 supervisors · built on systems already paid for

From a printed allocation sheet to a live view of the floor — and a way to measure it

47 bedrooms

Live daily in a working hotel

26 a day

Average changeovers to allocate and check

None

Per-room licence fees

The gap every operator knows

It is somewhere between eleven in the morning and half past two, and you cannot say with confidence how many of the day’s twenty-six changeovers are done, which of twelve housekeepers is behind, or whether the arrival at three is walking into a stripped bed. You find out when reception finds out, which is usually when the guest is standing at the desk.

For years the answer was paper: a printed allocation sheet in the morning, a radio call at lunchtime, and a housekeeper walking the corridor to check. It works, in the sense that the rooms get cleaned. It tells you nothing you can act on.

Why not simply buy the software

Housekeeping modules are generally priced per room per month. Run that arithmetic for a 47-bedroom property and the number is not outrageous — it is simply hard to justify against a problem nobody has measured yet. That is the honest reason for building instead of buying. Not vision: the suspicion of paying to solve something we could not yet describe.

What was built

It runs on Google Apps Script, which is to say it runs on the Google Workspace subscription already being paid for. That is not a recommendation of Apps Script as a platform. It is a recommendation of building on what you already own, because it removes the two things that kill internal projects at this scale: procurement, and the question of who owns the tool after the person who built it moves on.

The app does four things:

  • Distributes the day’s rooms to each attendant on their phone
  • Lets them mark a room complete with one tap
  • Asks for photographs on completion
  • Carries the small messages that used to travel by radio between twelve housekeepers, two supervisors and seven receptionists — guest is at breakfast, new arrival, extra towels needed

That last category matters more than it sounds. Most of what a housekeeper needs to pass on is not a status change; it is a small piece of context that expires within the hour. Getting it off the radio and onto a screen means reception can see it without interrupting anyone.

The part that actually pays

The app itself is a convenience. The reason to build it is what it lets you count.

Housekeeping is the largest variable cost line most independents have, and the one most often managed by feel. Twelve housekeepers and two supervisors against twenty-six changeovers a day is a real wage line, not a rounding error. Standard minutes per room type existed. Actual hours from the time and attendance system existed. The two had never been placed side by side on the same day. They now are — the day’s standard allowance against the minutes actually clocked, and the difference is the number.

Not total hours. Not cost per occupied room, which is an output rather than a lever. The variance, daily, against what that day’s checkouts and stayovers should have required.

What that gives an owner is not a stick. It is a definition. Before it, nobody could have said what a good housekeeping day looked like in that hotel — only whether the month’s wage bill felt high. Now there is a shape to argue with, and a way to see whether a change in allocation actually did anything.

Extending it across a portfolio

The same approach now covers serviced apartments, where the shape of the work is different: roughly fifty changeovers a week, no corridor to walk, and heavier photographic evidence at the end of each clean. A portfolio-level version follows the same logic across more than one property.

Small internal tools have a habit of buckling the moment you multiply them, and that is worth saying now rather than in a triumphant follow-up six months from now. But the counting travels even where the code does not.

What this means if you own a hotel

Three things, and the first two cost nothing.

  • Write down your standard minutes. Per room type, checkout and stayover separately. Most independents have never formally set these, or set them once and never revisited them after changing the linen or the amenity spec. You cannot measure variance without a standard, and setting one is worth the afternoon on its own.
  • Put your actual hours next to your actual checkouts, daily. Not monthly — a month hides everything. If your time and attendance system will not export easily, pull it by hand for a fortnight and see whether the picture is worth automating. You usually know within four days.
  • Then decide about software. If the variance turns out stable and small, buy nothing. If it is large and moves around, you have a management problem a purchase order will not fix — and now you have the evidence to go and fix it.

What is not claimed here

No saving, no percentage, no before-and-after. The app is live and in daily use, but a month of clean variance data does not exist yet, and a number you would have to defend is worth less than an honest blank. When there is one, it will be published here.

Is your housekeeping costing more than it should?

If you cannot say what a good housekeeping day looks like in your own hotel, that is the place to start — and it does not begin with buying anything.

More on this: hotel operations and performance · how to reduce hotel costs · all case studies