Blog · Board and management reporting
A scorecard dashboard connects each business objective to an actual result, an approved target, and an accountable owner. Follow a worked example with source totals, directional scoring, and a checked weighted result.
A scorecard dashboard compares each business objective with an actual result, an approved target, and an accountable owner. It tells a leadership team where performance falls short and which decision follows. Its value comes from consistent definitions and checked source figures, rather than from a particular chart style.
Write the objective before choosing the measure. Protecting margin, improving delivery reliability, reducing invoice errors, and building workforce capability require different evidence. A sales total alone cannot stand in for all of them.
For every objective, state what management will do when the result misses its target. That might mean reviewing discounts, changing warehouse staffing, correcting billing controls, or assigning training time. A measure without a possible decision is a weak candidate for the leadership page.
NIST's guidance on performance measurement emphasizes understandable, timely measures that inform decisions and support organizational goals. Use that test to keep the report focused.
A strategy dashboard follows the broader relationship between initiatives and outcomes. This scorecard concentrates on the objective-to-measure comparison used at the review meeting.
Keep a measure register alongside the business exports. Each definition needs its numerator, denominator, reporting period, exclusions, direction, target, owner, and effective date. Store the approved target separately from the actual result so a later target revision cannot rewrite past performance unnoticed.
An illustrative US industrial distributor, Cedar Supply, prepares its September 2026 scorecard from these files:
| Source file | Record represented by a row | Fields used |
|---|---|---|
| Sales and cost export | Posted invoice line | Invoice ID, date, net revenue, matched product cost |
| Delivery register | Completed order | Order ID, promised date, actual date, complete flag |
| Billing review | Reviewed invoice | Invoice ID, review date, error flag |
| Training roster | Employee assignment | Employee ID, required course, completion status |
Aggregate each file independently. Joining every invoice line to every delivery event can multiply revenue. Also keep the billing review population separate from the delivery population: they measure different events and need different denominators.
The CRM data quality scorecard addresses completeness and validity checks when account records support the measures. Business performance needs equally clear evidence about which records were usable.
The following tables contain the period inputs. Cedar uses posted net sales and matched cost for margin, completed orders for delivery, reviewed invoices for errors, and required employee assignments for training.
| Measure | Gross profit (USD) | Net sales (USD) | Calculation | Actual |
|---|---|---|---|---|
| Gross margin | 288,000 | 1,000,000 | 288,000 / 1,000,000 | 28.8% |
For the count-based measures, the numerator records qualifying orders, invoices with errors, or completed assignments, respectively. The denominator records the full eligible population.
| Measure | Numerator (count) | Denominator (count) | Calculation | Actual |
|---|---|---|---|---|
| On-time, complete delivery | 225 | 250 | 225 / 250 | 90.0% |
| Invoice error rate | 12 | 600 | 12 / 600 | 2.0% |
| Training completion | 54 | 60 | 54 / 60 | 90.0% |
The margin numerator means revenue minus matched cost, using the same accounting scope throughout. The detailed cost definition belongs in the gross profit margin guide; here the control is to reconcile both source totals before scoring.
Now compare actuals with targets approved for this period. The gap is actual minus target, expressed in percentage points. Positive gaps are unfavorable for the error rate because lower is better.
| Objective | Measure | Actual | Target | Gap (percentage points) | Owner |
|---|---|---|---|---|---|
| Protect earnings | Gross margin | 28.8% | 32.0% | -3.2 | Finance director |
| Keep delivery promises | On-time, complete delivery | 90.0% | 96.0% | -6.0 | Operations director |
| Improve billing accuracy | Invoice error rate | 2.0% | 1.5% | +0.5 | Billing manager |
| Build coverage of required skills | Training completion | 90.0% | 100.0% | -10.0 | Department leaders |
These targets are example management choices, not industry benchmarks. For a broader selection of objectives, use balanced scorecard KPIs rather than adding unrelated measures to this page.
Cedar elects to show a weighted summary, with attainment capped at full target achievement. This prevents overachievement on one measure from canceling a shortfall on another.
Higher-is-better attainment = Actual / Target.
Lower-is-better attainment = Target / Actual.
Weighted points = Weight × MIN(Attainment, 100%).
Weights below are percentage-point contributions to a possible total of 100. The inverse formula requires a positive actual and target. A zero defect result or a zero target needs a separately approved rule; negative values also require a different scoring convention.
| Measure | Attainment calculation | Attainment | Weight | Weighted points |
|---|---|---|---|---|
| Gross margin | 28.8 / 32.0 | 90.00% | 40 | 36.000 |
| Delivery | 90.0 / 96.0 | 93.75% | 30 | 28.125 |
| Invoice errors | 1.5 / 2.0 | 75.00% | 20 | 15.000 |
| Training | 90.0 / 100.0 | 90.00% | 10 | 9.000 |
| Total | 100 | 88.125 |
The summary is 88.13 out of 100, rounding only the final display to two decimal places. It does not mean that 88.13% of company strategy is complete. The result expresses this specific scoring policy. Keep status thresholds separate; the RAG dashboard guide covers those rules.
The weighted points must sum to the displayed total, and the weights must sum to 100. Each numerator must reconcile to its export and each population must match the written definition. Review duplicates, excluded records, missing values, and cutoff dates before approving the scorecard.
The billing manager should examine the error records; the operations director should examine orders that failed the delivery test. Training owners need the outstanding assignments. These are different actions even though each measure contributes to the same summary.
NIST's Baldrige strategy implementation commentary connects action plans with resources, measures, and assessment of progress. Apply that connection by recording an action owner, due date, and evidence required to close each issue.
Bring your approved measure register and a sample of your own sales, delivery, billing, or training export to Covirage. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See metrics governance for the supporting approach to consistent business measures.
A dashboard presents selected business measures for monitoring and investigation. A scorecard adds an explicit judgment against objectives and targets. The same report can serve both purposes when every result has a definition, comparison period, target, and accountable owner.
No. Separate measures often support better decisions than a composite. Use a weighted total only when leaders have approved the weights and scoring rules. Keep the individual results visible so strong performance in one area cannot conceal a serious failure elsewhere.
Mark the result unavailable and name the missing source or approval. Do not substitute zero or silently remove its weight. Publish the coverage limitation beside any summary and resolve the missing input before comparing the score with a complete period.