Rolling Forecast and Monthly Pack · September 2026

Kestwick Industrial Supplies Ltd

Distributor of fasteners, PPE, tools and maintenance supplies to manufacturers and trade customers across Yorkshire, with a web shop. 38 staff.

Worked example. Kestwick Industrial Supplies and its figures are fictional. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 2 notes).
The headline

The budget said £465,930; the rolling forecast says £293,684

Full-year EBITDA forecast
£293,684
against a £450,000 target and a £465,930 budget
Short of target
£156,316
£45,985 a month needed against £19,932 forecast, for 6 months
Year to date
£174,090
£65,560 behind budget after 6 months
Since last month
−£58,316
change in the year-end forecast

Verdict: Month 6 of 12 (September 2026): EBITDA for the year to date is £174,090, £65,560 behind budget. The full-year forecast is £293,684 against a target of £450,000 and a budget of £465,930: £156,316 short of target. To reach it: £45,985 a month needed against £19,932 forecast, for 6 months. The line moving profit most: Sales: account customers (-£262,738 for the full year against budget). Variances that matter (year to date against budget): 1. Sales: account customers -£68,300; 2. Cost of goods sold -£15,113; 3. Other overheads -£12,010. The year-end forecast has fallen 5 months running. 1 of the next 12 months is forecast to make a loss, covered by the months before.

This financial year

EBITDA by month: actual to September, then the forecast

Apr£29kMay£33kJun£35kJul£53kAug−£5kSep£29kOct£44kNov£21kDec−£23kJan£16kFeb£18kMar£43k

Actual Forecast · dashed line: budget for the month. December and August are the seasonal dips; the forecast months lose the packaging customer from November and gain the price rise from January.

The monthly pack

September 2026: month 6 of the financial year Apr 2026 to Mar 2027

Key figureActualBudgetSame time last yearAgainst budget
Sales year to date£3,816,100£3,878,300£3,634,000Worse
Gross margin % year to date31.2%31.6%31.4%Worse
Overheads this month£177,640£164,360£155,510Worse
EBITDA year to date£174,090£239,650£209,070Worse
Year-end EBITDA forecast£293,684£465,930£400,190Worse
Gap to profit target-£156,316––Short of target
Cash at bank£412,000––
Debtor days41 days––
Profit and lossThis monthBudgetBetter or worseYear to dateBudgetBetter or worseFull-year forecastFull-year budget
Sales£670,700£692,600−£21,900£3,816,100£3,878,300−£62,200£7,484,582£7,750,600
Gross profit£206,290£218,860−£12,570£1,189,280£1,225,550−£36,270£2,330,178£2,449,200
Gross margin30.8%31.6%-0.8 pts31.2%31.6%-0.4 pts31.1%31.6%
Overheads less other income£177,640£164,360−£13,280£1,015,190£985,900−£29,290£2,036,494£1,983,270
EBITDA£28,650£54,500−£25,850£174,090£239,650−£65,560£293,684£465,930
Variances

7 lines flagged at £10,000 or 10%; 0 comparisons without a reason

LineThis month v budgetYear to date v budgetThis month v last forecastYear to date v last yearReasons
Sales: account customers−£25,100−£68,300£12,200£132,300Budget: Volume below budget; the July clearance order flatters the year to date
Last forecast: Two large orders came in earlier than expected
Last year: Price and volume growth, plus the July clearance order
Sales: web shop£3,200£6,100£1,500£49,800Last year: Web shop growing about 12% a year
Cost of goods sold
flexed budget
−£5,244−£15,113−£11,260−£129,340Budget: Margin below budget: supplier price rises not yet passed on
Last forecast: Follows the higher sales
Last year: Follows the higher sales
Wages and employer costs−£1,760−£3,760−£760−£43,930Last year: April pay rise and National Insurance
Vehicles and fuel−£1,080−£7,170£120−£9,580Budget: Extra van leased in April, not in the budget
Last year: Extra van leased in April
Marketing−£11,500−£8,420−£12,100−£11,750Budget: Regional trade show in September
Last forecast: Trade show not in last month's forecast
Last year: Regional trade show in September
Other overheads£850−£12,010£650−£12,270Budget: Bad debt written off in August
Last year: Bad debt written off in August

