What should a 13-week cash-flow forecast for a hotel contain?

A 13-week hotel cash-flow forecast should show the cash available at the start of each week, the money expected to arrive, the payments expected to leave and the resulting closing balance. It should also show the lowest expected balance, the owner's operating buffer and the decisions needed before a shortage occurs. The forecast is useful when it connects to actual bank balances, booking payment arrangements, supplier commitments and payroll dates.

For a hotel in Cyprus, a weekly view can help bridge the gap between a seasonal commercial plan and immediate payment obligations. Rooms may be booked for a future month while recruitment, maintenance or supplier deposits must be paid now. Equally, a profitable stay may create a receivable that is collected later. The forecast should reflect the cash event, not simply copy the revenue date from the management accounts.

The 13-week horizon used here is a recommended management format, not a Cyprus statutory requirement. It provides a rolling short-term view while a separate monthly plan considers the rest of the year. All worked figures are illustrative assumptions. They are not funding advice, lender conditions or benchmarks for the cash reserve an individual hotel should maintain.

Define the entity, accounts and forecast dates

State exactly which business the forecast covers. The property-owning company, hotel operator and restaurant business may have separate bank accounts and obligations. Combining them without explaining transfers can create a misleading impression of available cash. Begin with the entity responsible for the payments being managed, then prepare an explicitly reconciled group view if needed.

Choose fixed weekly boundaries and a consistent cut-off time. Record whether the opening position is taken from the bank, the accounting records or a reconciled combination. Account for known payments already initiated but not yet reflected in the chosen balance. A model that starts with an unreconciled number can be precise in every later formula and still give the wrong answer.

List the accounts included and identify amounts that are restricted or otherwise unavailable for ordinary operations. Do not combine a possible borrowing facility with money already in the bank. If foreign-currency balances are material, show the currencies and the conversion assumptions separately. The purpose is a usable view of liquidity, not the largest possible headline balance.

Keep the weekly forecast distinct from the profit budget

The IFRS Foundation's IAS 7 overview distinguishes operating, investing and financing cash flows and explains that reconciling profit to cash involves non-cash items and timing differences. [1] This article's forecast is an internal planning tool, not an IAS 7 statement. The useful lesson is to identify actual receipts and payments rather than treating accounting profit as spendable cash.

A room sold on credit can contribute to revenue before collection. A deposit received for a future stay creates cash before the stay is delivered. A loan receipt improves liquidity without being operating revenue. Equipment spending requires cash even though its accounting treatment differs from an ordinary operating expense. Keep these distinctions visible so the forecast does not disguise the source of a funding gap.

Maintain a reconciliation to the commercial forecast and the accounts, but allow each report to answer its own question. The profit budget addresses economic performance. The short-term cash forecast addresses when money will be available to meet commitments. The companion guide on losses despite full occupancy shows why a strong room-night figure cannot answer either question by itself. [2]

Build receipts from the actual booking and collection process

Separate receipts into useful groups: guest payments collected directly, settlement from payment providers, intermediary remittances, corporate or group receivables, events and other operating income. For each group, document the expected payment timing and the evidence behind it. Use the hotel's actual contracts and settlement history rather than a standard delay applied to every booking.

Distinguish balances already receivable from new bookings expected during the forecast. Existing receivables should have named owners and realistic collection dates. New-business receipts need a commercial assumption connecting expected bookings to payment terms. Do not count an existing debtor in both the opening receivables schedule and the forecast revenue line.

Reconcile room receipts with deposits already collected. If a guest paid part of the stay before the forecast began, only the remaining expected collection belongs in future receipts. A booking report showing the full stay value can otherwise cause the model to count the same money twice. Keep a clear link between the reservation, amount previously paid and balance still due.

Model cancellations, refunds and settlement deductions explicitly

Review refund obligations and expected cancellations by the terms that actually apply. Record known refunds separately from a general allowance for uncertain future events. The refund date can matter as much as the amount when several payments fall in a week with payroll or rent. Do not assume that the booking's original revenue week is also the refund week.

Check whether intermediary or payment-provider settlements arrive gross or after deductions. If the forecast uses net receipts, do not deduct the same commission or fee again as a separate payment. If it uses gross receipts, include the corresponding deduction in the appropriate line. Consistency is more useful than choosing one format for every arrangement regardless of how money actually moves.

Record material disputes, chargebacks or retained settlements as identifiable uncertainties. Give each an owner and a next action. Avoid quietly reducing every receipt by a broad percentage when one specific unresolved item explains most of the exposure. An explicit uncertainty can be investigated; a hidden adjustment is harder for the commercial and finance teams to challenge.

Schedule payroll and staff-related payments on real dates

Use the actual payroll calendar and expected payment amounts, including known starters, leavers, variable pay and other relevant commitments. Coordinate with the person responsible for payroll. A monthly salary cost divided evenly across four weeks does not show the real cash requirement if employees are paid on one particular date.

Include employer payments and statutory remittances using dates and amounts confirmed by the Cyprus payroll or tax adviser. This guide does not specify contribution rates or filing deadlines. Record what has been confirmed and which calculations remain provisional. A forecast should surface that uncertainty early instead of replacing the adviser with an assumed calendar.

