Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Stop Building Rooming Lists for Every Hotel by Hand, and Stop Them Going Out Wrong?
Problems We Solve

How Do We Stop Building Rooming Lists for Every Hotel by Hand, and Stop Them Going Out Wrong?

Tour operators build rooming lists by hand from bookings, sharer notes and late changes. We generate them per hotel from live bookings, with changes tracked.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Rooming lists are usually rebuilt by hand for each hotel on each departure, copying names, room types, sharers and requests from the booking system. Late changes then go out as separate emails, and the hotel's copy drifts. We generate each hotel's rooming list from the live bookings, in the format the hotel wants, and send only the changes when anything moves.

Three weeks before departure, the copying starts

A departure of eighteen passengers staying in four hotels needs four rooming lists. Somebody opens the booking system, copies names into a spreadsheet, works out who is sharing with whom from the booking notes, marks the singles, adds the dietary notes and the ground floor request, and emails it to the first hotel. Then they do the same for the next one, which wants a different layout.

Two days later a couple change from a double to twins. A single traveller who had asked to share is now paying the single supplement. One passenger cancels. Each change is an email to four hotels, and at arrival one of them still has the old list printed at reception.

Why rooming lists go wrong

The information is correct in the booking system, more or less. The problems come from copying it by hand, per hotel, and then keeping four copies in step.

  • Sharing arrangements sit in free-text notes, not in a field the list can use.
  • Names are spelled differently on the booking and on the passport details.
  • Each hotel asks for a different layout, so no template fits all of them.
  • Changes after the first list are sent piecemeal and nobody tracks which version each hotel has.
  • Requests such as adjoining rooms or a walk-in shower live in a separate notes column.

What a wrong list costs on arrival night

A tired group arrives at 7pm. Two friends who booked twins have been given a double. A passenger's gluten-free note never reached the kitchen. Someone who cancelled is still on the list and the hotel charges the room. The tour leader spends the first evening at reception fixing it, and the passengers' first impression of the trip is the queue.

In the office, the cost is hours spent building lists by hand every week in the busy months, and the worry that one of the dozens sent this month is wrong.

Rooming lists generated from the bookings

We build rooming list generation into your booking workflow, so the list is produced rather than typed.

  1. Room sharing becomes structured data on the booking: who shares with whom, room type and bed type, rather than a line in the notes. Existing notes are converted once, with a person checking the ones that are unclear.
  2. Passenger names come from the booking, and the list flags any name that differs from the passport details you hold.
  3. Each hotel has its own template, set up once: columns, order, language, and whether they want dietary and mobility notes on the same sheet.
  4. The list for every hotel on a departure is generated in one step, as a spreadsheet or PDF, and sent from your mailbox with a version number.
  5. When a booking changes, the system works out which hotels are affected and prepares a change notice showing only what moved, with the new version attached.
  6. The system records which version each hotel has acknowledged, so you can see at a glance who is out of date.
ChangeOld wayNew way
Double to twinEmail each hotelChange notice generated for affected hotels
Passenger cancelsRemember to tell everyoneRemoval appears on the next version
New sharer matchedEdit four spreadsheetsOne booking change, lists regenerated
Hotel asks which list is currentSearch sent itemsVersion and acknowledgement shown

The week before departure, done differently

The operations person opens the departure, checks the sharing summary, and sends all four rooming lists at once. When the double becomes twins, the change notice goes to the three hotels where it matters. The day before arrival, a final version goes out, and the tour leader gets the same list on their phone.

If a hotel has not acknowledged the latest version, it shows on the departure screen, and someone rings them. That is the only manual chasing left.

Is rooming list day a problem in your office?

  • Rooming lists are copied by hand from the booking system.
  • Sharing arrangements are written in booking notes.
  • Each hotel's list is formatted separately.
  • Late changes go out as loose emails without version numbers.
  • Tour leaders find room mix-ups on arrival.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Hotels all want different formats. Can it cope?

Yes. Each hotel's template is set up once and reused for every departure, including layout and the language of the headings.

Do we have to change booking systems?

No. We work from the data in your current system. The main change is recording sharing as structured information rather than free text.

What about passenger data we should not send?

Templates include only the fields you choose for each hotel. What you share with suppliers is your decision under your own data policy.

Can hotels confirm receipt electronically?

They can reply to the email or click a confirmation link, and the system records it against the version. Hotels that just print it can be marked by hand.

How much work is the set-up?

Mostly the hotel templates and the one-time tidy of sharing notes. We scope it against your number of hotels and departures before building.

Keep reading

More on Problems We Solve

Start here

Tell us how your tour programme is run today

Describe your departures, how bookings come in, what you use to hold them (a reservations system, spreadsheets or both) and where the supplier paperwork lives. We will tell you what we would build, and if your current booking system can already do it with better setup, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →