KPI Dashboard Design · October 2026

Ottersgill Pump Services Ltd

Industrial pump repair, servicing and installation from workshops in Wakefield and Middlesbrough. 74 staff.

Worked example. Ottersgill Pump Services and its figures are fictional. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 3 notes).
The headline

28 KPIs, each defined once; the main job is fixing the data behind 18 of them

Goals tracked with good data
2 of 5
all five covered on paper; the rest wait on the data-fix plan
Top page
12
limit 12; 4 must-haves, cash in the bank among them
Data-fix plan
18 KPIs
first due 6 Nov 2026, last due 4 Dec 2026
ROI products unlocked
5 of 6
1 already possible (not counted); 3 of them wait on data fixes

Verdict: The register holds 28 KPIs for 5 goals; every goal has a leading and a lagging KPI on paper, but only 2 can be tracked with good data today. 12 are on the top page (limit 12), reviewed at “Weekly operations meeting” in 30 minutes. The main job is fixing the data: 18 KPIs are on the data-fix plan. Build first, from good data: Sales invoiced this month against plan, Debtor days, Cash in the bank. Of the 6 catalogue ROI products it feeds, 1 already possible (not counted), 2 unlocked once the dashboard is built and 3 only once the data is fixed or recorded. Report hours: 40 now; 12 target; 4 to refresh a month (an illustration of their worth, if the target is met, is on row 25). Measure the baselines again on 3 Jul 2027 (early read 4 Apr 2027).

Goals

Every goal is covered on paper; two can be tracked with good data today

GoalKPIsLeadingLaggingOn paperWith usable data
G1 Grow sales to £9.0m (from £7.8m)
Owner: Sales manager
532YesNo usable leading KPI
G2 Lift gross margin on jobs to 34% (from 30%)
Owner: Operations director
431YesOn paper only
G3 Get paid faster: debtor days down to 45 (from 63)
Owner: Finance manager
422YesUsable now
G4 Grow service contract income to £2.4m a year (from £1.9m)
Owner: Service manager
422YesOn paper only
G5 Keep good engineers: engineer leavers under 10% a year (from 18%)
Owner: Operations director
321YesUsable now

Before this, the monthly pack arrived three weeks after the month end, and three people meant three different things by “turnover”. The pack’s lateness is now a KPI of its own: 15 working days now, 5 by the year end.

The top page

Twelve figures for the weekly operations meeting, judged against this quarter’s step, not the year-end goal

KPINowThis quarterYear endRed ifData
Sales invoiced this month against plan Must
G1 · lagging · monthly · Finance manager
94%95.5%100%below 90.5%Good
New enquiries a week
G1 · leading · weekly · Sales manager
1920.525below 16.4Patchy
Value of quotations sent a week
G1 · leading · weekly · Sales manager
£142,000£151,500£180,000below £128,775Patchy
Gross margin on completed jobs
G2 · lagging · monthly · Operations director
30%31%34%below 29%Patchy
Engineer utilisation
G2 · leading · weekly · Service manager
71%72.8%78%below 69.8%Patchy
Debtor days Must
G3 · lagging · monthly · Finance manager
63 days58.5 days45 daysabove 64.3 daysGood
Jobs invoiced within two working days
G3 · leading · weekly · Finance manager
–90%90%below 85%Missing
Debt more than 60 days old
G3 · leading · weekly · Finance manager
£86,000£74,500£40,000above £93,125Good
Cash in the bank Must
General · lagging · weekly · Finance manager
£184,000£200,500£250,000below £160,400Good
Planned maintenance visits on time
G4 · leading · weekly · Service manager
88%89.8%95%below 86.8%Patchy
Engineer leavers in the last 12 months
G5 · lagging · monthly · Operations director
18%16%10%above 18%Good
Working days to issue the monthly pack Must
General · lagging · monthly · Finance manager
15 days12.5 days5 daysabove 15 daysGood

