Why to Use


It is a monthly report which reflects the realtime difference between the Recon and OYO OS Bookings Report. This report is available after the reconciliation report has been generated for that month. The difference is provided on three key parameters: Room revenue, hotel collect payments and OYO payments.


Only those bookings that have revenue or payment variance for that month are reflected in the variance report.



Columns in Variance Report


  1. Booking ID 

  2. Guest Name

  3. Check-in Date

  4. Checkout Date

  5. Status - Booking Status

  6. Room Category

  7. No Of Rooms

  8. Room Nights

  9. Room Rate

  10. OS Revenue - Revenue for the booking as per OS

  11. Recon Revenue - Revenue for the booking as per Recon Report

  12. Difference - Difference in Revenue

  13. Hotel Collect Payments

    1. OS - Hotel Collect Payments as per OS Report

    2. Recon - Hotel collect payments as per Recon Report

    3. Difference

  14. OYO Collect Payments

    1. OS - OYO Collect payments as per OS Report

    2. Recon - OYO Collect payment as per Recon Report

    3. Difference











How to Use the Variance report to match revenue and payments


Variance report will contain all bookings where there is a difference of revenue and payment as reported in recon report vs that available in OS.


  1. Revenue Total in Recon = Revenue Total in Bookings Report +- Revenue mismatch as per Variance report

  2. Payment total in Recon = Payments Total as Bookings Report +- Payment mismatch as per Variance report


Note : This can be validated at a booking level or at a monthly level.



Reasons for Variance in Recon and OS Reports


  1. Taxes: 

    1. Tax entered in the system is incorrect and is changed post-fact 

    2. Tax needs to be exempted

  2. Security Deposit: 

    1. Security Deposit incorrectly added by staff in room tariff and needs to be modified. (Only for Walk-In)

  3. Booking Modification/Deletion:

    1. Duplicate Booking created and needs to be deleted

  4. Early checkout:

    1.  Amount collected by property is different than what was suggested by OS as early check out amount

  5. Room category: 

    1. Room category changed at the same price as previous category

  6. Spill over bookings: 

    1. Bookings having their check-in and check-out dates in different months; eg.: Check-out on 25th September and Check out on 4th October









Understanding Revenue entries


  1. Revenue on OYO OS is reflected on URN basis

Example: A booking is of $1000 for 10 days with check-in on 27th September and check-out on 7th October. In this case, only 4 out of 10 days of the booking lie in September; hence, revenue for September is $400. If the booking is modified after the fact (reasons for booking modification have been stated above), this can lead to a change in the average daily rate and hence change in URN based room revenue. 


  1. On the other hand, recon once calculated is not modified, all modifications are collectively reflected in next month’s revenue for such bookings. 


Above two cases arise in spillover bookings


  1. Revenue in OYO OS contains early check-in and late check-out bills where bills are attached on check-in and checkout -1 dates respectively.



Understanding Payment entries


  1. Payments in oyo os is marked on the same day it is collected, when the date of payment is a revenue bearing day, for days before check-in payment is marked on checking and payment on or after checkout are marked on checkout -1 date.


  1. Payment in recon also work on the same logic except for spill overbookings payments collected upto recon freeze (usually 2nd of next month) are marked on last revenue bearing date of that recon month.


Eg:


 

SpillOver booking and Non SpillOver booking difference : Say a Booking ABCDEF123 was created on Nov 25th with Check-in date of Nov 29th and checkout date of Dec 2nd and was prepaid. The payment will be applied on Day 1 of revenue bearing day i.e. Nov 29th and not the day it was paid. On Variance report, we would have this payment in Variance as the OS reports work on ARR i.e. realized payments so the amount reflected in November OS report will be for URN in November and Recon might consider full amount as it was paid in November. Variance report will show this exact difference and will help match Recon with OS report.


If the same booking was from Nov 29th till Nov 30th, the Recon and OS reports will match as the recon consider the payment last revenue bearing day of the month and as this booking was not spilled over to the next month, the revenue and payments matches in current month itself.


Early Check-in Bill / Late Checkout Bill: OS Bookings report will add Early check in and Late checkout bills to Revenue but Recon does not. So These bookings are shown in Variance report for Revenue mismatch. Ex : A booking with ARR $ 50 was created and guest comes early to the property.  Property manager charges $20 from the guest. So the OS report will show revenue as $70 and will give details on Early C/I bill.