Rate Discrepancy Report - One of Very Important Document to See if Rooms are Being Sold at Unauthorized Rates

11 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$4.99
List Price:  $50
You save:  $45.01
€4.63
List Price:  €46.43
You save:  €41.79
£3.97
List Price:  £39.84
You save:  £35.87
CA$6.82
List Price:  CA$68.35
You save:  CA$61.53
A$7.55
List Price:  A$75.70
You save:  A$68.14
S$6.73
List Price:  S$67.50
You save:  S$60.76
HK$38.98
List Price:  HK$390.61
You save:  HK$351.63
CHF 4.51
List Price:  CHF 45.24
You save:  CHF 40.72
NOK kr54.26
List Price:  NOK kr543.73
You save:  NOK kr489.46
DKK kr34.58
List Price:  DKK kr346.49
You save:  DKK kr311.91
NZ$8.30
List Price:  NZ$83.18
You save:  NZ$74.88
د.إ18.32
List Price:  د.إ183.64
You save:  د.إ165.31
৳546.12
List Price:  ৳5,472.22
You save:  ৳4,926.09
₹416.06
List Price:  ₹4,169.01
You save:  ₹3,752.94
RM23.65
List Price:  RM237
You save:  RM213.34
₦6,162.65
List Price:  ₦61,750
You save:  ₦55,587.35
₨1,389.71
List Price:  ₨13,925
You save:  ₨12,535.28
฿183.42
List Price:  ฿1,837.93
You save:  ฿1,654.50
₺161.44
List Price:  ₺1,617.68
You save:  ₺1,456.23
B$25.31
List Price:  B$253.62
You save:  B$228.31
R92.35
List Price:  R925.45
You save:  R833.09
Лв9.05
List Price:  Лв90.76
You save:  Лв81.71
₩6,766.66
List Price:  ₩67,802.25
You save:  ₩61,035.58
₪18.54
List Price:  ₪185.85
You save:  ₪167.30
₱284.74
List Price:  ₱2,853.17
You save:  ₱2,568.42
¥763.79
List Price:  ¥7,653.25
You save:  ¥6,889.45
MX$84.68
List Price:  MX$848.50
You save:  MX$763.81
QR18.16
List Price:  QR182.05
You save:  QR163.88
P67.79
List Price:  P679.25
You save:  P611.46
KSh659.32
List Price:  KSh6,606.48
You save:  KSh5,947.15
E£238.99
List Price:  E£2,394.71
You save:  E£2,155.72
ብር285.64
List Price:  ብር2,862.14
You save:  ብር2,576.50
Kz4,171.64
List Price:  Kz41,800
You save:  Kz37,628.36
CLP$4,701.99
List Price:  CLP$47,114.21
You save:  CLP$42,412.21
CN¥36.11
List Price:  CN¥361.86
You save:  CN¥325.75
RD$289.15
List Price:  RD$2,897.38
You save:  RD$2,608.22
DA671.61
List Price:  DA6,729.65
You save:  DA6,058.03
FJ$11.24
List Price:  FJ$112.66
You save:  FJ$101.42
Q38.67
List Price:  Q387.57
You save:  Q348.89
GY$1,041.02
List Price:  GY$10,431.15
You save:  GY$9,390.12
ISK kr696.80
List Price:  ISK kr6,982
You save:  ISK kr6,285.19
DH50.19
List Price:  DH502.91
You save:  DH452.72
L88.14
List Price:  L883.23
You save:  L795.08
ден285.06
List Price:  ден2,856.31
You save:  ден2,571.25
MOP$40.05
List Price:  MOP$401.32
You save:  MOP$361.27
N$92.11
List Price:  N$922.98
You save:  N$830.86
C$183.18
List Price:  C$1,835.52
You save:  C$1,652.33
रु664.41
List Price:  रु6,657.44
You save:  रु5,993.03
S/18.57
List Price:  S/186.13
You save:  S/167.55
K19.23
List Price:  K192.74
You save:  K173.50
SAR18.71
List Price:  SAR187.52
You save:  SAR168.81
ZK134.22
List Price:  ZK1,344.96
You save:  ZK1,210.73
L23.05
List Price:  L231.04
You save:  L207.98
Kč116.12
List Price:  Kč1,163.58
You save:  Kč1,047.45
Ft1,806.23
List Price:  Ft18,098.50
You save:  Ft16,292.26
SEK kr53.82
List Price:  SEK kr539.37
You save:  SEK kr485.54
ARS$4,382.42
List Price:  ARS$43,912.11
You save:  ARS$39,529.68
Bs34.46
List Price:  Bs345.29
You save:  Bs310.83
COP$19,381.49
List Price:  COP$194,203.37
You save:  COP$174,821.87
₡2,543.28
List Price:  ₡25,483.82
You save:  ₡22,940.53
L122.92
List Price:  L1,231.72
You save:  L1,108.79
₲37,252.87
List Price:  ₲373,275.29
You save:  ₲336,022.41
$U190.71
List Price:  $U1,910.97
You save:  $U1,720.25
zł20.06
List Price:  zł201.01
You save:  zł180.95
Already have an account? Log In

