Sales reporting for the board – 12 KPIs, dashboards, forecast accuracy

Three typical sales reporting states in a European mid-sized B2B company in 2026: 1) quarterly PowerPoint deck (most common); 2) monthly Excel spreadsheet (second most common); 3) no regular reporting – the board asks when it wants to see a number (third most common).

All three share a flaw: the board does not see sales in real time. It reacts to weak results only when the report lands on the table. That is usually 4–12 weeks after the actual problem appeared. By then the pipeline is even weaker, leads keep getting lost, reps lose motivation. A single bad decision made too late can cost the company a quarter's revenue.

The mechanism is repeatable. The sales manager notices a pipeline drop in June. Decides it is temporary – does not alert the board. July – pipeline still weak. August – holidays, "natural seasonal dip". September – pipeline at 60% of target, the board finds out from the quarterly report. By October it is too late to save Q4.

Professional reporting eliminates this mechanism. The board has a dashboard visible at all times (not only at meetings). Every KPI has a 12-month trend and target comparison. Anomalies visible in 1 week (not 12). Corrective decisions made when there is still time to execute. This article shows how to build it.

The board of a mid-sized B2B company does not need 50 charts. It needs 12 KPIs that together give a full read on sales health. Each KPI has a clear data source (CRM), a clear benchmark (vs industry or internal target) and a clear alert threshold (when it needs intervention).

KPI 1 – Revenue (closed revenue in period). Absolute number, target comparison, 12-month trend. The most obvious, most reported. Often the only one the board sees – which leads to reactive management.

KPI 2 – Pipeline value (weighted). Sum of pipeline opportunity values weighted by probability. Shows the revenue that CAN close in the next period. A fuller picture in our article on sales pipeline.

KPI 3 – Pipeline coverage ratio. Ratio of weighted pipeline to the period target. B2B benchmark: 3x (for every EUR 1 of target, the company needs EUR 3 of weighted pipeline). Drop below 2x = alarm signal.

KPI 4 – Win rate. Percentage of pipeline opportunities ending in Closed Won. B2B benchmark: 20–35%. Drop below 15% = lead qualification or quote quality problem.

KPI 5 – Average deal size (AOV). Trend shows whether the company is selling larger or smaller deals. AOV growth of 20% with constant deal count = +20% revenue.

KPI 6 – Sales cycle length. Average days from SQL to Closed Won. Shorter cycle = more deals in the same time. Shortening cycle by 30% means 30% more revenue (at constant team capacity).

KPI 7 – Lead-to-close conversion. Percentage of top-of-funnel leads ending in Closed Won. Shows full funnel effectiveness.

KPI 8 – Sales velocity. Measures speed of revenue generation: (opportunity count × win rate × average value) / cycle length. Velocity growth = systemic improvement in the sales process.

KPI 9 – Activity metrics. Number of calls, emails, meetings per rep per week. Shows team activity (not outcome, but leading indicator).

KPI 10 – Quota attainment. Percentage of reps hitting quarterly target. Benchmark: 60–70%. Drop below 40% = targeting system poorly calibrated.

KPI 11 – New logo revenue vs existing customer revenue. Ratio of new client revenue to existing client revenue. Shows the company's dependency on the existing client base. A fuller picture in our article on customer success.

KPI 12 – Forecast accuracy. Forecast accuracy vs actual outcome in the period. A KPI in its own right, measured every quarter. Benchmark: +/-15% quarterly.

After picking KPIs the next step is the dashboard. Three approaches dominate in mid-sized companies: Power BI (most flexible), monday.com (simplest), CRM-native dashboard (fastest to deploy).

Power BI. The most extensive tool. Requires a Power BI consultant to configure (1–3 weeks of work, EUR 3.5–9k). Integrates with every CRM (Dynamics, monday.com, HubSpot, Pipedrive, Salesforce) and other company systems (ERP, marketing automation). Dashboard visible in Microsoft Teams, on a SharePoint page, in the Power BI app. Best choice for companies on Microsoft 365.

monday.com Dashboards. Simplest to configure. Dashboard visible inside monday.com. Configuration without a developer – 2–5 days of consultant or in-house ops work. Limitations: harder to add data from outside monday.com (e.g. ERP data). Best choice for companies with monday.com as the main CRM.

