13-Week Cash Flow for Hotels

Profit and liquidity move on connected but different clocks

I want you to imagine a hotel that has just completed a reasonably good month. Occupancy was acceptable, Rooms Revenue was ahead of the same month last year, Food & Beverage performed close to plan, and the P&L shows a positive operating result.

Then Finance tells the General Manager: "We may fall below our minimum usable cash level in six weeks."

At first, the two statements appear contradictory. They are not.

Profitability and liquidity are connected, but they are not measured on the same timeline.

• The hotel can earn revenue today and collect it weeks later.
• It can receive a deposit today for an event that will not be delivered until the future.
• It can consume electricity now and pay the invoice next month.
• It can recognise a monthly insurance expense while paying an annual premium in one concentrated cash movement.

I find it useful to think in three financial clocks

The dates can be identical, but they often are not. That is why I never use the monthly P&L alone to answer a cash question. The P&L tells us what the hotel earned or consumed; it does not automatically tell us when the money will enter or leave the bank.

A bank balance is a position; a cash forecast is a timeline

When I look at cash, I treat the bank balance as a snapshot and the 13-week forecast as the timeline.

A hotel may hold substantial cash today while payroll, tax, debt service, insurance and a capital milestone are concentrated inside the next four weeks. The reverse can also happen: the bank looks tight today while a supported event deposit and a large receivable are due shortly.

So I do not stop at "How much cash do we have?" I ask, "What should usable cash become after the receipts and obligations we currently know or can reasonably forecast?"

That forward view creates time. Time gives management options:

1. follow up a receivable before it becomes critical;
2. confirm funding before the breach;
3. challenge a purchasing assumption before a purchase order is committed;
4. discuss a project milestone before the contractual payment date; or
5. escalate an owner-level funding issue before ordinary operations are put at risk.

Why the P&L can look stronger than the bank

Three recurring hotel situations explain much of the apparent contradiction.

First, revenue can be earned but not collected: corporate credit, OTA remittances, disputed invoices and event balances can sit in receivables while the P&L already recognises the business.

Second, cash can arrive before profit: deposits and prepayments strengthen the bank before the hotel has delivered the stay or event.

Third, cash can leave without appearing as the same-period operating expense: loan principal, capital expenditure, tax settlements and some prepaid items affect liquidity even though they sit outside current-period operating profit.

For this weekly review, I do not expect you to rebuild the entire accounting cash-flow statement every Friday. However, I do expect the team to understand what is creating the near-term movement.

1. Is cash tied up in receivables or inventory?
2. Are several large payments falling in the same week?
3. Is a capital or funding decision arriving at the wrong time?
4. Or is the hotel simply not generating enough operating cash?

Once that is clear, the next question becomes much easier.

Same method, different hotel

The purpose of the 13-week view

I do not expect a 13-week forecast to predict the bank balance perfectly. Some weeks will be wrong because demand, collections and payments are not perfectly predictable. Its value is different: it makes the assumptions and the decision window visible early enough for management to respond.

That is why I build the forecast from operating evidence instead of asking Finance to type thirteen weeks of cash numbers without an explanation. Demand creates the revenue expectation. Payment methods and settlement lags convert that business into collections. Demand can also create consumption and purchasing needs. Supplier terms then convert those purchases into cash payments. The weekly cash curve is the result of those assumptions, not the starting point.

Action step - try this with your hotel

If every row has the same date, review whether you are unintentionally treating revenue, expense and cash as the same event.

Use the right liquidity horizon for the decision in front of you

I use three different cash views because each one answers a different management question. The annual cash budget tells me whether the overall plan is fundable. The monthly view shows which months may become tight.

The 13-week forecast tells me exactly which week creates pressure and what can still be changed. Problems begin when one view is asked to do the job of another.

Three liquidity horizons

This guide focuses on the third view. The 13-week forecast can use information from the annual Budget and Latest Forecast, but it does not rewrite either of them. I treat it as the hotel's near-term cash-management view.

Why 13 weeks?

I use thirteen weeks because it gives roughly one quarter of visibility while staying close enough to current bookings, receivables, supplier commitments and major payment dates for management to influence the outcome.

• Weeks 1-3 should contain a lot of hard evidence.
• Weeks 4-8 depend more on demand, pickup, purchasing and collection assumptions.
• Weeks 9-13 are less certain, but they still show whether a funding or payment concentration is building.

The farther the forecast horizon extends, the more important it becomes to distinguish base evidence from scenarios. A week twelve receipt may be reasonable to expect but less certain than tomorrow's card settlement. The forecast should make that difference visible rather than pretending every cell has the same confidence.

Set the forecast conventions once

Before you build the first weekly forecast, agree a few basic conventions and keep them consistent.

• Choose the week-ending day,
• reporting currency,
• whether receipts are shown gross or net of merchant deductions,
• which bank accounts belong to the hotel,
• how restricted cash is treated, and
• the cut-off for deciding which week a receipt or payment belongs to.

These may look administrative, but changing them from week to week can create false forecast errors.

A Friday-ending forecast, for example, should handle weekend merchant settlements consistently. A hotel with multiple currencies should avoid mixing an unconverted local-currency obligation into a USD base without an exchange assumption. A hotel that includes card-clearing balances as usable cash one week and excludes them the next will manufacture volatility that is not operational.

Gross or net receipts - choose one basis

