Reservation management

Hotel arrivals and departures list: daily filters, counts and room turnover

Build a useful daily hotel arrivals and departures list: separate expected and actual movements, reconcile stayovers and assign room turnover with a timestamp.

Two blank navy clipboards beside an ivory miniature hotel, brass keys and two neatly organized rows of tiles
Editorial illustration · AI generated

The short answer

A daily hotel arrivals and departures list shows who is expected, who has actually arrived or left, and which occupied rooms continue into the next night. Define the date, status filters, counting unit and snapshot time, then use room readiness and assigned responsibilities to plan turnover.

A morning reservation list can look reassuring while hiding the day’s real workload. Some arrivals have already checked in, a departure has extended its stay, and one guest has changed rooms without leaving the hotel. Reception needs a dated operational view that distinguishes these events before housekeeping receives its priorities.

The daily arrivals and departures list answers three questions: what is planned, what has happened, and what remains. It is different from a guest preparation checklist or group rooming list. Its purpose is to reconcile today’s movement and turn that information into room assignments.

Start with a date and explicit filters

Write the hotel’s reporting date and the snapshot time above the list, for example “19 October, updated 10:30, Baku local time.” If the software uses a business date, identify that date explicitly. A printed list is a snapshot, so a later change requires a refreshed version or a clearly dated correction.

Define which date field drives each section. Arrivals use arrival date; departures use departure date. Filtering by the date a reservation was created answers a different question. Exclude cancelled records from expected arrivals, and keep unresolved exceptions visible separately rather than silently counting them as confirmed movement.

Oracle’s arrivals report documentation distinguishes expected arrivals from reservations already checked in and describes date and other filters. These are reference examples, not a claim that BirOtel provides the same reports.

Choose one counting unit. A reservation covering two rooms is not one occupied room, and two people sharing a room are not two room arrivals. For turnover planning, use rooms and show guest numbers in a separate column when needed.

Separate expected and actual movement

Use four clearly labelled groups:

Group Meaning at the snapshot time
Arrivals still expected Due today and not yet checked in
Actual arrivals Completed check-ins during the reporting period
Departures still expected Due today and not yet checked out
Actual departures Completed check-outs during the reporting period

Never add “total arrivals planned today” to “actual arrivals today”: completed arrivals may already belong to that planned total. Record unplanned walk-ins, approved extensions and early departures as changes to the underlying reservation before refreshing the operational view.

A room move creates work in two rooms but is not a new hotel arrival or departure. Retain the same stay identity and show the room change separately. The room-move checklist explains the related room and account checks.

Reconcile stayovers with a simple room balance

In a fictional 18-room hotel, 12 rooms are occupied at the start of the period. Five are scheduled to leave and seven continue into the next night. Six rooms are expected to arrive. With no other changes, the projected overnight occupancy is 12 − 5 + 6 = 13 rooms.

At 10:30, three departures and two arrivals have actually completed. Current occupied rooms are therefore 12 − 3 + 2 = 11. Two departures and four arrivals remain expected. The seven stayovers are already included in the balance; adding them again would double count them.

These are room counts, not guest counts. An internal room move leaves this occupied-room total unchanged but can add cleaning work. Day-use stays and unusual overlapping arrangements need a separate reconciliation because movements during the day do not necessarily become overnight occupancy. Record corrections and their reason instead of forcing a total to fit.

Turn the list into today’s room work

Match each departing room to its next arrival only after checking room type, allocation and expected timing. “Departure planned” is not “vacant”; “vacant” is not “ready.” Confirm release, cleaning and inspection through the hotel’s procedure before promising access.

Use a compact operational checklist:

  • Confirm each room’s latest occupancy and cleaning status.
  • Identify rooms needed again today and their required ready time.
  • Assign cleaning and inspection to named employees.
  • Flag delayed departures or unavailable rooms for reception review.
  • Refresh the snapshot after a material change and retire old copies.

The housekeeping and room-status guide helps connect these priorities to room readiness. A departure count alone cannot tell the team how many rooms are safe to release.

Frequently asked questions

How often should the list be updated? Refresh at the start of work and after changes that affect room availability or priorities. Display the extraction time so colleagues can identify outdated copies.

Should every employee receive the complete reservation list? No. Share information needed for the assigned task. Housekeeping usually needs room, timing and relevant service instructions; identity documents, payment details and unrelated guest notes do not belong on its turnover sheet.

Can BirOtel produce this exact report automatically? BirOtel describes reservation records, expected movements, room statuses and daily reporting. Confirm the specific filters and output in a demonstration; use a manually filtered working list where necessary. For a small team, bring this example to the small-hotel software demo and verify the workflow with your own room inventory.

These guides are published by BirOtel. General methods, illustrative examples and current product capabilities are identified separately. Sources appear beside the relevant explanations.

[email protected]

Explore these workflows for your own hotel

Use your room inventory and daily tasks to assess whether BirOtel fits your hotel in a live demo.