Worthic calculates occupancy from the guest, tenant and owner-stay records attached to a real estate reporting line. For each reporting period, the system works out how many nights were available and how many of those nights were occupied by records that overlap the period.
For monthly occupancy reporting, Worthic splits the selected date range into month-based segments. If the report starts or ends mid-month, only the relevant portion of that month is counted. Available nights are calculated from the number of nights in that segment. For multi-unit properties, the calculation is done per active unit, so each unit has its own available-night and occupied-night count. Archived units are excluded.
Occupied nights are calculated by comparing each booking or tenancy record’s check-in and check-out dates with the reporting period. Only the overlapping nights count. For example, if a stay runs across two months, Worthic allocates the correct number of occupied nights to each month. Occupancy percentage is then calculated as:
occupied nights ÷ available nights × 100
Average nightly rate is calculated for short-term rental records only. Owner stays count toward occupancy, but they are excluded from nightly-rate calculation because they do not represent rental income.
For short-term rentals, Worthic first determines the booking’s rental value. Where linked property transaction lines exist, it uses actual rental income matched to that guest or booking. If not, it falls back to the booking’s base-currency amount or gross income. The booking value is divided by the booking’s total nights to get a nightly rate. When a booking overlaps a reporting period, that nightly rate is weighted by the number of nights falling inside the period. The final average nightly rate is the weighted total divided by the relevant rate nights, then rounded.