Restaurant & Hotel 13-Week Cash Flow Forecast: Weekly Cash Flow Spreadsheet

Full description

For owners, general managers and finance leads of restaurants, cafés and small hotels who need to know whether there will be enough cash to pay staff, rent, suppliers and tax over the next three months. You enter expected sales by channel and your payment schedule once. The workbook applies card and platform settlement delays, fees and supplier terms, then shows weekly closing cash against your minimum buffer, flags the weeks that fall short and lets you test a weaker scenario with one switch.

Save with a bundle: this template is also in the Hotel Finance, Development & Pre-Opening Bundle, 10 templates for $35 instead of $76. All 141 templates are in the All-Access Hospitality Template Library for $79.

What is inside

• Hospitality_13_Week_Cash_Flow_Forecast.xlsx: 8 tabs, 1,245 formulas, 2 native charts, 12 drop-down or number rules.
• Settings: start date, opening cash, minimum cash buffer, variance tolerance, a scenario switch (Base, Downside, Upside) and 6 receipt channels with settlement lag in days and fee or commission %.
• Receipts: gross sales by channel for week 0 to week 13, cash collected per week after lag, fees and scenario, plus room for 20 one-off receipts such as deposits or loan drawdowns.
• Payments: room for 14 suppliers with weekly purchases and payment terms, and 24 scheduled payments (payroll, rent, leases, loans, tax, utilities, insurance and other) with frequency and first due date.
• Payment_Calendar: the cash each line takes out in each of the 13 weeks, with totals by 7 payment types. Weekly, fortnightly, monthly, quarterly and one-off frequencies are handled by formula.
• Forecast_13W: opening cash, receipts, payments by type, net cash flow, closing cash and a buffer status for each week.
• Actuals: actual receipts and payments against the forecast for 13 weeks, with variance flags.
• Dashboard: 8 KPI tiles, a buffer alert line, a cash runway chart (closing cash against the minimum buffer) and a cash in and cash out chart.
• README.txt and LICENSE-and-Terms.txt.

How it works

1. Enter the start date, opening cash, minimum buffer and your receipt channels on Settings.
2. Enter expected gross sales by channel and week on Receipts.
3. List suppliers with their terms and every scheduled payment on Payments.
4. Read the forecast and the dashboard, then switch to Downside to test a weaker period.
5. Each week, enter actuals, save a dated copy and roll the start date forward by 7 days.

Details

• Format: Excel workbook (.xlsx). No macros.
• Language: English. Currency is a label you choose.
• Software: Excel 2016 or later, or a spreadsheet program that opens .xlsx files.
• Delivery: instant digital download. Nothing is shipped.

Good to know

• All sample sales, costs and dates are illustrative. Replace them with your own figures.
• Tax amounts, payroll dates and contribution rates are inputs. Verify local requirements.
• This is a planning tool, not accounting, tax or financial advice.
• Single-user license. Do not share or resell the files.

FAQ

Does it work for a restaurant only, or a hotel only?

Yes to both. Rename the channels on Settings to match your business and leave unused ones at zero.

How does the settlement lag work?

Each channel has a lag in days. Sales are spread over the week, so a 2-day lag moves part of a week's card sales into the next week, and a 30-day lag moves account sales about four weeks out.

How do I roll the forecast forward?

Save a dated copy, move the start date on by 7 days, update opening cash to your bank balance and shift your sales inputs up one row.

Does it work in Google Sheets?

It opens in Google Sheets and the formulas calculate. Check the drop-downs after import.

Is this a physical product?

No. It is a digital download. Refund terms follow the store policy at the time of purchase.