Distributor of fasteners, PPE, tools and maintenance supplies to manufacturers and trade customers across Yorkshire, with a web shop. 38 staff.
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.
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.
| Key figure | Actual | Budget | Same time last year | Against budget |
|---|---|---|---|---|
| Sales year to date | £3,816,100 | £3,878,300 | £3,634,000 | Worse |
| Gross margin % year to date | 31.2% | 31.6% | 31.4% | Worse |
| Overheads this month | £177,640 | £164,360 | £155,510 | Worse |
| EBITDA year to date | £174,090 | £239,650 | £209,070 | Worse |
| Year-end EBITDA forecast | £293,684 | £465,930 | £400,190 | Worse |
| Gap to profit target | -£156,316 | – | – | Short of target |
| Cash at bank | £412,000 | – | – | |
| Debtor days | 41 days | – | – |
| Profit and loss | This month | Budget | Better or worse | Year to date | Budget | Better or worse | Full-year forecast | Full-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 margin | 30.8% | 31.6% | -0.8 pts | 31.2% | 31.6% | -0.4 pts | 31.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 |
| Line | This month v budget | Year to date v budget | This month v last forecast | Year to date v last year | Reasons |
|---|---|---|---|---|---|
| Sales: account customers | −£25,100 | −£68,300 | £12,200 | £132,300 | Budget: 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,800 | Last year: Web shop growing about 12% a year |
| Cost of goods sold flexed budget | −£5,244 | −£15,113 | −£11,260 | −£129,340 | Budget: 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,930 | Last year: April pay rise and National Insurance |
| Vehicles and fuel | −£1,080 | −£7,170 | £120 | −£9,580 | Budget: Extra van leased in April, not in the budget Last year: Extra van leased in April |
| Marketing | −£11,500 | −£8,420 | −£12,100 | −£11,750 | Budget: 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,270 | Budget: 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).
| Line | Driver | Value | Why |
|---|---|---|---|
| Sales: account customers | Last year × growth | +2% | Volume up about 2% on last year over the last six months, before the price rise |
| Sales: web shop | Last year × growth | +12% | Web shop growing about 12% a year |
| Cost of goods sold | % of sales | 67.0% | Average of the last six months |
| Carriage out | % of sales | 1.9% | Steady at about 1.9% of sales |
| Wages and employer costs | Run rate | £111,010 a month | April pay rise already in the last three months |
| Rent and rates | Fixed amount | £19,200 a month | Lease and business rates for the year |
| Heat and power | Last year × growth | +5% | Seasonal; tariff up about 5% |
| Vehicles and fuel | Run rate | £10,047 a month | Includes the extra van leased in April |
| IT and software | Run rate | £4,770 a month | |
| Marketing | Run rate | £3,427 a month | September trade show entered as a one-off |
| Insurance | Fixed amount | £2,950 a month | Annual premium spread monthly |
| Other overheads | Run rate | £10,837 a month | August includes a bad debt, entered as a one-off |
| Month | Line | Amount | Applies | What it is |
|---|---|---|---|---|
| Jul 2026 | Sales: account customers | £55,000 | that month only | Past Clearance order from a customer closing a site |
| Aug 2026 | Other overheads | £14,000 | that month only | Past Bad debt written off |
| Sep 2026 | Marketing | £12,100 | that month only | Past Regional trade show: the cost above a normal month |
| Nov 2026 | Sales: account customers | −£25,000 | every month from then | Forecast Packaging customer lost to a competitor from November |
| Nov 2026 | Wages and employer costs | £3,300 | every month from then | Forecast Internal sales hire from November |
| Jan 2027 | Sales: account customers | £21,000 | every month from then | Forecast 4% price rise on account customers from 1 January |
| Apr 2027 | Wages and employer costs | £4,500 | every month from then | Forecast 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.
| Month | Sales forecast | Actual sales | Miss | EBITDA forecast | Actual EBITDA | Year-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.
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.
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.
| Date | What the agent found | Flag? | What people decided |
|---|---|---|---|
| 13 Nov 2026 | October 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 only | Nothing needed. The managing director read the note. |
| 11 Dec 2026 | November 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. | Flag | The 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 2027 | December'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. | Flag | The finance manager exported December again; it reconciled the same morning. |
| 13 Jan 2027 | After the re-export the year-end forecast rose £2,100, to £273,400. The six-month fall had ended. | Note only | Nothing needed. |
| 11 Feb 2027 | January 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 only | Nothing needed; the price rise stays entered as it was. |
| 11 Mar 2027 | February 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. | Flag | The 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.