Hotel weekly cash flow: will money arrive before the bills?

A hotel can look busy yet have too little money available when payroll and supplier bills fall due. A company invoice is unpaid, a card settlement has not reached the bank, or equipment payment falls in the same week. The owner’s question is therefore not only how much was sold, but on which date the money becomes usable.

Kentucky SBDC’s business planning guide distinguishes cash flow projections from profit statements and recommends explaining the timing, amounts and assumptions. The weekly hotel worksheet below is an editorial application of that general principle, not financial statistics about hotels in Azerbaijan.

Establish the opening balance

Use available bank funds and counted cash at the same cutoff date and time. Do not treat blocked funds as freely available. Moving cash into the bank is an internal transfer; it is not another receipt when calculating the hotel’s combined position.

A card preauthorisation is not a cash receipt. A deposit actually received can appear in cash flow, but receipt does not automatically make it earned revenue or entirely unrestricted money. Keep refund obligations and amounts that must be set aside visible.

Give every amount a date and a basis

Start with the next four weeks. This is a working example, not a required horizon; extend the forecast when major seasonal payments lie further ahead. Gather the following information:

• Guest receipts, with expected payment and bank availability dates.
• Company and agency balances, with invoices, agreed dates and confirmation status.
• Payroll, rent, utilities, purchases, refunds and equipment payments.
• Loan payments, owner funding and owner withdrawals on separate lines.
• Tax and other payment obligations on dates checked with the accountant.

Use amounts that will actually be paid. Do not mix a net revenue report with tax-inclusive bank movements. If a processor fee is already deducted from the expected receipt, do not subtract it a second time as an outgoing payment. Payment reconciliation helps establish a reliable starting position.

A four-week illustrative worksheet

Every figure below is hypothetical and represents actual cash movements in AZN. This is not a revenue or profit statement. Applicable tax and fees are assumed already reflected in the appropriate cash lines.

Week	Opening cash	Receipts	Payments	Closing cash
1	8,000	4,500	6,000	6,500
2	6,500	5,500	7,000	5,000
3	5,000	4,800	4,300	5,500
4	5,500	6,200	5,100	6,600

The calculation is opening cash + receipts − payments = closing cash. Suppose management chooses a planning floor of 4,000 AZN. This is a scenario assumption, not an appropriate reserve for every hotel.

If 2,000 AZN expected in week two arrives in week three instead, week two closes at 3,000 AZN. Week three then closes at 3,000 + 6,800 − 4,300 = 5,500 AZN. The final month’s result can remain unchanged while an interim payment shortage appears.

Look inside the week

Payroll may leave on Monday while a substantial receipt arrives on Friday. A positive weekly closing total can hide an earlier shortfall. Break tight weeks into days and check bank settlement timing.

Use the accounts receivable follow-up to support collection dates. An expected transfer must not be labelled as confirmed available money. Put uncertain bookings in a separate cautious scenario rather than relying on every enquiry becoming a paid stay.

Also distinguish the total cash balance from the amount available for a new purchase. Refund commitments or earmarked payments can make the apparent balance misleading. Keep these commitments visible without deducting the same cash payment twice.

Make it a weekly management routine

1. Compare last week’s forecast with actual bank and cash results.
2. Separate differences in amount from differences in timing.
3. Update delayed receipts and newly accepted obligations.
4. Identify the earliest day below the chosen planning floor.
5. Review non-urgent purchase timing and lawful, agreed payment options.
6. Record the decision owner and deadline.

Simply moving a due date in the worksheet does not change the obligation. Obtain any required agreement before treating a rescheduled payment as your base case. Reconcile obligations with the accountant; this operating worksheet does not replace accounting records.

Frequently asked questions

Why can a busy hotel run short of cash?

Sales, revenue recognition and receipt dates can differ. Payment obligations also follow their own calendar, which may not match occupancy.

How do we avoid counting a deposit twice?

Record the receipt once when money arrives. Forecast only the remaining amount when planning the guest’s final payment.

What should the minimum balance be?

There is no universal AZN figure. Set it from your own payment calendar, delays and funds that must be reserved; the example’s 4,000 AZN is not a recommendation.