CRM-native dashboards (Dynamics, HubSpot, Salesforce). Fastest to launch (1–3 days). Usually sufficient to start. Limitations: harder to build a view combining data from multiple systems. A good temporary dashboard choice, until the company deploys Power BI or a dedicated BI.

Practical recommendation: for a 50–250 person company in the Microsoft 365 ecosystem – Power BI. For a 25–100 person company with monday.com as the main tool – monday.com dashboards. For a company starting reporting and still unsure on KPIs – CRM-native dashboard for the first 6 months.

A dashboard with 12 KPIs alone is not enough. Without a reporting rhythm the board looks at the dashboard occasionally, draws no conclusions, makes no decisions.

Weekly (60 min, sales manager + reps). Weekly review of weighted pipeline, top opportunities, activity metrics. Decisions: time allocation on specific deals, escalations, next-week plan. Format: live at the meeting, dashboard visible.

Monthly (90 min, sales manager + head of sales + CFO). Monthly review of all 12 KPIs. Trend analysis, anomaly identification, strategic decisions (e.g. pricing correction, decision on a new marketing campaign, team training decision).

Quarterly (3h, board + sales + marketing + finance). Full quarterly analysis. Forecast accuracy measured and pulled as KPI. Next-quarter plan. Budget and hiring decisions.

Annual (1 day, board + leadership team). Full annual analysis. Targets for the next year. Strategy.

The key: the rhythm must be scheduled in the calendar for the entire year. Without that, the first 2 months work and it then fades.

Forecast accuracy is a reporting KPI most European mid-sized companies do not measure at all. It is usually the largest gap in reporting maturity – without it the board does not know whether to trust the dashboard numbers.

Definition: forecast accuracy = (actual revenue in period) / (forecast given at the start of the period). 1.0 = perfect forecast. 0.85 = forecast was 15% overstated. 1.15 = forecast was 15% understated.

Tracking over time. Forecast accuracy measured every quarter, at the end of each quarter. Recorded in the dashboard as a 12-month trend. Shows whether the company is learning to forecast more accurately.

Benchmarks: first 6 months of discipline: +/-30%. After 6 months: +/-20%. After 12 months: +/-15%. After 18 months: +/-10%. Better than +/-10% is hard to achieve in a mid-sized company (too many one-off fluctuations).

Corrective actions: if forecast accuracy is systematically beyond +/-25%, the problem is in CRM data quality (reps do not update statuses, probabilities are set rigidly). First action: weekly forecast meeting + rep education. If the problem persists after 3 months – introduce AI scoring (Dynamics Sales Insights, HubSpot AI). A fuller picture in our article on sales forecasting.

How many KPIs should I report to the board? 12 is a good balance. Fewer (5–7) loses the picture. More (20+) loses the insights. The key: 12 KPIs with stable definitions (do not change them every quarter).

Do we need Power BI? Not always. For a 25–100 person company on monday.com – monday.com dashboards are enough. For a 100+ person company on M365 – Power BI gives materially better flexibility.

How much does deploying sales reporting cost? EUR 5.5–14k of consultant work (KPI audit, tool configuration, CRM integrations, training). Deployment time: 6–10 weeks.

Should everyone in the company see the sales dashboard? The board, sales, marketing, customer success, finance – yes. Other employees – no (sensitive data). Role-based access.

What if the board does not look at the dashboard? Most common reason: the dashboard has too many charts or is poorly accessible. First action: simplify to 12 KPIs on one screen, push access in Microsoft Teams or Monday morning email with a link. Second action: monthly meeting with the dashboard as central piece.

Is AI in reporting worth it? Yes, but only in year two. Year one – tidy up KPIs, dashboard, cadence. Year two – Power BI Copilot for the board (natural-language questions), AI scoring for forecast accuracy.

Sales reporting in a mid-sized B2B company is no longer a quarterly PowerPoint deck. In 2026 it is a dashboard visible at all times, 12 KPIs with a 12-month trend, weekly/monthly/quarterly cadence and forecast accuracy as a separate KPI.

Deployment cost: EUR 5.5–14k of consultant work + optionally a Power BI licence (included with Microsoft 365). Time: 6–10 weeks. Effect: the board reacts to anomalies in 1 week (instead of 12), forecast accuracy improves by 30–50%, budget and hiring decisions based on numbers (not intuition).

A fuller picture in our articles: sales pipeline, lead management workflow and sales forecasting – from intuition to AI.