13-Week Cash Flow Forecast: Restaurant Cash Flow Spreadsheet

Profit is lovely. Cash pays the suppliers. Rent, wages and VAT often land in the same week. This forecast shows that week in advance, while you still have time to move a payment or chase a deposit.

What's inside

• Forecast: 13 weeks of cash in (sales, event deposits, other income) and cash out (suppliers, wages, payroll taxes, rent, utilities, loans, VAT, insurance, card fees, owner drawings), with the closing balance each week
• Low-balance alert: any week that closes below your minimum balance is marked Low
• Summary: lowest balance and its week, weeks below your buffer, total cash in and out, and the balance after 13 weeks
• Chart: your weekly balance against your buffer line
• Settings: start date, opening bank balance and minimum balance

Good to know

• Works in Excel, Google Sheets and LibreOffice, in any currency
• Start Here guide and a worked example for a European bistro
• Pairs with the Daily Cash-Up & Sales Log and the Annual Budget & Break-Even Planner

Works well with

• Annual Budget & Break-Even Planner
• Daily Cash-Up & Sales Log

Read: Deposits and balance terms for private events

All 25 tools in one download: Complete Restaurant Collection

Created by Kali Safwat for The Off-Menu Circle.

Digital download (.xlsx). You'll receive the file instantly after purchase.