Targets step evenly from today’s figure to the year-end goal; % tolerances are in percentage points. Team pages: Sales page (8 KPIs, sales manager, at the Monday sales huddle); Service and workshop page (8 KPIs, service manager, at the Weekly operations meeting); Money page (7 KPIs, finance manager, at the Monthly management meeting); People page (5 KPIs, operations director, at the Monthly management meeting).

Data readiness

10 good; 10 patchy; 8 missing

143Sales111Marketing32Delivery311People511Cash and profit

Good data Patchy Missing

Most of the gaps are in the CRM (quotations aren’t dated by stage) and in job costing (hours are booked late). Cash and debtor figures are good already.

A. The data-fix plan

Fix or start recording the data first, each with an owner and a date before go-live

#KPIDataWhoBy
1One-to-ones held in the monthMissingOperations director6 Nov
2Sickness absencePatchyOperations director6 Nov
3New enquiries a week Top pagePatchySales manager13 Nov
4Value of quotations sent a week Top pagePatchySales manager13 Nov
5Workshop repairs waiting over 10 daysPatchyWorkshop manager13 Nov
6Engineer utilisation Top pagePatchyService manager20 Nov
7Jobs invoiced within two working days Top pageMissingFinance manager20 Nov
8Annual value of live service contractsPatchyService manager20 Nov
9Renewals due with a quotation sentPatchyService manager20 Nov
10Planned maintenance visits on time Top pagePatchyService manager20 Nov
11Contract value lost in the last 12 monthsPatchyService manager20 Nov
12Quotation win rate by valueMissingSales manager27 Nov
13Open quotations by stage, datedMissingSales manager27 Nov
14Enquiries by sourceMissingSales manager27 Nov
15Quotations priced from the costing sheetMissingSales manager27 Nov
16Gross margin on completed jobs Top pagePatchyOperations director4 Dec
17Jobs over their estimated hoursMissingWorkshop manager4 Dec
18First-time fix rateMissingService manager4 Dec
B. The build sequence

Good-data KPIs only: the owner’s must-haves first, then goal coverage, then the least effort

#KPISourceEffortFirst step
1Sales invoiced this month against plan MustAccounting packageLowBuild now
2Debtor days MustAccounting packageLowBuild now
3Cash in the bank MustBank accountLowBuild now
4Working days to issue the monthly pack MustAccounting packageLowBuild now
5Engineer leavers in the last 12 monthsPayrollLowBuild now
6Debt more than 60 days oldAccounting packageLowBuild now
7Receipts from customers a weekBank accountLowBuild now
8Overtime hours per engineer a weekTimesheet appLowBuild now
9Website enquiries a monthWebsite analyticsLowBuild now
10Lost-time accidentsHealth and safety logLowBuild now
The dictionary

The top page’s entries, as the builder receives them

