After managing Hotel, creating Rate Code and completing the configuration of Room Categories, Transfers, Meal Plan & Supplement, our next step is to load rates of Rooms, Transfers, Supplements, Meals and Taxes. Rate loading is one of the most important steps in our HBT system. It includes:
- Rate loading for Room Categories,
- Meal Plan,
- Transfer and
- Supplement as per contract.
- It also includes loading of Tax Conditions as per contract. For example:
- Maldives has 3 types of taxes i.e. Green Tax, (USD 6 per person per night, regardless of age), 10% Service charges and 12% TGST
- Seychelles has 2 types of taxes i.e. 10% Service Charges and 15% Value added Tax
Important Note: While loading rates for Maldives hotel we have to load it exclusive of Green Tax i.e. USD 6
Also, note before loading our contracts rates, we have to create separate Excel Sheets for room rates. In this session, we will learn how to load rates for Rooms only.
Steps for loading Rates for Room:
- Select the Room type in which you want to load the rates from the contract.
- Select the base meal plan (on which room rates are based on0
- If rates are given in contract single double different then tick enables single pax rate loading or single & double rates are same no need to tick on enabling single pax rate loading.
- If rates are different in the same season, then we need to click on the expand button as shown in the pictures below.
- The most important part of rate loading is Rules which applied for 3rd, 4th, 5th etc adult & for 2nd & 3rd Child.
Examples 1:
Let’s consider rates for a 2 Bed Room is as below:
But our system does not have an option to load rates for Triple and Quad occupancy, instead, we have the Extra Person option. Hence, we calculate the Extra Adult Rate (3rd Adult): TPL – DBL = 152.
And for Quad: If the difference between Triple and Quad occupancy is as same the difference between Triple and Double then we do not have to click on rules.
But in cases like this where difference amount is different;
QUAD-TPL = 118
We follow the below steps
- We click on the rule button
- The accommodation rules box will open
- We have to put the 4th adult rate in the box.
- Click Extra Adult
- Add Rule
- Tick on Nth Pax Range
- Fill the box ‘From To’ rate
- Apply logic
- Click on ‘OK’
The logic we apply is as below:
For the 4th adult, we put from (2) to (2) Rate (34) Apply logic (Decrement). Extra Adult rate difference amount (3rd Adult) (152) – Quad difference amount (118) = 34
Now you can calculate the final rate:
SGL: 287 DBL: 338 TPL: 338+152 = 490 QUAD: TPL (490) + 118 = 608
[Extra adult (152) – 4th adult rule amount (34)]
Example 2:
1 child (2 – 11.99yrs) stays for free on the same board basis when sharing the room with their parents and after 1st child onwards USD 150 will be charged.
We click on the rule button then the accommodation rules box will open and we have to put the rule for the 1st child in the box.
- Click Extra Child
- Add Rule
- Tick on Nth Pax Range
- Fill the box ‘From To’ Rate
- Apply logic
- Click on ‘OK’.
The logic we apply is as below:
For 1st Child, we put From (1) to (1) Rate (150) Apply logic (Decrement).