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.

Last reviewed · Virgo Analytics

KPI scorecard, example

Complaint response has sat amber for 4 months with no action logged

Example data

KPI scorecard

July to October 2026

KPI scorecard, example data, each cell's value and band
KPIOwnerJulAugSepOctLatest action logged
Staff turnover, 12 monthsHead of People13.9%Green14.4%Green14.8%Green15.9%AmberExit interviews reviewed, 11 Nov
Absence rateHead of People2.6%Green2.6%Green3.5%Amber2.9%GreenReturn-to-work checks restarted, 12 Oct
First-time fix rateOperations Manager87.7%Green82.3%Amber87.4%Green87.4%GreenVan stock list changed, 10 Sep
Complaints answered in 2 working daysCustomer Service Lead88.3%Amber86.1%Amber85.0%Amber84.3%AmberNone logged
Amber 4 monthsRule: amber more than six months running turns red, set by the boardAction log: no entry for this line, July to October

Thresholds in the definitions log

KPIGreenAmberRed
Staff turnoverUnder 15.0%15.0% to 20.0%Over 20.0%
Absence rateUnder 3.0%3.0% to 4.0%Over 4.0%
First-time fix rate85.0% or more80.0% to under 85.0%Under 80.0%
Complaints answered in 2 working days90.0% or more80.0% to under 90.0%Under 80.0%
Example data: an invented field service company with about 180 staff, July to October 2026. Complaint response has fallen every month, from 88.3% to 84.3%, and under the rule it can stay amber through December.
Show the numbers
Inputs behind every cell, example data
KPIJulAugSepOct
Staff turnover25 ÷ 18026 ÷ 18127 ÷ 18229 ÷ 182
Absence rate108 ÷ (180 × 23)95 ÷ (181 × 20)142 ÷ (182 × 22)117 ÷ (182 × 22)
First-time fix rate1,140 ÷ 1,3001,020 ÷ 1,2401,180 ÷ 1,3501,215 ÷ 1,390
Complaints answered in 2 working days212 ÷ 240198 ÷ 230221 ÷ 260236 ÷ 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.

KPIFormulaA good readingThe common mistake
The reporting discipline
Definitions log coverageKPIs 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 coverageKPIs 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 amberConsecutive 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 timeThe 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 coverageLines 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 linesRed 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 figuresFigures 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.
KPIFormulaA good readingThe common mistake
People page
Staff turnoverLeavers 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 rateWorking 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.
KPIFormulaA good readingThe common mistake
Operations page
First-time fix rateJobs 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 jobsOpen 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.
KPIFormulaA good readingThe common mistake
Customer page
Complaints answered in 2 working daysComplaints 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 jobsComplaints 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.

The pack timetable

Example data

Working day after month endWhat happens
3Data cut-off. The month's figures are frozen.
5Owners send commentary on every red and amber line.
7The pack is issued.
  • 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

“What needs us this month?”The red and amber lines, with their commentary, on the first page.
“What has been amber too long?”Months at amber, set beside the rule.
“Who is dealing with it?”Owner coverage, and the latest action logged against each line.
“Can we trust last month's figures?”Restated figures, listed at the top of the pack.
“Are we losing people faster?”Staff turnover, by team.
“Are customers waiting longer for an answer?”Complaints answered in two working days, with complaints per 1,000 jobs beside it.

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.

Book a call

Free 30 min call