Rooming List

What information does a hotel need on a rooming list?

Enough per room to build a reservation and check a person in without calling you. Four groups of columns do that, and everything else is decoration.

• Who — the lead guest’s first and last name exactly as it appears on the ID they will present, plus every roommate sharing the room. A room can carry up to five occupants, and each one is a name the front desk needs, not a note in a margin.
• When — arrival and departure as dates, in one format you never vary. Write 2027-03-04 or Mar 4, 2027. “03/04” is 4 March to an American front desk and 3 April to half the world.
• What kind of room — the room-type names your contract uses, spelled the same way every time, plus a status per row: confirmed for a live reservation, cancelled for one you are withdrawing.
• Who pays — a billing instruction on every row, because billing varies inside one event far more often than teams expect.
• Anything else — accessibility needs, connecting rooms, early check-in, a floor away from the lift. The hotel cannot honour what it never sees.
• A blank confirmation-number column. You leave it empty; the hotel fills it in and sends the list back. That number is the key you audit against.

What should you leave off a rooming list?

Guest email addresses and phone numbers. A hotel does not need them to check anyone in, and once contact details are inside a property-management system and a forwarded email thread they cannot be recalled. The free template on this site leaves them out on purpose, and the rooming lists Blocks sends carry no guest contact details at all.

Two columns worth adding instead, once a single file covers a large event: which hotel each room is at, and which department or team it belongs to. They cost nothing to carry and they save splitting the file later — and the department column is what answers “how many rooms does production have on Friday” without re-sorting anything.

When is a rooming list due to the hotel?

By the cutoff date in your contract — commonly 21 to 30 days before arrival, and as little as 14 on short-lead or high-demand dates. The cutoff is the day the hotel releases whatever is still unnamed back into its own inventory, so the rooming list and the cutoff are one deadline seen from two sides. Yours is “get the names in.” Theirs is “take the rooms back.”

Set your own deadline one to two weeks ahead of it. The cutoff is the hotel’s date, not yours, and that gap is what lets you chase the names still missing, settle the roommate pairings, and clean the file before it goes. Teams who submit on the cutoff submit whatever they happen to have.

And keep the rooms you cannot name. A room allocated but unnamed is still a guaranteed room night you are contracted to pay for, so dropping it from the list only under-submits against a block you have already committed to. Leave the row in with the names blank and fill it in when you have one.

What do billing instructions on a rooming list mean?

They tell the hotel which charges go to the group’s master account and which go to the guest’s own card. Three settings cover almost everything:

• Room and tax to master, incidentals to the guest — the usual arrangement. You pay for the room; the guest pays for the minibar, the parking and the room service.
• All charges to master — the whole folio comes to you. Reserve it for rooms you genuinely mean to cover in full, and tell the guest, because this is the setting that produces surprise invoices.
• Guest pays all — the room sits in your block at your rate, but the guest settles their own folio at checkout. Common for self-paying attendees and for staff travelling on their own budget.

What is the difference between a preliminary and a final rooming list?

A preliminary list is the working version you send ahead of the cutoff so the hotel can start keying reservations and you can see what is still missing. A final list is what stands at the cutoff: the version the hotel builds confirmed reservations from and returns with a confirmation number against every room.

After the final list, stop sending lists. Send changes — add these three, cancel this one, move this arrival to 5 March — clearly marked as changes. Re-sending 200 rows every time something moves forces the hotel to re-key the file and reintroduces the errors you already fixed. A short, dated change note they can apply in minutes is worth more than a fresh attachment they have to diff by hand.

What does “certified true and correct” mean on a rooming list?

It is an attestation. A named person signs that the list, as submitted on that date, is accurate and complete to the best of their knowledge, and the signed version becomes the baseline that billing, pickup and any later dispute are measured against.

It turns up most on government, military, university and association business, where the group is spending someone else’s money and needs a signed record of what was submitted and when. It is a version stamp, not a waiver: it does not stop you correcting an error the hotel introduced, and it does not freeze the list. Changes after it go through the normal change process, and the certified version stays as the record of where you started.

Read what you are signing, and check who at your organization is authorized to sign it. If the form also certifies rates, eligibility or occupancy, you are attesting to more than the names.

What does a rooming list look like?

One row per room. A guest staying four nights is one row, not four; two people sharing are one row with two names, not two rows competing for the same bed. The moment the file has more rows than the hotel holds rooms, something is going to be double-booked or dropped.

How do you read a rooming list table?

Left to right is one room: who is in it, when they arrive and leave, what kind of room it is, and who pays. Down a column is your count. Those five rooms are sixteen room nights, and the busiest nights are the 5th and the 6th with five rooms occupied — which is how you read a peak night off a list.

Two columns deserve a second look every time. Nights should agree with arrival and departure rather than with what someone typed, and a room arriving on the 4th and departing on the 8th is four nights, not five. And the confirmation-number column tells you where in the process you are: blank means you have not sent it yet or the hotel has not confirmed it, and a number means there is a reservation on the hotel’s side to reconcile against.

Why does the hotel’s returned list differ from the one you sent?

Because it made a round trip through someone else’s system. You send names; the hotel keys them into a property-management system with its own room codes, its own name fields and its own idea of a date; and it sends back a confirmed list. Drift is normal, and four kinds of it are worth your attention: a name that changed, a date that moved, a room you submitted that has no reservation, and a reservation on their list that is not on yours.

Check it weeks out, not in arrival week. A date that slipped by a night is a room night you are billed for and a guest with nowhere to sleep on their first night. Caught early it is an email; caught at the desk it is an argument with a queue behind it. Match on the confirmation number first and the name second — the confirmation number is the hotel’s unique key for a reservation, and name matching breaks the moment two guests share a name or one name is spelled two ways.

This is the comparison Blocks runs for you. It matches the hotel’s returned file to your reservations by confirmation number before anything else, groups the differences by type, works out what the hotel’s own room codes mean from the rest of the same file rather than filing a mismatch on every row, and reads “BRENNAN, TYLER” and “Tyler Brennan” as one person. Accepted corrections become a changes-only email back to the hotel, and nothing changes on a reservation until you accept it.

How do you create a rooming list in Excel?

Start from a file that already has the columns rather than building headers from memory. There is a free .xlsx on this site: one row per room, up to five occupants, dates preformatted, a nights column that calculates itself from arrival and departure, and dropdowns on status and billing. It is built from the column set Blocks actually sends to hotels, so a filled-in copy imports cleanly instead of being retyped.

Then the discipline that keeps it clean. One row per room. One date format in every cell. Room-type names copied from the contract rather than paraphrased. The confirmation-number column left blank for the hotel to fill. TBD rows left in place. Save it as .xlsx and send it as an attachment — a list pasted into the body of an email loses its columns the first time somebody forwards it.