Transcript

Before the break, we were discussing about how to check the hotel revenue report. Right. So we were discussing the revenue and revenue that we need to check how we need to check. So some of these reports we cannot check here because the hotel it depends on the hotel's operating centers or operating systems, whatever you are using to arrive at departure report or Rate Variance report is also different for each but we have a sample we're gonna show you now, the housekeeping room clean also is there's no specific report, you just need to ask the housekeeping. Normally the system generate millions report so we have that report or we can show you now and then the captain order depends on the hotel or how they are using open items. It also depends on the US system.

What checks also we don't we I think we have a report. Mature Let me check. Under the split and merge check. We explained in detail what what you're supposed to check Good. So, the next one is Rate Variance report. So, what is a Rate Variance report?

So, the Rate Variance report will give you all the rooms which are sold at not centered. So, there is a standard price for set by the total for each segment for each room category, but, if the hotel is sending any room, which is not centered then it will show in the late variance report. So, the Rate Variance report looks like this. This is same in your templates also. So, you can refer to which page So, this one is you can see the columns are the room number of room number, how many number of rooms how many adults are there and then you have the guests name, arrival time, arrival date, departure time, their nationality, their market segment, route category and then they are rate and the discount percentage okay. To the rate and the discount percentage is the important thing.

So wherever the system finds either zero or discount, it will configure into the Rate Variance means the hotel is giving some discount. So the the reason what income what you're supposed to check, the interpreter is supposed to check the documents supporting document who approved the wreck who approved that is not and what was the reason for that is since it has detail of the market segmentation as well. So he remember when we were discussing that the segmentation of revenue should also be correct. So you can check your segmentation here as well. You don't need to go anywhere else because this report will list out all the rooms in the hotel, having a Rate Variance or having no experience normally. So it can because it will give you the nationality it will give you the room segment And it will give you the root category everything all information is there.

So, you can check from one report you can check all the aspects okay. So, you can check the discount, you can check the market segmentation and you can check the rate categories. So, even Even so, if you say let's say you have a red candle market through category right and you are seeing double the number of packs also. So, the incubator can check if this room category we are selling at a normal rate. So, if they are double or two people or three people are charging for extra bed or be charging for people rate or double rate or not right, because it can happen that the reservation when the when the room was booked, they book for one people. So there is a reason why one person rate or your hotel may have a double a double occupancy rate triple occupancy rate or four occupancy rate right.

So when reservation is not normally guests Don't, don't tell how many people's will stay, maybe one person will say two people will stay. So they make the booking when they come at different office how many people are staying so that because in your mind you have to show the passport or the National ID to stay at the hotel. So they have to stay so the front office they register many people's maybe 3d printers, but front office staff may not be very diligent to charge triple rate or double X to change the booking. So they may they will just key in the system and then it's okay but the income older job is to check are we charging for extra bad Are you charging for double occupancy? So even though you can take even the room is occupied the room is paid you stay 1% or 2% but there is a cost of two second was like you have to pay extra brick first you have to pay for the amenity you have to pay for the bathroom amenities.

