To build a cashflow forecast, you need three core categories of data: historical cash movements (receipts and payments), forward-looking assumptions about revenue and costs, and the timing of those flows. The more granular and accurate your inputs, the more reliable your forecast. Getting this right means knowing where your cash comes from, where it goes, and when.
Guessing at cashflow is quietly draining your runway
When cashflow forecasting relies on rough estimates rather than structured data, the gaps compound fast. A missed payment timing here, an optimistic revenue assumption there, and suddenly your runway looks three months longer than it actually is. By the time the shortfall becomes visible, your options narrow sharply. The fix is not a more sophisticated model. It starts with identifying the right data sources and building the habit of updating them regularly. Structure beats precision every time when you are working with incomplete information.
Poor visibility into cash timing is a bigger risk than poor visibility into profit
Profit is an accounting concept. Cash is what keeps the lights on. Many growing businesses focus on margin and revenue targets while underestimating how badly payment timing can distort their actual cash position. A profitable month with slow-paying customers and a large VAT bill can still leave you short. The practical fix is to separate your P&L thinking from your cash thinking. Your forecast needs to track when money actually moves, not when it is earned or accrued.
What is a cashflow forecast and why does it matter?
A cashflow forecast is a forward-looking projection of when cash will enter and leave your business over a defined period. It maps expected receipts against expected payments, giving you a running view of your cash position. It matters because it tells you whether you will have enough cash to meet obligations before a problem becomes a crisis.
Unlike a profit and loss statement, which records economic activity, a cashflow forecast focuses purely on timing. A business can be profitable on paper and still run out of cash if customers pay late, suppliers demand early payment, or a large investment hits at the wrong moment. The forecast gives you time to act, whether that means drawing on a credit facility, accelerating collections, or delaying discretionary spending.
For growing businesses especially, cashflow forecasting is not a finance department exercise. It is a core decision-making tool that founders and leadership teams need to engage with directly.
What data sources feed into a cashflow forecast?
A cashflow forecast draws from four main data sources: your accounting system, your sales pipeline, your accounts payable records, and your payroll and fixed cost schedule. Together, these cover the inflows and outflows that make up your cash position at any given point.
Your accounting system provides the historical baseline: what cash came in, what went out, and when. Your sales pipeline tells you what revenue is likely to close and when it will convert to an invoice. Your accounts payable records show what you owe and when those payments fall due. Payroll and fixed costs give you the predictable, recurring outflows you can anchor the forecast around.
Beyond these four, you should also factor in any known one-off items: tax payments, loan repayments, planned capital expenditure, or upcoming contract renewals. The more complete your data capture, the fewer surprises your forecast will surface after the fact.
How far back should historical financial data go?
For most businesses, 12 to 24 months of historical financial data gives you a reliable foundation for cashflow forecasting. This range captures seasonal patterns, payment cycle behaviour, and any one-off disruptions that might otherwise skew your assumptions if you only look at recent months.
If your business is younger than 12 months, use all available data and supplement it with industry benchmarks or comparable business data where you can. The goal is to understand your typical cash conversion cycle: how long it takes from a sale being made to cash actually landing in your account.
For businesses that have gone through significant structural change, such as a major product shift, a new pricing model, or rapid headcount growth, older data may be less relevant. In those cases, weight your most recent six months more heavily and use older data to identify patterns rather than absolute numbers.
What’s the difference between a 13-week and a 12-month cashflow forecast?
A 13-week forecast covers the immediate quarter on a weekly basis, giving you a detailed, near-term view of cash movements. A 12-month forecast covers the full year on a monthly basis, providing strategic visibility over a longer horizon. Both are useful, but they serve different purposes and require different levels of data precision.
The 13-week forecast is the operational tool. It is most useful when cash is tight, when you are managing a fundraise or restructuring, or when you need to make near-term decisions about payments, collections, or drawdowns. Because the time horizon is short, the assumptions can be tighter and the data more reliable.
The 12-month forecast is the planning tool. It helps you model scenarios, assess whether your business plan is financially viable, and identify future periods where cash might come under pressure. The trade-off is accuracy: the further out you project, the more your forecast depends on assumptions rather than known data.
In practice, many businesses run both simultaneously. The 13-week forecast is updated weekly with actuals. The 12-month forecast is reviewed monthly and adjusted as the business environment changes.
What assumptions does a cashflow forecast rely on?
A cashflow forecast relies on assumptions about revenue timing, payment terms, cost levels, and business activity. The most critical assumptions are your debtor days (how long customers take to pay), your creditor days (how long you take to pay suppliers), and your revenue conversion rate from pipeline to invoice.
Other common assumptions include: staff cost changes from planned hiring or departures, expected tax payment dates, the timing of any capital expenditure, and whether any existing credit facilities will be drawn or repaid. Each of these has a direct impact on your projected cash balance.
The quality of your assumptions determines the quality of your forecast. Overly optimistic revenue timing is the most common source of forecast error. If your sales team consistently closes deals in the last week of the quarter but your forecast assumes even distribution across the month, your cash position will look better in the first three weeks than it actually is.
Document your assumptions explicitly. This makes it easier to identify which ones are driving the biggest variance when you compare forecast to actuals, and it builds accountability into the process.
How do you improve cashflow forecast accuracy over time?
You improve cashflow forecast accuracy by comparing your forecast to actuals every period, identifying the largest variances, and tracing them back to specific assumptions. This variance analysis is what turns forecasting from a one-time exercise into a continuously improving process.
Start by tracking your forecast versus actual cash position on a weekly or monthly basis, depending on your forecast horizon. When a significant variance appears, ask whether it came from a timing difference (the cash moved, just not when expected) or a volume difference (more or less cash than anticipated). These have different root causes and different fixes.
Timing variances often point to assumptions about payment terms that do not reflect actual customer or supplier behaviour. Adjusting your debtor days assumption to match real collection data can dramatically improve near-term accuracy. Volume variances often point to revenue assumptions that are too optimistic or cost estimates that do not account for variable spend.
Over time, the businesses with the most accurate forecasts are not those with the most sophisticated models. They are the ones that build a consistent review rhythm and treat variance analysis as a learning process rather than a blame exercise.
How Greyt helps with cashflow forecasting
Building and maintaining a reliable cashflow forecast takes more than a spreadsheet. It takes financial expertise, the right data discipline, and someone who can interpret what the numbers are telling you before it becomes urgent.
We work with growing businesses to build cashflow forecasting processes that are practical, accurate, and actually used in decision-making. Here is what that looks like in practice:
- Setting up the right data structure so your forecast draws from accurate, up-to-date sources
- Defining and documenting key assumptions so they can be challenged and refined over time
- Running regular variance analysis to identify where forecasts are drifting and why
- Providing strategic interpretation, not just numbers, so leadership can act on what the forecast shows
- Flexible engagement from a few days per month to more intensive support during critical periods
If your current cashflow visibility is not giving you the confidence to make fast decisions, we can help you fix that. Get in touch with us to talk through what better financial oversight could look like for your business.