What Is a KPI Report and How to Use It

A KPI report is a short, recurring comparison of a few measured indicators, each set against a target and against the previous period, so the owner can decide the next action rather than just review what happened. The practical number is around five indicators, a deliberately small set that stays readable in a month when everything else is busy.

Your turnover line has never looked better. The VAT bill still lands on the same date, payroll still clears on the 28th, and the overdraft is doing work you never planned for it to do. Nothing in the statutory accounts explains why a record quarter feels like a squeeze.

That squeeze is the gap a KPI report exists to close. Not the year-end accounts, which record history for HMRC and Companies House. Not a live dashboard showing whatever has been keyed in so far today. The report is the fixed monthly comparison that tells you whether growth is profitable, whether the cash is arriving, and which single decision needs making before the next month closes.

What Is a KPI Report

A KPI report is a regular summary of selected measures that helps an owner decide what to do next. For example, a growing business may see sales rise while its bank balance falls. A report that puts sales, margin and cash measures together can show where to act.

Why it isn't your profit and loss account

A profit and loss account records income and costs for a period. A KPI report helps manage performance by comparing selected measures with a target or an earlier period. The accounts show what happened; the report helps turn that result into a decision.

A useful report stays selective. Around five indicators is a practical starting point, rather than a long list that obscures what needs attention.

The cycle that keeps it honest

Start by recording a baseline, then collect and compare the figures each month. Keep the definitions consistent: if revenue or cash collected is calculated differently from one report to the next, the comparison becomes unreliable. Charts can help show a change, but they cannot fix inconsistent measures.

For a UK SME, a practical monthly set could include revenue, gross margin, cash collected, debtor days, enquiry-to-sale conversion and delivery performance. Put each selected measure beside its target and previous-period result, then connect a meaningful change to a decision.

Consider a limited company director whose sales are rising as the business grows. The team is busy, but the bank balance is lower than it was a year ago. Revenue alone cannot explain the pressure: margin, collection speed and delivery capacity may all be changing at once.

Treat the table as a menu, not a checklist. Choose the measures that reflect the decisions your business needs to make.

The Fields Every KPI Line Needs

A KPI report fails in a specific, predictable way: it presents descriptive numbers with no decision rule attached. Revenue is up, margin is down, nobody is named, nothing happens. The Office for National Statistics management practices research measures management quality partly through firms' use of KPIs and targets alongside continuous improvement and employment practices, and reports that stronger management-practice scores are positively associated with productivity, profitability, innovation investment and business resilience, with research indicating part of that relationship may be causal.

Eight fields fix it. Use debtor days for a trade business invoicing on 30-day terms as the running example, because it's the line owners most often get wrong.

The formula. Trade debtors divided by credit sales, times the days in the period. Write it once and never paraphrase it. Trade debtors of £150,000 against £450,000 of credit sales over a 90-day period gives 30 days. If one month's report uses total sales instead of credit sales, the comparison dies and no one notices for two quarters.

The unit and the owner. Days, not pounds. The owner is whoever can chase the money or change the terms, usually the finance lead rather than the salesperson who promised the work.

The period and the source. The month just closed, taken from the aged receivables report in reconciled bookkeeping. A salesperson's estimate of what's coming in is not a data source.

The three fields that force action

The target. 35 days against 30-day terms, which builds in a few days of leeway without pretending the terms don't exist.

The variance threshold. Amber above 40 days, red above 50, or red regardless of the number whenever forecast cash drops inside the payroll and VAT buffer. That second trigger is the one owners forget, and it's the one that matters in a short month.

The action response. Owner, deadline, expected cash effect. "Call the three largest overdue accounts this week and move new work to deposits" is an action response. "Monitor closely" is not.

Variance analysis should later separate volume, price, mix and cost effects rather than merely flagging that profit is below budget. For each line you keep, the same fields apply, and any metric that can't produce an owner and a red-item response should be cut from the pack. If the selection itself feels uncertain, this guide to choosing the right KPIs for your business sets out how to narrow it down.

Why Cash Indicators Sit Beside Profit

Profit is the scoreboard. Cash is the oxygen. A month can look excellent on the first and still leave you unable to clear payroll on the 28th, because the invoice went out late, the customer sat on it, and the stock and wages went out regardless.

