The 13-Week Cash Flow Forecast: Method and Best Practices

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a rolling table that projects, week by week, the cash inflows and outflows you expect over a full quarter. It works in real cash terms, the money actually received or paid from your bank accounts, not in accounting profit. An issued invoice only appears when its payment is expected to land on the account.

This horizon is built for operational steering: it answers the question, will I have enough liquidity to meet my obligations over the coming weeks? For a CFO or an SME owner, it is the bridge between the annual budget and the day-to-day reality of the bank balance.

Why thirteen weeks specifically?

Thirteen weeks equal one quarter. The horizon is a balance point: short enough for assumptions to stay reliable, long enough to anticipate major due dates such as VAT, corporate tax, payroll, social contributions or loan repayments.

Beyond thirteen weeks, uncertainty grows quickly and the forecast loses precision; below it, you lack the runway to react. A rolling quarter gives enough visibility to decide, deferring an investment, negotiating a supplier term, drawing on a credit line, before pressure becomes critical.

How to build it, line by line

Start from the opening position: the consolidated bank balance across every account and every bank. That is the forecast's zero point.

Then enter expected inflows: customer payments (based on real payment terms, not invoice dates), recurring income, grants or contributions. Next, the outflows: suppliers, salaries and social charges, VAT and taxes, rent, loan instalments. Known commitments, placed orders and signed contracts, belong in the grid even if they are not yet invoiced.

In Tresoria, this takes the form of an editable planning grid that you fill in yourself, with a choice of 13-week, 6-month or 12-month horizons. It is a tool to capture and structure your assumptions, not an automatic projection derived from transaction history.

The rolling principle: update every week

A 13-week forecast is only valuable if it rolls. Each week you move the window forward one notch: the past week drops out, a new week is added at the far end, and the whole grid realigns.

At the same time, last week's forecast is replaced by the actuals. Bank data enters Tresoria through file imports (CSV, Excel, XML) or scheduled SFTP/REST connectors; a live bank connection is not yet available and sits on the roadmap. This regular refresh turns a one-off exercise into a living steering instrument.

Comparing actual against forecast

Reconciling actual with forecast is the heart of the method. Week after week you measure the gaps: a customer payment that arrived late, an outflow larger than planned, a due date that was missed.

These variances are not errors to hide but a source of learning: they expose over-optimistic assumptions and sharpen the next ones. An actual-versus-forecast view, like the one Tresoria provides, helps you quickly see where the forecast drifted and why.

The most common mistakes

The first is confusing revenue with cash: a sale only enters treasury when it is paid, often several weeks after the invoice. Ignoring real payment terms distorts the whole forecast and inflates the anticipated working capital need.

Next come forgetting tax and social due dates, underestimating seasonality, and above all failing to update: a frozen forecast quickly becomes obsolete. Finally, chasing too much detail kills the discipline; a readable grid maintained every week beats an exhaustive model abandoned after a month.