It's a Monday morning in March. The café did £14,200 in turnover last week, the best week since Christmas. The accountant sent through the management accounts on Friday and they showed a tidy net profit for February. Then at 8.47am the phone buzzes: the bank has bounced a standing order. Rent went out at midnight. Card settlement from the weekend doesn't land until Tuesday.

You are profitable. You are also, technically, broke.

This is the gap that quietly closes hospitality businesses every year. Not bad food, not bad service, not even bad margins. Cash showing up in the wrong week.

A 13-week cash flow forecast is the cheapest, most underused tool for fixing that gap. It takes about 90 minutes to build the first time and 15 minutes a week to keep alive. This piece walks you through what it is, how to build one for a café, what to watch for, and how to stop it from becoming another spreadsheet you abandon by week three.

Profitable and broke at the same time

Profit is an opinion. Cash is a fact.

Your P&L is built on the accruals principle: it records turnover when you earned it and costs when you incurred them, regardless of when money actually moved. That's the right way to see whether the business model works. It's the wrong way to know whether you can pay this Friday's wages.

A few timing differences quietly do most of the damage in a café:

Card settlement lag. Most acquirers pay you 1-3 working days after the transaction. A bank holiday weekend can stretch that to four or five. Your P&L counted the sale on Saturday; the cash arrives Wednesday.
Supplier credit terms. Your dairy invoice is dated 12th of the month, due 30 days later. The P&L expensed the milk when you used it. The cash leaves your account weeks afterwards, often in a single Friday batch run that hits like a truck.
VAT. The single biggest cash flow shock for a growing café. You collect VAT on every cup of coffee, but it isn't yours - it belongs to HMRC, payable quarterly. If you've been spending it, the bill arrives like a meteor.
PAYE and pension. Monthly, on the 22nd. Easy to forget if you're focused on net wages going out on the 28th.
Holiday accrual. Staff earn holiday every shift they work. They take it (and get paid for it) in lumps, often during your quietest weeks. The P&L might smooth this with an accrual; the cash account does not.
Rent. Many café leases are quarterly in advance on the English quarter days (25 March, 24 June, 29 September, 25 December). Three months of rent in one Tuesday. Brutal if you weren't ready.

If you've never sat down and written the timing of these out, your forecast will lie to you. The point of a 13-week view is to make every one of them visible.

For a fuller walk through how the P&L itself fits together, the reading your café's P&L like an operator post is the natural companion to this one.

What a 13-week forecast actually is

A weekly grid. Thirteen columns across, one for each of the next 13 weeks. A column of categories down the side. Cash in at the top, cash out below, opening and closing bank balance at the boundaries.

Why 13 weeks?

It's roughly a quarter, so it captures at least one VAT cycle and usually one rent quarter day.
It's far enough out that you can see a problem coming and steer.
It's close enough that the numbers can be reasonably accurate. Forecasting beyond 13 weeks tends to dissolve into wishful thinking.

The output isn't a number. It's a shape. You're looking at the line that the closing bank balance traces across 13 weeks, and asking: where does it dip, where does it cross zero, and what should I do about it now while I still have time?

How to build one for a café

Open a new spreadsheet. One row per category. One column per week, dated by the Monday of each week. You want roughly this structure:

