Advance Deposit and Daily Cash Agent
Tracks guest and group deposits held against the day's cash position across the hotels.
- Industry
- Hotel
- Department
- Finance
- Team
- Planning and Compliance
- Kind
- Decision-maker
- Approver
- Financial Controller
- Code
- FIN-18
It keeps a daily position for each property of cash in bank against the advance deposits it holds for future stays and events: guest prepayments, non-refundable rates, group and wedding deposits, gift voucher balances and loyalty-redemption settlements due, split into what is still refundable under the cancellation terms and what is earned on arrival. It tests whether cash covers the refundable deposits by the required ratio, forecasts the position over the coming weeks from arrivals, cancellations and deposit schedules, and recommends transfers between the operating and deposit accounts for the controller; it never moves funds itself.
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 property management system (PMS) and the bank feeds: advance deposits held by booking and rate plan, group and event deposits from the sales and catering system, voucher balances and the operating and deposit account balances..
- 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 prepares the recommended transfers for the controller to release. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The deposit policy: deposit and cancellation terms by rate plan and group contract, the deposit account and ring-fencing rules, gift voucher liability and expiry rules, cancellation patterns by lead time and season, bank cut-off times and the required cover ratio.
Reads from
the property management system (PMS) and the bank feeds: advance deposits held by booking and rate plan, group and event deposits from the sales and catering system, voucher balances and the operating and deposit account balances.
Acts in
the treasury system: it prepares the recommended transfers for the controller to release.
Hands back
An object with as_of, properties (a list, each with property, operating_cash_usd, deposit_account_usd, refundable_deposits_usd, earned_deposits_usd, voucher_liability_usd, cover_ratio and headroom_usd), forecast (a list, each with date, property, refundable_deposits_usd, expected_refunds_usd and cover_ratio), transfers_recommended (a list, each with property, from, to, amount_usd and settle_date) and summary.
Asks a person when
It prepares any transfer between accounts, cover falls below 1.0 or headroom below 50000, or a month-end figure rests on a forecast rather than a bank confirmation.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Cash must cover refundable deposits by (ratio) | 1.0 | Cash in the deposit account must be at least this multiple of deposits still refundable. |
| Cover headroom alert (USD) | 50000 | Headroom over required cover below this is flagged. |
| Cancellation history used (days) | 365 | History used to forecast cancellations and refunds by lead time. |
| Deposits become earned on | arrival | When a deposit moves from refundable liability to earned and can leave the deposit account. |
| Bank transfer cut-off (local time) | 15:00 | Transfers prepared after this settle the next business day. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Split deposits held into refundable and earned using each rate plan's and contract's cancellation terms; deposits are earned on arrival.
- Cash in the deposit account must cover refundable deposits by at least 1.0; flag headroom below 50000.
- Forecast refunds from 365 days of cancellation history by lead time and season, plus known group and event cancellations.
- Recommend transfers of earned deposits from the deposit account to operating, or top-ups the other way, timed before the 15:00 cut-off.
- Gift voucher balances stay a liability until redeemed or expired under the voucher terms.
- It never releases or moves funds; every transfer goes to the Financial Controller.
See the Advance Deposit and Daily Cash Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.