Separate payroll cost changes from cash-timing changes. An additional shift may increase the underlying cost, while a different payment date merely moves the outflow. Both can affect the forecast, but they require different decisions. Do not present a timing change as a recurring saving or assume that a staffing reduction can be implemented without its own obligations and operating consequences.

Include suppliers, recurring commitments and essential spending

Start supplier payments with outstanding invoices and agreed terms. Add purchase orders or commitments not yet invoiced, then forecast the purchases needed to deliver expected stays. Reconcile these layers to prevent duplication. If a linen order is already committed, it should not also appear as an unexplained addition to the general operating-cost allowance.

Identify rent, utilities, insurance, software, maintenance contracts and other recurring payments. Use actual renewal or instalment dates. Annual bills are easy to overlook when the model is built only from a recent month. Ask department managers about commitments that finance has not yet received, such as a scheduled repair or an equipment deposit.

Separate essential operating requirements from spending that is genuinely discretionary. Any proposed deferral needs an owner and confirmation of its feasibility. Delaying an uncommitted improvement is different from withholding a contractual payment. The forecast may support a conversation with a supplier, but it does not itself change the obligation or authorise non-payment.

Show tax, financing and capital expenditure separately

Include taxes and other statutory payments on dates confirmed by the relevant adviser, with any uncertainty flagged. Keep their cash treatment consistent with the receipts and supplier figures. If transaction values include tax, the related settlement needs to be represented appropriately. Avoid mixing net and gross assumptions because the resulting cash error can persist across many weeks.

Record debt service from the actual facility schedule, separating principal, interest and fees where useful for management understanding. Include owner injections or new borrowing only when the baseline's evidence standard is met. A discussion with a lender is not the same as an available facility, and a shareholder's intention is not the same as a confirmed transfer date.

Capital expenditure needs its own payment schedule: deposits, progress payments, final payments and any associated operating interruption. The hotel-feasibility guide addresses the wider investment picture. [3] The 13-week model should show the near-term cash consequences without pretending that a short horizon establishes whether the investment is financially attractive over its life.

Use a structure the team can reconcile

A practical weekly layout begins with opening cash, adds operating receipts, subtracts operating payments, shows investment and financing movements, and calculates closing cash. Next week's opening cash equals the previous week's closing cash. Add separate rows for the agreed minimum operating buffer and the surplus or shortfall against that buffer.

Keep supporting detail outside the summary. A receivables schedule can explain incoming payments, a supplier schedule can explain outgoing payments and an assumptions register can explain estimates. The owner should be able to trace a material number without searching across dozens of disconnected files. Record the source, responsible person, last update and confidence level for significant assumptions.

Label actuals and forecasts distinctly. Protect formula cells where practical, keep input conventions consistent and retain prior dated versions. A small model with clear ownership is preferable to an elaborate workbook whose numbers cannot be explained. The most useful forecast is one the team can update correctly every week, including when its usual author is absent.

Follow a three-week illustration through the cash balance

Assume a hotel begins week one with EUR 25,000. Expected receipts are EUR 32,000. Payroll payments are EUR 20,000, supplier payments EUR 18,000 and other payments EUR 7,000. Total payments are EUR 45,000, so closing cash is EUR 12,000: EUR 25,000 plus EUR 32,000 less EUR 45,000. This is an invented example, not a forecast for a real property.

Week two begins with EUR 12,000. Receipts of EUR 28,000 and payments of EUR 30,000 leave EUR 10,000. Week three then receives EUR 18,000 but requires EUR 42,000 of payments, producing a projected balance of negative EUR 14,000 before additional funding or agreed actions. The useful warning is visible before the third week's payments arrive.

Suppose a separately confirmed EUR 15,000 funding receipt is available in week three. The projected balance becomes positive EUR 1,000. If management's illustrative operating buffer is EUR 8,000, a EUR 7,000 buffer shortfall still remains. Positive cash is therefore not automatically adequate liquidity. The appropriate buffer and funding decision depend on the property's obligations and uncertainty.

Identify the lowest point, including within the week

A weekly closing balance can conceal a midweek shortage. If payroll is due on Tuesday and a large remittance arrives on Friday, the Friday balance may look comfortable while Tuesday cannot be funded. For weeks with concentrated obligations or low headroom, prepare a daily view of the material receipts and payments.

Report the minimum expected cash position, its date and the assumptions that drive it. Distinguish that result from the closing balance at the end of week thirteen. An attractive final balance does not solve an earlier funding gap. The owner needs to know when action is required, how much uncertainty surrounds the figure and which decision can change it.

Show committed facilities separately from the cash balance and assess their actual availability under the relevant terms. Do not assume an undrawn amount can be used without checking conditions. Where facilities or balances are restricted, obtain the appropriate advice and describe the restriction in the model rather than hiding it in a footnote no decision-maker reads.

Build scenarios around specific uncertainties

Choose the few events that could materially change the short-term position. Examples include a delayed group payment, higher refunds, an urgent repair or weaker new-booking collections. Change the relevant dates or amounts in a scenario while preserving the baseline. A general percentage reduction across all receipts may be less informative than modelling one significant debtor arriving two weeks late.

