How to Build a 13-Week Cash Flow Forecast - Step by Step
Last week we covered why profitable businesses run out of cash. The fix for almost every version of that problem is the same tool: a 13-week cash flow forecast. This week, here's exactly how to build one.
If you've never built one before, that's normal - nobody teaches this to business owners. It's standard practice for finance directors and lenders, but almost never for the people who actually need it most: business owners managing their own cash without a finance team behind them.
The good news: it's not complicated. It's a spreadsheet, a bit of discipline, and fifteen minutes a week once it's set up.
Why 13 weeks specifically
Not 12 months, not 4 weeks. Thirteen weeks - one quarter - hits a specific sweet spot.
It's short enough to be based on things you actually know, not guesswork. You can usually say with reasonable confidence which customers will pay in the next three months and what your fixed costs will be. Stretch that forecast to a year and you're mostly speculating.
It's also long enough to see problems coming. If a cash shortfall is nine weeks away, you have nine weeks to do something about it - chase an invoice, delay a purchase, arrange short-term finance. Find out on the day it happens and your options have shrunk to almost nothing.
And thirteen weeks lines up neatly with a UK business's natural rhythm: it roughly matches your VAT quarter, so tax due dates fall naturally within your forecast window instead of surprising you from outside it.
Annual forecasts are a strategy tool. The 13-week forecast is a survival tool. Most business owners need the second one far more often than the first.
What goes into it
Two columns, one balance line, thirteen weeks across the top.
Inflows - money actually landing in your account:
Customer payments, mapped to the date you realistically expect them (not the invoice due date - the date they actually tend to pay)
Any grants, loans or investment due to land in the window
Other income: asset sales, tax refunds, anything one-off
Outflows - money actually leaving your account:
Payroll and contractor payments
Rent, utilities, subscriptions
Supplier payments
Tax - VAT, PAYE, corporation tax, with actual due dates flagged
Loan repayments
Owner drawings or dividends
Notice what's not on this list: nothing about invoices you've sent but haven't been paid for, and nothing about profit. This is cash only - money that has actually moved or is realistically about to.
Building it: six steps
List your expected inflows, week by week, based on what you actually know - not what invoice terms say should happen.
List your fixed outflows - the costs that go out regardless of how the month is trading: rent, payroll, subscriptions.
Add your variable outflows, clearly flagged as estimates rather than known figures.
Calculate the net movement for each week - inflows minus outflows.
Add your actual opening bank balance, then run it forward as a rolling closing balance, week by week.
Look for any week where that closing balance goes negative. Those are your risk weeks - the ones that need attention now, while you still have time.
That's the whole mechanism. The value isn't in the spreadsheet being clever - it's in being honest about the numbers and looking far enough ahead to act.
Using it every week, not just building it once
A forecast built once and never touched is just a document. The value comes from the habit:
Update it every Monday morning. Fifteen minutes, once the structure exists.
Compare actual to forecast. Where were you wrong, and why? That gap is often more informative than the forecast itself - it tells you which customers actually pay on time and which of your assumptions need adjusting.
Roll it forward each week - drop week one, add a new week thirteen, so you always have a full quarter of visibility.
Share it with your accountant monthly. It changes the entire conversation, from "how did we do" to "here's what's coming and here's where I need help."
The five warning signs worth checking against right now
Before you've even built your first forecast, these five signs tell you whether you're already in the territory this tool is built to catch:
You're regularly waiting until the last possible day to pay suppliers
Overdue invoices represent more than 20% of your monthly revenue
Your bank balance at month-end is consistently lower than it was at the start
You're using an overdraft or credit card to cover ordinary running costs, not one-off costs
You can't answer the question "how many months of runway do I have at the current rate?"
If any of these are true, don't wait until the forecast is perfect to start using it. A rough version built this afternoon is worth more than a polished one you never get round to.
Where to start
You don't need accounting software or a finance qualification to build this - a spreadsheet and thirty focused minutes will get you a working first draft.
If you'd rather work from a done-for-you structure than build one from scratch, The Business Owner's Cash Flow Guide walks through this exact forecast - and the full picture around it - in plain English, with a template ready to fill in.
And if you want a second pair of eyes on it once it's built - someone who's read cash flow forecasts professionally, not just built one for their own business - that's exactly what a Financial Confidence Workshop is for: a practical session covering cash flow, margins and financial decision-making, built around your actual numbers.
Not sure where your business currently stands? Download the free 10 Questions to Ask Your Accountant checklist - ten questions that surface exactly this kind of gap in one conversation.
Related reading: Why Profitable Businesses Run Out of Cash