Hotel block, room-night and deadline log
Compare commitments, bookings and actual use by night, linking cutoff, rooming-list, reduction and individual cancellation terms.
Nightly commitments, amendments and usage evidence remain linked.
- File formats
- English XLSX · CSV (UTF-8)
- Version
- 2.0
- Editorial review
- 31 Oct 2026
- Use this for
- Compare commitments, bookings and actual use by night, linking cutoff, rooming-list, reduction and individual cancellation terms.
When to use it
Compare commitments, bookings and actual use by night, linking cutoff, rooming-list, reduction and individual cancellation terms.
This form does not calculate contractual reductions or attrition charges automatically. Distinguish rooms from room-nights and keep personal rooming lists restricted.
Start with the guide: Group room block cutoff and unused commitment managementFill in the template step by step
When to use it
Open a record when preparing the work. Link later checks and changes using the same item ID.
What to have ready
- Contract/amendments and all four deadlines
- Nightly pickup, actual-stay and hotel billing records
Separate commitment, confirmed, pending and outside-block status by night.
Link the four deadlines and reduction/change responses to clauses.
Compare actual stays with credited pickup, charges and credits and investigate differences.
Worked example
Fictional example, not an actual event or supplier record
Eight columns · scroll horizontally to view the complete worked example.
| Contract, hotel and night ID | Committed rooms and agreement | Confirmed, requested, outside block | Four deadlines and clause | Change request and hotel decision | Actual stay, no-show, cancellation | Invoice and resale-credit check | Unknown owner and deadline |
|---|---|---|---|---|---|---|---|
| HT01 / Hotel A / 20 Nov | 20 rooms / AGREEMENT-v1 | 12 confirmed, 2 requests, 1 outside-block case | Cutoff5 Nov, list10 Nov, reduction3 Nov, individual15 Nov / C1–4 | Before reduction request | Before stay | Resale-credit terms pending | Housing Lee to obtain hotel response by 2 Nov 12:00 |
| HT01-C1 / 20 Nov | 18 rooms / amendment v2 | 14 confirmed, 1 request / PICKUP02 | Original C1–4; hotel confirms any change | CH01 sent2 Nov; hotel H01 approved3 Nov | Before stay | Request invoice against v2 | Registration Kim to check confirmation IDs 10 Nov 10:00 |
| HT01-FINAL / 20 Nov | 18 rooms / v2 | PICKUP03 / confirmation IDs restricted | C1–4 retained | CH01 and H01 linked | STAY01: 17 rooms; 1 no-show treatment pending | INV01; resale credit unconfirmed | Settlement Park to request explanation 23 Nov 12:00 |
Blank template preview
This preview shows a few rows. The downloaded file contains 24 prepared rows.
Eight columns · scroll horizontally to view the complete blank worksheet.
| Contract, hotel and night ID | Committed rooms and agreement | Confirmed, requested, outside block | Four deadlines and clause | Change request and hotel decision | Actual stay, no-show, cancellation | Invoice and resale-credit check | Unknown owner and deadline |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
Sources used to develop this template
EVENTODIT created this template using the working methods described in the public sources below. It is not an official form and has not been reviewed or approved by those organisations.
- Virgin Hotels Las Vegas — Meeting & Event Planning Guide, p.6
Adapted to link the guide’s checks with evidence, owners and follow-up records. The fields are editorial proposals, not an authority’s official submission form.
- Florida Housing — executed 2024 Hyatt Place St. Petersburg Downtown agreement and amendment, historical example
Adapted to link the guide’s checks with evidence, owners and follow-up records. The fields are editorial proposals, not an authority’s official submission form.