What is a cash flow forecast? An 8-step guide for finance teams

Most finance teams we speak to have a cash flow forecast. Most of those forecasts don't actually work. They're built on stale data and forgotten assumptions, telling you where cash was rather than where it's going. Does that sound familiar?

If it does, you're not alone. The numbers back this up. According to a BlackLine survey, 49% of finance executives have concerns about data accuracy, and 44% say a lack of cash flow visibility makes them less confident that the business can remain competitive. For companies managing multiple legal entities, the gap between forecasted and actual cash balances can become so wide that major decisions are made without a clear picture of where cash actually stands.

This article walks through what a cash flow forecast actually is, why it matters so much, and how to build one that genuinely supports better decisions rather than gathering dust in a shared drive.

What is a cash flow forecast?

A cash flow forecast is a projection of how much money you expect to flow in and out of your business over a specific period, typically weekly, monthly, or quarterly. It shows you whether you'll have enough cash on hand to cover your obligations (payroll, rent, and vendor payments) at any given point, even if your business is technically profitable on paper.

The core components are cash inflows (revenue collected, not just invoiced), cash outflows (expenses, debt repayments, and capex), and the resulting opening and closing cash balance for each period.

It's one of the core financial planning and analysis functions. Where an income statement or a profit and loss statement (P&L) tells you if the business is profitable, a cash flow forecast tells you if it can keep its doors open next month.

Why is a cash flow forecast so important to businesses?

According to the Federation of Small Businesses, around 50,000 UK businesses close every year due to cash flow problems. Not profitability problems. Not market fit issues. Cash.

A reliable cash flow forecast changes how your finance team operates:

• Every financial decision gets sharper. As GTreasury's analysis of forecasting costs shows, clear visibility into upcoming cash flows reduces excess interest costs, prevents underinvestment, and keeps liquidity management efficient. When your forecast is reliable, every call on hiring, procurement, or capital expenditure is grounded in real data.

• Your finance team spends time on the right work. The 2024 FP&A Trends Survey, which gathered insights from over 2,400 finance practitioners worldwide, found that only 35% of FP&A professionals' time goes to high-value tasks like generating insights. The rest is consumed by data collection and validation. A forecast built on clean, accessible data shifts that balance.

• You can plan proactively instead of reactively. A trustworthy forecast lets you project the business's financial health with confidence, anticipate cash shortages before they hit, and make informed decisions across financing, investing, and operations.

But when your forecast is inaccurate, those benefits reverse. You overspend on borrowing you don't need, miss investment windows you don't see coming, and lose hours each week reconciling data that should have been clean from the start. Forecasting stops being a planning tool and becomes another source of uncertainty.

What are the components of a cash flow forecast?

A useful cash flow forecast for mid-market businesses needs several interconnected elements working together:

• Opening cash position: Start with verified actual cash balances by bank account, including available credit facilities and any restricted cash identified separately. This baseline must reflect reality, not estimates derived from profit and loss data.

• Operating cash inflows: These include accounts receivable collections aged by payment terms, cash sales, customer deposits, interest income, and tax refunds. Timing is critical here. Your income statement may recognise revenue on an accrual basis, but your forecast needs to reflect when cash actually arrives.

• Operating cash outflows: These cover supplier payments, payroll and benefits, operating expenses such as software subscriptions and professional fees, and tax obligations. They should be scheduled by expected payment date, not invoice date.

• Investment activities: This category captures capital expenditure, asset sales, and technology investments.

• Financing activities: These include loan proceeds, debt repayments, and dividend distributions.

• Closing cash position: Each period should end with a clear closing cash position, along with cumulative balance trends and minimum cash threshold indicators.

• Documented assumptions: Record payment terms, collection patterns, and seasonal variations explicitly so your team can trace any variance back to its root cause.

• Scenario planning: Build optimistic, pessimistic, and stress-case views alongside your base case.

Put together, these components give you a forecast you can explain, update, and use. Not just one you can generate.

How do you build a cash flow forecast that actually works?

