This report gives booking-wise revenue & payment split for the Used Room Nights (URNs) in the selected date range. The bookings that appear in the report will change based on the filters applied. Default selected filters:
  1. Booking source: All sources
  2. Booking status: Confirmed, Checked-in, Checked-out, Saved
  3. Date Type: In-stay

Scenario

Booking with a daily room rate of $50 has check-in on 1st Sept. and checkout on 11th Sept., then it has 10 URNs, implying total revenue of $500.
Below is the description of column headers and how the above booking report may change under various scenarios:

1. Bookings

Those bookings are included which have “Used Room Nights” (URNs) in the selected date range.
When the selected date range is from 1st Sept to 5th Sept, then this booking will show as In-Stay booking.

2. Room Nights

Total URNs in the selected date range.
When the selected date range is from 1st Sept to 5th Sept, then no. of Room Nights will be 5

3. Room Revenue

Revenue that is expected to be generated from these bookings for the selected date range. Early check-in and late checkout bills are attached as room revenue on check-in date and checkout date -1 respectively.
When the selected date range is from 1st Sept to 5th Sept, then room revenue from the above booking is $250.

4. Other Bills

All bills (other than room revenue) included except Early check-in and late checkout; these are also divided on the pro-rata basis of URNs.

5. Total Payment

Only those payments reflected which have been collected in the selected date range. Payments before check-in date (Eg: Pre-paid bookings) are considered on check-in date and payments made on or after checkout are considered on the checkout-1 date
Case 1: The above booking was fully paid for on 25th August. When a selected date range is 1st Sept to 5th Sept, Payment will be $500 (Payments before check-in date rule)
Case 2: The above booking was fully paid for on 1st Sept during check-in. When a selected date range is 1st Sept to 5th Sept, Payment will be $500 (Payment is on a collection basis, and not URN basis)
Case 3: Above booking was paid for during check-out on 11th Sept. When a selected date range is 1st to 5th Sept, Payment shown will be $0
Case 4: Above booking was fully paid for during check-out on 11th Sept. When selected date range is 5th to 10th Sept, Payment shown will be $500 (checkout-1 date rule)
Case 5: The above booking is paid on a daily basis, $50 every day. When the selected date range is 1st to 5th Sept, Payment shown will be $250.

6. Booking Modifications

Booking extensions :
Bookings are extended and effective rate is modified.
Above booking is extended for 4 days, check-out on 15th Sept. For the extension, the PM offers a reduced room rate for $43. Total revenue now is: ($50*10)+($43*4)=$672. Effective room rate for the entire duration is $48 (=$672/14).
Revenue:
When selected date range is from 1st Sept to 5th Sept on 15th Sept, then room revenue from the above extended booking is $240 (=$48*5)
A booking or a payment can be modified before recon freeze by recon and fulfilment based on requests from the owner or Property manager. These changes are also reflected in report changing the overall revenue.
Any other booking modification like early checkout may lead to reduction of room revenue, which will be reflected in the report.

7. Date Type Filter Selected - Arrival

  1. Bookings - Which have check-in between the given date range.
  2. Revenue, Payment - Same logic as above

8. Date Type Filter Selected - Departure

  1. Bookings - Which have check-out between the given date range.
  2. Revenue, Payment - Same logic as above

9. Date Type Filter Selected- Bookings Date

  1. Bookings - Which have created at between the given date range.
  2. Revenue, Payment - Same logic as above