Thursday, November 19, 2026 Independent journalism
MediaChannel

bussiness

What is a cash flow forecast and how do you build one?

A cash flow forecast tells you whether your business will have enough money to pay its bills before the problem arrives. Here's a plain-language guide to what it is and how to build one.

Close-up of hands analyzing financial document with US dollar bills on table.

Photo by Mikhail Nilov on Pexels

A cash flow forecast is a projection of the money expected to flow into and out of a business over a future period, usually 13 weeks, 6 months, or 12 months. It doesn't measure profit. It measures timing: when cash actually lands in your account versus when it leaves. That gap is where businesses get into trouble, and a forecast is the tool that lets you see the gap before it swallows you.

Many owners conflate a cash flow forecast with a profit and loss statement, but the two answer different questions. A profit and loss statement tells you whether a business earned more than it spent. A cash flow forecast tells you whether the business can pay its bills on Tuesday. A company can be profitable on paper and still run out of cash if customers pay late and suppliers demand payment now.

The two sides of a cash flow forecast

Every forecast is built from two columns: cash inflows and cash outflows. Inflows include customer payments, loan proceeds, interest earned, and any asset sales. Outflows cover wages, rent, supplier invoices, loan repayments, tax obligations, and operating costs. The net difference between the two, week by week or month by month, is your closing cash balance for each period.

The opening balance for each period carries over from the closing balance of the previous one. This is what makes the forecast dynamic: a single bad month compounds into the next unless you act. That compounding effect is exactly why building the forecast ahead of time matters rather than reviewing it after the fact.

How to build a cash flow forecast step by step

Start with your opening cash balance: the actual amount sitting in your business accounts right now. Then map out every expected inflow and outflow across your forecast period. Use real data where you have it and conservative estimates where you don't.

For inflows, work from your confirmed sales orders, your average debtor days (how long customers typically take to pay), and any recurring contracts. If a customer usually pays 30 days after invoice, record that revenue 30 days after the invoice date, not on the day you raise it. This is where most first-time forecasts go wrong. Revenue booked is not cash received.

For outflows, list fixed costs first. Rent, payroll, loan repayments, and insurance are predictable. Variable costs like stock purchases, marketing spend, and contractor fees require more judgment. Use the previous three months as a baseline and adjust for known changes ahead.

Once you have both columns mapped, subtract outflows from inflows for each period and carry the net balance forward. If any period shows a negative closing balance, you've identified a potential shortfall. That's the point of the exercise. You now have time to respond: draw on a credit facility, accelerate debt collection, defer a capital purchase, or negotiate extended payment terms with a supplier.

Weekly vs monthly forecasts

The right time horizon depends on your business's situation. A business with tight margins and unpredictable revenue needs a 13-week rolling forecast updated weekly. A stable, subscription-based business can work comfortably with a monthly forecast across 12 months.

Rolling forecasts are more useful than static ones. A static forecast is set once and rarely revisited. A rolling forecast moves forward by one period each week or month, so you always have a consistent window into the future. It forces a regular discipline of comparing actuals to forecasts and updating your assumptions.

Common mistakes that undermine a forecast

The biggest mistake is using invoice dates rather than expected payment dates. The second is ignoring seasonality. A retail business that records flat monthly sales through December and January will produce a forecast that's completely detached from reality.

A third mistake is treating the forecast as a set-and-forget document. The numbers change. Customers pay late, a contract falls through, an unexpected repair bill arrives. The forecast only helps if you update it regularly against actuals and understand why the variance occurred.

Finally, don't build the forecast in isolation. Cash flow affects every part of a business, from hiring decisions to supplier negotiations. The forecast should inform those decisions, not sit in a spreadsheet that nobody reads.

What to do when the forecast shows a shortfall

A forecast that reveals a shortfall is doing its job. You have four levers: increase inflows, decrease outflows, accelerate collections, or access external funding. In practice, most businesses pull a combination of all four.

Chasing debtors faster is usually the quickest lever. Shortening your payment terms from 30 days to 14 days, sending invoices immediately on delivery rather than at month-end, or offering a small early-payment discount can shift thousands of dollars of timing in your favour. On the outflow side, deferring a capital purchase by even one month can bridge a gap without touching your credit lines.

If external funding is needed, a revolving credit facility is often the most flexible option for short-term cash flow gaps. It lets you draw and repay funds as the gap opens and closes, rather than taking on a fixed-term loan for a temporary problem.

Tools for building your forecast

A well-structured spreadsheet is enough for most small businesses. Xero and similar cloud accounting platforms include built-in cash flow forecasting tools that pull directly from your live accounting data, reducing the manual work and the risk of data entry errors. For businesses with more complex cash flows, dedicated tools like Float or Futrli connect to your accounting system and automate the rolling forecast process.

Whatever tool you use, the discipline matters more than the software. A forecast updated monthly in a simple spreadsheet beats an automated dashboard that nobody checks.