So these are the extra charges so that's why we can charge for extra or extra costs and charges. So, one thing you can check is the extra one second thing you can check is the rate versus the room category. Sometimes the hotel does upgrade right they give the guest book for one category, but the guest came under the wrong category because you are either upselling or you are upgrading the room guest for free. So, those are also you can check from here. The most important check is the rate various reports supposed to be checked by Night Manager First, the person who is doing the front office or the front office manager, then it comes to the income auditor so income auditor is only checking that is checked by the front office and it has some reasons. So, whenever there is a discount, there has to be a reason measure.

So in Gemalto supposed to check that reason, and the approval quality normally the hotel have a delegation of authority, how much discount operation manager get how much discount general manager can approve our discount a director has to approve however discount supervisor can correct everyone has a delegation of authority supervisor can approve maybe 5% discount or 10% discount manager maybe can approve 15% or the general manager can approve only 20% or 30% or maybe 50% more than that need to get over. So, the intermodal job is to check is that do a follow up if the if there is a discount given, so, they will need to check the documentation who approved the discount is it as per the delegation of authority of the hotel owner. So, you need to be aware of delegation of authority as well. So, then you identify all the documentation and then check the approvals and the reason for that discount.

And then check the market segmentation and upgrades from this Maxim from this Rate Variance report. So, this rate various report how often you To check every day, because this is a daily report right. So, Sunday we have we have a full occupancy. So the report will be very long and Sunday the occupancy is only very little. So the report that it will be short answer, but it doesn't matter. It has to be checked every single day.

Especially by admins. Though because the primary person to check this report is the Night Manager or the front office manager then it comes to the income on the income order never check this report directly. Okay even though is the responsibility but income auditor is checking it after the front office manager. This is a system generated normally because you're going to prepare it manually. Nowadays every every PMS is generating this. This one is from E Fo this one from EZ fo abre also generate this template is almost the same thing.

Employee report is not changing because the standard okay there is another report, call rules. Stevens report, I was telling you one report which is the discrepancy between the hotel front office occupancy and housekeeping occupancy right. So this report is will tell you what is the status this report is from opera. So they have a room number, room type room status so fo rooms mean this room is occupied as per fo our front office is this, this room was supposed to be occupied through the front office, front office, when it says zero means for front office, it does not occupy it means they did not collect the money or they did not allow the guest to stay in. They did not shoot the key. But housekeeping says the room was dirty so they clean them.

So who's dangerous? Who said but there has to be a question. So the income altar is checking it every day. Normally, his report is also generated, who is editing this report, housekeeping, housekeeping generate and give it to them in the particle because the first status is done by front office second status is done by housekeeping. housekeeping is once they clean the room and then they will generate the report at the end of the day and they pass on to income auditor in the auditor can print it directly by themselves also, but the housekeeping need to write down the reason because there is an occupancy discrepancy reason right somebody is writing down the discrepancy also. So, the housekeeping manager is checking every day and then they collect with the front office whatever your from your side room is not occupied from my side who is occupied what is the problem all right so they can reason okay the room was leave the room was kept the guests check out without any payment or the guests overstay.

Right can be many reasons for differences. So they sort out the differences and then they submit to the income auditors but income auditor normally be very fun. It can be if they is a very serious doubt it can go even to the CCTV camera to check if the guests really stay there or not. Right You can check you should never ignore this report never ignored this report. Even though everybody signed this report there is a mention there is a reason measured but you need to always check for the reason because normally is is not normal to have differences is quite abnormal. Normally there is no should not be any differences in a day maybe if it's a when I was working for Bangkok for 800 rooms we used to get only one room two rooms a day maximum or sometimes even four months there is no discrepancy because the string the controls are a straight out is the technology with a key are issued automatically from the systems they should not be many differences.

So ideally there is no difference. But if there is a difference that is quite serious, clear on the Rubin report. Okay, so this section We are going to do only these report because why check report

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.