SunPMSby SunTatva Technologies
Menu
FeaturesSolutionsIntegrationsReportsHelp CenterVideosFAQSign inRequest a demo

Reservation Reports

Reports · Updated

On this page
  1. Before you start
  2. Reservation Detail
  3. No-Show/Cancel Revenue
  4. CRS Rate Plan
  5. Booking Comparison Report
  6. Messages you may see
  7. Tips and FAQ
  8. One page per report

Four reports about bookings. Open them from Reports > Reservation Reports.

Before you start

CRS Rate Plan only has data if the property is connected to a channel manager/CRS.

Reservation Detail

Screen title: Reservation Detail Report. Purpose: list every reservation by a chosen date. Filters:

Filter Values
From Date / To Date range applied to the date chosen next
Select Date Res.Date (booking date), Date In, Cancel Date, No-Show Date
Reservation Source All, CRS Only, Walk-In
Status All, Confirmed, Unconfirmed, NoShow, Canceled
Columns: ID, Folio #, Guest Name, Phone Number, Email, Room Name, Res Date, Date In, Date Out, Total Payment, Status, Cancel/No-Show Date, Sales & Channel Category, Sales & Channel Name, ADR, Total Charges. Grouped (not grouped for Walk-In). Sortable, paged on screen; PDF/Excel contain all rows.
Answers: "Which bookings did we take last week?", "Who cancelled this month?".

No-Show/Cancel Revenue

Filters: From Date, To Date, Filter By (ALL, Cancel, No-Show). Columns: Folio No, Guest Name, Room Name, Date In, Date Out, No-show/Cancel Date, Revenue Posting Date, Advance Deposit, Rental Revenue, tax. Groups by No-Show or Cancel. Shows revenue kept from guests who did not arrive. This revenue is included in Daily Summary and Monthly Tax Detail on its Revenue Posting Date, not on the original stay date.

CRS Rate Plan

Filters: From Date, To Date, CRS Rate Plan (ALL or one plan). Columns: Folio No, Guest Name, Reservation Date, Date In, Date Out, CRS Rate Plan, CRS Engine, Status. Shows which online rate plan each channel booking used.

Booking Comparison Report

Opens from the Booking Comparison Report card ("Compare booking performance across criteria", privilege 248) in a criteria window, then a result page. It is a pickup (pace) report: it compares the reservations on the books as of one date with those as of another date for chosen stay dates. Full page: Booking Comparison Report.

  1. In Reservation comparison for set Reservation As Of (cannot be after the PMS date), Reservation Date On (Arrival/Departure, Arrival or Departure) and Stay duration from / To.
  2. In Reservation comparison with set Reservation Date With (cannot be after the PMS date) and its Stay duration from / To.
  3. Click Add Criteria. Up to 5 pairs; Remove deletes one after you confirm. Messages: "Please select valid date criteria." (From after To), "Maximum criteria limit exceeded.", "Please select atleast one criteria."
  4. Click Show. The result page has a report banner switch and Export (PDF, Excel, Email (PDF)). Columns: No., Line, Reservations As Of, Stay Duration, Reservations, Room Nights, Room Revenue (rent without tax), ADR, Cancelled. Each criterion has four lines: A, B, Difference (A - B) and % Change (blank when B is 0). No grand total. Answers: "How many more bookings do I have than yesterday or last week?", "Is the month picking up faster than before?".

Messages you may see

No record found!; see criteria messages above.

Tips and FAQ

  • Q: Reservation Detail shows fewer rows than Arrival. A: Arrival includes walk-in check-ins; set Reservation Source = All and Select Date = Date In.
  • Q: Why is revenue in No-Show/Cancel Revenue but not in the stay date report? A: It is dated on its posting date.

One page per report