Hotel Rooming List Template, Format and a Worked Example

Rooming List Meaning: What the Hotel Does With It

When you book a group, the hotel first agrees a block with you: say 20 rooms for three nights at a group rate. At that point the rooms have no names on them. The rooming list is what turns those 20 anonymous rooms into 20 reservations.

Once it arrives, reservations staff load each name into the property system and assign room types. Then they check sharing against bed set-ups, flag accessibility needs and set billing instructions, so the room charge goes to you and the minibar goes to the guest. Some hotels pre-print key cards and welcome envelopes from it. A late or messy list means all of that happens at the front desk while your group waits.

So the list isn't admin for its own sake. You're handing the hotel its work order.

When to Send the Rooming List

The date that matters is the cut-off in your group contract. After it, unnamed rooms usually return to the hotel's general inventory and the group rate may no longer apply to anything you add. Cut-offs are commonly two to four weeks before arrival, tighter in peak season. A pattern that works:

Hotel Rooming List Format, Column by Column

Hotels will take almost any layout you send, but they all need the same information. We use this format in our template:

Hotel Rooming List Example

A short, made-up example: a 7-room family and friends group in Kuala Lumpur, three nights, bed and breakfast. Look at rows 3, 5 and 6. That's where real lists usually break, and it's worth seeing why.

Fictional names and hotel, for illustration only. Total: 7 rooms (3 double, 2 twin, 1 triple, 1 single), 14 named guests plus 1 infant.

Free Hotel Rooming List Template (Excel)

It prints wide on A4 with the column headings repeated on every page. Excel, Google Sheets and Numbers all open it. Some hotels send their own rooming list format; if they do, use theirs, because it probably feeds straight into their system.

Sharing Rules: Twin, Double, Triple and Children

Most rooming list errors we see are sharing errors. Four things to get right:

Twin is not double

A twin room has two separate beds. A double has one. Two colleagues on an incentive trip will not thank you for the difference, and neither will a couple who end up apart. Ask. Don't assume.

Triples are usually doubles with an extra bed

Plenty of hotels, especially in city centres, have no true three-bed rooms. A "triple" is a twin or double plus a rollaway, and the third guest gets the rollaway. Say which set-up you want, and tell your client before they arrive so they aren't surprised.

Children are priced by age on arrival

Hotels often price children in bands, something like 0 to 5 and 6 to 11, with 12 or over treated as an adult. The bands vary by hotel and the contract wins. Write the age each child will be on check-in day, and you won't get caught by a birthday.

Cots and extra beds have to be requested

They're limited, and some room categories can't physically take one. If it isn't on your list, assume it won't be in the room.

Names, Late Changes and the Version Problem

Use passport names, split into surname and given names, with the surname in capitals. This matters more than people think: the guest checks in with a passport, and the desk looks for that exact spelling.

Single-name passports trip up hotel systems that insist on a surname. Agree a convention with the hotel before the list goes in. Some put the name in both fields; others borrow the airline habit of "FNU" (first name unknown) as a placeholder.

Then there's versioning. Group lists change, sometimes a dozen times. Two habits save a lot of grief:

• Number every version and date it in the header. Always send the whole list, never "just the changes".
• Keep a change log (the template has a sheet for it): what changed, when, who sent it, and whether the hotel acknowledged it.

Comp Rooms, Deposits and Attrition: the Money Side of a Group Block

The rooming list sits on top of a contract, and three clauses in that contract decide what the group really costs you.

Complimentary rooms. Many hotels give one free room for every set number of paid rooms. One per 15 to 25 is common, often in the lowest category and sometimes room only. It varies a lot, so read yours. Show the comp room on the rooming list like any other room and mark it in the notes.

Deposits. Groups are rarely pay-at-the-end. A deposit at signing and the balance some weeks before arrival is a typical structure, with dates written into the contract.

Attrition. This clause sets how many rooms you can drop without paying for them. Mews gives a worked example: a group contracted 200 room nights at an 80% threshold but picked up only 140, so 20 room nights fall short and are charged at the contracted rate times an agreed fee percentage (Mews, hotel attrition). Your rooming list at the cut-off is the evidence of pickup, so get it right.

If you're still at the contract stage, the guide to negotiating allotment contracts covers release periods and how to push back on attrition.

Group Hotel Bookings and DMC Quote

What the portal does is book rooms at net rates individually or as multi-room bookings, with a lead guest named per room and a per-room line on the voucher. That covers most families and small groups of a few rooms. For a real group block, with a rate negotiated for the whole group, comp rooms and a cut-off, go through our group bookings route or the group tour booking desk, and send your list in this template by email. Airport transfers for the group can be added from transfers.

If you're new to running groups, the guide to booking group tours covers the wider plan: flights, coaches, guides and timing.

How to Register for B2B Hotel Rates

1. Fill in the free agent registration form.
2. Upload your business registration when asked; our team reviews it.
3. Once approved, book hotels, transfers and tickets at net rates and top up your wallet by bank transfer.

Register free →