The scale of the problem is not anecdotal. The Office of the Small Business Commissioner's late payments research reports that late payments cost the UK economy almost £11 billion annually, affect more than 1.5 million businesses, and leave approximately £26 billion in late payments outstanding at any given time, with affected businesses estimated to be owed an average of £17,000. A government review estimated SMEs were owed an average of £22,000 in 2022.

Cash stress is now the normal condition rather than the exception. The British Business Bank's small business finance report found that 22% of smaller businesses reported cash-flow or late-payment difficulties in Q3 2025, up from 19% in Q3 2024.

The cash lines your pack should carry

• Aged receivables: who owes what, bucketed by how late it is
• Debtor days: the single number that tells you whether collections are speeding up or stalling
• Overdue-invoice percentage: how much of the book has slipped past terms
• Cash collected versus billed: the gap between invoicing effort and money banked
• Forecast closing cash: the balance you expect at month end, not the one you hope for
• Supplier-payment exposure: what leaves the account before your customers pay you

Profit metrics deserve their own scrutiny too, and this founder's guide to profit metrics is a useful companion for reading margin and return figures next to the cash lines rather than in isolation.

For the mechanics of the cash side, our guide to understanding your company's cash flow walks through how collections, payment runs and VAT timing interact across a quarter.

Set the threshold from your own buffer

If overdue receivables rise, the report should show the resulting cash shortfall, the funding requirement and the fix. Earlier invoicing, deposits, credit limits, staged billing and escalating disputed invoices are the usual levers, and they work fastest when someone owns them. The action threshold comes from your own payment terms and cash buffer, never a borrowed industry benchmark that ignores how your customers pay.

A single month can also lie. Seasonality or one large one-off job distorts the picture, which is why every line needs the prior period beside it. Leading indicators such as qualified pipeline, conversion rate, utilisation, average selling price and retention tell you what's coming. Lagging indicators such as revenue, gross margin, operating profit, debtor days, headcount and cash generated tell you what landed.

A red cash line is an intervention, not a colour on a chart. If nobody's name and no deadline sit next to it, delete the row and save yourself the meeting.

A Monthly Pack for a Growing SME

Numbers only make sense as a story. Here's a worked pack for Alba Fit-Out Ltd, a fictional Central Scotland services firm with about £80,000 monthly turnover, 30-day terms and an ambition to pass seven figures without starving the bank.

UK business-demography data shows why both current performance and longer-term outcomes belong in the same pack. The ONS business demography bulletin recorded approximately 317,000 business births in the UK in 2024, up from 316,000 in 2023, with the birth rate rising from 11.0% to 11.1%. Among businesses with at least 10 employees, 292,000 were recorded in 2024, of which 14,330 (4.9%) were classed as high-growth on employment, the highest rate since 5.0% in 2018. Market entry and sustained expansion are different measures, and a report that tracks only activity will miss the second one entirely.

Reading it line by line

Revenue is green, and it isn't the story. Gross margin falling from 38% to 31% is where the month went wrong: one discounted job plus subcontractor overruns hit price and cost at the same time. Split properly, volume helped, price hurt, and a costly mix finished the damage.

Cash is the second problem. Collecting £61,000 against £80,000 billed means the month's work funded itself and not much else. At 54 debtor days against a 35-day target, with 28% of the book overdue, the question stops being "how do we sell more" and becomes "how much of payroll and VAT is this shortfall".

Three actions come out of the pack, each with a name and a date. Deposits on new jobs. A credit limit on the slowest account. A chase list worked to a Friday deadline.

Conversion at 22% against 30% is amber because it's the leading edge of next quarter's revenue, and on-time delivery at 96% is green because it proves the team can still deliver. That last point is why the pack stays small. Five or six linked lines are enough, and utilisation or retention earns a place only when a red item proves the pack is blind to capacity or repeat work. Rising turnover is not healthy growth when margin or cash conversion is falling. For a fuller picture of how to read the underlying statements, see this guide to how to read management accounts. Teams in project-based sectors may also find a financial reporting guide for post-production heads useful for structuring the same pack around job-level margin.

When a Simple Monthly Report Beats a Live Dashboard

Real-time is not automatically better. A monthly pack built on reconciled figures usually beats a live screen fed by late invoices, half-posted bills and two different definitions of revenue, because the comparison holds still long enough to mean something.

Access isn't the constraint. In 2024, 83% of UK businesses handled some form of digital data, according to the Business Data Use and Productivity Study. The gap is judgement about which numbers deserve a decision, not software.

