Guest Reports
Global Annual 2016 Radar Report
This report was used for the 2016 Radar report.
Global Annual 2017 Radar Report
This report calculates the statistics that are requested in the 2017 Radar Report. It does not automatically get submitted to Radar. Rather you need to use these statistics to answer the questions directly in the Radar report interface.
Report Options:
Reporting Year
Stay Locations to Include.
Indicate for each location whether it is a House, a Hotel or a Family Room.
Hotel Paid By Chapter - select the Paid By code to indicate a hotel stay paid by the Chapter
Daily Guest Census Report
This report lists guests, patients, and several additional fields for each guest stay. it is a quick and concise report.
Report Options:
Date Range options:
Guests in House as of
Arrival
Expected Departure
Actual Departure
Stay Type
Location
Fields to include
Sort Order
Guest Arrival Report
This report lists all guests expected to arrive in the selected date range.
Report Options:
Date Range for Guest Arrival
Include All Rooms, Include Rooms Based on Room No., Include Rooms Based on Location
Sort Order: Guest Name, Room #
Guest Departure Report
This report lists all guests expected to depart in the selected date range.
Report Options:
Date Range for Guest Arrival
Include All Rooms, Include Rooms Based on Room No., Include Rooms Based on Location
Sort Order: Guest Name, Room #
Guest Birthday Report
This report lists guests, patients, additional adults and additional children with birthdays the in the selected month and day range.
Report Options:
Month and day range for birthdate
Include No Phones, Preferred Phones, All Phones, or Selected Phone Types
Include No Emails, Preferred Emails, All Emails, or Selected Email Types
Show Only Birth Day and Month
Include Address
Date Range for Guests in Room
Guest Type Selection
Location Selection
Sort Order: Name, Birthdate, Birth Month and Day
Guest Item Usage Report
This report shows the number of items that have been checked out and used by guest during a selected time period. The report can be run as a summary or showing the detail each time an item is checked out.
Report Options:
Date Range for Guest Arrival, Departure, Expected Departure, Item Checked Out Date, Item Checked in Date
Item Types to Include
Items to Include
Summary or Detailed Report
Sort Order (for Detailed Report only)
Guest List Report
This is a list of guest and patient names, with arrival and departure dates, room number, and number of nights.
Report Options:
Date Range for Currently in House, Arrival Date, Expected Departure, Actual Departure
Stay Type Selection
Location Selection
Sort Order: Guest Name, Arrival Date, Departure Date, Current Room #
Guest Payment Report
This is a list of guest payments grouped by date and payment method, with arrival and departure dates, room number, paid by and invoice #..
Report Options:
Date Range for Payment Date
Payment Method Selection
Paid By Selection
Location Selection
Guest Request List
This lists guests who were or are on the request list as of the selected date range. It shows the number of nights on the list and the resultant stay type if they move off the request list.
Report Options:
Date Range for nights on the request list
Location Selection
Include Address
Include No Phones, Preferred Phones, All Phones, or Selected Phone Types
Sort Order: Name, Days on Wait List, Date Started on Request List
Guest Room Cleaning Status Report
This lists rooms in the selected location, showing their cleaning status for today.
Report Options:
Location Selection
Guest Service Usage Report
This report shows the number of services that have been used by guest during a selected time period. The report can be run as a summary or showing the detail each time a service is used.
Report Options:
Date Range for Guest Arrival, Departure, Expected Departure,Service Start Date, Service End Date
Services to Include
Summary or Detailed Report
Sort Order (for Detailed Report only)
Guest Wait List
This lists guests who were or are on the wait list as of the selected date range. It shows the number of nights on the list and the resultant stay type if they move off the wait list.
Report Options:
Date Range for nights on the wait list
Location Selection
Include Address
Include No Phones, Preferred Phones, All Phones, or Selected Phone Types
Sort Order: Name, Days on Wait List, Date Started on Wait List
House Operations Report
This is a detailed set of metrics about the operations of the House month by month over a period of time. For a detailed explanation of each line in the report, see the House Operations Report topic.
Report Options:
Year for the report and last Month it should cover
Location Selection
Select Guest Regions to include
Select Third Party Payors to include. Note that Third Party Payors are grouped into Paid By Groups on the Codes tab of Admin.
Select Paid by Family codes to indicate which Paid By codes should be considered "Paid by Family" on the report.
Select Volunteer Project Codes to include in the volunteer metrics.
Select Gift Method Codes for each gift method listed separately in the Donors section.
Select Gift Fund Codes to include in the Donors section.
Invoice Report
This report lists invoices with billing and payment details
Report Options:
Invoice # Range or Invoice Date Range
Summary View (Totals only)
Sort Order: Guest Name, Paid By Name, Date, Invoice #
Lodging Receipts Report
This gives a list of payments received in the date range, with patient and guest names, Paid By name, and date, amount and fund.
Report Options:
Date Range for nights on the wait list
Location Selection
Include Address
Include No Phones, Preferred Phones, All Phones, or Selected Phone Types
Sort Order: Name, Days on Wait List, Date Started on Wait List
Occupancy Report
This report compares two periods and shows occupancy rates and other statistics for the location specified.
Report Options:
Date Range for Two Periods
Location Selection
Outstanding Invoices Report
Under Construction
Patient Details Report
This is a list of guest stays, with guest name and dates, each with details about the patients.
Report Options:
Date Range of Stay
Location Selection
Include Birth Date
Include Gender
Include Location
Include Priority
Include Region
Include Diagnosis
Include Medical Facility
Include Ethnicity
Include Patient Address
Include Patient User Defined Fields
Sort Order: Guest Name, Patient Name, Arrival Date
Patient Geographical Origin Report
This report shows a count of patients broken down by selected geographical locations of the family.
Date Range
Report by:
City
Country
County
State
Do Not Show Zero Lines
Patient Statistics Report
This report shows a count of patients broken down by selected patient parameters.
Report Options:
Date Range
Report by:
Stay Location
Priority
Region
Diagnosis
Medical Facility
Ethnicity
User Defined Fields
Do Not Show Zero Lines
Payment Statistics Report
This report shows a breakdown of charges and payments by Paid By
Report Options:
Date Range for Two Periods
Location Selection
Summary Report
Guest Statistical Overview (formerly RADAR Report)
This report calculates the values that are requested on the annual RADAR report for Ronald McDonald House and Family Room use statistics. For details on how each value is calculated, see the RADAR Report Details topic.
Report Options:
Date Range for the Report
Locations to include in each section
Definition of Paid By codes for Guest Self Pay and Hotel Stays Paid by Chapter
Room Statistics
This report lists each room in the selected locations, showing average usage and a breakdown of the geographical source and diagnosis of each group of families that used the room.
Report Options:
Date Range for the Report
Locations to include in each section
Breakdown statistics by city, region or state
Room Roster Report
This report shows the names of guests and other occupants in the House as of a selected date. It includes additional details, such as alerts and car license plates.
Report Options:
Date
Location Selection
Simple Roster or Detailed Roster
Sort Order: Room #, Guest Name, Patient Name
Stay Type Statistics Report
This report shows a count of stays, with the number of nights and percentage of total, for each Stay Type.
Report Options:
Date Range
Location Selection
Third Party Payor Report
This report lists Third Party Payors as defined in the Paid By codes and shows the charges, payments, and balance due for each guest stay.
Report Options:
Invoice Date Range
Uninvoiced Charges Report
This report lists guest stays and charges for charges that have been incurred but have not yet been added to an invoice.
Report Options:
Charge Date Range
Arrival Date Range
Location
Paid By
Sort Order