The question I get most often from small business owners isn't about marketing or pricing. It's this: "Why does my profit look fine on paper, but my bank account keeps dipping?" Nine times out of ten, the answer is that they're watching profit instead of cash. A cash flow forecast is the instrument that fixes that blind spot—and building one for a small business takes less time than most people think, once you stop overcomplicating it.
Below is the exact method I use, including the parts that tripped me up when I first started (spoiler alert: I once forecasted receivables at 30 days for a client whose actual collection average was closer to 58—that mistake cost them a very uncomfortable payroll week).
Key Takeaways
- A cash flow forecast tracks when money actually moves, not when it's invoiced or earned.
- For most small businesses, a 13-week rolling forecast is the right operational tool; a 12-month view is for planning, not daily decisions.
- Your forecast is only as good as your receivables assumptions—get those wrong and everything downstream is fiction.
- Excel works fine up to a point. A connected tool becomes worth the money once you have more than ~30 transactions a month.
- Build three scenarios (base, slow, tight), not one. The base case is a comfort blanket; the others are what save you.
What a cash flow forecast actually does (and what it doesn't)
A cash flow forecast is a table showing money coming in and money going out over a defined period, with a running balance at the bottom. That's it. It is not a P&L, it is not a budget, and it is not a substitute for your accountant's year-end work.
The distinction matters more than it sounds. Your P&L records revenue when you invoice. Your forecast records it when the client pays. For a business that waits 45 days to get paid, that gap is the whole ballgame. I've watched a bakery with healthy margins nearly miss rent because a single wholesale client stretched payment to two months without warning.
Direct vs indirect forecasting—which one should you use?
Two schools exist. Direct forecasting builds the forecast line by line from actual expected transactions: this invoice lands on the 12th, this supplier bill leaves on the 28th, this loan payment goes out on the 1st. It's granular and precise, and it's what you want for weeks and months.
Indirect forecasting starts from projected revenue and adjusts using historical collection patterns and payment ratios. Fewer lines, less work, less accuracy on timing.
My honest opinion: for a business with fewer than 200 transactions a month, direct is worth the effort. Above that, a hybrid—direct for the big items, indirect patterns for the long tail—keeps the model manageable. I'll die on the hill that a small business owner should know their top ten cash movements by date, not just their aggregate monthly number.
How to create a cash flow forecast for your small business, step by step
Here's the sequence I follow, refined over years of building these for clients and for my own ventures.
Step 1: pick your horizon and frequency
Two horizons, two purposes:
- 13-week rolling forecast — updated weekly, weeks as columns. This is your operational early-warning system. It catches shortfalls before they become emergencies.
- 12-month forecast — updated monthly, months as columns. This is for planning, tax provisioning, seasonal scheduling, and conversations with lenders.
If you can only build one, build the 13-week. A year-long forecast in months hides the fact that all your bills land in week three while all your receipts land in week five.
Step 2: start from your real opening cash position
Not your bank balance from the statement you remember. Open your banking app, right now, and use the cleared balance. Then subtract any checks you've written that haven't cleared. That opening number anchors everything else; if it's wrong, the whole forecast lies to you politely.
Step 3: map your inflows with painful honesty
Inflows are where optimism kills forecasts. Break them into categories:
- Confirmed receivables — invoices already issued, with a real expected payment date (not the due date—the date you actually expect the money)
- Recurring revenue — subscriptions, retainers, contracted work
- Pipeline revenue — weighted by probability, not by hope
- Other inflows — loans, tax refunds, asset sales
Here's the number that surprised me: when I ran the actual collection data on my own consultancy, the average days-to-pay was 47 days against 30-day terms. I'd been forecasting at 30 for over a year. Adjusting that one input shifted my projected month-end balance by roughly 30% in the tightest month. Use your real collection average, not your stated terms.
Step 4: map your outflows, including the ones you forget
Every cash forecast I've audited that failed had the same failure mode: the owner forgot the lumpy or irregular outflows. Include these deliberately:
- Payroll and payroll taxes (with exact dates)
- Rent, utilities, insurance premiums (note which are annual and when they hit)
- Supplier payments, with negotiated payment terms reflected accurately
- VAT and other tax obligations—quarterly VAT is a cliff, not a slope
- Loan repayments and interest
- Owner draws or salary—yes, you pay yourself, and it must be in the model
- Capital expenditure—new laptop, vehicle, equipment deposits
That last one catches people. A £4,000 equipment deposit landing in the same week as payroll and a VAT bill is exactly the kind of collision a good forecast prevents. The tax and payroll dates alone are reasons enough to build this properly—they're fixed, they're non-negotiable, and they're the ones that trigger nasty surprises.
Step 5: calculate the running balance—and actually read it
Columns: opening balance + inflows − outflows = closing balance. That closing balance becomes the next period's opening. Drag it across.
The point isn't the number at the end. The point is the lowest number anywhere in the row. Look for the trough, not the destination.
A worked example: a small design studio over 12 months
Let's make this concrete. Here's a simplified cash flow forecast example for a two-person design studio with one retainer client and project work. I've rounded figures but kept the structure exactly as I'd build it.
| Month | Inflows | Outflows | Net | Closing balance |
|---|---|---|---|---|
| January | 14,000 | 11,500 | +2,500 | 8,500 |
| February | 9,500 | 11,000 | −1,500 | 7,000 |
| March | 7,200 | 13,800 | −6,600 | 400 |
| April | 16,500 | 10,200 | +6,300 | 6,700 |
| May | 12,000 | 11,100 | +900 | 7,600 |
Look at March. On paper, the studio is profitable for the year. But in March the closing balance drops to £400—dangerously thin. Why? A project invoice was pushed to April, and a VAT payment plus annual insurance landed the same week. Without the forecast, the owner finds out when a card payment bounces. With it, they can chase that invoice in mid-February or negotiate the insurance to a monthly plan.
That's the practical value: not prediction, early warning.
Excel vs online tools: which should you actually use?
Both work. The right choice depends on your transaction volume and how disciplined you are about manual updates.
| Factor | Excel / spreadsheet template | Online forecasting tool |
|---|---|---|
| Cost | Free to near-free | Monthly subscription |
| Setup time | 1–3 hours with a good template | 30 minutes if bank-connected |
| Automation | None—you update it manually | Pulls transactions from bank/accounting |
| Best for | Simple, low-volume businesses | Businesses with 30+ transactions monthly |
| Risk | You stop updating it by week six | Setup cost, learning curve |
Here's the thing nobody tells you about Excel-based forecasts: the tool isn't the problem, the follow-through is. I've built beautiful 13-week models in spreadsheets that clients abandoned within two months because updating them took 40 minutes every Monday. A live bank connection that does the boring part for you is worth more than a perfect template you never open.
Where can you get a free cash flow forecast template?
Plenty of accountants and business banks publish free downloadable templates. A quick search for "cash flow forecast template Excel" will surface dozens. My advice: pick one, then strip it down. Most templates come with 20 tabs and complex formulas for businesses ten times your size. Delete what you don't need. A one-page, five-column, 13-week forecast you actually maintain beats a fifteen-tab financial model sitting untouched.
Building in scenarios—and what to do when the forecast shows a shortfall
A single forecast is a gamble. Three is a plan.
- Base case: things go roughly as expected.
- Slow case: your biggest client pays 30 days late and one project slips a month.
- Tight case: both happen, plus one deal lost.
Run all three. If your tight case shows a negative balance in month two, you know exactly where your pain point is—and you have months to prepare instead of days to panic.
When the forecast reveals a shortfall, your options are limited but real: chase receivables early, negotiate supplier terms, draw on an overdraft or credit line before you need it, delay discretionary spending, or bring forward a project milestone. The key insight is that all of these require lead time—and the forecast is what buys you that lead time. Without it, your options shrink to the desperate ones.
What most small businesses get wrong
Looking back at the forecasts I've built, the recurring failures cluster around a few patterns:
The best forecast is the one you'd actually update weekly—buy the simplest tool that survives Monday mornings. Beyond that, the three things that tank most forecasts are: collecting data too late (by the time your accountant reconciles, the warning is worthless), ignoring seasonality (a business with a quiet August needs the forecast to shout about it), and forgetting the owner's draws (you're a cash outflow too).
One more: don't chase precision. A forecast with clean round assumptions you trust beats a perfect-looking model built on guesswork. I learned that the expensive way.
None of this replaces your accountant, and I'm not pretending it does. But a forecast you build and actually use gives you something no year-end statement can: a month's warning before the problem instead of a phone call after it.
So here's the question worth sitting with. If you opened your banking app right now and looked at the next eight weeks—the invoices not yet paid, the tax due, the payroll scheduled—would you know, to within a few hundred pounds, which week is your tightest? If the answer is no, you already know what to build this weekend.
