In 12+ years of working with UK founders, I have sat across the table from hundreds of business owners who were genuinely confused about why they were struggling financially. Many of them were profitable on paper. They had customers, they were making sales, and their margins looked reasonable. But they were constantly stressed about money, constantly chasing their bank balance, and in some cases, on the edge of collapse.
The answer, almost without exception, was the same: they had no cash flow forecast, or the one they had was so optimistic as to be functionally useless.
Here is the uncomfortable truth that most business guides soft-pedal: cash flow kills more businesses than poor sales, bad products, or weak strategy combined. According to research from GBAF and Novuna, 82% of businesses that fail do so because of cash flow problems [1]. Not because they had a bad idea. Not because the market wasn’t there. Because they ran out of money — often while technically turning a profit.
A cash flow forecast does not prevent this from happening automatically. But it gives you the early warning system to see a cash crisis approaching with enough runway to do something about it. That is the only reason you need to take this seriously.
This guide will walk you through exactly how to prepare a cash flow forecast — whether you are building one for a bank loan application, a Start Up Loans submission, or simply to understand the financial reality of your business. I will cover the direct method (which most startups should use) and the indirect method (which applies once you have a trading P&L to work from), along with the common mistakes that turn a potentially useful document into an expensive fiction.
What a Cash Flow Forecast Actually Is (and What It Isn’t)
A cash flow forecast is a month-by-month projection of the money flowing into and out of your bank account. It is not a profit and loss statement. It is not a balance sheet. It specifically tracks when cash arrives and when it leaves, because timing is everything.
This distinction matters more than most founders realise. I regularly work with clients whose P&L shows healthy profit but whose bank account shows something very different. A client of mine — a Bristol-based events company — was generating strong revenue and appeared profitable on the P&L. But they invoiced clients on 60-day terms while paying their suppliers and venue deposits upfront. The gap between paying out and receiving payment meant that at any point in the year, they had substantial “profit” tied up in unpaid invoices while their bank account was running on empty. Three months before I started working with them, they had almost missed payroll.
That gap between profit and cash is exactly what a forecast captures. It forces you to think not just about whether money will come in, but when it will arrive relative to when you need to pay your bills.
Why Lenders Require It
If you are applying for a Start Up Loan through the British Business Bank (loans of up to £25,000 at a fixed 6% rate), the cash flow forecast is one of the two non-negotiable documents in your application alongside your business plan [2]. The assessment panel uses it to judge whether your business will generate enough cash to service the loan repayments — not whether it might be profitable in theory, but whether real money will actually flow through the business in the right amounts at the right times.
The same is true of bank lending, commercial finance, and most investor due diligence. Sophisticated funders read cash flow forecasts as a window into how well a founder understands their own business. Unrealistic assumptions, ignored costs, and wishful revenue projections are visible immediately to anyone who reviews these documents regularly. I have seen otherwise strong applications fail because the cash flow forecast revealed that the founder had not thought through their payment cycles, their VAT obligations, or the real timing of their revenue.
Get it right, and it tells a compelling story of business viability. Get it wrong, and it undermines everything else in your application.
The Direct Method: The Right Approach for Most Startups
For the majority of startups and early-stage businesses, the direct method is the correct approach. It is simpler, more intuitive, and does not require a profit and loss statement to produce. You are simply forecasting your bank account: what comes in, what goes out, and what you have left at the end of each month.
Step 1: Set Up Your Time Horizon
For a Start Up Loan application, you need a minimum of 12 months. For most business plan purposes, 24 months is standard — the first year in monthly detail, the second year sometimes in quarterly blocks once you reach year two. For internal management purposes, a rolling 13-week (weekly) forecast alongside a monthly view gives you the visibility to make good decisions.
Set up a simple spreadsheet with months along the top (columns) and income and expenditure categories down the left (rows). The final rows should calculate your net monthly movement (receipts minus payments) and your closing bank balance for each month, which becomes the opening balance for the following month.
Step 2: Forecast Your Cash Receipts
This is where most founders either get it right or create a document that actively misrepresents their business. The discipline required is to forecast when cash actually arrives in your bank account — not when you invoice, not when a sale is agreed, but when the money lands.
How payment timing works by business type:
Service businesses invoicing on terms: If you invoice on 30-day terms, a January sale creates a February cash receipt. If your customers routinely pay late (and in 2025, 90% of UK businesses experience late payments, with the average delay sitting at 32 days beyond invoice date [3]), then you should build this into your assumptions rather than assuming prompt payment that experience suggests will not materialise.
Product businesses: Card payments typically clear within 1-7 days. Cash sales are immediate. If you sell through distributors or larger retailers, their payment terms may be 60-90 days — which dramatically affects your cash position relative to when you incur production costs.
Subscription businesses: Recurring monthly payments provide the most predictable cash flow and should be modelled as such, with churn assumptions built in from month three or four onward.
Building a realistic revenue forecast:
The sales numbers in your cash flow forecast need to be defensible. “We think we will sell X” is not sufficient for a lender, and it is not sufficient for your own planning purposes either.
Depending on your business model, work backwards from the metrics that drive revenue. For an online business, this means forecasting website visitors, conversion rate, and average order value — then building in a realistic ramp-up time for traffic to develop. For a service business, it means being specific about the number of clients you can realistically serve, your pricing, and a credible timeline for signing initial contracts.
I work with clients to develop what I call a conservative case and a base case — never an optimistic case for loan applications, because an experienced assessor will immediately question numbers that assume everything goes well from day one. The conservative case assumes a slower start than you hope for, clients who take longer to commit, and some months with lower revenue than planned. If your business is viable under conservative assumptions, it is genuinely viable.
A common mistake to avoid: Do not include funding as revenue. If you are applying for a Start Up Loan and that loan will be an inflow to your business, include it in your cash flow as a financing receipt, clearly labelled. It is not turnover, and treating it as revenue distorts every subsequent calculation.
Step 3: Forecast Your Cash Payments
This section needs to be comprehensive. Every cash payment your business will make — not expenses in an accounting sense, but money actually leaving your bank account — belongs here.
Startup costs (one-off, pre-trading payments): Equipment, fit-out, initial stock, website build, professional fees (legal, accountancy), initial marketing spend. These often hit in month one or two and are the reason many businesses run into cash trouble before they have generated any revenue.
Cost of sales (variable costs linked to each sale): The direct costs you incur to deliver what you sell — materials, direct labour for each job, packaging, payment processing fees. These should move in proportion to your revenue assumptions and should appear in the month you actually pay for them, not necessarily when the associated sale is made.
Fixed operating costs: Rent and business rates, utilities, insurance, subscriptions, and minimum staff costs (including your own drawings if you are paying yourself). These apply every month regardless of trading performance. Be thorough — work through your bank statements if you have them, or build the list from scratch for a pre-trading business, and do not underestimate.
Staff costs: Include employer’s National Insurance contributions (currently 15% on earnings above the secondary threshold from April 2025) and any employer pension contributions on top of salary costs. Many first-time business owners forget these on-costs, which can add 20-25% to base salary costs.
VAT: If your business will be VAT-registered (compulsory once turnover exceeds the current threshold of £90,000, but often worth registering voluntarily from the start), VAT needs to be included in your cash flow. You collect VAT from customers on sales and pay VAT to suppliers on purchases. The net amount is paid to HMRC quarterly. This means you will have VAT payments in months 3, 6, 9, and 12, which can be a significant cash outflow if you have not planned for them. On the positive side, if you are incurring significant startup costs, you may be due a VAT refund in early quarters.
Corporation tax and income tax: For limited companies, corporation tax is due nine months and one day after your accounting year end. For sole traders and partnerships, income tax is paid in January and July under the self-assessment system. Neither of these follows the month you earned the profit, so they need to appear in your forecast in the correct months based on when the payments are actually due.
Loan repayments and interest: If you are including a Start Up Loan in your forecast, the monthly repayments (capital and interest) need to appear as a cash payment from the month the loan commences.
Seasonality: Does your business have seasonal peaks and troughs? A retail business will generate a disproportionate share of annual revenue in November and December. A summer-focused hospitality business may earn 60-70% of its annual revenue across five months. Build these patterns into both your receipts and your costs — and ensure you have sufficient cash to survive the quiet months.
Step 4: Calculate Your Net Position and Running Balance
For each month, subtract total cash payments from total cash receipts. This gives you the net cash movement for the month — positive means you ended the month with more cash than you started with; negative means you spent more than you received.
Add the net monthly movement to the opening bank balance to give your closing balance for that month. This closing balance becomes the opening balance for the next month.
The closing balance line is the most important row in your forecast. It tells you at a glance whether you will have enough money in the bank to cover your commitments each month. A negative closing balance means you will be unable to pay your bills — which may trigger a need for additional funding, an overdraft facility, or operational changes (accelerating receivables, delaying non-essential payments).
Interpreting what you see: A forecast that shows consistently growing closing balances month on month does not automatically mean a healthy business — check that the trajectory is driven by genuine trading activity rather than loans, deferred payments, or aggressive revenue assumptions. A forecast that shows a consistently negative or declining closing balance is a clear warning sign that needs addressing before you launch, not after.
The Indirect Method: For Businesses with an Existing P&L
Once your business is trading and you are producing a profit and loss account (P&L), the indirect method allows you to derive your cash flow forecast from your P&L by adjusting for the timing differences between when income and costs appear in the P&L and when the associated cash actually moves.
This method is more technical. It is what accountants use for formal financial statements, and for most founders reading this, it is worth understanding conceptually without getting lost in the details. If you have an accountant, this is exactly the kind of adjustment they should be helping you with.
The key adjustments are as follows:
Days Sales Outstanding (DSO): How many days, on average, does it take your customers to pay you from the invoice date? If your DSO is 45 days, then sales shown in month one on the P&L will appear as cash in month two (roughly). Extending DSO — because customers are paying more slowly — means your cash position deteriorates even while your reported sales remain strong. This is exactly what happened to my Bristol events client: their DSO was increasing silently while their P&L looked fine.
You can calculate your current DSO simply: divide your accounts receivable balance by your average daily sales (annual sales divided by 365). A DSO of 30 days or under is healthy for most businesses. Above 60 days, and you have a structural cash flow challenge that needs active management.
Days Payable Outstanding (DPO): The flip side of DSO. How long are you taking to pay your own suppliers? Extending DPO — paying your suppliers more slowly — improves your short-term cash position but can damage supplier relationships and may breach agreed-upon payment terms. The optimal approach is to negotiate the longest payment terms you reasonably can at the start of supplier relationships, rather than simply paying late.
Prepayments and accruals: The P&L includes costs in the period they are incurred, not necessarily when you pay for them. An annual insurance premium paid in January appears as one month of insurance cost in each month’s P&L but as a single cash payment in January. Conversely, if you have used a service but not yet been invoiced (an accrual), the P&L shows the cost but no cash has yet left your account. These timing differences—prepayments and accruals—require adjustment when converting the P&L to cash flow.
Capital expenditure: When you buy a significant asset — equipment, vehicles, or fit-out costs — the P&L spreads the cost over the asset’s useful life through depreciation. Your cash flow shows the full payment in the month you actually pay for it. Always include planned capital expenditure in your cash flow for the month of purchase, and always subtract depreciation (a non-cash P&L charge) when reconciling P&L to cash flow.
VAT: Your P&L is always prepared excluding VAT. Your cash flow must include VAT on receipts and payments, with the quarterly net settlement to HMRC captured accurately.
The practical steps to build the indirect method forecast are:
- Start with your net profit from the P&L
- Add back depreciation (non-cash charge)
- Adjust sales for the timing of customer payments (DSO adjustment)
- Adjust costs for the timing of supplier payments (DPO adjustment)
- Account for prepayments and accruals
- Add VAT on receipts and deduct VAT on payments, and include quarterly HMRC settlement
- Add any capital expenditure payments (not shown in P&L at cost)
- Add or subtract any financing movements (loan drawdowns or repayments)
The Five Most Common Cash Flow Forecast Mistakes I See
After reviewing hundreds of cash flow forecasts as part of our business plan work at SGI, we have seen the same errors repeatedly. These are not complex mistakes — they are predictable ones that undermine otherwise credible forecasts.
Mistake 1: Assuming immediate revenue from day one. Almost no business generates significant revenue in its first month of trading. There is setup time, marketing lag, sales cycle lead time, and the simple reality that it takes time to build a customer base. A realistic forecast shows a ramp-up period of two to four months before revenue reaches anything like its intended run rate. Forecasts that show strong sales from month one are a red flag to any experienced reviewer.
Mistake 2: Forgetting startup costs. The costs incurred before you start trading — registering the business, building the website, fitting out premises, buying initial stock or equipment, professional fees — are often overlooked or underestimated. I had a client who had carefully forecast all their monthly operating costs but had not included the £8,000 of pre-trading costs in their forecast. This created an instant cash deficit that they had not planned for and had no facility to cover.
Mistake 3: Ignoring the timing gap between invoice and payment. This is the most common error for service businesses. If you invoice on 30-day terms and your customers pay on time, January’s sales become February’s cash. If your customers habitually pay late (and, in 2025, over 62% of SME invoices are paid late [4]), that timing gap is even greater. A forecast that treats sales and cash receipts as the same thing in the same month is not a cash flow forecast — it is a P&L dressed up as one.
Mistake 4: Underestimating fixed costs. Founders consistently underestimate the cost of operating their business each month. This is partly optimism and partly inexperience. The discipline of building costs line by line — including employer National Insurance, pension contributions, insurance, subscriptions, accountancy fees, and a contingency buffer for unexpected expenses — almost always reveals a higher cost base than the initial estimate.
Mistake 5: Building only one scenario. A single forecast that represents your “expected” outcome is less useful than three scenarios: conservative, base case, and growth case. The conservative case shows whether your business can survive a slower-than-hoped start. The growth case shows how your cash requirements change as you scale. Lenders appreciate scenario analysis because it demonstrates that you have thought rigorously about risk, not just assumed success.
Practical Tips for Building a Forecast That Holds Up to Scrutiny
After working on hundreds of these documents, here is what separates a cash flow forecast that a lender or investor finds credible from one that raises questions:
Tie every assumption to evidence. Every revenue line should have an explanation: “Based on our average order value of £X, targeting Y customers in month one, ramping to Z by month six based on confirmed pipeline and comparable business launch data.” Every cost line should have a source. Where you are estimating, say so and explain your reasoning.
Be conservative on income, realistic on costs. The asymmetry is deliberate. If you underestimate income, you raise less than you might need but remain solvent. If you underestimate costs, you run out of money. I always tell clients: the lender is hoping you are right about the income; they are relying on you being right about the costs.
Include a contingency line. I recommend building in a minimum 10% contingency on your total expenditure forecast, explicitly labelled. This signals to reviewers that you understand businesses do not run exactly to plan, and it provides a genuine buffer when unexpected costs arise.
Keep it up to date. A cash flow forecast prepared in January and filed in a drawer is worth nothing by March. The most valuable use of this document is as a live management tool — update actuals each month, reforecast the remaining period, and understand why your actual cash position varies from your forecast. The variance analysis is where the management insight lives.
Use the right tool. For most startups, a well-structured Excel or Google Sheets model is perfectly adequate. The Start Up Loans Company provides a free template on their website. More sophisticated businesses use dedicated cash flow software such as Float (which integrates with Xero and QuickBooks), Fluidly, or Futrli. The tool matters less than the discipline of using it consistently.
A Note on the Personal Survival Budget
For Start Up Loan applications specifically, the cash flow forecast is assessed alongside a personal survival budget — a separate document that shows the assessor what you personally need to draw from the business each month to cover your living costs, and demonstrates that the business can fund this without compromising its cash position.
This is not a formality. Assessors will check that your drawings are included in your cash flow forecast, and that the business generates sufficient cash to cover both its operating costs and your personal income requirements. If the numbers only work because you have assumed you will not pay yourself anything for two years, that is a concern both for the assessor and for your own sustainability.
Be honest in this document. Understating your personal costs to make the business look more cash-generative will only create problems for you later when the gap between what you projected and what you actually need becomes apparent.
Your Cash Flow Forecast Implementation Checklist
Before you finalise your forecast, work through these checks:
Structure and completeness
- Monthly columns covering a minimum 12 months (24 months for most applications)
- Opening balance established and clearly stated
- All categories of cash receipts included (sales by type, loan drawdowns, VAT refunds)
- All categories of cash payment included (startup costs, COGS, overheads, VAT payments, tax, loan repayments)
- Net monthly movement calculated for each month
- Closing balance calculated and carried forward as next month’s opening balance
Assumptions
- Revenue ramp-up period included (not full revenue from month one)
- Payment timing adjusted for your specific business model (not sales = cash in the same month)
- Late payment buffer included in receivables timing
- Seasonality reflected where applicable
- All pre-trading/startup costs captured
- Staff costs include employer NI and pension contributions
- VAT is included in receipts and payments, with quarterly settlement shown
- Tax payments (corporation tax or self-assessment) in the correct months
- Capital expenditure is shown in full in the month of purchase
- Contingency line included (minimum 10% of total costs)
Credibility checks
- Conservative case and base case scenarios prepared
- All major assumptions documented and defensible
- No months showing a negative closing balance without a plan to address
- Personal survival budget prepared and consistent with cash flow
- The document has been reviewed by someone else before submission
Conclusion
A cash flow forecast is not a bureaucratic requirement invented by lenders to make your life difficult. It is the most useful financial tool available to an early-stage business because it forces you to confront the timing reality of your finances before that reality confronts you.
The businesses that manage cash well are not necessarily the ones with the best products or the most talented founders. They are the ones that know, three months in advance, that a shortfall is coming — and have the time to act. That might mean accelerating a sales campaign, negotiating extended payment terms with a supplier, arranging an overdraft facility, or simply delaying a discretionary purchase. All of those responses are available when you have visibility. None of them are available when the problem is already at your door.
Build your forecast before you launch. Update it every month without exception. And treat the variance between forecast and actual not as a failure but as the most valuable management information your business generates.
If you would like help preparing a cash flow forecast as part of your business plan — whether for a Start Up Loan application, investor presentation, or internal management planning — SGI Consultants works with UK founders at every stage of business development. We have helped secure over £250m in business funding, and the quality of the financial modelling in our clients’ plans is a consistent factor in their success.
Get Help With Your Cash Flow Forecast
You can also download our free Business Plan Template, which includes a cash flow forecast template, from our resources page.
Download the Free Business Plan Template
Frequently Asked Questions
How far ahead should a cash flow forecast go?
For a Start Up Loan application, 12 months is the minimum. For most business plan purposes, 24 months is standard. For day-to-day management, a rolling 13-week forecast, alongside monthly projections, provides the best visibility for operational decision-making. The further ahead you forecast, the less precise the numbers will be — which is fine, provided you update the forecast regularly as your actual position becomes clearer.
What is the difference between a cash flow forecast and a profit and loss forecast?
A P&L shows income and costs in the period they are earned or incurred, regardless of when cash changes hands. A cash flow forecast shows when money actually enters and leaves your bank account. A profitable business can and does run into cash flow problems because of timing differences — especially if it invoices customers on credit terms while paying suppliers upfront. Both documents are important for a complete financial picture; the cash flow forecast is the one that tells you whether you can pay your bills.
Do I need an accountant to prepare a cash flow forecast?
Not necessarily, especially for a direct method forecast for an early-stage business. The free templates from the Start Up Loans Company and basic spreadsheet skills are sufficient for most startup applications. Where accountant input adds value is in more complex businesses, businesses with significant capital expenditure or financing structures, or when you need to derive a cash flow from an existing P&L using the indirect method. At a minimum, have your forecast reviewed by someone with financial experience before submitting it to a lender.
What if my cash flow forecast shows a negative balance in some months?
A negative closing balance means you will not have enough cash to cover your commitments in that month. This is a problem that needs a solution, not a figure to be hidden. Solutions might include: increasing your requested loan or overdraft facility to cover the gap, delaying a capital purchase, accelerating your sales effort in prior months, adjusting payment terms, or reconsidering the timing of the business launch. A lender who sees a negative balance in your forecast will ask how you plan to address it — have a clear answer prepared.
Should I include VAT in my cash flow forecast?
Yes. If your business is VAT-registered (or will be), your cash flow forecast should include VAT on receipts and payments, with the quarterly net settlement to HMRC shown as a separate line. Your P&L should exclude VAT, but your cash flow must include it because it directly affects the money in your bank account.
What is a personal survival budget, and do I need one?
A personal survival budget is a document that shows your monthly income requirements — what you need to draw from your business or earn elsewhere to cover your living expenses. It is required for a Start Up Loan application and is used alongside the cash flow forecast to assess affordability. Even where it is not formally required, preparing one is good practice because it ensures your business plan includes realistic drawings for your own income rather than the common error of planning as if you will work for free indefinitely.
References
[1] GBAF / Novuna Business Cash Flow, ‘One in Three SME Leaders Do Not Fully Understand Cash Flow Despite 82% Facing Cash Flow Problems’, December 2025. Available at: globalbankingandfinance.com
[2] British Business Bank / Start Up Loans, ‘What is a Start Up Loan’, 2025. Available at: startuploans.co.uk
[3] Coface, ‘2025 UK Payment Survey: Companies Face Rising Payment Delays Amid Buyer Cash Flow Concerns’, 2025. Available at: coface.com
[4] FreeAgent / Financial IT, ‘SME Cash Flow Crisis: Nearly Two-Thirds of Invoices Paid Late Across the UK’, 2025. Available at: financialit.net
[5] QuickBooks UK, ‘2025 UK Small Business Late Payments Report’, November 2024. Available at: quickbooks.intuit.com
[6] UK Money / ONS, ‘How Many New Businesses Fail in the UK’, 2025. Available at: ukmoney.net
Related Posts
Kurt Graver is the founder and CEO of SGI Consultants, a business consultancy that has helped over 2,000 entrepreneurs establish successful startups using systematic business development methodologies. An accountant with an MBA and 25 years of commerce and consultancy experience, Kurt specialises in strategic planning, market analysis, and sustainable business growth