Book a demo Sign in
Rates & inventory Live

Derived rates

The tariff is one number and the gaps: type the display rate, the room gap and the meal gap, and every plan on every type is derived — with the OTA promotion on top.

The owner's own spreadsheet had six inputs and everything else on it was a formula: the PMS rate is the minimal display rate plus the room gap plus the meal gap; the OTA's rate is that plus what the OTA will discount. This is that sheet, inside the product, with the formula kept and the retyping removed.

How it reads

Change the one number and every plan on every type moves with it; change a gap and only that column moves.

Two-way

The sheet can be read the other way: given the price the hotel wants a guest to see on an OTA, it says what to push. Three tabs — the card as derived, the card as pushed, and the worked example the manual shows with three pictures.

What it does not do

It writes the rate card. It does not touch a rate already agreed on a booking — the rate agreed is the rate carried.

More on Rates & inventory

Rate plans and seasonsA hotel keeps its own plans — room-only, breakfast, half board, full board — each saying what it includes, priced by season, and read by every screen that quotes. Every plan is priced on one formRoom-only, breakfast, half board and full board for every room type across a date range — set in one press, not twelve. A room is priced by who sleeps in itSingle, double, triple, the extra bed, the child under six and the child under twelve — the quote reads the occupancy, and the channel receives the same table. RestrictionsMinimum stay, closed to arrival, stop sell, a closed date — written once, shown above the chart, and pushed to every channel. The GST slabThe slab follows the tariff by law. The system reads the rate on the night and applies the slab in force — and a channel price that says tax zero is a price with the tax inside it. The rate agreed is the rate carriedThe price on the booking is the price the night is posted at. The desk may name it until the guest leaves; after that a change is a note, not an edit. Rooms and room typesA hotel keeps its own inventory — types, real room numbers, floors, how each is made up — and changes it after go-live without raising a ticket. How many rooms are left each nightThirty nights down the page with the sold, the blocked and the free — for the person deciding whether to open the rate. The rate is recommended with its reasons, and a person says yesEvery night of every room type scored every hour against what is on the books — occupancy against the hotel's own booking curve, pickup, last rooms, need dates, events — and a price proposed with the reasons in words. Approve writes it and the channel is told the same minute. Off by default; no autopilot.