View Source

The Revenue Report creates a summary report of total Room and Non-Room Revenue (excluding taxes) Country, Agent, Company, Guest Type, Rate Plan, Room Type, State, Source and User.

This is a historical report as it only displays data from actual Room Rent and Non-Room Rent charged to folios. It does not display payments you have received by cash, credit card, etc. To see payment receipts, see the Manager's Report , Transaction Summary Report and Advanced Deposits Report.

The Revenue report is primarily used to analyze actual revenue generated in by source, room type, etc. and includes # of room nights, ADR, total revenue and % of revenue.

It is useful for tracking revenue from specific channels or agents and can be used to see which room types are generating the highest % of Revenue and have the highest ADR, etc.

The report can be run for a specific date or over a date range in the past. The room revenue data is generated from amounts actually posted to folios: Room Rent posted to folios during Night Audit and and Non-Room Revenue items manually charged. This includes advanced charges to bookings (ARC). See Advanced Charges Report (ARC). Any Inventory Items such as, "Cancellation Fees" that are part of the Inventory Group: RENT will be reported under "Non Room Revenue". See Inventory Groups and Inventory Items

Things to know about the Revenue Report

To see Occupancy during the Revenue period, go to Occupancy Report and run it for the same date range. NOTE:There are times when Night Audit timing may cause discrepancies in the Revenue and Occupancy reports. Occupancy and Revenue are different reporting paradigms and not intended to be equal at all times. Revenue is RENT posted to a folio during a specific time frame. Occupancy is ROOMS occupied. See this KB Article for further explanation.
To see the details of the bookings summarized in the Revenue Report, run the Bookings Production Report for the same date range.
If you are posting Charges (Rent and/or other Charges) in advance of the current system date. See Advanced Charges to Folio and Advanced Charges Report (ARC)
The revenue totals generated in a Revenue Report are for Room Rent and Non-Room Rent. To see only total Room Rent Revenue by source or for a specific time period, use the Bookings Report. The room rent revenue on the Bookings Report will match the total room rent revenue in the Revenue Report if sorted by the same term.
Revenue displayed in this report needs to be ACTIVE or COMPLETE status. A booking made during the reported time frame, but not checking in until a future date (ie, status is CONFIRMED or UNCONFIRMED), is NOT reported on this report. Even if an advance charge to the folio were made, the future booking is not included in the Revenue Report.
To see details on any non-room revenue, go to the Item Analysis Report
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
You can also use Search Bookings to create detailed list of bookings filtered by search criteria such as, room type, rates, etc. This can be helpful in trying to locate any discrepancies.

"Revenue by" sort terms:

Keep in mind that since some of the sort options in this report are generated from data you enter like Source and Guest Type so entering relevant terms to your business can help with planning and marketing.

The following sort terms can be entered and customized in setup.

Guest Type - We provide default Guest Type terms like 'Return" and "Phone". These can be edited and you can add more Guest Types in the Setup Area. We encourage you to setup Guest Types that are relevant to you like Return, First Time Guest, Referral, etc. Guest Types are entered in the Booking Data of each booking.
Sources - We provide default Source terms like 'Unknown" and "website". These can be edited and you can add more sources in the Setup Area. We encourage you to setup Sources that are relevant to sources you are using like Groupon, Travel Agent, Front Desk, Etc. Sources are entered in the Booking Data of each booking.
Agent - Name of Travel Agent entered in booking. This will say "None" if not entered in booking data .
Company - Company name in booking data if entered. This will be blank if not entered .

To create a Revenue Report:

Go to REPORTS | MANAGERS REPORTS
Click on Revenue 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.
Revenue 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 data.
Choose the report format: HTML, Excel or Text.
Click Generate Report

Revenue 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.
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)
Non Room Revenue: This is the sum of all Inventory Items excluding RENT posted on folios for bookings in the date range queried. For example, if you have a 'Cancellation Fee' that is part of the Inventory Group: RENT this is still considered as 'Non Room Revenue' on the reports.
% 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).
% Total Revenue: This is the percentage of total revenue (including sum of room & non room) for each category in the 'Revenue By' selection.

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