A small convention can prevent a large double count. Suppose the guest pays $100 by card and the processor deposits $97 after a $3 merchant deduction. If I forecast the receipt net, I put $97 into MONEY_IN and do not deduct the same $3 again in MONEY_OUT. If I forecast gross, I put $100 into MONEY_IN and show the $3 fee separately in MONEY_OUT. Either basis can work; mixing the two cannot.

I use the same discipline for OTA deductions, commissions, taxes or other pass-through amounts. Decide the basis once, document it in START, and keep it consistent from one weekly review to the next.

What belongs in the 13-week view

• Opening usable cash that is reconciled and available.
• Supported receipts expected to reach the bank during the horizon.
• Material dated payments, whether operating, statutory, financing or capital.
• Known timing effects from deposits, receivables, supplier terms and settlement cycles.
• Named scenarios kept outside the base when their conditions are not yet met.
• Management actions only when their timing and authority are sufficiently supported.

What does not belong is equally important: an annual budget total divided by thirteen; unsupported funding; a hoped-for collection with no evidence; a supplier payment moved simply because cash is short; or an optimistic occupancy assumption inserted only to prevent a breach.

A typical 13 Week liquidity may look like below.

Use a direct cash method

This is intentionally different from a statutory or indirect cash-flow statement. An indirect statement is important for reporting and reconciliation, but the weekly hotel decision requires direct knowledge of what will actually reach or leave the bank in each week.

Base forecast, at-risk receipts and scenarios

One of the easiest ways to make a cash forecast look healthier is to include money that management hopes will arrive. I avoid that. Keep the base forecast separate from at-risk receipts and scenario-only funding so that the team can see the real expected position first.

In the Harbour View case, I deliberately keep potential owner funding outside the base forecast until the receipt is sufficiently supported. A discussion or approval is not the same thing as cash in the bank.

Same method, different hotel

Management mistakes to avoid

• Using the monthly P&L forecast as if it were weekly cash.
• Putting the entire receivables balance into Week 1 because it is "due".
• Including an owner or lender facility before the receipt is sufficiently supported.
• Moving supplier payments into later weeks without an agreed change in due date or authority.
• Combining base, downside and management-action scenarios into one number.

Action step - try this with your hotel

• Set the basic forecast conventions for your hotel: week-ending day, currency, bank accounts included and treatment of restricted cash.
• Choose one large expected receipt and label it Base, At Risk or Scenario Only. If you cannot explain why it belongs in Base, keep it outside the base forecast for now.

Reconcile the opening position and define the decision boundary before forecasting

Before I forecast Week 1, I first prove the opening cash number. A bank report may show $260,000, but some of that balance may be restricted, reserved, uncleared or otherwise unavailable for ordinary hotel obligations. So the question is not simply, "What cash appears in our accounts?" It is, "How much cash can the hotel genuinely use?"

Four opening-position distinctions

Harbour View opening position

Harbour View shows total bank and cash balances of $260,000.

Of that amount, $80,000 is held in a restricted FF&E reserve.

Opening usable cash is therefore $180,000.

The hotel also sets a management liquidity floor of $120,000.

Please note, these are synthetic teaching assumptions, not industry benchmarks. You will find this worked example in the companion Excel workbook — see the download link and QR code on page 3.

Figure 3.1 - Harbour View companion excerpt: reconcile total cash to opening usable cash before the 13-week forecast begins.

Define the liquidity floor

Realistically, I would never wait until cash reaches zero before acting. I prefer to define a hotel-specific minimum usable cash level - the liquidity floor - below which management must escalate, protect cash or arrange funding.

The right level depends on the individual property: you can take into account monthly payroll burden, fixed rents and contracts, statutory obligations, critical suppliers, debt requirements, bank-transfer constraints, owner policy and emergency resilience can all matter.

The floor is deliberately not a generic benchmark such as "one month of payroll". A small owner-operated hotel and an internationally managed resort may need very different boundaries. The important control is that the boundary is defined before the forecast becomes uncomfortable, rather than being lowered after the fact to avoid showing a breach.

A practical liquidity-floor discussion

For an owner-operated hotel, the floor may be driven primarily by the next payroll, statutory payments and several operating-critical suppliers.

For a branded or financed property, additional owner, lender, reserve or contractual conditions may matter.

Management should therefore document why the floor exists and who has authority to change it.

A number that nobody can explain will usually be ignored when pressure arrives.

A committed but undrawn facility can improve resilience, but I still show cash and the facility separately. If a draw requires conditions, approvals or documentation, those conditions belong in the action plan or scenario. Available borrowing capacity is not the same as a completed cash receipt.

Headroom and gap

Action step - try this with your hotel

• Reconcile your latest total bank balance to the amount that is genuinely usable for normal hotel obligations.
• Write down a preliminary minimum cash level for your property and one sentence explaining why that level matters. If you cannot explain the number, discuss it before using it as a trigger.

Use Revenue Management or lead-period history to create the operating driver before the receipt

For the first few weeks, you can often build much of the cash-in forecast from known card settlements, issued invoices, existing events and committed receipts. By Weeks 8-13, much of the business may not yet be on the books. At that point I do not want Finance to guess the cash number directly; I want the hotel to forecast the operating demand that should create it.

Where Revenue Management exists

If you have Revenue Management, use it. Finance should not independently invent occupancy. Revenue Management should provide the latest supported Rooms outlook using on-the-books business, pickup, cancellations/wash, group probability, segment/channel mix, event dates, available inventory and current pricing evidence. Finance then translates that demand view into expected cash timing.