← All AI ROI products
Founder pricing
AI product · Profit and cash

Rolling Forecast and Monthly Pack

From your monthly management accounts: every profit and loss line forecast for the next 12 months by a driver you can explain, the year end against budget and your profit target, the variances that matter with a reason for each, and a one-page monthly pack.

About 3–5 hours to set up, then an hour a month (estimate)Your management accounts from Xero, Sage or QuickBooksRun it yourself or with Geoff
What it answers

Four questions it answers

  1. 1

    Where will the year end?Actuals to date plus a line-by-line forecast.

  2. 2

    What will the next 12 months look like?A forecast that rolls on every month.

  3. 3

    What moved this month, and why?Variances flagged at your materiality, with reasons.

  4. 4

    Can we trust the forecast?Past forecasts against what happened.

Choose this when you get monthly management accounts but your only forward view is a budget set months ago. For the bank balance week by week, see the 13-Week Cash Flow Forecast; for orders from the pipeline, the Sales Forecast and Pipeline Review.

Founder pricing. The method, the calculation spreadsheet with 26 built-in checks, and a complete worked example are built and tested. The first client for this product gets the founder price, in return for permission to measure the results and, if they are good, write them up as a case study. After that, the price goes up. Book a call to take the founder place.

What you get

What you get

A rolling 12-month forecast and a one-page pack

Every line by run rate, last year, a fixed amount or a share of sales, with a one-page monthly pack of the key figures you choose.

The year end

Against your budget and profit target, and what closing the gap needs.

One-offs handled

Taken out of the base, and known changes added.

Variances that matter

Against a flexed budget, flagged at your materiality, each with a reason.

A spreadsheet you can check

Reconciled to your accounts, with 26 built-in checks.

A monthly agent in your own accounts

With guided or done for you, the forecast rolls on each month in your own accounts against the target you set, and you are told what moved the year end. Nothing leaves your business, and no decision changes, without one of your people approving it.

Worked example

An industrial distributor's year end

A fictional 38-person industrial supplies distributor set a budget of £465,930 EBITDA in March. Six months in, it was £65,560 behind for the year to date, after a pay rise, an extra van and a bad debt.

Forecasting each line from its own driver, with a lost customer and a January price rise entered, put the year end at £293,684: £156,316 short of the £450,000 target, and £58,316 lower than last month's forecast.

Read the full example

Kestwick Industrial Supplies LtdFictional · Worked example
Budgetfull-year EBITDA
£465,930
Forecastfull-year EBITDA
£293,684
Short of target
£156,316
Year to datebehind budget
£65,560
IllustrativeAll names and figures are invented.
How it works

Five stages

  1. Load

    Your monthly profit and loss and the budget.

  2. Drive

    A driver and a reason for every line.

  3. Explain

    The variances above your materiality.

  4. Roll

    On a month, every month.

  5. Keep

    Each month the agent rolls the forecast on in your own accounts and names what moved the year end, so a shortfall is seen while there is time to act.

Three ways to buy

Do it yourself, with Geoff, or done for you

The same method and the same spreadsheet in every option. You choose how much of your own time goes in.

Self-implement kit

Run it yourself

For owners comfortable with a spreadsheet and an AI assistant.

  • The AI skill
  • The calculation spreadsheet
  • A worked example
  • The buyer's guide
Book a call
Guided implementation

Run it with Geoff

For owners who want a second pair of eyes on the data and the analysis.

  • Everything in the kit
  • A working session with Geoff to set the drivers
  • Your first monthly pack, reviewed
  • A review after three months of track record
  • The monthly agent, set up with you in your own accounts
Book a call
Done for you

Geoff runs it

For owners who would rather hand over the data and get the answer.

  • Geoff builds the forecast in your own systems, from your accounts
  • Sets the drivers and one-offs with you
  • The agent's first three monthly roll-forwards in your account, each pack reviewed with you
  • Hands over the monthly routine
Book a call
What you'll need

Data you already have

  • 12 to 24 months of monthly management accounts
  • This year's budget, if you have one
  • Known changes: contracts, prices, hires
  • About 3–5 hours to set up (estimate)
  • For the monthly agent (guided and done for you): an AI assistant your business already uses or approves, that can run a scheduled task and connect read-only to your accounting system; we confirm this with your IT before you commit
Which AI?

Designed for Claude, in an open format

It is built on the open Agent Skills standard and designed for Claude (any plan, with code execution switched on). A paste-in version is included for ChatGPT, Gemini and Microsoft Copilot; it has not yet been tested on them.

The calculations live in the spreadsheet, not in the AI, so the numbers don't depend on which assistant reads them.

See the year end while there's time to change it

Book a short call to talk it through.

Book a call
Geoff@fox.coach · 07770 683883 · fox.coach