Knowing what goes into a cash flow forecast is one thing. Building one that stays accurate and useful week after week is another. Here are eight steps that move you from a static spreadsheet to a forecast your team can actually rely on:

1. Set your time horizons and update cadence

Before building anything, decide what periods you're forecasting and how often you'll update. Most organisations benefit from running more than one forecast simultaneously, each serving a different purpose:

1. Short-term (daily to 13 weeks): This is your operational liquidity forecast. The 13-week rolling forecast (a forecast that moves forward each period, so you're always looking a full quarter ahead) has become the gold standard for managing cash, and AICPA-CIMA recommends finance professionals implement this rolling cycle for mid-market businesses. It updates weekly and gives you near-term precision where accuracy matters most. Use this to answer: can we meet next month's obligations?

2. Medium-term (two to six months): This bridges operational execution and strategic planning. Update monthly. Use this to flag upcoming pressure points like seasonal dips, large contract renewals, or planned headcount increases.

3. Long-term (six months to several years): This supports capital allocation, funding strategy, and major investment decisions. Update quarterly. Use this to answer: can we fund next year's growth?

Match each horizon to a specific update cadence and assign an owner. Your 13-week forecast should refresh on a set day each week (many teams use Monday or Tuesday, once the prior week's transactions have settled). Your medium-term view updates monthly, typically during or just after month-end close. Your long-term forecast refreshes quarterly alongside broader planning cycles.

A forecast that sits untouched for months is just a snapshot with an expiry date. Weekly updates on the short-term view force your team to revisit assumptions, incorporate new information, and catch variances before they compound.

2. Gather and integrate your data sources

Forecast accuracy lives or dies on data quality. The more accurate your spend data is at the point of capture, the less manual work you'll need to do before it reaches your forecast. Whether you're building in a spreadsheet or a dedicated forecasting tool, start by identifying where your key inputs live: accounts payable and accounts receivable data, payment terms and behaviour patterns, invoice and billing activity, and working capital metrics such as Days Sales Outstanding (DSO) and Days Payable Outstanding (DPO).

This is where many finance teams hit their first bottleneck. When data sits in disconnected systems (e.g., one tool for cards, another for invoices, and spreadsheets for expense claims), aggregating that data into a reliable forecast becomes a manual, error-prone exercise.

And even in good months, when the data has been captured correctly, finance teams still carry the anxiety of month-end, manually cross-checking everything because one missed entry could throw the close. The process works, technically, but it never feels under control.

This is one of the reasons we built Spendesk. By consolidating procurement, cards, expenses, invoices, and budgeting into a single platform, finance teams get real-time visibility into committed and actual spend across every payment method without manually stitching data together.

3. Choose and combine your forecasting methods

There are two core approaches to building a cash flow forecast, and they serve different purposes:

1. The direct method tracks actual cash receipts and disbursements. It's considered the most accurate approach for short-term forecasting because it uses real cash movements rather than accounting adjustments. If you need to know exactly how much cash you'll have in three weeks, this is the method to use. Apply it to your 13-week forecast by listing expected cash receipts from customers and mapping disbursements to suppliers, payroll, and tax authorities against their actual due dates.

2. The indirect method starts with net income and adjusts for non-cash items and working capital changes. It's better suited to longer-term strategic planning where transaction-level granularity is less critical. Use it for your quarterly or annual forecast, starting from projected net income and adjusting for items like depreciation, amortisation, and shifts in working capital.

These approaches aren't mutually exclusive. Many treasury teams use the direct method for their 13-week operational forecast and the indirect method for longer-term planning, letting each method serve the purpose it's best suited for.

4. Document your assumptions explicitly

Every forecast rests on assumptions, and undocumented assumptions are the fastest route to unreliable numbers. Record payment terms, historical collection patterns, and seasonal variations on the revenue side. On the expense side, capture vendor payment schedules, payroll cycles, and the distinction between recurring and one-time costs. Note your growth projections and what resources they require.

When your forecast inevitably diverges from reality, documented assumptions let you trace the variance to its source rather than guessing at what went wrong.

5. Build in scenario planning

Scenario planning means building multiple versions of your forecast, each based on a different set of assumptions about what might happen. Instead of a single "most likely" view, you model how your cash position would change under different conditions so you can prepare for each before it arrives.

A single-scenario forecast gives you a plan. Multiple scenarios give you preparedness. At minimum, build a base case (most likely outcome), an optimistic case, a pessimistic case, and a stress case that tests severe liquidity constraints.

Run sensitivity analysis on the variables that matter most: What happens if collection times extend by 10 days? What if a major customer delays payment? What's the impact of accelerating supplier payments to capture early-payment discounts?

These scenarios turn your forecast from a static prediction into a decision-support tool.

6. Establish a regular variance analysis process

A forecast only improves if you study where it was wrong. Each week, pull your actual closing cash position and compare it line by line against your forecast. Set a materiality threshold for investigation (for example, any line item that deviates by more than 5% or £10,000) and run root cause analysis on each: was the assumption wrong, was the timing off, or was the data incomplete?

The Association for Financial Professionals makes this point in their cash forecasting guide: treasury should look at actual accounts payable alongside business trends not yet reflected in the forecast. Track your variance patterns over time. If collections consistently arrive five days later than forecasted, update your DSO assumption rather than explaining the same miss every week. The faster you can close that gap between what happened and what you predicted, the sharper your next forecast becomes.

That speed depends on how quickly you can access actual spend data. If you're reconstructing it weeks later from credit card statements and late expense claims, your variance analysis is already stale by the time you run it. Real-time visibility into spending as it happens changes that equation entirely.

For example, Spendesk reports that customers achieve up to four days faster month-end close and a 95% on-time receipt submission rate, giving finance teams the rapid feedback loop that makes variance analysis genuinely useful.

7. Close the loop with cross-functional collaboration

Your forecast is only as good as the operational intelligence feeding it. Business units hold critical information about upcoming deals, planned purchases, staffing changes, and seasonal patterns that won't appear in your financial systems until after the fact.

Set up a recurring monthly check-in (or a brief weekly async update) with department heads from sales, operations, HR, and procurement. Give each team a simple prompt: what significant cash inflows or outflows do you expect in the next 13 weeks that finance doesn't already see? A large deal closing early, a delayed vendor payment, a planned hiring push: these all shift your cash position, and the sooner they reach your forecast, the more useful it becomes.

Treasury consolidates those inputs, updates the forecast, and shares a short summary back so business units can see how their plans affect the company's cash position. Over time, this feedback loop transforms forecasting from a finance-only exercise into an organisation-wide discipline where teams naturally flag cash-relevant decisions before they happen.

8. Automate what you can, and invest your time where it counts

Many treasury teams still spend hundreds of hours collecting, collating, and aggregating data manually. That time could be spent analysing trends, refining assumptions, and advising the business on cash implications of strategic decisions.

Start by mapping out your current forecasting workflow and identifying the steps that are purely mechanical: exporting data from bank portals, copying transaction details into spreadsheets, categorising expenses by GL code, reconciling card statements against receipts. These are the tasks to automate first.

Use accounting automation to handle data aggregation, transaction categorisation, and routine reconciliation. Once those manual steps are removed, redirect that time toward the work that actually improves your forecast: investigating why collections slowed last quarter, stress-testing your assumptions against new business conditions, and advising leadership on the cash implications of strategic decisions they're weighing now.

The forecast that works is the one you actually maintain

A useful cash flow forecast comes down to three things: clean data going in, documented assumptions you can challenge, and a weekly habit of comparing what you predicted with what actually happened. Get those right and every other step in this guide falls into place.

The hardest part isn't building the forecast. It's getting accurate spend data fast enough to keep it current. That's exactly what Spendesk solves. Our all-in-one platform gives finance teams real-time visibility across cards, invoices, and expenses, so your forecast stays connected to reality.

Book a demo to see how it works.