How to make a rooming list for a group event or incentive trip
Check-in data, room types, roommates, extra beds, release and attrition, without endless spreadsheet versions.
A rooming list is what you send the hotel to show who sleeps in each room, the room type, each guest’s arrival and departure dates and the details the hotel needs for check-in. You build it from confirmed registrations, reconcile it with the room block you signed with the hotel and deliver it before the release date. The list itself is not the hard part. The hard part is letting the client, the guests and the hotel touch it without ending up with ten versions of the same spreadsheet.
The right order: contract, registration, rooming
The rooming list is the last link in a chain. If an earlier link breaks, the list inherits the problem.
- Room block with the hotel. How many rooms, which types, which nights, at what rate, with what release and what attrition.
- Registration form with the questions that feed rooming: dates, room preference, who they want to share with, check-in details (ideally only from confirmed guests).
- Allocation: who goes in which room.
- Client review.
- Send to the hotel before release, and manage changes until check-in.
If you are coming from the registration form, our event registration form guide covers what to ask and what to skip.
What the hotel needs for check-in
It depends on the country and the hotel, but this is what is usually required:
| Field | Why |
|---|---|
| Full name exactly as on the ID | Check-in and guest registration |
| Room type | Hotel allocation |
| Sharing with | Doubles, twins or triples |
| Arrival and departure date per guest | Not everyone arrives and leaves on the same day |
| ID or passport number and nationality | Guest registration |
| Date of birth | Guest registration |
| Contact (phone or email) | More and more hotels ask for it |
| Notes | Extra bed, cot, late arrival, accessibility |
In Spain, for example, accommodation providers must register a fair amount of data per guest (identity, ID document, nationality, date of birth, contact and more). Ask the hotel exactly which fields they want and in what format before you open the form, not in show week.
What should not go on the hotel list
Allergies, health data, emergency contacts and the client’s internal notes. If the hotel needs allergies for the restaurant, send them as a separate list for the kitchen, not stapled to each guest’s passport number. The less data travels, the lower the risk.
Room types and how to name them
Every hotel has its own catalogue, but for groups we work with these:
- Single or double for single use: one person in a double room. The norm for senior staff on corporate trips.
- Double: one large bed. Couples.
- Twin: two separate beds. Colleagues sharing.
- Triple: usually a double with an extra bed or rollaway. Always ask whether it is a real bed or a folding one.
- Suite or upgraded room: for the client, speakers or VIPs. Count them separately in the block.
A classic: the client asks for “doubles” and means twins. Before sending anything, confirm with both client and hotel what each type means.
Roommates: ask properly so you do not have to undo
If there are shared rooms, ask in the form, and ask well:
- “Who would you like to share with?”, free text, first and last name.
- “Are you happy to share with someone you don’t know?”, so you have room to manoeuvre.
- If relevant, “Do you need a single room for any reason?” (free text, no medical explanations required).
Typical problems: A asks for B and B asks for C. A types “Mike” and there are three Michaels on the list. Someone asks to share with a person who is not coming. That is why roommate requests are reviewed before placing anyone, not after.
In Forms, the Rooming board spots the who-do-you-want-to-share-with question on its own and recognises who is named, nicknames included. Next to each person you see who they want to share with and where that person is, and when you place someone it offers to add their roommate too, or move them if they are already in another room. It saves cross-checking names by eye.
Extra beds: what fits versus what you recommend
A room that fits three people does not mean three people should go in it. We separate two numbers:
- Maximum capacity: what the hotel allows (beds plus extra bed).
- Agency standard: what we recommend for a good experience.
Example: on an incentive with four-bed cabins, the maximum is 4 but our standard is 3. If the group grows and a fourth person has to go in, it can be done, but it must be visible that they are on an extra bed so the client decides knowing the trade-off.
In Forms Rooming you set up each type with photos, beds, maximum and agency standard. Above the standard, the bed shows in orange as an extra bed on the board, on the client link and in the PDF, and the header shows how many people are on extra beds.
Release, attrition and no-shows: where the money goes
These are negotiated in the room block contract, not in the rooming list, but the rooming list tells you whether you are on track.
Release
The date when blocked rooms not yet confirmed with a name go back to the hotel at no cost. Sometimes there are several staggered dates.
Example: a block of 60 rooms with release at 30 days: anything without a name on the rooming list that day goes back. If you have 52 registered guests with rooms at 30 days, you release 8 and sleep well.
Attrition
The percentage you can reduce without penalty after release. Example: with 10% attrition on 52 rooms, you can drop to about 47 without paying for the rest. Below that, the hotel charges the difference as per the contract.
No-shows and late changes
Who pays if someone does not turn up, whether the first night or the whole stay is charged, and until when you can change names at no cost. All of this belongs in the contract. Contracts includes a room block template covering the rooming list, release dates and no-shows, so it does not live in an email thread.
And what is paid separately
Agree with the hotel what goes on the client’s master account (usually room and breakfast) and what each guest pays (minibar, room service, parking). Put it in writing. Otherwise, on departure day there is a queue at reception and an invoice nobody recognises.
Working with the client without endless spreadsheets
The usual drama: you send the spreadsheet, the client forwards it to HR, HR changes three names, someone saves it as “rooming_final_v3_REAL.xlsx” and you are still working on v2. How we avoid it:
- One list, in one place. The one built from confirmed registrations. No copies.
- The client works through a link, not an attachment. They can move guests or only view, as you decide, and never see emails or personal data.
- Only confirmed guests count. Unconfirmed people take no bed.
- Internal deadline a few days before the hotel’s release, so you have slack.
- The hotel file is generated at the end, once final, with the fields the hotel needs and nothing more.
- Changes after sending, in writing and dated, to the same hotel contact.
In Forms the Rooming board works like this: unassigned guests on one side and rooms grouped by type, with their photos. On desktop you drag; on mobile you tap the person and then the room. Drop someone on another person and they swap. With the client link, they can do it themselves, no account needed. Downloads: a PDF with photos per room type for the client, a spreadsheet per guest and the full rooming list for the hotel, choosing which fields go in (check-in data by default, with health, allergies and emergency contacts unticked).
Common mistakes
- Opening registration before signing the block, then finding the hotel only has twins.
- Asking everyone for passport details in the first form.
- Counting unconfirmed people as accommodated.
- Not looking at the release date until it has passed.
- Sending the hotel a spreadsheet with allergies, emergency numbers and client notes.
- First names only, or nicknames (“Pete from sales”).
- Identical arrival dates for everyone when half arrive the day before.
- Letting the client edit their own copy of the spreadsheet.
Quick template for your next rooming list
- Block signed: rooms per type and night, rate, release, attrition, no-shows and master account.
- Hotel asked: exact fields and rooming list format.
- Form: dates, room preference, roommate, check-in data from confirmed guests only.
- Room types set up with beds, maximum and agency standard.
- Roommate requests reviewed before placing.
- Client reviewing by link, no personal data on show.
- Internal deadline set before release.
- Hotel file with check-in data and nothing else.
- Separate allergy list for the restaurant.
To try it with your next group, Rooming sits inside the responses of any Forms form.
Frequently asked questions
What is a rooming list?
It is the list you send the hotel showing who sleeps in each room, the room type, each guest's arrival and departure dates and the details the hotel needs for check-in.
What information does a hotel need on a rooming list?
At minimum, full names exactly as on the ID, room type, arrival and departure dates and who shares with whom. In many countries, including Spain, guest registration rules also require ID number, nationality and date of birth, among others.
What is the release date in a room block?
It is the date when blocked rooms you have not confirmed with a name go back to the hotel at no cost. After that date, rooms you have not released are usually charged as per the contract.
What is attrition?
It is the margin the contract gives you to reduce rooms or room nights without penalty. Below that threshold, the hotel charges for what you do not use.
How do I avoid ten versions of the rooming spreadsheet?
Work on a single list that lives in one place, give the client a link to move or review guests, and generate the hotel file only once it is final.