# KPI report for a business owner: what goes in it, and how to build it from your CRM

https://salesbond.app/blog/kpi-report-business-owner/
Published: 2026-11-02 · Updated: 2026-11-14

A KPI report is a periodic document that shows a handful of key numbers against their targets, with a short explanation of what changed. For an owner of a sales business it should fit on one page, take every number from the CRM and say how reliable those numbers are.

Most KPI report templates leave out the reliability part. The guides written for any department of any company say pick metrics, add charts, present to stakeholders, and none of them says which six to eight numbers an owner of a small sales team should read, which CRM field each comes from, or how to tell whether the number is true.

## A KPI report for an owner, in one paragraph

Eight lines at most, one period. Each line carries a KPI, its target, this period’s value, the previous period for comparison, and one sentence from whoever prepared it saying why it moved. On top sits a header with the period, the pipelines included and the moment the data was pulled. At the bottom, a reliability note: how much of the open pipeline has no amount, no close date or no owner. If yours runs to a second page, it has turned into a sales report or a deck, which are different documents with different readers; we covered [what goes in a sales report](https://salesbond.app/blog/sales-report-what-to-include-built-from-crm/) separately. The owner is not going to act inside the CRM; they will ask one or two questions on Monday, and the short page exists to make those the right questions.

## Report or dashboard: which one answers which question

A dashboard answers “what is happening now”. A report answers “what happened in the period, and why”. The owner needs both, on different rhythms, and the mistake we see most often is making one do the other’s job.

A dashboard refreshes every time you open it, which is exactly why it cannot be teh record of the month. The number you saw on the 3rd is gone by the 10th, and nobody wrote down why it changed. A report is frozen at the moment it was pulled, with a comment next to every number. Someone can be held to it a month later.

So keep a KPI dashboard for the owner’s weekly glance, with the tiles tied to CRM fields the way we laid out in [the KPI dashboard for a business owner](https://salesbond.app/blog/kpi-dashboard-business-owner/), and a KPI report as the written record of the period.

## Eight KPIs an owner can read in five minutes

Pick from these eight, and cut to six if the business is simple. Every one of them is calculated from fields that already exist in a standard CRM pipeline: deal value, stage, expected close date, won or lost date, next activity, owner, organization. If a KPI on your list cannot be traced to a field, nobody can check it, so leave it off.

| KPI | The owner’s question | Calculated from |
| --- | --- | --- |
| Won revenue vs plan | Did we make the number? | Value of deals with a won date in the period, against the period target |
| Forecast for the next period | What will we make? | Open deals with an expected close date in the next period, by stage, value |
| Win rate | Do we sell what we open? | Deals won divided by deals closed (won plus lost) in the period |
| Deal cycle | How long does money take to arrive? | Won date minus created date, median across won deals in the period |
| Conversion by stage | Where do deals die? | Stage change history: deals entering each stage versus deals leaving it forward |
| Money at risk | How much of the open pipeline is quietly stuck? | Open deals with no next activity, a past expected close date, or an empty amount |
| Repeat customers | Are existing customers coming back? | Organizations with two or more won deals; share of won revenue from them; customers past their usual reorder interval |
| Customer concentration | Who could hurt us by leaving? | Top-10 organizations by won value, as a share of the period’s revenue |

Win rate and conversion by stage are the two most often confused. Win rate is one figure for the whole funnel; conversion by stage is one per stage and tells you where the funnel narrows. If there is room for only one, take conversion by stage, because a falling win rate always has a stage behind it.

Money at risk is the open pipeline that shows a warning sign: no next activity, a close date already behind it, or no amount at all. Most teams leave it off because it is not in the CRM’s default reports, and it is the KPI we would fight hardest to keep. [Money at risk](https://salesbond.app/blog/revenue-at-risk-sales-pipeline/) is the earliest warning about next month, and revenue against plan only describes the month that has closed.

## Targets, thresholds and the one-line comment

Each line needs a target, a flag rule and one sentence of comment, and our short piece on [what a KPI is](https://salesbond.app/blog/what-is-a-kpi/) helps when someone on the team asks where the number comes from.

Won revenue and the forecast take their targets from the plan. For win rate, deal cycle and conversion by stage, use last quarter’s own value: the point is to see the direction. For money at risk pick a share of open pipeline you can live with.

Our flag rule is plain. A KPI is flagged when it is behind target by more than the elapsed part of the period explains, so half the plan mid-month is fine and half the plan on the 28th is not. Rates and cycle times have no elapsed part, so they are flagged only when they are worse than target by more than a few points. Write the rule into the template once, and a flag means the same thing every month.

The comment names a cause the owner can check in the CRM. “Forecast down because two Proposal-stage deals moved their close date to next quarter” is the kind of comment that works; “Forecast softened due to market conditions” sends the owner nowhere. The head of sales writes it, since only the person who talked to those customers knows whether a moved date is a delay or a polite no.

## The one-page KPI report template, and an example you should not quote

The skeleton is deliberately plain. Header: period, pipelines included, timestamp of the data pull. Then the eight rows: KPI, target, this period, previous period, comment, with flagged rows marked. Then the reliability line: share of open deals with no amount, no expected close date, no owner. Optionally, three sentences at the bottom on what went well, what went wrong and what is being done about it.

![One-page KPI report template: eight KPI rows with target, this period, previous and comment columns, two flagged rows, reliability line](https://salesbond.app/wp-content/uploads/2026/11/kpi-report-business-owner-2.png)

Every number in the example is invented to show the shape of the page, so do not quote it, benchmark against it or put it in a deck.

A hypothetical team of four reps, one pipeline, month of October.

| KPI | October | Plan or previous | Comment |
| --- | --- | --- | --- |
| Won revenue | 180,000, flagged | plan 220,000 | Two deals worth 55,000 together moved their close dates into November |
| Forecast for November | 240,000 | plan 220,000 | Includes those two deals, so the forecast is borrowing from October |
| Win rate | 31% | previous 34% | Three losses to “no decision”, none to a competitor |
| Deal cycle, median | 46 days | previous 41 days | The Proposal stage is where the extra days sit |
| Conversion, Proposal to Negotiation | 38%, flagged | previous 52% | Same cause |
| Money at risk | 96,000 of 410,000 open | n/a | 61,000 of it is eleven deals with no next activity |
| Repeat customers | 44% of won revenue | n/a | Four customers past their usual reorder interval, named |
| Customer concentration | Top-10 customers 71% of revenue | n/a | The largest one 27% |

Reliability: 18% of open deals have no amount, 9% no close date, 3% no owner.

With 18% of open deals missing an amount, the 96,000 of money at risk is a floor, and that is the reason the reliability line belongs in the report.

Each CRM gap breaks a different KPI. Empty amounts pull won revenue, the forecast and money at risk down together, so the page looks consistent while being wrong, and missing close dates turn the forecast into a guess. Making the amount and the expected close date required at a given stage does more for next month’s report than any change to the the layout. To measure the gaps before plugging them, we keep a list of [the CRM data quality metrics worth tracking](https://salesbond.app/blog/crm-data-quality-metrics/).

## Monthly KPI report, weekly note

For a team of two to ten reps, a monthly KPI report and a weekly look at the dashboard is the rhythm that holds. A month has enough closed deals for win rate and deal cycle to mean something. A weekly report on a small team swings on two deals, and the comments turn into noise.

The exception is money at risk and the reliability line. Those two move weekly and its cheap to pull them, so some teams send a one-line weekly note with just those and the full page monthly. We described the whole owner and head of sales set, and how the weekly and monthly pieces fit together, in [the CRM reporting set with a weekly cadence](https://salesbond.app/blog/crm-reporting-owner-head-of-sales-report-set-weekly-cadence/).

Whatever the rhythm, fix the day, so the owner knows when to expect the page and notices when it is late.

## Building it from the CRM without a Friday spreadsheet

Most of the page above is a filter and a sum over fields the CRM already has. Nobody should be redoing that by hand every month. We build SalesBond, a sales management layer on top of the CRM a team already uses. It works with Pipedrive, HubSpot, Salesforce, Zoho CRM, Microsoft Dynamics 365, Freshsales, Close, monday CRM, Copper, Zendesk Sell, Nutshell, Insightly, Attio, Bitrix24 and Kommo (amoCRM).

The way in is a free CRM audit. SalesBond looks at the last 30 days of the connected CRM and sends a PDF report, CRM Report. Seven days later a second PDF shows what changed, if the team has worked on the findings, and the report stays weekly after that.

Mapped onto the eight KPIs: money at risk, conversion by stage (the pipeline bottleneck section), repeat customers and customer concentration (the top-10 clients section) come straight from it. Its CRM score with five sub-scores is the template’s reliability line turned into one number you can follow week to week. Won revenue against plan and the forecast are not CRM Report sections; in SalesBond they live in Sales Plan. Win rate and deal cycle come from the CRM’s own reports.

Two limits. The numbers are deterministic, computed from the CRM records, and AI writes only the summary text and the stage-name suggestions. The report names the deals and the money, but the one-line comment is still yours to write, and SalesBond does not create tasks in the CRM without a person deciding to.

For a first KPI report the audit is useful for a reason other than the numbers: it tells you, before you design the template, how much of your CRM the template can be trusted with. If the reliability side comes back weak, fix the missing amounts and close dates first and build the eight-KPI page a month later. [Check your CRM with SalesBond](https://salesbond.app/).

## FAQ

**How do I create a KPI report?**
 Pick six to eight KPIs that each trace to a CRM field, and write a target and a flag rule next to each. Pull the fields for the period, add a one-line comment per KPI and a reliability line for the open pipeline. The template above is the owner’s version; a head of sales needs per-rep and per-stage detail on a separate page.

**What is a KPI example?**
 Won revenue against plan: the value of deals with a won date inside the period, compared with the period target. Two fields, deal value and won date, and one number from the plan.

**Can you provide an example of a KPI report?**
 The hypothetical October page in this article: eight rows, two of them flagged, a comment per row, and a reliability line. The numbers are invented, so copy the shape and ignore the values.

**What are the top 3 KPIs for a sales business owner?**
 Won revenue against plan, money at risk and customer concentration. The first says what happened, the second what is about to, the third how much of the business depends on one or two names. Forecast comes fourth, once the expected close dates in the CRM are filled in well enough to trust it.