KPI, definition, period and edge casesSource and second sourceAllowed breakdown
Sales invoiced this month against plan
Sales invoiced in the month ex VAT, less credit notes ex VAT, ÷ the month's sales plan
Period: Calendar month; invoice date. Edge cases: A credit note counts in the month it is raised, whatever the original invoice's month; the plan is the budget agreed in September, not revised
Accounting package
checked against: Sales day book total for the month
By customer or job
New enquiries a week
Enquiries logged in the CRM in the week from customers asking for a price or a visit, not repeat service calls
Period: Monday 00:00 to Sunday 23:59; date logged. Edge cases: One enquiry per customer per need: a second call about the same pump is not a new enquiry
CRM
checked against: Phone log for one sample week a quarter
By customer or job
Value of quotations sent a week
Total value ex VAT of quotations issued in the week
Period: Monday to Sunday; quotation issue date. Edge cases: A revised quotation replaces the earlier one (counted once, at its latest value); service contract renewals excluded
CRM
checked against: Quotation numbers issued in the week, from the quotation register
By customer or job
Gross margin on completed jobs
(Job sales ex VAT − labour at standard cost − materials − subcontract) ÷ job sales ex VAT, for jobs completed in the month
Period: Calendar month; job completion date. Edge cases: Jobs spanning two months count in the month they complete; warranty returns are charged to the original job
Job management system
checked against: Gross margin in the monthly management accounts
By customer or job
Engineer utilisation
Hours booked to chargeable jobs ÷ hours paid, engineers only, for the week
Period: Monday to Sunday; timesheet date. Edge cases: Training, travel between jobs and workshop cleaning are not chargeable; holiday and sickness hours are excluded from hours paid
Timesheet app
checked against: Payroll hours paid
By team or site
staff data
Debtor days
Trade debtors at the month end ex VAT ÷ sales invoiced ex VAT in the last three months × 91 (ex VAT on both sides)
Period: Last calendar day of the month. Edge cases: Retentions and disputed invoices included; unallocated cash deducted from debtors
Accounting package
checked against: Aged debt report total at the same date
By customer or job
Jobs invoiced within two working days
Jobs completed in the week invoiced within two working days of completion ÷ jobs completed in the week
Period: Monday to Sunday; job completion date. Edge cases: Jobs held for a customer's order number count as late; bank holidays aren't working days
Job management system
checked against: Invoice dates in the accounting package
By customer or job
Debt more than 60 days old
Total including VAT of unpaid sales invoices more than 60 days past their invoice date (not their due date), at Friday close
Period: At Friday close; invoice date. Edge cases: Disputed invoices included and listed separately; credit notes not yet allocated are deducted
Accounting package
checked against: Aged debt report
By customer or job
Cash in the bank
Cleared balance of all business bank accounts at Friday close, less any overdraft drawn
Period: Friday close. Edge cases: Deposit accounts included; uncleared cheques and card payments excluded
Bank account
checked against: Bank reconciliation in the accounting package
Whole business
Planned maintenance visits on time
Planned maintenance visits completed by their due date in the week ÷ visits due in the week
Period: Monday to Sunday; due date. Edge cases: A visit the customer postpones in writing is re-dated, not late; a part-completed visit is late
Job management system
checked against: Visit reports signed by the customer
By team or site
staff data
Engineer leavers in the last 12 months
Engineers who left in the last 12 months ÷ average engineers employed over the 12 months
Period: Rolling 12 months to the month end; leaving date. Edge cases: Retirements and dismissals included and shown separately; apprentices excluded
Payroll
checked against: HR spreadsheet leavers list
By team or site
staff data
Working days to issue the monthly pack
Working days from the month end to the management pack reaching the directors
Period: Calendar month end; date the pack is emailed. Edge cases: Bank holidays aren't working days; a pack sent after 5pm counts as the next working day
Accounting package
checked against: Date of the email sending the pack
Whole business

People data: 7 staff; 2 health; groups of at least 5; per-person figures not allowed. Sickness absence and lost-time accidents are health data (special category): shown as rates by team, never with reasons, and only once an appropriate policy document is in place.

How the value is shown

Unlocks: mostly once the data is fixed

ROI productKPIs it needs, and their statusUnlocked?
13-Week Cash Flow ForecastReceipts from customers a week Ready when built
Debtor days Already possible
Cash in the bank Already possible
Unlocked once the dashboard is built
Sales Forecast and Pipeline ReviewOpen quotations by stage, dated Record the data first
Quotation win rate by value Record the data first
Unlocked once the data is recorded
Profit by Customer and ProductGross margin on completed jobs Fix the data firstUnlocked once the data is fixed
Customer Retention ReviewAnnual value of live service contracts Fix the data first
Contract value lost in the last 12 months Fix the data first
Unlocked once the data is fixed
Staff Turnover Cost ReviewEngineer leavers in the last 12 months Ready when builtUnlocked once the dashboard is built
Working Capital Release PlanDebt more than 60 days old Already possibleAlready possible: not counted

Measure later: 17 of 28 KPIs have a ‘Now’ figure with its source; they are measured again six months after go-live (3 Jul 2027), with an early read on 4 Apr 2027. Report hours a month: 40 now; 12 target; 4 to refresh. Illustration only, if the target is met (not a forecast): £8,640 a year after the build; £4,440 in the first year, after £4,200 to build it.

The weekly review

