Restaurant Cash Flow Template UK 2026 — Weekly Tracking and 13-Week Forecast

Disclosure: This article is written by Shaun McManus, founder of SmartPubTools and creator of the Restaurant Console. All operational claims reflect genuine experience at Teal Farm Pub, Washington.

Why Do Restaurants Fail Despite Being Profitable?

Key Takeaway: Most restaurant failures are cash flow failures, not profitability failures. A restaurant can show a profit on its P&L and still run out of cash — if VAT quarters, rent days, and payroll all land in the same week and revenue dips. A 13-week cash flow forecast costs nothing to build and is the single most important financial tool an independent operator can have.

Running this problem at your pub?

Here's the system I use at The Teal Farm to fix it — real-time labour %, cash position, and VAT liability in one dashboard. 30-minute setup. £97 once, no monthly fees.

Get Pub Command Centre — £97 →

No monthly fees. 30-day money-back guarantee. Built by a working pub landlord.

By Shaun McManus | Last Updated: May 2026

Cash flow is not the same as profit. A restaurant that turns over £10,000/week and makes 10% net profit (£1,000/week) can still face a cash crisis in a week where VAT payment (£8,000 quarterly bill), rent (£4,000 monthly), and payroll (£6,000) all fall together and revenue drops 20% due to bad weather. Understanding and forecasting your cash position is as important as tracking your GP%.

The Key Cash Flow Timing Differences in Restaurants

Cash outflowTypical timingCash flow impact
Food and drink purchases7-30 days creditManageable — time to generate revenue first
Staff wagesWeekly or monthlyFixed — must be funded regardless of revenue
RentMonthly or quarterlyLarge quarterly rent creates cash crunch risk
VAT paymentQuarterly (or monthly on annual accounting)£5,000-15,000 lump sum — must be reserved weekly
Employer NI and PAYEMonthly to HMRCFixed — must be set aside from payroll
Utility billsMonthly direct debitPredictable — include in weekly fixed cost
Equipment repair/replacementUnpredictableReserve fund essential — minimum £500/month

VAT — The Silent Cash Flow Killer

VAT is the most common cause of restaurant cash flow crises. A restaurant turning over £10,000/week at 20% VAT is collecting approximately £1,667/week in VAT on behalf of HMRC (on the standard-rated proportion of sales). Over a 13-week VAT quarter that is £21,667 due to HMRC on the due date.

The operators who struggle are those who spend the VAT they collected. The fix is simple: set aside your net VAT liability weekly into a separate account. Calculate it as part of your weekly P&L — the Restaurant Console Report module includes VAT in the weekly calculation so you always know your net-of-VAT position.

13-Week Cash Flow Forecast Template

WeekExpected revenueFood/drink purchasesWagesRent (if due)VAT reserveOther fixedNet weekly cashCumulative cash
W1£9,500£2,850£2,500£0£500£800£2,850£2,850
W2£10,200£3,060£2,500£4,000£540£800-£700£2,150
W3-13

A 13-week forecast shows you which weeks are cash-tight before they arrive. If Week 7 shows a negative cumulative cash position because VAT and a quarterly rent both fall together, you have 6 weeks to act — extend supplier credit, hold a stock sale, push delivery volume, or arrange a short-term facility.

Weekly Cash Flow vs Monthly P&L — Why You Need Both

Your monthly P&L shows profitability over a period. Your weekly cash flow shows your bank balance trajectory. Both are essential. A restaurant without a P&L does not know if it is profitable. A restaurant without a cash flow forecast does not know if it will be solvent in 8 weeks.

The restaurant weekly P&L guide explains how to structure your profit and loss statement. The restaurant break-even calculator shows the minimum revenue needed to cover all fixed costs each week. Together these give you the complete financial picture.

Cash Flow and Labour Cost

Labour is your largest and most fixed cash outflow. Unlike food purchases (which can be reduced by ordering less), wages must be paid regardless of revenue. At Teal Farm Pub, running labour cost at 15% against the 25-30% UK benchmark is primarily a cash flow advantage — less fixed cash committed per week means more resilience during quiet periods. See the restaurant labour cost guide for the benchmark formula and reduction strategies.

Run Your Restaurant From One System — £97 One-Time

The Restaurant Console Weekly Cockpit tracks P&L actual vs target vs last year with forward forecasting — giving you the revenue side of your cash flow picture week by week. The Report module calculates VAT automatically so you always know your net position. £97 one-time, your data in your Google Drive.

Get the Restaurant Console →

✓ Weekly Cockpit: P&L actual vs target vs last year + forecast
✓ Report module: weekly P&L with VAT calculation
✓ Your data stays in YOUR Google Drive
✓ No monthly fees. No subscription. £97 once.

Frequently Asked Questions

Why do profitable restaurants run out of cash?

Cash flow timing. Large outflows (VAT quarter, rent, payroll) landing in the same week as a revenue dip can empty a bank account even in a profitable business. A 13-week forecast prevents surprises.

How do I create a restaurant cash flow forecast?

List all weekly cash inflows and outflows, project forward 13 weeks using your revenue forecast and known fixed payment dates. The cumulative weekly cash position shows which weeks need attention.

How should a restaurant manage VAT cash flow?

Set aside your net VAT liability weekly into a separate account from your weekly P&L. Never spend VAT collected — a quarterly bill of £15,000+ without reserved funds is the most common restaurant cash crisis.

What is a good cash reserve for a UK restaurant?

Minimum 4-6 weeks of fixed costs. At £8,000/week fixed costs that is £32,000-48,000. Build towards it by ringfencing a percentage of weekly net profit.

How often should a restaurant review its cash flow forecast?

Weekly — roll the 13-week forecast forward each Monday, updating actuals and adjusting forward projections based on bookings and seasonal patterns.

Running your pub on gut feel?

The Pub Command Centre gives you wet GP%, cellar checks, staff cost and weekly P&L — from your phone, every shift. £97 once. No subscription.

See the Pub Command Centre →

Leave a Reply

Your email address will not be published. Required fields are marked *