AI agent for hotel managers
Hotel Rate Sheet Consistency Agent
Every rate sheet matches the approved rate rules.
What it does
Approved hotel rate changes often do not show up consistently across working rate sheets. When a rate change is approved, this agent compares each sheet's effective dates and prices with the approved rules. It drafts corrections, then recalculates package totals, minimum-stay restrictions and other dependent rules. If a correction breaks a dependent rule, such as a package total or a minimum stay, it repairs that rule and reruns the checks. It only corrects from the approved rules, never from its own judgment about pricing. The revenue manager approves publishing. Edge case: two approved rules overlap on the same dates, so the agent asks the revenue manager which applies rather than choosing.
How it works
Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.
Read the steps as a list
- Rate change approved
- Compare sheets with approved rules
- Draft corrections
- Recalculate totals and restrictions
- Do package totals and restrictions still follow the rules?If not: repair the dependent rule. Back to step 3.
- Revenue manager approves publishingThe agent waits here for your OK.
- Reconciled rate-sheet pack
How it decides
It corrects from the authoritative rules and re-checks dependent rules after each change.
- The approved rules are the only authority.
- Dependent rules are rechecked after every change.
- Overlapping approved rules go to the revenue manager.
- No pricing decisions by the agent.
Make it yours
Every agent is a starting point. You choose these settings for your own situation.
- Rate sheets to compare
- Dependent rules to recheck (packages, minimum stay, discounts)
- Rounding rules for totals
- Who approves publishing
- Pack format
What keeps you in control
It always asks you first
- Publishing rates
- Pricing decisions
Hard limits
- No publishing.
It stops when
- Done: all sheets consistent.
Set it up
We guide you through the set-up, step by step
Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.
- One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
- The agent then walks you through connecting your own data, one source at a time
- A downloadable copy with the flow chart, the rules and the full guide