+ is better for profit. The three that matter, year to date against budget: 1. Sales: account customers -£68,300; 2. Cost of goods sold -£15,113; 3. Other overheads -£12,010. The line moving profit most for the year: Sales: account customers (-£262,738 for the full year against budget).

How each line is forecast

5 run rate, 3 last year × growth, 2 fixed, 2 % of sales

LineDriverValueWhy
Sales: account customersLast year × growth+2%Volume up about 2% on last year over the last six months, before the price rise
Sales: web shopLast year × growth+12%Web shop growing about 12% a year
Cost of goods sold% of sales67.0%Average of the last six months
Carriage out% of sales1.9%Steady at about 1.9% of sales
Wages and employer costsRun rate£111,010 a monthApril pay rise already in the last three months
Rent and ratesFixed amount£19,200 a monthLease and business rates for the year
Heat and powerLast year × growth+5%Seasonal; tariff up about 5%
Vehicles and fuelRun rate£10,047 a monthIncludes the extra van leased in April
IT and softwareRun rate£4,770 a month
MarketingRun rate£3,427 a monthSeptember trade show entered as a one-off
InsuranceFixed amount£2,950 a monthAnnual premium spread monthly
Other overheadsRun rate£10,837 a monthAugust includes a bad debt, entered as a one-off
MonthLineAmountAppliesWhat it is
Jul 2026Sales: account customers£55,000that month onlyPast Clearance order from a customer closing a site
Aug 2026Other overheads£14,000that month onlyPast Bad debt written off
Sep 2026Marketing£12,100that month onlyPast Regional trade show: the cost above a normal month
Nov 2026Sales: account customers−£25,000every month from thenForecast Packaging customer lost to a competitor from November
Nov 2026Wages and employer costs£3,300every month from thenForecast Internal sales hire from November
Jan 2027Sales: account customers£21,000every month from thenForecast 4% price rise on account customers from 1 January
Apr 2027Wages and employer costs£4,500every month from thenForecast April 2027 pay review (National Living Wage and pay rise)

One-offs are entered as the amount above or below a normal month: the September trade show cost £12,100 more than marketing's usual £3,400, so that is what comes out of the run rate. Cost of goods sold follows all sales; a business whose channels earn different margins would give each its own cost line.

Track record

Past forecasts missed sales by 3.4% on average

MonthSales forecastActual salesMissEBITDA forecastActual EBITDAYear-end forecast then
May 2026£640,000£628,700+1.8%£36,000£33,330£455,000
Jun 2026£652,000£649,100+0.4%£37,500£34,910£440,000
Jul 2026£655,000£698,600-6.2%£38,000£53,080£410,000
Aug 2026£590,000£553,800+6.5%£12,000−£4,920£385,000
Sep 2026£657,000£670,700-2.0%£39,150£28,650£352,000

The year-end forecast has fallen 5 months running: Apr £455,000 → May £440,000 → Jun £410,000 → Jul £385,000 → Aug £352,000 → now £293,684. The pay rise, the extra van and the lost packaging customer arrived one at a time; a budget set once in March couldn't show that, and the NOTE asks which driver keeps being cut.

How confident are we?

What this rests on

Actuals are the management accounts for 18 months to September 2026, checked against the accounts’ year-to-date totals. Each line is forecast by its driver (5 run rate, 3 last year × growth, 2 fixed, 2 % of sales): run rates are the last three months less one-offs entered; last year’s months have past one-offs taken out; growth rates, fixed amounts and % of sales are your own assumptions, with 4 known change(s) added. Lines that follow sales are compared with a flexed budget (the budget’s share of actual sales). The materiality, unusual-month, margin, best-month and cash thresholds are assumed. Leases: rent as an expense (old basis). It forecasts profit (EBITDA), not cash: the bank balance needs the 13-Week Cash Flow Forecast. Past forecasts missed sales by 3.4% on average.

