Cash flow forecasting when your income is project-based, not recurring

For UK businesses with project-based revenue—like creative agencies, consultants, builders, and freelancers—cash flow forecasting can feel more like guesswork than science. Unlike companies with steady, recurring monthly income, your revenue arrives in large, irregular chunks. This makes traditional forecasting methods, which often rely on smooth, predictable sales cycles, feel completely inadequate, leaving you vulnerable to unexpected cash crunches even when your business is profitable on paper.

This guide provides practical, UK-specific techniques for forecasting your cash flow when your income is lumpy and project-driven. We'll move beyond simplistic models to build a robust forecast that gives you a true picture of the cash moving in and out of your business. You'll learn how to analyse your sales pipeline, account for invoicing milestones, and realistically predict when cash will actually land in your bank account, helping you make better decisions and reduce financial stress.

Why Standard Forecasting Fails for Project-Based Businesses

Most simple cash flow forecasts work by taking your average monthly income and subtracting your average monthly expenses. This is fine if you run a subscription business or a retail shop with consistent daily sales. But for a project-based business, this model is dangerously misleading.

The core problem is timing.

You might win a £50,000 project in March, but the work spans four months. You might invoice in stages: 25% upfront, 50% on a key deliverable, and 25% on completion. Add 30-day payment terms (which often stretch to 45 or 60 days in reality), and the cash from that March "win" might not fully arrive until August. Meanwhile, you have to pay salaries, rent, software subscriptions, and project-specific costs every single month.

A simple forecast sees "£50,000 income" and "£15,000 expenses" and shows a healthy profit. A cash flow forecast sees a huge outflow of cash for months before the corresponding inflow arrives, flagging a potential cash-flow crisis. For project-based work, a profitable business can easily run out of cash. That's why a more sophisticated approach is not a 'nice-to-have'—it's essential for survival.

The Building Blocks of a Realistic Forecast

A reliable forecast is built from the ground up. Instead of using broad averages, we need to get granular, starting with the most predictable figures and then layering on the more uncertain elements.

1. Start with Your Outgoings (The Knowns)

Your costs are the most predictable part of your forecast and provide a solid foundation. It's much easier to predict what you'll spend than what you'll earn. Start by listing all your expected cash outflows for the next 6-12 months.

Fixed Costs (Regular and Predictable):