30 minutes, every week, the same agenda

ItemTimeWhat you look at
Top page: anything red or amber, and why10 min12 KPIs on the top page; discuss only those outside their tolerance (red or amber) against this quarter's target
Leading KPIs: what they say about the next four weeks8 min10 leading KPIs measured weekly or daily
Last week's actions: done or not5 minLast week's action list
New actions: who does what, by when5 minOne owner and one date for each action
Data fixes: on track for their dates?2 min18 KPIs on the data-fix plan (Plan, part A): any due this week?
How confident are we?

What this rests on

The goals, KPIs, definitions, owners and targets are as agreed with the owner and the managers on 14 Oct 2026; the Now figures are from the sources named against each. Whether each KPI is measured now, how good its data is and the effort to automate it are the team’s judgement, not tested; duplicates are caught only where two definitions read the same. Quarterly targets step evenly from Now to the year-end target, and red and amber work off this quarter’s step (percentage points for % KPIs). The top-page limit (12) and the most one person should own (33%) are assumed. The value case is Unlocks: the dashboard makes the named ROI products possible, mostly once the data is fixed; it is not a forecast of profit. Report hours now are counted; the target (12 hours), refresh hours and build cost are estimates, so the £ line is an illustration if the target is met, not a forecast.

The specification is finished when it is handed over; building it is the next job. Check each built figure against its second source before the top page is used.

The months after

What the agent flagged, and what was decided

At handover the agent was set up in Ottersgill's own AI assistant account, with read-only access to the accounting package, the bank feed, the timesheet app, the job management system and the HR spreadsheet. Every Monday at 7:00, before the weekly operations meeting, it reads each KPI from the source named in the register, writes the latest figures into a new dated copy, runs the checks and sends the managing director a short note: what is red and amber against this quarter's target, and which data fixes are due. It uses the register's own targets and tolerances, and the rule on Inputs that four amber readings in a row are flagged. It reports people figures only by team, and the sickness rate not at all until an appropriate policy document is in place. Nothing left Ottersgill, and no decision changed, without one of its own people approving it. These events continue the fictional example; the dashboard itself goes live in January.

Weekly runs
7
19 October to 30 November
Flags raised
5
on four of the seven runs; the others sent the weekly note only
Cash flagged
3 weeks early
amber four readings running on 9 November; red on 30 November
Data-fix dates followed up
2
each moved by its owner, with a reason
DateWhat the agent foundFlag?What people decided
19 OctThe first run read the 10 KPIs with good data. Of the 12 on the top page, six had a figure: five amber, and Debt more than 60 days old red at £96,800.FlagThe finance manager called the five oldest debts that week.
2 NovDebt more than 60 days old back to amber, at £88,300.Note onlyNothing new needed; the weekly calls continued.
9 NovThe data-fix date for One-to-ones held in the month passed with nothing recorded.FlagA column was added to the HR spreadsheet and the date moved to 30 November.
9 NovCash in the bank amber for the fourth reading running, falling from £191,000 to £176,500.FlagThe managing director asked for a 13-week cash view before approving the van purchase.
23 NovThe data-fix date for Jobs invoiced within two working days passed: completion dates were blank on about 40% of jobs.FlagCompletion date became a required field, and the fix date moved to 11 December.
30 NovCash in the bank red at £158,900, after the VAT quarter was paid.FlagThe van purchase was held until December's receipts were in.

At the 30-day check-in on 16 November, Geoff and the managing director read the log together. They kept four amber readings as the rule, and agreed the note should list the data fixes due in the coming fortnight.

What the agent added. The method is unchanged: same register, same targets and tolerances, same checks. The agent made sure the figures were read every week, before the dashboard was even built, and that the data-fix dates were followed up as they passed. The falling cash balance was flagged three weeks before it went red. The figures above are fictional, and no £ figure is claimed for the agent.

Fictional and labelled: these events continue the worked example. The same six events are the sample rows in the Agent log of the worked-example spreadsheet. The agent is part of the guided and done-for-you routes; the self-implement kit does not include it.