This financial year is in scope of the FRS 102 lease rules (periods beginning on or after 1 January 2026): management accounts showing rent will show lower EBITDA than the statutory accounts; ask your accountant which basis to forecast on. The forecast is of profit, not cash: December is forecast to make a loss, but the months before cover it and there is £412,000 at the bank; check the bank balance in the 13-Week Cash Flow Forecast all the same.

The months after

What the agent flagged, and what was decided

At handover the managing director kept the 4% price rise from January, put the year-end gap to the board and asked for a cost review. The agent was then set up in Kestwick's own AI assistant account, with read-only access to the accounting system. The working day after each month's accounts are closed, it adds the month to a new dated copy of the forecast, records what last month's forecast said, rolls it on a month, runs the checks and sends the managing director a short note naming what moved the year end. It uses the rules on Inputs: the £450,000 profit target, the £10,000 materiality, and a flag when the year-end forecast falls by more than that in a month. Nothing left Kestwick, and no decision changed, without one of its own people approving it. These events continue the fictional example.

Monthly runs
5
October to February closes, November 2026 to March 2027
Flags raised
3
one a data problem, stopped before any figures were used
Year-end forecast in February
£290,300
from £271,300 at its lowest in November
Driver changes
1
proposed and approved by Kestwick's own people
DateWhat the agent foundFlag?What people decided
13 Nov 2026October closed. The year-end EBITDA forecast fell £3,800, to £289,900: under the £10,000 that needs a flag. The fall had run six months and was already known, so the note listed it.Note onlyNothing needed. The managing director read the note.
11 Dec 2026November closed. The year-end forecast fell £18,600, to £271,300. The note named the biggest mover: carriage out at 2.6% of sales against the 1.9% driver, after a new carrier's fuel surcharge.FlagThe finance manager proposed carriage at 2.3% of sales from December, with the reason on Drivers, and the managing director approved it. The operations manager asked the carrier to cap the surcharge.
13 Jan 2027December's year-to-date sales on Actuals were £34,200 below the management accounts: a credit note had been reversed after the export. The note gave no figures.FlagThe finance manager exported December again; it reconciled the same morning.
13 Jan 2027After the re-export the year-end forecast rose £2,100, to £273,400. The six-month fall had ended.Note onlyNothing needed.
11 Feb 2027January closed. The year-end forecast rose £16,900, to £290,300: account customer sales were 3% above forecast in the first month of the 4% price rise.Note onlyNothing needed; the price rise stays entered as it was.
11 Mar 2027February closed. Gross margin was 29.8%, more than a point below the last 12 months' 31.3%: the steel fixings supplier's 6% rise had not reached Kestwick's price list.FlagThe purchasing manager updated the fixings price list from 1 April. Cost of goods sold stays at 67% of sales until March shows the effect.

At the 30-day check-in on 16 November, Geoff and the managing director read October's note and log row together. No rule needed changing; every decision in the log that followed was Kestwick's own.

What the agent added. The method is unchanged: the same drivers, one-offs, materiality and target. The agent made sure the forecast rolled on every month and that each note said what had moved the year end, so the carrier's surcharge and the supplier's price rise were acted on in the month they appeared. Every change to a driver was proposed and approved by Kestwick's own people. The benefit here is the result holding and problems caught earlier; no £ figure is claimed for it.

Fictional and labelled: these events continue the worked example. The same 6 events are the sample rows in the Agent log of the worked-example spreadsheet. The workbook's other sheets stay as at September 2026; each month was saved as its own dated copy. The agent is part of the guided and done-for-you routes; the self-implement kit does not include it.