Hotel Cash Flow Agent
Monitors each property's cash position through the seasons, deposits, owner distributions and FF&E spend.
- Industry
- Hotel
- Department
- Finance
- Team
- Planning and Compliance
- Kind
- Decision-maker
- Approver
- Financial Controller
- Code
- FIN-11
It keeps a rolling weekly cash forecast for each property from bank balances, card and OTA settlements due, city ledger receipts, advance deposits taken and refundable, payables by due date, payroll, tourism and sales tax remittances, management fees, owner distributions and FF&E reserve spend. When a week falls below the minimum balance, often in the low season or ahead of a renovation, it proposes the actions that close the gap before the shortfall happens.
How it works
7 steps, and a person signs off before step 7.
- 01Looks it up
Finds the record the request is about in the bank feed and the accounting system: bank balances, card and OTA settlements pending, city ledger due dates, advance deposits, payables due and scheduled tax, fee and distribution payments by property..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Forecasts, when it decides
Projects what each option will cost or return before it recommends one.
- 05Works it through
Prepares the draft, match, recommendation or reply, with its sources.
- 06Asks a person
Hands the work to Financial Controller with its reasoning before anything goes out.
- 07Acts
Once approved, it acts in the treasury system: it updates the cash forecast and queues the approved actions. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The treasury policy: minimum operating cash per property, seasonality of receipts, card and OTA settlement timing, advance deposit rules (refundable versus earned), tax remittance dates, the management agreement's fee and distribution terms, the FF&E reserve and the credit facility.
Reads from
the bank feed and the accounting system: bank balances, card and OTA settlements pending, city ledger due dates, advance deposits, payables due and scheduled tax, fee and distribution payments by property.
Acts in
the treasury system: it updates the cash forecast and queues the approved actions.
Hands back
An object with as_of_date, weeks (a list, each with week_start, property, opening_usd, receipts_usd, payments_usd, closing_usd, refundable_deposits_usd and below_minimum (true or false)), facility_headroom_usd, actions (a list, each with action, amount_usd, week and effect) and summary.
Asks a person when
It proposes a facility draw, a change to an owner distribution, a deferral of FF&E spend or a change to a payment date, or any forecast week falls below 250000.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Minimum operating cash per property (USD) | 250000 | A forecast week below this triggers actions. |
| Weeks forecast | 13 | The forecast horizon. |
| Treat refundable deposits as unavailable | On | When on, advance deposits still refundable under the cancellation policy are not counted as available cash. |
| City ledger receipts slip by (days) | 10 | Expected direct-bill receipts are moved this many days later in the forecast. |
| Facility headroom alert (USD) | 100000 | Headroom below this is flagged. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Forecast 13 weeks by property from bank balances, settlements, receipts, deposits, payables, payroll, tax remittances, fees, distributions and FF&E spend.
- When on is true, exclude advance deposits still refundable under the cancellation policy from available cash.
- Move expected city ledger receipts 10 days later than due, and time card and OTA settlements by their actual lag.
- Tourism and sales tax collected is always remitted on its due date and is never used to close a gap.
- When a week falls below 250000, propose actions in order: chase receipts and group deposits due, defer discretionary FF&E spend, reschedule the owner distribution, then draw on the facility.
- Flag facility headroom below 100000 and send any draw, distribution change or payment date change to the Financial Controller.
See the Hotel Cash Flow Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.