Comparative Statistics
This report is located under Management > Financial > Comparative Statistics. Comparative Statistics provides the following statistics in two reports, one containing the base data used to calculate statistics, and one containing statistics calculated from that base data.
Users must first “map” their specific Unit types to these types (i.e. the types 2 BR / 1 BA and 2 BR /2 BA would both map to “two bedroom”) in the “Unit Types” Tab.
Comparative Stats Base Data
The application gathers the following base data for the dates as described above for the various Unit type breakdowns (and any other filters selected):
-
Unit Available Days Total : This is the total number of days in the date range for Units that are marked to include in statistics and that have active lease contract dates, regardless of whether the Unit is active or inactive. Both the start lease day and the end lease day are included in the calculation for Unit available days.
-
Occupied Days Total : This is the number of days for which there are Reservations in Units that are marked to include in statistics. For Units with subunits, if there is a Reservation in the main Unit or in any of the subunits, the Unit is considered occupied. Note that if there is more than one Reservation for the Unit (i.e., two subunits each have a Reservation for the day), this counts as only one occupancy.
If the default ‘Rate Prorating’ setting is set to “By Night,” the departure day for a Reservation in the Unit is not included in the occupied days total (unless there is at least one resident ledger for the Unit that has rent with a “Daily” rate type). In these cases, the last day included in the occupied days total is the previous day.
Note that a Unit that is not considered available (i.e., does not have a contract) may have a Reservation (thus, occupied days) associated with it. This can (but does not always) result in an occupancy percent figure that is over 100%.
If a package rate is used for rent, or a Reservation has no rent paying ledger, all days are counted as occupied. A single Reservation with multiple ledgers on any given day counts as one occupied day.
When using the Transfer Module and a resident is transferred from one Unit to another, the departure date of the first Reservation equals the arrival date of the second Reservation. Technically, two Units are “occupied” on this day. However, because the same resident is in both Units on that day, it does not make sense to count that resident twice for occupancy.
For determining the number of occupied days in these cases, the departure date of the Reservation in the first Unit is considered as the day before the actual departure date. This prevents the same resident from being counted twice on the actual departure date.
Rental Revenue Total
Rental revenues are calculated from the Resident Ledger lines created from the “bill from” and “bill to” dates for Rent charges, regardless of whether or not those charges have been invoiced yet. Manually added “other charges” posted to rent accounts are not included in the rental revenue figure.
Note that revenue may or may not be generated for the bill to date as follows:
-
Default prorate type in settings is “By Night” For monthly, weekly, or nightly charge types, no revenue will be generated for the bill to date. For daily charge types, revenue will be generated for the bill to date.
-
Default prorate type in settings is “By Day” For nightly charge types , no revenue will be generated for the bill to date. For all other charge types, revenue will be generated for the bill to date.
A Daily Rate (DR) is calculated for rent for every resident ledger for the day for both Units and subunits that are marked to include in statistics. The base rates used for this calculation (for all figures except the budget figure) are the rent rates that are automatically generated by Oscar from the Resident Ledger lines created from the “bill from” and “bill to” dates for Rent charges.
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.
The budget figure is the sum of amounts entered into the budget module for all accounts that have been selected as ADR accounts in the financial settings section of Orion.
Monthly Rate
Previously, statistics used the default prorate formula selected in Settings to calculate a daily rate from a monthly rate. For Daily Stats, monthly rates are always prorated to determine a daily rate. For Comparative Stats, a daily rate is calculated only if necessary.
The new calculations for Statistics use the number of days for the charge as the basis for converting both monthly and package rates into daily rates. This provides a more accurate figure for Daily Stats, and a much closer match between Comparative Stats and Daily Stats.
Note that changing the Rent Rate on a Resident Ledger or changing the “Bill From” or “Bill To” dates on a Resident Ledger/Reservation has an effect on the Daily Rate. However, applying credits to rent does not affect the Rent Rate and therefore does not affect ADR.
Previously, projected rent revenue (Statistics) did not include rent rates based on Rent Builder. SA has modified all statistics so that these rates are now included.
Comparative Stats Calculated
This report contains the following data for each Unit type (along with the total for all Units types) for each date range, and the totals only for the month budget.
Occupancy % : Occupied Days / Unit Available Days
Rental Revenue : This is the same as in the Base Data Report (see above)
Average Daily Rate : Rental Revenues / Occupied Days
Rental Rev Par : Rental Revenues / Unit Available Days
Average Units : Unit Available Days / Number of Days in date range (rounded to a whole number of Units)
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.
% Change (Current to Last Year) : This is calculated for each of the above categories that contain data for the month for the previous year. The figure contained in this column is calculated as follows:
Current Month Figure – Last Year Month Figure / Last Year Month Figure
For example: 100 (current) – 75 (last year) / 75 (last year) = + 33% = % Change
For example: 75 (current) – 100 (last year) / 100 (last year) = – 25% = % Change
Rent Reconciliation comparison to Comparative Statistics
For the same period and Market selection, the “Rent Posted to G/L” total should equal the sum of all ADR account amounts on the P & L, and the “Calculated Rent” total should equal the revenue total on Comparative Statistics.
The Statistics reports include only projected Rent revenue generated in Units marked to include in statistics. The Rent Reconciliation may also include projected rent revenue for Units that are not marked to include in statistics.
The Rent Reconciliation Report has been modified to indicate which Reservations with a non-zero calculated rent are in non-statistical Units (via a double asterisk next to the Reservation number).
On the last page of the Rent Reconciliation report below the “Calculated Rent” total, two additional totals are now displayed: “Not Included in Statistics,” and “Included in Statistics.” The “Included in Statistics” total should match the rent revenue per the Comparative Stats report.
Notes:
The “Effective Rate” label has been changed to “Current Rate.” Although the source for this data is the same as it was previously, the actual calculated amount may not necessarily be based on this rate, since the calculated amounts are now from the resident ledger lines instead of the current charge definition.
Rent credits associated with transfer activity may be posted to a period for which there is no calculated rent charge. These lines on the report will contain a negative G/L amount, the same negative amount for the calculated charge, and will contain NULLS for current rate, type, etc.
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.