Opening cash (week's starting bank balance)

Cash in

Card takings (banked)
Cash takings (banked)
Deliveroo / Uber / Just Eat payouts
Wholesale / B2B invoices paid
Vouchers and gift card redemptions in cash
Other (grants, refunds, owner injection)

Cash out

Payroll (net wages)
PAYE, NI, pension
Rent
Business rates
Utilities (gas, electric, water)
Card processing fees
Major supplier 1 (e.g. coffee roaster)
Major supplier 2 (e.g. dairy)
Major supplier 3 (e.g. bakery / fresh produce)
Other suppliers
VAT
Insurance
Software / subscriptions
Equipment / repairs
Loan / finance repayments
Owner draws
Other (accountancy, marketing, sundries)

Closing cash (opening + cash in - cash out)

The closing balance of each week becomes the opening balance of the next.

Three rules of thumb when filling it in:

Forecast the timing, not the average. A £4,800 monthly dairy bill isn't £1,200 a week; it's a single line in the week the direct debit hits.
Use the actual day money moves. Card settlement is 2 days after the sale. Your wholesale customer pays on day 30, not day 1.
Be honest about turnover. Use last year's same week as your starting point, then adjust for what you actually know about this year. Half-term, weather, a closed road, a new opening down the street.

The first time you do this, it's a couple of hours' work. After that, a Monday morning ritual.

A worked example

Here's a simplified version for a single-site café turning over around £12k a week. Numbers are rounded for clarity.

Week	Opening	Cash in	Payroll	Suppliers	Rent	VAT	Other	Closing
W1	£8,400	£11,800	£4,200	£2,100	£0	£0	£900	£13,000
W2	£13,000	£12,400	£0	£2,300	£0	£0	£1,100	£22,000
W3	£22,000	£11,200	£4,200	£2,100	£0	£0	£1,400	£25,500
W4	£25,500	£10,900	£0	£2,200	£6,000	£0	£900	£27,300
W5	£27,300	£11,100	£4,200	£2,300	£0	£0	£950	£30,950
W6	£30,950	£9,800	£0	£2,200	£0	£0	£1,200	£37,350
W7	£37,350	£8,200	£4,400	£2,000	£0	£14,500	£1,000	£23,650
W8	£23,650	£8,600	£0	£2,000	£0	£0	£1,000	£29,250
W9	£29,250	£11,100	£4,400	£2,200	£0	£0	£950	£32,800
W10	£32,800	£11,300	£0	£2,200	£0	£0	£1,000	£40,900
W11	£40,900	£11,800	£4,400	£2,300	£0	£0	£1,200	£44,800
W12	£44,800	£12,000	£0	£2,300	£6,000	£0	£950	£47,550
W13	£47,550	£11,500	£4,400	£2,300	£0	£0	£1,100	£51,250

Look at week 7. Turnover dips because of February half-term. The quarterly VAT bill of £14,500 lands the same week. Closing cash drops by nearly £14k from the previous week.

The week itself isn't a disaster - you still close at £23,650. But notice what would happen if you also had an unexpected fridge breakdown (£3k), a slow Friday from bad weather, and a delayed B2B payment. That £23,650 cushion shrinks fast.

The point is not the absolute number. The point is that at the start of week 1 you can already see that week 7 is the tight one, and you've got six weeks to do something about it - hold off on the new espresso machine, push the catering invoices out earlier, time the owner draw for a different week, ring HMRC about a Time to Pay arrangement if needed.

That's the whole game. Make the cliffs visible while you can still walk around them.

The Monday morning habit

A 13-week forecast that you build once and never touch is just an artefact. The value comes from rolling it.

Every Monday morning, 15 minutes:

Update last week's actuals. What did you actually take? What actually went out? Drop those into the previous week's column so you can see your forecast accuracy.
Drop off the oldest week, add a new one at the end. It's a rolling 13-week view, always looking at the next 13.
Adjust this week and next based on what you now know. Big private booking confirmed? Add it. Supplier saying their card terminal is broken and they'll bill double next week? Note it.
Look at the closing balance line. Is any week below your minimum operating cushion? Does any week go negative? If yes, that's this week's planning problem.
Decide one action. Even if everything looks fine: one thing you'll do this week to either improve the forecast or handle a future tight spot.

That's it. 15 minutes. Done sitting at the counter with a coffee before opening.

The Monday slot matters because cash flow problems compound silently if you don't look at them. By the time you feel the squeeze in your stomach, the lever you needed to pull (a price rise, a supplier renegotiation, a dropped subscription) needed pulling four weeks ago.

If you already do a monthly financial reporting routine, think of the 13-week as the weekly counterpart. The monthly tells you how the business is doing. The weekly tells you whether it can keep doing it.

The five forecasting traps

Almost everyone falls into at least one of these the first time. Worth flagging up front.

1. Over-optimistic sales

The most common one. You forecast last year's same week plus 5%, but last year had a glorious sunny May Bank Holiday and this year's forecast is rain. Or you forecast a flat year when half-term is calendar-shifted into a different month.

Anchor on actual prior-year turnover for the same calendar week, then make a single named adjustment if there's a genuine reason to. "+5% optimism" isn't a reason; "new bus stop outside the door from May" is.

2. Forgetting VAT

If you're VAT-registered, VAT is the largest single cash outflow most cafés have outside payroll, and it lands in three giant lumps a year. Forecasts that miss it are not forecasts; they're fiction.

Newly registered cafés get hit hardest. The VAT-pot mentality - mentally setting aside the VAT every week so it isn't yours to spend - takes time to form. We've written separately about the VAT cliff facing UK cafés, and the 13-week forecast is the practical antidote: it forces the VAT bill onto the same page as everything else, so you can't pretend it isn't coming.

3. Forgetting holiday pay

Staff holiday is paid out in lumps, usually during the school holidays - which are also often your quietest weeks. So you've got reduced takings and a higher payroll bill in the same week. If your forecast just rolls payroll as a flat number, you'll miss it.

Look at last year's actual weekly payroll, identify the holiday-heavy weeks, and pencil those in.

4. Ignoring supplier credit term shifts

Suppliers quietly change terms. Your dairy might shift from 30 days to 14 days. A new supplier might want pro-forma for the first three months. A coffee roaster might offer 60 days but pull it back if you're a day late once.

When terms shift, your cash outflows compress closer to the date of supply. A forecast based on old assumptions will show cash you don't actually have.

Re-check supplier terms once a quarter when you re-anchor the forecast.

5. Treating it as a one-off

The forecast you build today is wrong. It will be more wrong tomorrow. Its value comes from being continuously updated, not from being correct.

People build it once, get demoralised when reality diverges, and abandon it. The trick is to expect divergence. The forecast is a hypothesis you test every Monday morning, not a prediction you have to defend.

How this changes when you scale

The cash flow conversation gets bigger, not smaller, when you open a second site. Pre-opening costs, deposit, fit-out, double the rent, double the payroll - and the new site won't break even for months. Site one's cash subsidises site two's cash, and most second-site failures are because the founder didn't model that runway honestly.

If that's where you're heading, the 13-week is the foundation. Stretch it to 26 or 52 weeks for the opening project plan, but keep the 13-week rolling discipline for the live business. We've written more on this in the post on scaling from one café to two.

The same logic applies if you're feeling the squeeze from cost pressures. If wages, rates, energy and supplier prices are all moving against you - and right now, most of them are - the 13-week forecast is how you find out which week the cliff edge actually is, rather than guessing.

Where Brikly fits

Honest answer: most café owners don't keep the spreadsheet alive. Not because they're not capable - because the data is scattered. Card takings live in your acquirer's portal. Cash takings live in the till. Supplier invoices live in your inbox or a paper folder. Bank balance lives in the banking app. Pulling all of that together every Monday is the part that quietly kills the habit.

This is what PulseBrik is built for. PulseBrik is the financial dashboard layer of Brikly: it connects your bank feed, your POS, and your supplier invoices, and surfaces a real-time cash position alongside P&L trends and business health. Instead of starting from a blank spreadsheet, you open PulseBrik on a Monday morning and the actuals are already there, last week's forecast variance is already calculated, and the next 13 weeks are projected from your real patterns - not from a vibes-based guess.

You still make the judgement calls. The spreadsheet just stops being homework.

The bottom line

Every café owner I know who's gone under has been profitable on paper somewhere along the way. The thing that closes the doors is rent on a quarter day, a VAT bill, a half-term week, an equipment failure - landing on the same Tuesday as a delayed card settlement.

Cash flow forecasting isn't accountancy. It's pattern recognition for solvency. Thirteen weeks ahead, every Monday, fifteen minutes. That's the deal.

Build the spreadsheet this week. Roll it next week. By week four, you'll wonder how you ran the business without it.

Ed O'Brien has run Hunters Cake Company for 17 years across cafés in Witney, Burford, and a bakery in Carterton, Oxfordshire. He's building Brikly - modular tools that give independent café owners the same data the big chains have, without the big chain price tag.