The cost of getting that wrong is visible in the wider data. The Small Business Survey 2025 panel report found that the share of panel firms reporting sales growth fell from 55.6% in 2022 to 40.3% in 2025, while only 29.7% reported product or service innovation in 2025. A revenue-only report would have looked respectable through that entire slide while pipeline quality, innovation and operational risk steadily deteriorated.

How often each line deserves a look

Cash buffer and a large overdue balance: weekly, because a week is long enough to lose an overdraft argument. Margin, conversion and debtor days: monthly, once the books close. Retention, innovation and strategic progress: quarterly. Anything reviewed daily that can't change daily is a chart eating your morning.

Timing matters as much as frequency. If last month's figures excluded late invoices and this month's include them, the variance is an accounting cut-off difference, not a performance change. Keep the formula identical and compare against the same month last year as well as the budget when a quarter is seasonal. Where a quiet quarter or a deliberate growth push changes what good looks like, change the target in writing and say why.

Three ways a pack goes wrong

• Too many KPIs: fifteen lines guarantees nobody reads past the third, and the red one gets buried
• No owner on red items: a colour without a name and a deadline is decoration
• Rewarding sales while working capital deteriorates: commission based on invoiced revenue, cash collapse six weeks later

A balanced set covers cash conversion, customer retention, delivery capacity, gross margin, staff utilisation and one strategic marker. Even in a membership business such as a gym, where the gym management dashboard KPIs tend to focus on recurring revenue and churn, the same rule holds: a metric earns its place by triggering a decision, not by filling a panel.

How to Build and Run the Monthly Report

Here's the routine, in the order it should run.

1. Write the objective in one line. Something like profitable growth with cash on hand for VAT, payroll and tax. Every metric that follows has to serve that sentence.
2. Choose five or six indicators covering sales quality, margin, cash conversion and delivery capacity. For each, record the formula, unit, source, owner, target and red threshold before you calculate anything.
3. Fix the accounting cut-off. Five working days after month end, once bank transactions, sales invoices and purchase invoices are posted. Without a cut-off, this month and last month are measured over different lengths of time.
4. Pull from two places only. Reconciled bookkeeping for the financial lines, and one operational source for the rest, the CRM for enquiries and the job system for on-time delivery.
5. Calculate variance twice. Against target and against the prior period or last year. For profit, split the gap into volume, price, mix and cost rather than reporting that profit is below budget.
6. Colour from your own buffer. Red, amber and green defined by your cash position and payment terms, not a benchmark borrowed from a sector report.

7. Write the response for every red line. Owner, deadline, expected cash or margin effect. Two sentences is enough, and the second sentence is the one that gets done.
8. Hold a 45-minute review. Ten minutes on what moved, twenty on the red items, fifteen on one decision: deposits, a price rise or a hiring pause. One decision per meeting beats six intentions.
9. Store the pack somewhere fixed. Next month starts from the same definitions, the same layout and the same targets, so the only variable is performance.

Keep a rolling 13-week cash view beside the monthly pack. A late customer gets tested against the forecast before it hits the overdraft, which is the whole point of holding both.

Practical rule: change a target when the season or a deliberate growth push demands it, and note why in the pack. Change a formula mid-year and you've broken the comparison that makes the report worth reading.

Start the Next Closed Month with Five Lines

Pick your next closed month and write five lines before you buy any software: revenue, gross margin, cash collected versus billed, debtor days, and one leading indicator such as conversion or utilisation. Fill in the formula, source, owner, target and red action for each, using the build routine above.

Put the first review in the diary for five working days after month end and ban new metrics until that meeting has happened twice. If the books aren't reconciled by then, fix the bookkeeping cut-off before trusting any dashboard built on top of it. A report that can't be compared with last month isn't a report, it's a screenshot.

A report also needs a rhythm that survives busy months. Stewart Accounting Services works with UK SMEs on bookkeeping, regular reporting and cash flow planning, with the aim of building long-term relationships rather than preparing accounts once a year, and we help clients reduce costs, improve income and improve cash flow. Using the latest software, we build fully interlinked financial projections so a change in one area shows its effect elsewhere, which is what keeps a monthly pack comparable rather than decorative.

Bring three things to a first conversation: last month's debtors list, last month's gross margin, and the decision you keep postponing. Start at stewartaccounting.co.uk and book a review of your monthly reporting, so the next closed month arrives with five lines already waiting and a decision attached to each one.