Separate a timing delay from a permanent loss. If EUR 10,000 expected in week four is now expected in week six, reduce week four and increase week six. If collection is doubtful, the downside may need to remove it rather than merely postpone it indefinitely. Explain which case is being modelled and why.

Avoid combining every adverse assumption into an unexplained worst case. Use a realistic downside and, where helpful, a more severe stress case with its assumptions stated. The forecast is not a probability model unless the evidence supports that treatment. Its practical value is to identify decisions that remain workable across plausible changes in timing and demand.

Turn projected shortfalls into dated actions

For each material gap, record the amount, week, decision owner and latest useful action date. Potential actions may include resolving overdue invoices, correcting settlement errors, reconsidering discretionary spending or seeking an agreed financing arrangement. Evaluate the operating and commercial consequences, not only the improvement in one spreadsheet cell.

Keep proposed actions separate from confirmed changes. If a supplier has not agreed revised terms, the baseline should not quietly assume them. If a marketing offer may accelerate deposits, include its discount cost, delivery obligation and uncertainty. A short-term cash benefit can create a later margin or refund exposure that the owner needs to understand.

When the model indicates that obligations may not be met, bring the accountant and appropriate professional advisers into the decision promptly. The forecast is a tool for providing reliable facts; it is not a substitute for advice about the business's legal or financing position. Do not wait for the bank balance to become the first indication that the assumptions failed.

Update weekly and explain the variance

At the agreed cut-off, replace the completed week's forecast with actual receipts and payments, reconcile closing cash and add a new thirteenth week. Keep the previous forecast so the team can see what changed. Northern Ireland's public business guidance also emphasises comparing actual results with forecasts and investigating differences; that general management principle is useful here without importing UK legal rules into Cyprus. [4]

Explain significant variances by cause. A late receipt is a timing difference; a cancelled event may be a lost receipt; an omitted annual bill is a forecasting error. Those explanations help improve the next version. Simply moving an unpaid balance forward every week can conceal a collection problem that needs a different decision.

Use a short review with finance, operations and the person responsible for commercial collections. Confirm the cash position, the next low point, changed assumptions and action owners. Keep routine detail in the supporting schedules. The meeting should produce decisions and follow-up, not only a new coloured chart showing the same unresolved shortfall.

Link the short-term model to seasonality and business performance

Extend important commitments beyond the visible horizon in a separate monthly view. A loan payment or refurbishment instalment just after week thirteen still matters. The rolling model should connect to the annual operating plan, especially when the hotel is approaching closure, reopening or a change in service scale. Otherwise, the apparent improvement may come only from a large bill moving outside the displayed period.

Compare the cash assumptions with the hotel revenue plan. A forecast based on stronger direct bookings needs a realistic collection pattern and acquisition budget. The direct-versus-OTA guide explains why channel economics require more than a commission comparison. [5] A change in channel mix can affect both contribution and timing, and the model should capture the relevant differences without double counting.

Do not use the cash model to conceal an underlying operating loss. Borrowing can bridge timing, but the longer-term plan must show how the business generates sufficient value. Conversely, a viable hotel can still require working capital at a particular point in its cycle. Present both perspectives so the owner can distinguish a short-term funding issue from a business-model problem.

Checklist before the owner relies on the forecast

Confirm the entity, accounts, cut-off date and reconciled opening cash. Check that receipts reflect actual collection timing and that deposits, receivables and future bookings are not duplicated. Verify payroll dates, supplier commitments, recurring bills, adviser-confirmed statutory payments, debt service and investment instalments. Identify unavailable cash and unconfirmed funding clearly.

Trace each closing balance into the next week. Review the lowest point and any midweek exposure. Show the operating buffer, downside assumptions and outstanding decisions. Keep a dated version, assign the next update and record which material inputs still need confirmation. The checklist is a management control, not a certification that the business is solvent or that a lender will provide funding.

HoHo Consultancy can help hospitality owners connect commercial and operating information to a practical management review. [6] Prepare the reconciled bank position, receivables, supplier balances, payroll calendar, booking payment terms and major commitments for an initial discussion. The useful outcome is a forecast the team can explain and maintain, supported by specific actions before pressure becomes urgent, rather than a one-off spreadsheet that looks complete but is never reconciled to reality.

Sources and related services

[1] IFRS Foundation: IAS 7 overview
Primary accounting context; the article proposes an internal forecast, not an IAS 7 statement. Accessed 19 October 2026.

[2] Companion guide: Why a full hotel can lose money
Internal local draft. Accessed 19 October 2026.

[3] Companion guide: Hotel feasibility study
Internal local draft. Accessed 19 October 2026.

[4] nibusinessinfo: Keep business finance forecasts up to date
Public Northern Ireland business guidance used only for general forecast-review practice, not Cyprus law. Accessed 19 October 2026.

[5] Companion guide: Direct versus OTA hotel bookings
Internal local draft. Accessed 19 October 2026.

[6] HoHo Consultancy: Hospitality consulting in Cyprus
Related service; no promise of funding or financial results. Accessed 19 October 2026.