Versions Compared

Old Version 17

changes.mady.by.user Erica Johnson

Saved on

compared with

New Version 18

changes.mady.by.user Erica Johnson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column

The Bookings Report creates a list of bookings that were booked or created summary report of booking activity and room revenue generated on a specific date or date range and sorted by a specific term you choose like Source or Room Type.by Agent, Company, Guest Type, Rate Plan, Room Type, Source and User. 

This report is primarily used to analyze the volume of booking activity for a specific time frame to see the most popular room types, the average # of and the room revenue generated by source, room type, etc. This includes the # of bookings, room nights, the ADR, total revenue, % of revenue, etc.

This report It is also useful for tracking the sources of your booking activity to determine and productivity for specific channels or agents . It and can also be used to see which room types are getting the most bookings for planning and maintenance purposes.

Run multiple reports for different time frames to compare productivity to previous periods. Save the reports to Excel or .csv to merge the data or graph the comparisons. See Saving Reports to Excel

Note that the "Revenue" column displays totals from the rates originally saved with the bookings - not any charges (such as RENT) posted to the folio(s).

, have the highest ADR and generating the most revenue, etc.

Keep in mind that since some of the sort options in this report are generated from data you enter like Source and Guest Type, it is good practice to make sure you enter these in setup.

 

 

Note:

  • The revenue totals generated in a Bookings Report are for Room Rent only. To see total Revenue (including non-room revenue) by source or for a specific time period, use the Revenue Report.  The room rent revenue on the Bookings Report will match the total room rent revenue in the Revenue Report if sorting by the same term. See Revenue Report
  • To see the details of
these
  • the bookings summarized in the Bookings Report,
choose
  • run the Booking Production Report for the same date range.
 
 
  • To compare productivity to previous periods, run the same report for different date ranges. You can save the reports to Excel or .csv to merge the data and graph the comparisons. See Saving Reports to Excel
Column
width30%
Info
iconfalse
titleManagers Reports

Children Display
pageManagers Reports

Tip
titleTip

Use Search Bookings to create detailed list of bookings filtered by search criteria such as, room type, rates, etc.

 

 

To create a Bookings Report:
  • Go to REPORTS | MANAGERS REPORTS
  • Click on Bookings Report
  • Choose Date: Choose a single date or date range. I.e. for a single date choose Dec. 1, 2015 and Dec. 1, 2015 in both the start and end dates. 
  • Bookings By: Sorts revenue by chosen term in drop down list: Agent, Company, Guest Type, Rate Plan, Room Type, Source and User.  You must choose a sort term. Note: All reports will result in the same revenue amount, but will say "none" for Agent and "unassigned" for Company if none is chosen in the Booking datedata. 
  • Choose the report format: HTML, Excel or Text.
  • Click Generate Report
Bookings Report displays the following information:
  • First column: This column is titled with the sort term you chose. I.e. if you choose Source, the first column will be title Source. If you choose Room Type, the first column will be titled Room Type.
  • Room Nights: Total number of nights in all bookings.by the sort term chosen.
  • Bookings: Total Bookings made by sort term: CONFIRMED, UNCONFIRMED, CANCELLED, COMPLETE
  • Avg Nights: The average nights of the total bookings made.
  • ADR: Average daily rate of the total bookings made by the sort term. % of Rate Revenue from the rates saved with the bookings - NOT the actual RENT posted to the folios.
  • Room Revenue: Total Room Revenue from booking NOT including taxes. This displays totals from the rates originally saved with the bookings - not any charges (such as RENT) posted to the folio(s)
  • % Room Revenue: % of total room revenue by the sort term chosen. Total Room Revenue from bookings NOT including taxes. This displays totals from the rates originally saved with the bookings - not any charges (such as RENT) posted to the folio(s)..

See report examples: Bookings Report Source and Bookings Report Room Type