MI and KPI reporting
MI and KPI reporting is the monthly pack where each function's owner sees which figures moved and says what they'll do about them. The board reads the red and amber lines first, and every line has a written definition, one owner and a red, amber, green rule agreed in advance.
KPI scorecard, example
Complaint response has sat amber for 4 months with no action logged
| KPI | Owner | Jul | Aug | Sep | Oct | Latest action logged |
|---|---|---|---|---|---|---|
| Staff turnover, 12 months | Head of People | 13.9%Green | 14.4%Green | 14.8%Green | 15.9%Amber | Exit interviews reviewed, 11 Nov |
| Absence rate | Head of People | 2.6%Green | 2.6%Green | 3.5%Amber | 2.9%Green | Return-to-work checks restarted, 12 Oct |
| First-time fix rate | Operations Manager | 87.7%Green | 82.3%Amber | 87.4%Green | 87.4%Green | Van stock list changed, 10 Sep |
| Complaints answered in 2 working days | Customer Service Lead | 88.3%Amber | 86.1%Amber | 85.0%Amber | 84.3%Amber | None logged |
| Amber 4 monthsRule: amber more than six months running turns red, set by the board | Action log: no entry for this line, July to October | |||||
Thresholds in the definitions log
| KPI | Green | Amber | Red |
|---|---|---|---|
| Staff turnover | Under 15.0% | 15.0% to 20.0% | Over 20.0% |
| Absence rate | Under 3.0% | 3.0% to 4.0% | Over 4.0% |
| First-time fix rate | 85.0% or more | 80.0% to under 85.0% | Under 80.0% |
| Complaints answered in 2 working days | 90.0% or more | 80.0% to under 90.0% | Under 80.0% |
Show the numbers
| KPI | Jul | Aug | Sep | Oct |
|---|---|---|---|---|
| Staff turnover | 25 ÷ 180 | 26 ÷ 181 | 27 ÷ 182 | 29 ÷ 182 |
| Absence rate | 108 ÷ (180 × 23) | 95 ÷ (181 × 20) | 142 ÷ (182 × 22) | 117 ÷ (182 × 22) |
| First-time fix rate | 1,140 ÷ 1,300 | 1,020 ÷ 1,240 | 1,180 ÷ 1,350 | 1,215 ÷ 1,390 |
| Complaints answered in 2 working days | 212 ÷ 240 | 198 ÷ 230 | 221 ÷ 260 | 236 ÷ 280 |
MI reporting KPIs and how to calculate them
The first group measures the pack itself: whether its definitions, colours, owners and dates are written down and kept to. The other three are the function pages from the example. Revenue, margin and cash take one summary line each, linked to the finance dashboard, which gives their formulas.
| KPI | Formula | A good reading | The common mistake |
|---|---|---|---|
| The reporting discipline | |||
| Definitions log coverage | KPIs with a complete log line ÷ KPIs in the pack × 100. |
Every line complete before the pack goes out | Accepting “as per finance” as a formula. A formula someone has to go and find is a missing formula. |
How to read it Complete means the line holds everything the pack reads from it: the name it prints, the formula and source table behind the number, the owner who comments, the threshold that sets the colour and the cadence that sets the month. | |||
| RAG rule coverage | KPIs with written green, amber and red thresholds in the definitions log ÷ KPIs in the pack × 100 |
Every coloured cell traces back to a threshold in the definitions log | Colouring cells by feel each month. The same reading turns amber in one pack and green in the next. |
| Months at amber | Consecutive months each KPI has sat amber, set beside the number of months the written rule allows before amber turns red |
Every run of amber has a dated action from its owner by the next pack | Reading amber as safe because it isn't red. Under a rule of more than six months, a KPI can slide for half a year before anyone has to act. |
| Pack issued on time | The working day after month end the pack went out, against the issue day in the timetable |
On the timetable's day, every month | Counting calendar days. A month ending on a Friday then gets a different deadline from one ending on a Tuesday. |
| Owner coverage | Lines with one named owner ÷ lines in the pack × 100 |
Every line owned by one role | Naming a team, or two people. When the line goes red, a shared owner means nobody answers for it. |
| Commentary on red and amber lines | Red and amber lines with owner commentary ÷ red and amber lines × 100 |
Each one carries a sentence on the cause and a sentence on the action, with a date | Commentary that reads the chart aloud. “Response time fell this month” repeats the cell and says nothing about next month. |
| Restated figures | Figures changed after the pack was issued ÷ figures in the pack × 100 |
None, and any restatement listed at the top of the next pack | Correcting a figure quietly in next month's trend line. The board's earlier decision then rests on a number nobody can find. |
| KPI | Formula | A good reading | The common mistake |
|---|---|---|---|
| People page | |||
| Staff turnover | Leavers in the last 12 months ÷ average headcount over those 12 months × 100. This row counts every leaver. Some packs count voluntary leavers only. |
Inside its threshold, and read by team so one team's exits show up | Dividing by today's headcount. In a company that is hiring, that makes the rate look lower than it was. |
| Absence rate | Working days lost to absence ÷ (headcount × working days in the month) × 100. This row counts in headcount days. Some packs count hours, or full-time-equivalent days. |
Inside its threshold, with long-term absence shown as a line of its own | Mixing short spells with long-term absence in one figure. One long absence can then turn the whole line amber. |
| KPI | Formula | A good reading | The common mistake |
|---|---|---|---|
| Operations page | |||
| First-time fix rate | Jobs fixed on the first visit ÷ jobs completed × 100 |
Inside its threshold, read by engineer and by job type | Booking the return visit as a new job. The first job then counts as fixed, so link every return visit to the job it came back for. |
| Overdue jobs | Open jobs past their due date at month end ÷ open jobs at month end × 100 |
Flat or falling, with the overdue jobs split into age bands | Reporting the count alone. Ten jobs a day late and ten jobs a month late are different problems. |
| KPI | Formula | A good reading | The common mistake |
|---|---|---|---|
| Customer page | |||
| Complaints answered in 2 working days | Complaints answered within two working days of receipt ÷ complaints received × 100 |
Inside its threshold, with the clock stopped when the customer gets the answer | Starting the clock when the complaint is logged. If logging lags behind receipt, response looks faster than the customer saw it. |
| Complaints per 1,000 jobs | Complaints received ÷ jobs completed × 1,000 |
Flat or falling as job volume grows | Reading the count of complaints alone. More jobs bring more complaints, so a rising count can hide a falling rate. |
How to build management reporting
Data sources
The HR system for leavers, headcount and absence, the job management system for jobs and visits, and the complaints log. The definitions log is a source too. It sits in a table the pack reads, one row per KPI, so a threshold changed in the log changes the colour in the pack.
Grain
One row per KPI per month, holding the numerator, the denominator, the value, the band, the owner and the latest action. Last month's row is never overwritten, because months at amber are counted from those rows. Under it, each KPI keeps the grain of its own source: one row per leaver, per absence, per job, per complaint.
Refresh cadence
Monthly, at the data cut-off in the timetable. Figures are frozen at that point, so the numbers owners comment on are the numbers the board reads.
How many periods amber runs before it turns red
You set this, per KPI or for the whole pack, and write it into the definitions log. The example turns a line red after more than six months at amber, for every line.
What counts as an action
Agree it before the first pack. In the example it is a dated entry in the action log with an owner and a due date. A line of commentary alone doesn't count, which is why the complaints row shows “None logged” four months in.
Questions board reporting should answer
The sales dashboard and marketing KPIs pages give the sales and marketing lines a pack like this can carry, each with its formula.
Business reporting by tool
Power BI
Keep the thresholds as columns in the definitions log table, and write one measure that returns the band for each KPI and month. Power BI's conditional formatting can take a cell's colour from a field, so the colour follows the log. Moving a threshold is then one edit, made by the owner of the log.
Data Studio (formerly Looker Studio)
Work out the band in the source table, before the report reads it, and colour the scorecard from that field. Months at amber needs every past month's row, so the table behind the scorecard has to keep history.
Excel
If your action log already lives in a workbook, keep it as one table with the KPI, owner, action, date logged and due date, and have the scorecard look up the latest entry for each KPI. A blank lookup is how “None logged” appears on its own.
Google Sheets
With a work or school Google account, you can assign a comment in Google Sheets to a person as an action item, and they get an email about it. Owners can then be asked about their amber line on the cell itself. Copy each assigned action into the action log with its date, because the months-at-amber count reads the log.
For a pack like the example, where complaint response sat amber for four months with no action logged, our dashboards and BI service writes the definitions log and the amber-to-red rule with your owners, then builds the pack on your own systems. If nobody in-house has time to run the monthly cycle, fractional analytics covers the cut-off, the checks and the chasing for commentary. An AI assistant needs the same log before it can answer “which KPIs have been amber since summer?”, and that's where AI-led analytics starts.
Questions about MI reporting
Is MI reporting the same as management reporting?
In practice, yes. MI means management information, and the management report is the pack that carries it. Some firms keep MI for the regular figures and management reporting for the whole pack with commentary. Either way, each scorecard row takes its formula, colour band and owner from the definitions log, so a figure means the same every month.
What should a board reporting pack include?
It needs one page per function, each with its KPIs, their red, amber or green bands, the owner and the latest action, then the finance summary linked to the full finance pack. Put the red and amber lines with their commentary on the first page, so the board starts with what needs a decision.
Who should set the red, amber and green thresholds?
The KPI's owner proposes them and whoever receives the pack, the board or the leadership team, agrees them. They go in the definitions log with the date agreed. Changing a threshold is a decision of its own, recorded in the log, so a colour never changes because someone moved the line between months.
How soon after month end should management reporting go out?
In the example it goes out on working day 7, after the data cut-off on day 3 and owners' commentary on day 5. Set your own dates in working days, because calendar days give a different deadline every month, and fit them to how long the ledger and the operational systems take to close.
Can business reporting be automated?
Yes for the figures, bands and colours, which build themselves from the source systems at the cut-off once the definitions log holds each formula and threshold. Owner commentary and actions can't be automated, and shouldn't be. The pack is worth reading because a named person says what they'll do about each red and amber line.
Which lines in your board pack have no owner?
On the call we go through last month's board pack with you and mark every line that has no written threshold or no single named owner.