Version four of the coach tour's list
The tour operator's rooming list for next Thursday arrives as a spreadsheet: forty-two names, room types, sharing arrangements and dietary notes in a comments column. Your reservations manager sets aside an afternoon to enter it into the group block in the PMS. Twin, twin, double, single supplement, two surnames in one cell, a note saying 'please put Mr and Mrs Jones near the lift'.
Two days later version five arrives. The subject line says 'updated list' and nothing else. Somewhere in forty-two rows, three names have changed, one twin has become two singles, and a wheelchair user has been added. Finding those differences means holding the two spreadsheets side by side and reading line by line.
Then the wedding coordinator sends her guest list as a PDF, the football club sends theirs as a photo of a handwritten sheet, and the conference organiser sends a link to a shared document that keeps changing.
Why the retyping never goes away
Your PMS can hold a group block and a set of named reservations inside it. What it cannot do is understand a spreadsheet laid out by somebody else. Every group organiser uses their own template, their own words for room types and their own way of showing who shares with whom.
- Room types are described differently: 'twin', 'two singles', 'TWN', 'double for 2 friends'.
- Sharers are shown by merged cells, colour, or the same number in a column.
- Special requests and dietary needs are mixed into one notes field.
- Updated versions are sent whole, with no indication of what changed.
- Some PMS products can import a file, but only in their own fixed format, so someone still has to rebuild the list first.
So the job falls to a person who is good at it, and each group takes as long as that person's afternoon allows.
What the retyping costs
Hours of reservations time for every group, repeated for every new version. Errors that are easy to make and hard to spot: a name spelled wrong on the key card envelope, a twin set up as a double, a dietary note that never reached the kitchen. On the day of arrival, the coach pulls up and forty people wait in the lobby while the desk untangles two rooms that the list had wrong.
There is also the risk that a change never gets entered at all, because version five looked the same as version four at a glance. You find out when a guest who was taken off the list is still charged for the room, or a new guest arrives with no reservation.
How we build a rooming list importer
- The organiser's file is dropped into the importer or forwarded to a dedicated address. Spreadsheets, CSVs and PDFs are all read. For scanned or handwritten lists, text extraction produces a draft for checking.
- The importer maps the organiser's columns and room type words to your own room types, remembering the mapping for that organiser next time.
- Sharers are paired up and each room is checked against the group block: too many twins, a room type you have not allocated, a guest with no room.
- Dietary and access needs are pulled out of the notes into separate fields so they can go to the kitchen and to front desk.
- When a new version arrives, the importer compares it with the last one and lists every change: added, removed, moved, room type changed.
- Once a person has reviewed the flagged items, the names are loaded into the group block through your PMS API, or produced as a file in your PMS's own import format.
| In the organiser's list | What the importer does |
|---|---|
| '2 singles, sharing' | Maps to your twin room type and pairs the names |
| 'Veggie, nut allergy' in notes | Moves it to dietary fields and flags it for the kitchen |
| Version 5 with no explanation | Lists the three names that changed and the room that split |
| More doubles than the block holds | Flags it before anything is loaded |
Nothing loads without a person approving it. The importer does the reading and comparing, and your reservations team makes the calls.
What reservations looks like after
The tour operator's list arrives, the importer reads it, and the reservations manager spends her time on the four flagged rows rather than all forty-two. When version five comes in, she opens the change list, sees three changes, and emails the organiser about the one that does not fit.
On the day of arrival, key card envelopes are printed from the loaded names, the kitchen has the dietary list, and the desk knows which rooms have access needs. The history of every version is kept, so if an invoice is disputed later you can show what the organiser asked for and when.
Signs rooming lists are costing you
- Every group's list is retyped into the PMS by hand.
- Updated lists arrive whole and someone compares them line by line.
- Room types and sharers have been set up wrong on arrival day.
- Dietary notes from group lists do not always reach the kitchen.
- Only one person in reservations really knows how to handle groups.