13-Week Cash Flow Forecasting for SMEs
Most SME cash flow forecasts are either out of date, built in a spreadsheet nobody trusts, or simply missing. A good forecast tells you what your bank balance will look like in 13 weeks — and why. Here is what that actually requires.
Cash flow forecasting for SMEs works when it is rolling, weekly, and built on real cash movements rather than accruals. A good one tells you what your bank balance will be over the next 13 weeks — and why — so you can act on a squeeze while you still have time to do something about it. Most growing businesses have something (a spreadsheet, a Xero report, a number in the founder's head), but a forecast that actually drives decisions is rarer than it should be.
Why most SME cash forecasts fall short
The most common problem is staleness. A forecast built on last month's actuals and updated quarterly is not a forecast — it is a history lesson with optimism attached. By the time you spot a cash squeeze, you have about two weeks to act. That is rarely enough.
The second problem is structure. Profit and loss does not equal cash. A business can be profitable on paper while a large customer pays 60 days late, a VAT or GST bill lands, and payroll goes out on Friday. Cash and profit diverge constantly in a growing business, especially one carrying inventory or funding work-in-progress.
The third problem is ownership. If the forecast lives in a spreadsheet that only the bookkeeper updates, the founder has no real relationship with it. They glance at it once a month and go back to running the business by gut feel.
What a good cash flow forecast actually contains
A 13-week rolling view. Thirteen weeks is the standard for good reason. It is short enough to be accurate and long enough to give you time to act. Each week you roll it forward by one week and update actuals. The discipline of doing that weekly matters more than the sophistication of the model.
Real cash movements, not accruals. You want to see money leaving and entering your bank account — not revenue recognised, not invoices raised. That means mapping actual payment terms. If you invoice on 30-day terms but your biggest customer pays at 45, the forecast needs to reflect 45 days. If your Stripe payouts settle two business days after the transaction, that lag matters when you are watching a tight week.
Explicit assumptions. Every forecast is a set of assumptions wearing a spreadsheet. A good one makes those assumptions visible: expected collections on outstanding debtors, scheduled supplier payments, known upcoming costs such as rent, payroll, loan repayments, and tax instalments. When actuals diverge from forecast, you can see exactly which assumption was wrong and correct it.
How Xero helps — and where it stops
Xero's short-term cash flow tool is useful. It uses your bills, invoices, and bank account to give you a simple near-term projection, and for a business with straightforward finances that can be enough.
It has limits, though. Xero does not know about a contract you have agreed verbally but not yet invoiced. It does not model scenarios — what happens to your cash position if your biggest customer moves to 60-day terms? It does not pull in your Stripe receivables pipeline or your Shopify sales trend. And it does not roll forward automatically each week without someone maintaining it.
For a business turning over a few million, Xero's built-in view is a starting point. The gap between that and something decision-useful is where a finance lead or fractional CFO earns their keep.
The difference between a forecast and a model
A forecast tells you what is likely to happen based on current information. A model lets you test scenarios: what if you win that contract? What if a key customer leaves? What if you push through the price increase in Q2?
Growing SMEs need both. The 13-week rolling forecast keeps you safe week to week. A slightly longer-range model — six to twelve months — helps you answer bigger questions: Can we afford to hire? Do we need a credit facility? When do we run out of runway if growth slows?
I have found that the modelling conversations are often where the most useful strategic thinking happens. Not because the numbers are magic, but because forcing precision on assumptions brings disagreements into the open that were previously just noise.
Where automation fits in
Once you have a forecast structure that works, parts of it can be automated. Pulling actuals from Xero into a rolling model, flagging when a debtor goes past terms, updating Stripe or Shopify revenue actuals daily — these are solvable with the right data pipeline.
Automation does not replace judgement. Someone still needs to decide whether a verbal contract counts as probable revenue, or whether to use the stretch sales target or the base case. But it removes the manual grind of copying numbers between systems, which means the forecast gets updated more often and the person responsible for it spends their time thinking rather than wrangling data.
Our AI build and automation work often starts exactly here — with a finance process that is partly manual and partly broken.
What to do if you have no forecast at all
Start simple. A spreadsheet with your opening bank balance, your expected inflows week by week, and your expected outflows week by week will tell you more than nothing. Build it for 13 weeks. Update it every Monday.
If that sounds manageable, start this week. If it sounds like something that will never happen given everything else on your plate, the finance function probably needs more senior attention than a bookkeeper can provide — closer to what a fractional CFO does — and that is worth addressing sooner rather than later.
Frequently asked questions
How often should I update my cash flow forecast? Weekly is the standard for a 13-week rolling forecast. Monthly is better than nothing but leaves too little reaction time if something goes wrong.
What is a 13-week cash flow forecast? A rolling forecast covering the next 13 weeks, updated weekly with actuals. It is the most common format used by finance professionals to monitor near-term liquidity.
Can Xero do cash flow forecasting automatically? Xero has a basic short-term cash flow tool built in. It is useful for simple businesses but does not handle scenarios, non-invoiced pipeline, or multi-source data. Most growing SMEs need something more structured.
Does a fractional CFO help with cash flow forecasting? Yes. Building and owning the cash flow forecast is one of the core practical outputs of a fractional CFO engagement. The goal is not just a model but a finance rhythm that keeps the leadership team informed and able to act.
General information, written to be useful — not financial, tax, investment or legal advice. For decisions specific to your business, take advice from a suitably qualified professional.
Think this might be a fit?
Tell us what you're trying to improve. We'll come back on whether it's a fit and a sensible next step — usually a short call and a free Finance & Automation Health Check.