Managed IT support, cyber security and cloud services on monthly contracts for businesses, schools and care providers across Leicestershire, Nottinghamshire and Derbyshire. 40 staff. Oct 2025 to Sep 2026 against Oct 2024 to Sep 2025.
Calibration: last year the firm lost 15% of its gross profit to controllable causes; the assumed band chances predict 11% for the next 12 months. Close enough to use, and if anything on the low side: the expected loss is not overstated.
Verdict: A year ago you had 38 customers buying £3,328,000 a year. In the last 12 months they bought £2,616,300: you kept 74% of their revenue (gross revenue retention), or 79% counting growth (net). 6 customers lost and 5 shrinking cost £383,616 of gross profit a year, 61% of it in your control (partly controllable reasons at half); the biggest reason was Price (28% of it). Last year you lost 15% of your gross profit to controllable causes; the bands predict 11% for the next 12 months. Looking ahead, £147,208 of gross profit is expected to go if nothing changes (5 High; 4 Medium; 27 Low); if every High-band customer went it would be £247,200 a year. 9 renewals worth £830,000 a year fall within 6 months, carrying £93,029 of that expected loss. The 6 customer saves and 2 cause fixes should keep between £31,759 and £56,345 of gross profit a year (saves £31,759, cause fixes £24,586; they can overlap), for £18,030 in the first year (£3,900 of it cash): a first-year net of £9,759 to £31,272 (£6,621 if they do half as well). Best for the money: “Review with the finance director before the November renewal; map the new contacts”.
Price, service failures and a customer taking IT in-house account for most of the loss. Service failures and a departed contact are fully in the firm’s control; price (one loss at a public tender), fit and the in-house decision only partly; a practice bought by a national group not at all. The reason is not known for 8% of the revenue lost: low enough to trust the pattern, but those two customers should still be asked.
| Customer | Status | Reason | Previous 12 months | Last 12 months | Gross profit lost a year |
|---|---|---|---|---|---|
| Dravington Foods Ltd | Lost | Taken in-house | £182,000 | £14,500 | £80,400 |
| Coltmere Housing Trust | Lost | Price | £148,000 | £9,200 | £66,624 |
| Pellbrook Solicitors LLP | Lost | Service failure | £96,000 | £0 | £46,080 |
| Belcote Academy Trust | Shrinking | Price | £210,000 | £128,000 | £39,360 |
| Larkhollow Veterinary Group | Lost | Closed or bought | £64,000 | £0 | £30,720 |
| Gorsedale Logistics | Shrinking | Contact left | £156,000 | £98,000 | £27,840 |
| Arnmere Print Finishers | Lost | Service failure | £52,000 | £0 | £24,960 |
| Eskridge Dental Practices | Shrinking | Product or fit | £80,000* | £36,000 | £21,120 |
| Thrushbeck Care Homes | Shrinking | Service failure | £120,000 | £84,000 | £17,280 |
| Fennick Lettings | Lost | Not known | £38,000 | £2,100 | £17,232 |
| Kestermoor Engineering | Shrinking | Not known | £74,000 | £49,000 | £12,000 |
* Recurring revenue only: Eskridge’s contract was cut to £3,000 a month in August, so its trailing revenue understated the loss.
| Customer | Band | Signs | Next renewal | Expected loss | If lost | Save plan |
|---|---|---|---|---|---|---|
| Marefield Plastics Steady | High | 4 | 30 Nov 2026 | £28,992 | £72,480 | Yes |
| Belcote Academy Trust Shrinking | High | 4 | 31 Mar 2027 | £24,576 | £61,440 | Yes |
| Gorsedale Logistics Shrinking | High | 4 | 30 Jun 2027 | £18,816 | £47,040 | Yes |
| Thrushbeck Care Homes Shrinking | High | 4 | 31 Dec 2026 | £16,128 | £40,320 | Yes |
| Rothlow Furniture Steady | High | 3 | Rolling | £10,368 | £25,920 | Yes |
| Cotesbrook Law Steady | Medium | 2 | 28 Feb 2027 | £7,488 | £49,920 | None |
| Sallowby Hotels Steady | Medium | 2 | 30 Sep 2027 | £6,984 | £46,560 | Yes |
| Kestermoor Engineering Shrinking | Medium | 2 | 31 Aug 2027 | £3,528 | £23,520 | None |
| Eskridge Dental Practices Shrinking | Medium | 2 | 31 Jan 2027 | £2,592 | £17,280 | None |
| Kirkwold Precision Steady | Low | 1 | 15 Dec 2026 | £1,056 | £35,200 | None |
| Ivelby Recruitment New | Low | 1 | Rolling | £590 | £19,680 | None |
9 renewals worth £830,000 a year, rolling contracts included, fall within 6 months, carrying £93,029 of the expected loss. Belcote Academy Trust has a tender or competitor quotation under way. Ivelby Recruitment and Kirkwold Precision renew (or can leave on a month’s notice) within 3 months with no plan: neither is at risk, but someone should own each renewal.
| Plan | Gross profit kept a year | First-year cost | First-year net |
|---|---|---|---|
| Repeat-fault review each month; any fault logged three times goes to the service desk manager Fix a cause: Service failure · Service desk manager · 50% chance | £22,080 | £3,960 | £15,360 |
| Review with the finance director before the November renewal; map the new contacts Save a customer: Marefield Plastics · Account manager · 30% save share | £8,698 | £720 | £6,890 |
| Price and scope review before the March renewal; a visit to the trust's finance director each quarter Save a customer: Belcote Academy Trust · Managing director · 30% save share | £7,373 | £1,440 | £5,011 |
| MD meets the new operations director; service review and a named engineer Save a customer: Gorsedale Logistics · Managing director · 30% save share | £5,645 | £1,350 | £3,589 |
| Quarterly business review and a monthly credit-control call Save a customer: Rothlow Furniture · Account manager · 30% save share | £3,110 | £630 | £2,092 |
| Three named contacts at every customer; the MD meets each customer's senior person twice a year Fix a cause: Contact left · Managing director · 30% chance | £2,506 | £1,530 | £662 |
| Service recovery: fix the three repeat faults; weekly report until the renewal Save a customer: Thrushbeck Care Homes · Service desk manager · 30% save share | £4,838 | £3,660 | £574 |
| A monthly on-site day and a free security audit Save a customer: Sallowby Hotels · Account manager · 30% save share | £2,095 | £4,740 | −£2,907 |
Saves keep £31,759 and cause fixes £24,586 a year; they work partly on the same customers, so the plans keep between £31,759 and £56,345. The cost is mostly the team’s time; £3,900 of the £18,030 is cash. Belcote is a public academy trust: any price or scope change has to fit its procurement rules, and free work or gifts may breach its gifts policy. “A monthly on-site day and a free security audit” costs more than it keeps in the first year: a Medium-band customer does not justify a monthly on-site day. Cut it back to a quarterly visit, or keep it for another reason.
Revenue by customer comes from the sales ledger for Oct 2025 to Sep 2026 against Oct 2024 to Sep 2025, checked against the accounts’ turnover; recurring revenue is used instead where given. Lost means this year’s revenue is 10% or less of last year’s; shrinking, down by more than 25%; reasons come from the team and are only as good as what customers said, and how far each is in your control is your judgement on Inputs. The chance of losing a live customer in the next 12 months is assumed by warning-sign band (40% High, 15% Medium, 3% Low), giving a predicted 11% against last year’s actual 15%; the 30% of that risk a save plan keeps is assumed too. A cause fix counts last year’s controllable losses from that cause × the expected reduction × the chance it works (50% if customers told us or a test elsewhere, 30% best practice, 20% a hunch), which assumes next year’s losses look like last year’s. Saves and cause fixes can overlap on the same customers, so the gross profit kept is a range. Plans build up over 3 months; later years count 50% of the gross profit kept. Margins are 48% by default: if your team is a fixed cost, a loss costs more than gross profit shows.
The firm’s own figures are the revenue by customer, the reasons and the warning signs; the chances of losing a customer by band and the share a save plan keeps are assumed starting points. Record each quarter which customers were banded what, and who left: after a year, replace the assumed chances with your own.
Fictional, continuing the example. Soarbridge chose the guided route and, in the final session, set up an agent in an AI assistant the business already uses, connected read-only to the sales ledger, the aged debtors report, the service desk, the CRM and the contracts register (its IT confirmed this before it committed). On the first working day of each month it re-reads four of the six warning signs for every live customer from those systems (orders down, a complaint, paying late after 30 days, no senior contact), takes the other two and the renewal dates from the Customers sheet, bands each customer with the same rule as the review, and sends the managing director a short note. It flags every move into High, a move into Medium for a customer worth at least £15,000 of gross profit, and a renewal within 3 months with no save plan. It never contacts a customer or changes a band, a plan or a chance. Nothing left the business, and no decision changed, without one of its own people approving it.
| Date | What the agent flagged | What was decided |
|---|---|---|
| 14 Oct Flag | Test run at set-up: two renewals within three months had no save plan, Kirkwold Precision (15 December) and Ivelby Recruitment (rolling monthly). | The managing director judged both healthy: no save plans, but the account manager owns both renewals. |
| 2 Nov Flag | Cotesbrook Law moved from Medium to High: an invoice was 41 days past due, on top of August's complaint and the February renewal. | Credit control called that week; the managing director arranged to meet the practice manager, and a save plan was added. |
| 1 Dec Flag | Sowlane Haulage moved from Low to Medium: orders were down 34% on the same three months last year. | A listening call found a depot had closed. No save plan; the smaller contract is noted for the quarterly rerun. |
| 1 Dec No flag | Kirkwold Precision renewed for two years, so its renewal left the window. | Nothing needed. |
| 4 Jan Flag | The aged debtors export failed because a login had changed, so the agent reported a data problem and no figures. | The office manager renewed the read-only login the same morning; the rerun found no new flags. |
| 4 Jan No flag | Thrushbeck Care Homes renewed for a year and moved down from High to Medium. | Nothing needed; its save plan carries on. |
At the check-in on 27 November, after the first monthly run (about day 45), Geoff and the managing director read the log together; no rule needed changing. The failed export in January was fixed by Soarbridge's own office manager, as the set-up intends: after the check-in the agent is theirs. What the agent added: Cotesbrook Law's late payment reached the managing director at the start of November, four months before its renewal, instead of at the next quarterly rerun. The bands use the review's assumed chances, so the agent's running total of gross profit at risk is an expected figure, not a forecast for any customer. The months after add nothing to the figures above, and no £ figure is claimed for them.