• Salaries and Pensions: Include gross salaries, employer's National Insurance contributions, and pension contributions.
• Rent and Business Rates: Your monthly commercial lease payments.
• Software Subscriptions: Accounting software, project management tools, design software, etc.
• Utilities: Internet, phone, electricity (you can use historical averages).
• Insurance: Professional indemnity, public liability, etc. (often paid annually, so divide by 12 for a monthly view, but remember it's a single large cash outflow).
• Loan Repayments: Any business loans or financing.
• Accountancy Fees: Your monthly retainer or an estimate for quarterly/annual work.

Tax Payments (Crucial but Often Forgotten): These are significant, non-monthly cash outflows that can sink a business if not planned for.

• VAT: If you're VAT-registered, you'll have a large VAT bill due every quarter. This is a pure cash flow item—you collect it for HMRC and then pay it over. Your forecast must show the cash leaving your account in the month it's due.
• Corporation Tax: Due 9 months and 1 day after your company's year-end. This is a massive annual cash outflow that must be factored in.
• PAYE/NI: The tax and National Insurance deducted from employee salaries is paid to HMRC monthly or quarterly.

Variable & Project Costs (Less Predictable): These costs are tied directly to the work you're doing.

• Subcontractors & Freelancers: If you use external specialists, forecast their costs based on the project timelines.
• Materials & Supplies: For builders, designers, or makers, this is a major cost. Tie it to specific project milestones.
• Travel & Expenses: For client meetings or site visits.
• Advertising & Marketing Spend: This may fluctuate based on your pipeline.

By mapping out these costs first, you establish your monthly cash burn rate. This is the minimum amount of cash you need to bring in each month just to stand still.

2. Forecast Your Income (The Unknowns)

This is the most challenging part, but it's where you can move from guessing to making educated estimates. We’ll use a combination of confirmed work and a weighted pipeline.

Confirmed Work & Invoicing Milestones

Start with projects that are already signed and in progress. Do not forecast the total project value in a single month. Instead, break it down by invoicing milestones.

For a £20,000 web development project, the invoicing schedule might be:

• Month 1 (On Signing): £5,000 (25%)
• Month 2 (Wireframes Approved): £5,000 (25%)
• Month 3 (Development Complete): £10,000 (50%)

This gives you a much more accurate picture of when you can raise an invoice, which is the first step. The next, more critical step is forecasting when that invoice will actually be paid.

The Reality of Payment Terms vs. Debtor Days

Your invoice might say "Payment due in 30 days," but your real-world experience likely tells a different story. To create an accurate cash forecast, you need to use your average debtor days, not your stated payment terms.

• Payment Terms: The contractual period you give a client to pay (e.g., 30 days).
• Debtor Days: The average number of days it actually takes for your clients to pay you.

You can calculate a rough average of your debtor days with this formula: (Your Total Accounts Receivable / Your Annual Revenue) x 365

If your debtor days average is 47, then for forecasting purposes, you should assume cash from an invoice will arrive approximately 47 days after you issue it, not 30. This single adjustment will make your cash flow forecast dramatically more realistic. Improving this number—by having a clear, consistent, and automated invoice chasing process—is one of the fastest ways to improve your cash flow.

Using a Weighted Sales Pipeline

For work that isn't yet confirmed, you can use a weighted pipeline to forecast potential income. This involves assigning a probability of winning to each deal in your sales process.

First, define your sales stages. They might look something like this:

Sales Stage	Description	Probability of Winning
Lead / Enquiry	Initial contact has been made.	10%
Proposal Sent	A detailed proposal and quote has been delivered.	25%
Negotiation	Client is actively discussing terms and pricing.	60%
Verbally Agreed	Client has confirmed they want to proceed, awaiting contract.	90%
Contract Signed	The deal is won. The project moves to "Confirmed Work".	100%

Now, you can calculate the weighted value of your pipeline for any given month.

• You have a £15,000 project at the Proposal Sent stage (25% probability). Weighted value = £3,750.
• You have a £40,000 project in Negotiation (60% probability). Weighted value = £24,000.

Your total weighted pipeline forecast for that period is £27,750. This isn't the actual cash you'll receive, but it's a far more realistic estimate of future income than simply hoping for the best or assuming you'll win everything.

Putting It All Together: Your Rolling Cash Flow Forecast

Now you can combine your income and outflow forecasts into a single spreadsheet. This should be a rolling 12-month forecast that you update at least monthly.

Your spreadsheet should have months across the columns and these categories down the rows:

1. Opening Bank Balance (The closing balance from the previous month)
2. CASH IN
   • Payments from Confirmed Invoices (factoring in debtor days)
   • Weighted Pipeline Income (a conservative estimate)
   • Total Cash In
3. CASH OUT
   • Salaries & PAYE/NI
   • Rent & Rates
   • Software, Utilities, etc.
   • Project Costs (Subcontractors, Materials)
   • VAT Payment
   • Corporation Tax Payment
   • Total Cash Out
4. Net Cash Flow for Month (Total Cash In - Total Cash Out)
5. Closing Bank Balance (Opening Balance + Net Cash Flow)

The Closing Bank Balance is the most important number. This tells you your actual cash position at the end of each month. If you see this number turning negative in three months' time, you have an early warning to take action now.

Scenario Planning: Prepare for the Unexpected

The final layer of a powerful forecast is scenario planning. Because your income is lumpy, you need to understand how different outcomes could affect your cash position. Create three versions of your forecast:

1. The Most Likely Case: This is your main forecast, built using your confirmed work and weighted pipeline.
2. The Best Case: What happens if you win that big project you pitched for, and your biggest client pays 15 days early? This shows you your potential upside and helps you plan for growth.
3. The Worst Case: What happens if you lose that big project, and a key client payment is 60 days late? Does your closing balance go negative? If so, when?

This "worst case" forecast is your most valuable risk management tool. It's not about being pessimistic; it's about being prepared. If you know a cash crunch is possible in Month 4, you can:

• Aggressively chase all outstanding invoices.
• Secure an overdraft facility with your bank before you need it.
• Delay non-essential spending.
• Offer a small discount for early payment on a large upcoming invoice.

Without a forecast, these problems hit you as a surprise. With a forecast, you can manage them proactively. Automating parts of this process, for instance by using a tool like InvoiceReminder to ensure your payment collection is as prompt and predictable as possible, helps to stabilise the "cash in" side of your forecast and reduce the volatility of your worst-case scenarios.

Frequently Asked Questions

How far ahead should I forecast for a project-based business?

A good rule of thumb is to have a detailed, granular forecast for the next 3 months and a higher-level, more simplified forecast for the next 12 months. The 3-month view gives you an immediate operational guide, while the 12-month view helps with strategic planning, like hiring decisions or planning for major tax payments.

What's the difference between a cash flow forecast and a profit & loss report?

Profit is the difference between your revenues and your costs over a period (accrual accounting). Cash flow is the actual movement of money in and out of your bank account. A project-based business can be highly profitable on its P&L report but have negative cash flow because it has to pay staff and suppliers long before client payments arrive. Always manage your business by your cash flow forecast, not just your P&L.

How should I handle VAT in my cash flow forecast?

VAT is purely a cash flow item. When you invoice a client for £1,000 + VAT, you should forecast £1,200 as the cash in. However, that £200 is not your money. You are holding it for HMRC. In the month your VAT return is due, you must forecast a large cash out for the total amount owed. Forgetting to do this is one of the most common causes of unexpected cash shortages in VAT-registered businesses.

My sales are completely unpredictable. How can I possibly forecast income?

Even in a highly unpredictable business, you can create a useful forecast. Start with what you know: your fixed costs. This tells you your baseline cash burn. For income, be extremely conservative. Use your weighted pipeline with low probability percentages. If you have no pipeline, create a "worst case" income scenario based on the lowest sales month you've had in the last two years. This creates a survival budget and any income above that is a bonus. The goal isn't to be perfectly accurate, but to understand your risks.

What does "cash or accrual" mean for my forecast?

A cash flow forecast, by definition, must be done on a cash basis. This means you only record income when the money physically lands in your bank account, and you only record an expense when the money physically leaves it. Accrual accounting, which is what your P&L uses, records revenue when it's earned and expenses when they're incurred, regardless of when the cash moves. For managing your bank balance, only the cash basis matters.

Why do my 'debtor days' matter so much?

Debtor days measure the real-world delay between invoicing and getting paid. If your payment terms are 30 days but your debtor days are 55, it means you have to fund an extra 25 days of your company's entire operations for every project. Reducing your debtor days from 55 to 40 by improving your credit control process has the same effect as injecting a huge amount of cash into your business.

---

A robust cash flow forecast is your roadmap to navigating the highs and lows of project-based work. By moving beyond simple profit-and-loss thinking and focusing on the actual timing of cash movements, you can gain control over your finances and make decisions with confidence. While forecasting takes effort, a consistent and predictable invoicing and collections process is a critical part of the puzzle.

InvoiceReminder can help by automating the time-consuming work of chasing overdue invoices. By connecting to Xero, QuickBooks, FreeAgent or Sage, it sends scheduled email reminders to your clients based on rules you set, helping to reduce your average debtor days and make your cash inflow more predictable. For UK small businesses, freelancers and accountancy practices looking to stop chasing by hand, the Free plan currently includes unlimited email reminders at no cost. InvoiceReminder is built by the team behind WeCovr, a UK company authorised and regulated by the Financial Conduct Authority in its capacity arranging over a million insurance policies.