Book a demo Sign in
Setting a hotel up

One number and the gaps — the derived rate sheet

Price the cheapest room once; every other room type and plan is a gap on top. Type what you want in hand and be shown the rate to push.

*Operations → Rates → Derived rates.* Instead of six prices, the hotel keeps one — the display rate of its cheapest room, room only — and a gap for everything else. Three tabs: Gaps and Promotions are set up once; The sheet is where a price is changed from then on.

Two ways in. Type a display rate and read what every room and plan will push, and what each nets. Or type the rupees you want in hand and read the display rate that reaches it (the smallest whole rupee that does), and what everything else becomes. Either way, Set these rates writes the one number for the nights you choose; the gaps do the rest and the channel manager is told on its own. Bookings already taken keep the price they were made at.

Gaps: each room type says which it is priced from, and by how much.
Gaps: each room type says which it is priced from, and by how much.
Promotions: what the OTA takes off and what it keeps, and what a displayed rupee comes home as.
Promotions: what the OTA takes off and what it keeps, and what a displayed rupee comes home as.
The sheet: a display rate or an in-hand figure, every room and plan worked out from it, and the button that sets them.
The sheet: a display rate or an in-hand figure, every room and plan worked out from it, and the button that sets them.

Do this

  1. Gaps — the first tab. Do this once.
  2. Priced from — for each dearer room type, choose the base. On its own means it keeps its own prices.
  3. Gap — rupees on top of the base, per night. Zero is allowed; a minus is not.
  4. Save. The type is repriced from the base at once, on every plan, and is no longer offered on the form below — set the base and it follows.
  5. Promotions — the second tab. Name each one as the OTA shows it, with its percentage off.
  6. Add. Order matters: they come off one after another, as they do on the OTA. Untick counts to leave one out without deleting it.
  7. OTA commission — its percentage, then Save.
  8. Net factor — what one displayed rupee comes home as. Nothing on this tab changes a price.
  9. The sheet — type a display rate on the base (the cheapest room, room only) …
  10. … or the rupees you want in hand. The other is worked out.
  11. The table — for every room type and plan: the rate to push, what the promotions leave, the commission, and what comes home. The base cell is marked *the number*.
  12. Nights — first and last.
  13. Set these rates. One number is written; the gaps price everything else in the same call, and the channel manager is told on its own.

A worked example

Standard Room is the base. Balcony is the base + 750, Deluxe is the base + 1,000; breakfast is + 925 on every room. The OTA runs three promotions — 25%, 0% and 10% — and takes 20% commission. Net factor 0.75 × 1 × 0.9 × 0.8 = 0.54: a hundred rupees displayed comes home as fifty-four.

Forward. Display 9,999 on the base. Balcony room-only pushes 10,749; with breakfast 11,674. Balcony room-only walks 10,749 → 8,062 (25% off) → 8,062 (0%) → 7,256 (10%) → commission 1,451 → 5,805 in hand. Every step is rounded to the rupee before the next, which is why it is 5,805 and not 5,804.

Backward. Want 3,000 in hand on the base. The sheet finds the smallest display rate that reaches it: 5,556 (5,556 → 4,167 → 4,167 → 3,750 → 750 commission → 3,000). Balcony and Deluxe follow at 6,306 and 6,556, breakfast at + 925 on each. Press Set these rates and that is what the channel manager shows.

Why the gap is never negative. The base is the cheapest room — the number the OTA shows as "from". If a room is cheaper than the one you called the base, make it the base.

More in Setting a hotel up

Opening a hotel: the whole thing in orderSix phases from the GST certificate to the first night audit, and what each one needs. Getting the hotel group signed upWhat Asar does, what the hotel does, and why nobody here chooses your password. After the wizard: making the hotel actually readyThe wizard makes a hotel that exists. This is what makes it one that can trade. Setting the restaurant up, in the order it has to be doneGST groups and stations before dishes, dishes before tables. Backwards means rebuilding the menu. The first real dayOne booking end to end before you rely on it, then the three daily habits. The month after openingFour things to read on a schedule, and the one that changes on its own. Adding a hotel: the five stepsOne wizard, five steps, and the hotel exists. Everything after it is adjustable. Room types and real room numbersThe type sets the price. The numbers are the rooms a guest is actually given. Room categories and room numbersAdding a category, putting rooms in it, moving a room, and taking one out of the inventory. Rates, plans and the cancellation policyA rate per type and date, and the rules that go with selling it. Adding and changing rate plansCreating a plan, what the meal codes mean, pricing one plan off another, and what stops you retiring one. Closing a date, minimum stay and stop sellThe five rules that decide whether a night may be sold, how to set them, and how to lift one. Rates run out — the check that is not about configurationA hotel that was ready in August stops being sellable in February. Load rates further ahead. Seasons — a date range that prices differentlySetting a peak or a lean period once instead of typing a hundred nights. Going live: the readiness checksEleven or so checks per hotel, and what each one means it cannot do yet. The onboarding boardEvery hotel in the group at once, and what each is still missing. Lists and reasonsEighteen short lists your staff pick from, and why free text was worse.