HorecaHire
A hotel cash flow forecast template predicts actual money expected to arrive in the bank and leave it over a defined period. It is not the same as hotel profit, an accounts receivable aging report or a budget. This HoReCaHire 13-week cash planning guide includes a weekly opening-and-closing cash model, group deposit controls, payment-priority questions and a realistic rupee exercise developed for hospitality operations.
Hotel cash flow forecast template: direct formula
Forecast ending cash = opening available cash + forecast cash receipts − forecast cash payments. The two supporting rules are to use actual expected cash movement dates—not the date revenue was recognized—and to document whether expected collections are confirmed, tentative or overdue. Include restricted/escrowed balances separately where appropriate; a positive bank balance doesn’t mean all cash is available for unrestricted spending.
Why hotels need weekly rather than only monthly cash plans
A hotel may collect an event deposit months before a banquet, pay suppliers after the event, owe salaries weekly or monthly and face a large equipment bill during a low-occupancy period. A monthly P&L can show booked revenue even when an OTA remits later. A hospitality cash-flow template released in October 2026 presents a 13-week weekly horizon with scenario adjustments, thresholds and payment tracking. This is a commercial template illustration rather than an official financial reporting standard.
What belongs in a hotel cash forecast
| Expected receipt | Possible source | Needed verification |
|---|---|---|
| Direct hotel reservations | Actually due guest/processor settlements | Settlement date and fee netting |
| OTA merchant payouts | Approved OTA remittance | Real cutoff and charges |
| Group and banquet deposits | Contract-backed payment schedule | Avoid double-counting prepaid revenue |
| Corporate receivables | Genuine AP/AR agreed receipts | Invoice aging and probability |
| Operating payments | Payroll, utilities, suppliers, taxes | Approved due dates, not guesses |
| Capital and financing | Equipment, rent, debt or reserve transfers | Actual obligations and restrictions |
Worked ₹ weekly forecast example
Suppose a fictional independent hotel begins Monday with ₹8,00,000 unrestricted opening cash. It expects ₹4,50,000 of verified receipts during the week and ₹6,20,000 of properly scheduled payments. Ending projected cash = ₹8,00,000 + ₹4,50,000 − ₹6,20,000 = ₹6,30,000. If the hotel’s approved minimum liquidity buffer is ₹7,00,000, the projected shortfall below that management threshold is ₹70,000. This is a management scenario, not a legal minimum or real hotel balance.
| Forecast row | Fictional rupees | Formula |
|---|---|---|
| Monday opening cash | 8,00,000 | Actual reconciled starting point |
| Weekly expected collections | +4,50,000 | Genuine receipts and timing |
| Weekly scheduled payments | −6,20,000 | Actual authorized obligations |
| Projected weekly close | 6,30,000 | Opening + receipts − payments |
| Management reserve threshold | 7,00,000 | Illustrative internal policy |
| Gap below threshold | 70,000 | Threshold − forecast close |
Copy-ready 13-week hotel forecast worksheet
| Field | Record |
|---|---|
| Week beginning / ending | [Actual week dates] |
| Opening unrestricted cash | [Reconciled bank and cash balances] |
| Confirmed booking/guest settlements | [Legitimate expected settlement dates] |
| OTA/corporate collections | [Invoice/payout reference and confidence] |
| Deposits and event receipts | [Signed contract and repayment obligations] |
| Payroll, statutory and utilities | [Scheduled actual due dates] |
| Supplier, rent and equipment payments | [Approved purchase, invoice or lease] |
| Taxes, financing and capital expenditure | [Real payment schedules] |
| Ending cash / reserve gap | [Computed and owner-reviewed] |
| Scenario and corrective action | [Owner, evidence, priority, next update] |
Three confidence categories for collections
- Confirmed: actual settlement/payout or contractual collection with a verified due date and appropriate confidence.
- Likely but conditional: genuine corporate or group amount expected yet subject to customer action or dispute; show sensitivity.
- Uncommitted: tentative future bookings or sales leads; do not treat as guaranteed bank deposits.
- Past due: overdue accounts receivable are not available cash until genuinely collected.
- Refund exposure: valid refundable group deposits may need a separate liability scenario, not counted as free profit.
13-week rolling cash forecast SOP
- Confirm bank balance and all restricted cash at the beginning of the week.
- Gather verified hotel booking/payout schedules, AR and due supplier bills.
- Align every forecast transaction to expected bank movement date.
- Classify committed, contingent, disputed and seasonal activity separately.
- Calculate each week’s ending balance and roll it into the next opening balance.
- Test sensitivity to lower OTA deposits, a canceled group and urgent repairs.
- Document authorized actions and compare last week’s forecast with actual transactions.
- Extend the model one new week after closing the oldest completed week.
Cash flow pitfalls for hotel managers
- Using projected occupancy × ADR as guaranteed bank receipts.
- Counting a group advance as both a new deposit and later full guest payment.
- Ignoring refundable deposit obligations and contractor retentions.
- Comparing gross OTA room value with net platform remittance.
- Leaving paid taxes, payroll and equipment deposits out of the same week’s cash plan.
- Treating every positive P&L month as sufficient liquidity.
- Posting optimistic receipts into earlier weeks to hide a projected minimum-cash breach.
Hotel cash forecast vs restaurant P&L
A restaurant may recognize eligible sales when served while the processor remits later, or pay for kitchen supplies before the related revenue is earned. The P&L answers whether recognized activity contributed to profit under its accounting basis. The cash forecast answers whether the hotel can meet actual due payments. Both are useful and neither should be altered to make the other look attractive.
Review questions for the Financial Controller
Can all major receipts be linked to source documents? Which corporate invoices are disputed? Are statutory and staff obligations fully budgeted? What happens if the largest confirmed banquet deposit is delayed by a week? Which equipment work is safety-critical and cannot be postponed? The GM should choose transparent authorized responses, not hold lawful wages or withhold essential guest safety expenses solely to improve a weekly line.
Related HoReCaHire managerial resources
Read Hotel General Manager responsibilities, Duty Manager duties, F&B financial oversight, Restaurant Manager controls, staff attendance cost records and hotel finance recruitment.
Frequently asked questions
What is the hotel cash flow forecast formula? Opening cash plus forecast cash inflows minus forecast cash outflows. Is a banquet deposit immediate profit? Not automatically, even when cash arrives. Should I forecast weekly for 13 weeks? It is a useful short-term rolling view, not a mandatory reporting period. Does cash flow equal RevPAR? No, RevPAR is a rooms revenue metric.
Editorial note: Original HoReCaHire 13-week framework and fictional rupee cash arithmetic; compared with published 2026 hospitality cash forecasting models. Validate real financial treatment and liquidity obligations with your Financial Controller.
