Cash Flow Forecast in Xero: What It Does and What It Doesn't

Xero is excellent accounting software, and we build our whole practice on it. But if you're relying on Xero alone to forecast your cash, there are some real gaps you should know about — because the difference between what Xero shows and what you actually need has caught out plenty of owners.

Here's an honest, Xero-Certified-Advisor's view of what Xero does for cash flow forecasting, and where you still need something more.

What Xero does give you

Xero has two relevant features, and they're genuinely useful as far as they go.

The Short-term cash flow tool

Built into Xero, this projects your bank balance roughly 7 to 30 days ahead based on the bills and invoices already entered. It's a helpful glance at the immediate horizon: it takes your current balance, adds invoices due, subtracts bills due, and draws a line. For a quick "am I okay this week?" check, it does the job.

Xero Analytics Plus

The paid add-on extends the projection to around 90 days and layers in some pattern-detection, predicting recurring transactions from your history. It's a step up, and for some businesses it's enough.

Where Xero stops

Both tools share the same underlying limitation: they forecast from what's already in Xero, using stated dates. That creates several blind spots.

1. It assumes customers pay on the due date

Xero places an invoice's expected receipt on its due date. But your customers don't pay on the due date — they pay when they pay. A customer on 30-day terms who reliably pays in 47 days will make Xero's forecast wrong by more than two weeks, every time. A genuine forecast adjusts each receipt to the customer's actual payment behaviour. Xero doesn't do this.

2. Tax is not properly modelled

VAT, PAYE and Corporation Tax are large, predictable, dateable outflows — and the most common reason a forecast that looked fine turns red. Xero's cash tools don't automatically place your VAT payment in the right week at the right amount. That £8,000 VAT bill in week seven is exactly the sort of thing that sinks an unprepared forecast.

3. It can't see what's not in Xero yet

The deal you're about to close, the big supplier invoice about to land, the equipment you're planning to buy next month — none of it is in Xero, so none of it is in the forecast. A real forecast incorporates the owner's forward knowledge, not just the accounting system's history.

4. It's not a true weekly 13-week view

The professional standard is a rolling 13-week cash flow forecast — a full quarter, week by week, refreshed weekly. Xero's short-term tool is shorter and less granular than that, and even Analytics Plus isn't structured the way a treasury-grade 13-week model is.

So what should you actually do?

• Use Xero's short-term tool for the daily glance — it's fine for that.
• Keep your Xero clean. Any forecast is only as good as the data underneath it. Reconciled bank feeds and correctly-dated bills matter.
• Build a proper 13-week forecast on top — adjusted for real payment behaviour, with tax modelled correctly, and your forward knowledge layered in.
• Remember cash isn't profit. Neither Xero's P&L nor its cash tool alone tells the whole story — see cash flow vs profit.