Daily Statistics
This report is located under Management > Financial > Daily Statistics. The Daily Stats reports were created to replace the statistics for occupied, Unit count, occupancy, and ADR that are currently provided by the Statistics in the Reservation section of the navigation bar in Oscar (in the calendar). At this point, the Daily Stats do not include reports for Resident Activity (arrivals, departures, etc.).
Unlike the existing Statistics in the Reservation section, the Daily Stats reports use the exact same methodology and calculations as those employed in the Comparative Statistics module in the Management section. (See Comparative Statistics Report documentation for the base data and the calculated statistics.)
When using the Transfer Module and a resident transfers from one Unit to another, if an invoice has been generated on the first Reservation that includes charges for dates on the second Reservation, at the point of committing the transfer, those charges are added to the second Reservation and credits for them are automatically generated on the first Reservation.
If these credits are not included in calculating revenue, revenue will be overstated. All statistics reports automatically include transfer credits for rent in calculating projected rent revenue.
There are four Daily Stats reports; Standard, Standard-Day Detail, Corporate Client and Corporate Client-Day Detail.
Access to all four reports is via the Management Section / Financial Reports /Daily Stats.
Standard
The Standard daily stats include both the base data (available Units, occupied Units, available minus occupied Units, and rent revenue) and the calculated stats (occupancy percent, ADR, and RevPar) for each day of the selected date range, for each Unit type.
There are two options for Unit type: The Unit type mappings that were set up for Comparative Stats, or the regular Unit types that have been set up in Oscar.
There are two options for ordering: Date / Unit Type, or Unit Type /Date. For the first, summary data is provided for each day; for the second, summary data is provided for each Unit type.
To compare the data returned by the Daily Stats to those returned by the Comparative Stats, run the Daily Stats for a single Market for a single month (enter the first day of the month and the last day of the month), select the Comparative Stats Unit type option, and order by Date / Unit Type option.
Then run the Comparative Stats for the same Market. Set the Through Date to the first day of the month used for the Daily Stats, and select the Base Data Option.
All of the grand totals and the Unit type totals in the first column (Month to Date) on the Comparative Stats should match those of the first day of the Daily Stats.
All of the grand totals in the second column (Current) on the Comparative Stats should match those of the grand totals on the Daily Stats. (Note that the rent revenue figure may be off by a few pennies due to rounding issues. The amount should be negligible and have no effect the ADR stats.)
Standard – Day Detail
The Standard – Day Detail report provides a listing of all Units and Reservations that are included in calculating the base statistics (available, occupied, and total rent revenue) on the Standard report for a single day. Information on Unit contracts (which affect the availability figure) is included, along with information on Reservation arrival and departure dates.
This report was created to allow Users to see exactly what comprises the Daily Stats figures.
An asterisk next to a Unit indicates that, although the Unit is included in the stats, it is currently marked as inactive. Also, note that if a Reservation number is included with the “from” and “thru” dates missing, it means that the Reservation is not in the Unit on that day (based on the arrival and departure dates), but is generating rental revenue (based on the bill from and bill to dates).
Corporate Client
The Corporate Client daily stats are similar to the Standard daily stats, except that they are calculated for a single Corporate Client (with or without any sub Corporate Clients).
The User must select a Corporate Client to run this report.
Note that the available and occupied figures are always exactly the same when running the Corporate Client daily stats (i.e., occupancy is always considered to be 100%).
Corporate Client – Day Detail
The Corporate Client – Day Detail report is similar to the Standard – Day Detail report, except that it does not include any information on Unit contracts.
Report Key
* Unit is inactive.
Missing dates-From and thru dates for Reservations indicate the Unit is not occupied however it is being invoiced.
On Transfer Reservations that are not committed, there will be occupancy but no revenue. On the Originating Reservation there will be revenue but no occupancy. Therefore the Origination Reservation revenue will be overstated and the uncommitted Transfer Reservation will be understated.
Within the same Market this will be a wash. Inter Market, this could cause some overstated or understated revenue.
Verifying Statistics
Issue: The schedule board count of occupied days does not match what the Statistics report shows.
To analyze one day in the period where there seems to be a difference, run Daily Statistics Standard – Day Detail report, for a single day for a single Property.
Each Unit ID is displayed with the Unit Lease details as well as the Reservation that is booked that day.
Here are the reasons why the occupancy numbers don’t match the Schedule Board:
Unit ID : CRE-102
The Available column contains a 0. If there is a 0 that means that there is no contract on the Unit for the day selected; however there is a Reservation for that day. This is overstating occupancy, because technically there is not a Unit to lease that day if there is no contract; however there is a Reservation booked on that day.
Unit ID : CRE-205 (GBP)
This Unit is missing a contract as well. Additionally, this Unit is not displayed on the schedule board. After searching for the Unit id, it is discovered that the Unit is “Inactive” which is why it isn’t displayed. This is also notated by the asterisks. However there is a Reservation, #109 on the Unit that says “Do Not Book Reservation”. Blocking Units with this type of status will always skew Statistics because Orion considers it a Reservation.
The Daily Statistics reports bases “Unit Lease Days” on the Unit contract. The Unit being marked Inactive only removes the Unit from the schedule board view. Inactive Units with either a contract and/or a Reservation for the day will be included. “Occupied Days” is based on a Reservation for the date or date range; whether there is a contract or not.
Using the Day Detail Report is extremely helpful as it assists with identifying these types of discrepancies which skew statistical reporting.
Target Rate
Billing In statistics, revenue for target rates and their subs is handled differently than that for non-target rate reservations.
Statistics uses the Target Rate stored in the master reservation and assigns a zero rate to the sub-unit reservations to calculate the rent revenue. The master and sub-unt reservations as counted as one.
Note: sub-unit reservations that fall outside the arrival and departure dates of the master reservation will not be included with the target rate group. If a rate is stored in the sub-unit reservation that falls outside the group, the rate is calculated separately from the group and is added to the revenue for the unit on the statistical reports.
Priority Reservations
Priority reservation place holder units are NOT counted in Available days for occupancy; however the reservation stay days ARE counted in Occupied days. This can skew occupancy. Revenue is counted for priority reservations the same as actual reservations.