How to create a financial forecast for your business

A financial forecast helps you plan income, costs, tax and cash flow so you can make confident decisions and keep your business on track over the next 12 months.

When you run a business, you’re making decisions every week that affect your income, your team and your future. A financial forecast helps you make those decisions with clarity.

It’s simply a forward-looking view of what you expect to happen in your business over the next 6 to 12 months. Done properly, it becomes a working tool you come back to regularly, not a spreadsheet you create once and forget.

If you already use management accounts to track performance month by month, a forecast is the natural next step. It takes what’s happened and projects what’s likely to happen next.

Let’s break it down.

Why you should have a financial forecast

A forecast gives you control. Many business owners look at the bank balance and assume that tells the full story. Cash in the bank matters but it doesn’t show future tax, large annual costs or income that hasn’t arrived yet.

Tracking your company’s financial health month to month already improves visibility. A forecast builds on that by looking ahead. A clear forecast helps you:

• plan for Corporation Tax and VAT before they’re due;

• decide whether you can afford a new hire;

• check if your current pricing supports your goals;

• plan consistent salary or dividends;

• understand whether your business can fund your long-term plans.

If you’re thinking about retirement or stepping back in the future, forecasting also feeds directly into that bigger picture.

• Step 1: Set up your forecast

  You don’t need complex software to build a useful forecast. A well-structured spreadsheet is more than enough to get started.

  Across the top, map out the next 12 months. Down the left-hand side, group your rows into clear sections so the flow makes sense, in this order:

  Income, broken down into the types of revenue you actually generate, such as retainers and project work.

  Direct costs so you can see gross profit clearly.

  Overheads, followed by a line for operating profit.

  Elements that often get missed: tax provisions, VAT payments, PAYE and National Insurance, along with your planned salary, dividends and pension contributions.

  Opening and closing bank balances each month.

  Create a simple cash flow section beneath your profit forecast. Adjust for payment delays from clients, VAT quarters, annual insurance renewals, and large one-off purchase

  Either next to these columns at the top of the sheet or on a separate tab, put your assumptions. This includes expected growth, known hires, price changes or cost increases.

  This way, when you review the forecast in three months’ time, you’ll remember what it was built on and make adjustments easily.

• Step 2: Decide the timeframe

  We recommend starting with a 12-month forecast. This is long enough to capture seasonality, annual renewals, tax payments and known projects.

  If you’re considering scaling the business, stepping back from day-to-day work or planning an eventual exit, modelling two years ahead gives you space to see how those decisions affect profit, drawings and long-term wealth.

• Step 3: Forecast your income

  While it’s tempting to be optimistic, base your financial forecast on evidence. Look at:

  • existing contracts or recurring revenue;

  • confirmed projects in your pipeline;

  • historic monthly averages;

  • seasonality patterns.

  If you’ve been reviewing your profit & loss report (P&L) regularly, you’ll already know your typical monthly turnover and margins.

  For service-based businesses, it often helps to split income by:

  • retainers;

  • one-off projects;

  • other income streams.

   This shows whether your forecast relies heavily on one client or one type of work. Be realistic. A conservative forecast you beat feels far better than one you constantly miss.

• Step 4: Forecast your direct costs

  Direct costs are those linked to delivering your service. This might include:

  • freelancers and subcontractors;

  • staff salaries directly tied to delivery;

  • software tied to projects;

  • materials.

  Review your historic gross margin from your P&L and sense-check whether it’s sustainable.

  If you’re planning growth, factor in increased delivery costs before the revenue fully lands.

• Step 5: Add your overheads

  Overheads are your fixed or semi-fixed running costs. Think:

  • rent or co-working;

  • core software;

  • insurance;

  • accountancy fees;

  • marketing;

  • admin salaries.

  These are easier to forecast because they’re usually consistent month to month. Include annual renewals and known one-off costs. Spread them monthly if that makes the forecast easier to read, but keep a note of when the cash actually leaves the bank.

• Step 6: Build in tax

  This is where many forecasts fall down. If you run a limited company, forecast:

  • Corporation Tax at the relevant rate;

  • VAT payments if you’re VAT registered;

  • PAYE and National Insurance if you employ staff.

  Tax isn’t optional and it isn’t flexible. Treat it as a normal outgoing in your forecast rather than something you’ll “deal with later”. This one change alone can transform your cash-flow stability.

• Step 7: Add drawings, dividends and pensions

  Your forecast should reflect how you plan to take money out. If you pay yourself a mix of salary and dividends, model both clearly. Dividends must be affordable based on retained profit, not just bank balance.

  If your company makes pension contributions for you, include those too. They’re part of the long-term plan and affect available profit. 

  This step connects your business forecast to your personal goals. It stops the business from funding today only and starts aligning it with your future.

• Step 8: Turn it into a cash-flow view

  This is where you’ll see pressure points before they arrive. Your forecast should show:

  • expected cash in;

  • expected cash out;

  • closing bank balance each month.

  If clients typically pay in 30 days, make sure your forecast reflects that delay. If VAT is quarterly, show the payment month clearly.

How to keep your forecast live

A forecast only works if you keep it up to date and accurate. Here’s a simple rhythm:

1. Review monthly

At the end of each month:

• compare actual results to forecast;

• update the next 11 months;

• adjust for new information.

If you already review management accounts monthly, add the forecast into that same meeting.

2. Treat it as a working document

Your forecast should evolve. New client signed? Update income. Cost increasing? Adjust margins. Planning a hire? Model the impact before committing.

3. Use it to make decisions

The purpose of a forecast is to help you make better decisions. If you see cash tightening in three months’ time, you can take action. For example:

• chase debtor days earlier;

• delay a discretionary cost;

• adjust drawings;

• increase pricing.

How forecasting links to bigger goals

Forecasting is the bridge between today’s trading and long-term financial freedom. When you can see projected profits, drawings and pension contributions clearly, you can model how close you are to your personal targets.

If you’d like help building a forecast that reflects your real numbers and supports both your business and personal goals, we can sit down together and model it properly. Once you see your numbers clearly, decisions feel calmer and far more deliberate.