Rooms on the Books

Report parameters

Field

Description

Report Name

The name of the report.

From Date

The start date from when the data must be considered for generating the report.

To Date

The end date until when the data must be considered for generating the report.

Building Codes

A selection list consisting of all the building codes. All building records created in the Building Codes (Settings à Setup à Room à Building Codes) screen are displayed as options in the drop-down list. Users can select multiple or all the building codes from the list to be displayed in the report generated.

Consider Wholesaler as Transient

When enabled, the room count and revenue from wholesaler bookings will be displayed in the report as follows:

  • Wholesaler bookings with comps - the count will be included in the Occ column and the Trans sub column under the Comp column.

  • Wholesaler bookings without comps - the count will only be included in the Occ column.

When disabled, the room count and revenue from wholesaler bookings will be displayed in the report as follows:

  • Wholesaler bookings with comps - the count will be included in the Occ column and the Group sub column under the Comp column.

  • Wholesaler bookings without comps - the count will only be included in the Occ column.

By default, this flag will be disabled.

Get Sold Rate/ Posted Revenue

  • When enabled, actual room revenue of reservations after discounts or adjustments applied to the original room rate will be considered and the room revenue will be displayed accordingly. Also, for future reservations within the date range, the rate at which the rooms were sold will be considered as room revenue.

  • When disabled, the rate at which the rooms were originally sold will only be considered when calculating the room revenue. Any discounts or adjustments made on the original rate will not be considered.

By default, this flag will be disabled.

Include Non-Bedded Rooms

  • When enabled, the revenue from non-bedded rooms will also be included in the total revenue displayed in the report.

  • When disabled, the revenue from non-bedded rooms will not be included in the total revenue displayed in the report.

By default, this flag will be disabled.

Sample Report

A close-up of a number

Description automatically generated

Report Fields

Field

Description

Day

Day of the week in the given date range.

Date

Date from the given date range.

ROOMS

OOO

Number of rooms with out of order status.

DNS

Number of rooms with do not sell status.

Avail

Number of available rooms.

Occ

Number of occupied rooms.

Occ%

Percentage of occupied rooms.

Occ% (U/P)

Percentage of picked up rooms.

Vacant

Number of vacant rooms.

TOTAL

Guest

Number of guests scheduled to arrive in the given date.

Arrive

Number of guests arrived the reservation.

S/O

Number of sold out rooms.

Depart

Number of guests scheduled to depart in the given date.

ARRIVALS

NGTD

Number of non-guaranteed reservations for the given date.

GTD

Number of guaranteed reservations for the given date.

GTD %

Percentage of guaranteed reservations for the given date.

GROUP

Sold

Number of sold group rooms.

UnP/U

Number of group rooms that are not picked up.

ADR

The system calculated average daily rate.

Comp

Trans

The number of transient complimentary rooms in the bookings.

Group

The number of group complimentary rooms in the bookings.

EST TOTALS

Revenue

The estimated total revenue generated through all the rooms for the given date.

ADR

The system calculated average daily rate of all the rooms for the given date.

Note: Report considers Sold Rates against the rooms