Blog · Board and management reporting · Sales teams
Choose a KPI for commercial manager reviews that connects net revenue, price realization, gross profit and customer growth. Work a segment example against targets and isolate the effect of one changed input.
A useful KPI for commercial manager reviews connects revenue with the price, margin and customer movement behind it. Track net revenue and gross profit against plan, then use price realization and customer growth to explain the result. A sales target on its own cannot show whether the business earned acceptable economics.
Commercial management joins pricing, customer decisions and financial outcomes. Keep pipeline stage definitions and activity coverage in the existing B2B sales KPI guide. The scorecard here focuses on what the company actually sold, what it earned and how its customer base changed.
| Measure | Calculation | File needed | Review question |
|---|---|---|---|
| Net revenue attainment | Net revenue / Revenue target | Invoice register and approved targets | Did recognized sales meet the plan? |
| Price realization | Net revenue / List value for the same units | Invoices and effective price list | How much of the applicable list value was retained? |
| Gross profit attainment | Gross profit / Gross profit target | Sales, matched COGS and targets | Did sales deliver the planned gross profit dollars? |
| Gross margin | Gross profit / Net revenue | Sales and matched COGS | What share of revenue remained after COGS? |
| Revenue growth | Current revenue / Prior revenue − 1 | Matched-period sales | How much did the comparable business grow? |
| Net customer growth | (New customers − Lost customers) / Starting customers | Customer history | Did additions exceed losses on a consistent basis? |
Net sales should reflect discounts, returns and allowances. The IRS explanation of gross profit subtracts returns and allowances from gross receipts, then subtracts cost of goods sold from net receipts. The example uses that relationship, without treating the management scorecard as a tax return.
Gross profit is not operating profit. The SEC's financial statement guide distinguishes the costs subtracted to reach gross profit from operating expenses that follow. Keep selling expenses and service costs visible elsewhere when they affect an account's economics.
A US industrial distributor reviews the quarter ended March 31, 2026. Its core and specialty segments have distinct products; equivalent units are standardized within each segment. All revenues are net of recorded credits and rebates, all costs match the units sold, and the price list is the effective list applicable to those units.
| Segment | Units sold | List price per unit (USD) | Net revenue (USD) | COGS (USD) | Revenue target (USD) | Gross profit target (USD) | Prior matched revenue (USD) |
|---|---|---|---|---|---|---|---|
| Core | 10,000 | 100 | 920,000 | 600,000 | 950,000 | 320,000 | 850,000 |
| Specialty | 5,000 | 160 | 760,000 | 470,000 | 800,000 | 300,000 | 700,000 |
| Total | 15,000 | 1,680,000 | 1,070,000 | 1,750,000 | 620,000 | 1,550,000 |
List value is units multiplied by the applicable list price. Gross profit is net revenue less COGS. Compute the ratios from those amounts and display percentages to one decimal place, retaining full precision in the calculations.
| Measure | Core | Specialty | Total calculation | Total |
|---|---|---|---|---|
| List value (USD) | 1,000,000 | 800,000 | 1,000,000 + 800,000 | 1,800,000 |
| Net revenue attainment | 96.8% | 95.0% | 1,680,000 / 1,750,000 | 96.0% |
| Price realization | 92.0% | 95.0% | 1,680,000 / 1,800,000 | 93.3% |
| Gross profit (USD) | 320,000 | 290,000 | 1,680,000 − 1,070,000 | 610,000 |
| Gross profit attainment | 100.0% | 96.7% | 610,000 / 620,000 | 98.4% |
| Gross margin | 34.8% | 38.2% | 610,000 / 1,680,000 | 36.3% |
| Revenue growth | 8.2% | 8.6% | 1,680,000 / 1,550,000 − 1 | 8.4% |
Core missed its revenue target while meeting its gross profit target. Specialty missed both. That points to different conversations, even though both segments recorded growth. Review the approved plan's unit and cost assumptions before assigning a price or cost explanation to either variance.
The price realization guide owns the detailed comparison of invoice prices with list prices. Here, price realization explains commercial outcomes alongside margin; it does not establish that every difference from list was unauthorized.
Define a customer as a stable buying-account ID assigned to one segment for this example. New customers had no qualifying purchases before the quarter; lost customers meet the company's declared inactivity rule at quarter-end. An account cannot enter both categories in this bridge.
| Segment | Starting customers | New customers | Lost customers | Ending customers | Net customer growth |
|---|---|---|---|---|---|
| Core | 100 | 12 | 7 | 105 | 5.0% |
| Specialty | 60 | 8 | 3 | 65 | 8.3% |
| Total | 160 | 20 | 10 | 170 | 6.3% |
The total check is 160 + 20 − 10 = 170. Net customer growth is (20 − 10) / 160 = 6.25%, displayed as 6.3%. Keep the unrounded result for subsequent calculations.
Customer count growth does not establish the value of the retained base. Losing a major account while adding small accounts can increase the count and damage economics. Use the linked customer KPI guide for the broader customer view, rather than treating this bridge as a retention analysis.
Now change only Core's net revenue from $920,000 to $950,000. Assume the same units, list prices, COGS, targets, prior revenue and customer records. This is a controlled illustration of improved realized price on identical sales, rather than a second operating forecast.
| Company measure | Original | With Core net revenue changed | Calculation after change |
|---|---|---|---|
| Net revenue (USD) | 1,680,000 | 1,710,000 | 950,000 + 760,000 |
| Revenue attainment | 96.0% | 97.7% | 1,710,000 / 1,750,000 |
| Price realization | 93.3% | 95.0% | 1,710,000 / 1,800,000 |
| Gross profit (USD) | 610,000 | 640,000 | 1,710,000 − 1,070,000 |
| Gross profit attainment | 98.4% | 103.2% | 640,000 / 620,000 |
| Gross margin | 36.3% | 37.4% | 640,000 / 1,710,000 |
| Revenue growth | 8.4% | 10.3% | 1,710,000 / 1,550,000 − 1 |
| Ending customers | 170 | 170 | Customer inputs unchanged |
The $30,000 increase in revenue adds $30,000 to gross profit because the illustration holds COGS fixed. Gross margin increases by 1.1 percentage points using unrounded ratios. The gross profit margin guide explains the denominator and weighted-total check in more detail.
In actual records, verify that higher net revenue was not accompanied by additional rebates, delivery obligations or incremental costs. A one-input illustration isolates a relationship; real account decisions need the complete economics.
Tie segment revenue and COGS to the quarterly income statement. Tie list value to the same invoice quantities and effective price records, rather than today's list. Preserve the approved target version so performance cannot improve merely because a target changed afterward.
Company percentages must divide company totals. Do not average segment margins, realization percentages or attainment percentages. The gross profit check is 320,000 + 290,000 = $610,000, which must equal total revenue less total COGS. The customer bridge must reconcile to distinct account IDs after resolving transfers and duplicates.
Finance owns those definitions and checks. The commercial manager owns the explanation and next action, with pricing and account owners resolving their exceptions. Review price leakage, customer mix and costs before deciding which conversation should happen next.
Bring invoice quantities, net sales, matching costs, effective list prices, targets and customer history to Covirage. Covirage maps the columns, and its tools compute and check the segment comparisons; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own data.
See how this supports sales teams connecting commercial actions with recorded outcomes.
There is no universal main measure. Net revenue and gross profit attainment are useful paired outcomes because they show whether sales and economics meet the plan. Price realization and customer movement then help explain the result and identify the action an owner should take.
No. Revenue can rise because of discounting, acquisitions or a shift toward lower-margin products. Add gross profit, margin and a consistent customer cohort. Then separate changes in realized prices, costs and product mix before deciding whether the growth improved the business.
Use the close cadence for reconciled financial outcomes and a more frequent operational review for actions that can still change them. Mark provisional cost or rebate estimates clearly. Compare periods with equivalent cutoffs rather than putting incomplete current sales beside a fully closed prior period.
The commercial manager owns the actions and explanations, finance owns the financial definitions and reconciliation, and account owners validate customer changes. Price-list and cost owners resolve their respective exceptions. One accountable reviewer should approve the final scorecard boundaries and target versions.