Blog · Board and management reporting
A customer dashboard brings account revenue, margin, buying frequency, and service burden into one comparison. This worked US example shows the source rows, reconciliation checks, and the effect of changing one service-cost input.
A customer dashboard compares account revenue, margin, buying frequency, and service burden over the same period. Its value comes from consistent definitions and totals that tie back to the source files. A large revenue number is only the starting point for deciding where an account needs attention.
This example is an internal commercial overview for sales and finance. It uses exported account data and a small set of measures, with each calculation visible. A customer service dashboard answers operational questions about support activity; the account view below connects selected service costs to commercial outcomes.
A fictional US distributor wants to review account performance for the quarter ended September 30, 2026. It asks which accounts produce gross profit, how often they order, and how much post-sale service they consume. All amounts are USD.
The team uses an account master, an order export, a ledger export, and a service-hours export. Each has the same de-identified account key. The account master supplies one record per account, while the other files contain activity that must be summarized to account level before the summaries are matched.
| Source | Fields used | Required check |
|---|---|---|
| Account master | Account key, active status | One row per account |
| Order export | Account key, order ID, order date | Count distinct eligible orders |
| Ledger export | Account key, net revenue, COGS | Tie totals to the quarter's ledger |
| Service export | Account key, service date, hours | Tie hours to the approved service report |
| Finance cost schedule | Loaded service cost per hour | Confirm the cost boundary and effective period |
Do not match individual order lines directly to individual service records. That can repeat both revenue and hours. Summarize each source at the intended account level first, then confirm that matching the summaries preserves each source total.
Net revenue already reflects discounts and returns under the distributor's reporting policy. The SEC's guide to financial statements explains net revenue after returns and allowances and gross profit after cost of sales. Keep those definitions stable across accounts.
Finance supplies a loaded service rate of $50 per hour. These hours relate to post-sale account support excluded from COGS, so applying the rate does not charge the same cost twice. The rate is an illustrative supplied assumption, not an industry benchmark.
| Account | Net revenue (USD) | COGS (USD) | Distinct orders | Service hours |
|---|---|---|---|---|
| A | 150,000 | 102,000 | 15 | 40 |
| B | 100,000 | 70,000 | 10 | 100 |
| C | 50,000 | 38,000 | 5 | 20 |
| Total | 300,000 | 210,000 | 30 | 160 |
The active-account population is the three accounts shown. Orders count purchases, rather than invoice lines or individual products. The average orders per customer formula covers the eligibility choices when a larger account base includes customers with no purchases.
Gross profit = Net revenue − COGS
Service cost = Service hours × Loaded hourly rate
Contribution after specified service cost = Gross profit − Service cost
The contribution label is deliberate. It excludes sales expense, corporate overhead, financing costs, and any other costs not supplied in this example. It is not net profit.
| Account | Gross profit (USD) | Gross margin | Service cost (USD) | Contribution after service (USD) | Contribution margin |
|---|---|---|---|---|---|
| A | 150,000 − 102,000 = 48,000 | 32.0% | 40 × 50 = 2,000 | 48,000 − 2,000 = 46,000 | 30.7% |
| B | 100,000 − 70,000 = 30,000 | 30.0% | 100 × 50 = 5,000 | 30,000 − 5,000 = 25,000 | 25.0% |
| C | 50,000 − 38,000 = 12,000 | 24.0% | 20 × 50 = 1,000 | 12,000 − 1,000 = 11,000 | 22.0% |
| Total | 90,000 | 30.0% | 8,000 | 82,000 | 27.3% |
Gross margin divides gross profit by net revenue. Contribution margin divides the specified contribution by net revenue. Percentages are rounded to one decimal after calculation; dollar amounts here are exact.
For account A, contribution margin is 46,000 / 150,000 = 30.7%. The company calculation is 82,000 / 300,000 = 27.3%, rather than an equal-weight average of account percentages. The gross profit margin worked example explains the same denominator principle for gross margin.
Buying frequency is 30 / 3 = 10.0 orders per active account for the quarter. That company figure does not mean each account placed the same number of orders; the source rows show the difference. Preserve the account-level counts beside the summary so an average does not hide infrequent buyers.
Three reconciliations make this comparison reviewable:
The distinct order total must also remain 30 when the account summaries are matched. Check unmatched keys before accepting a total: an unmatched service row should not disappear simply because its account has no order in the period.
A spreadsheet summary can help inspect these source totals. Microsoft's PivotTable guidance notes that numeric values normally summarize as sums, while values interpreted as text can produce counts. Confirm the aggregation instead of accepting a plausible-looking number. Covirage is not affiliated with Microsoft.
Now change only account B's service hours from 100 to 160. Revenue, COGS, orders, the account population, and the $50 hourly rate remain the same. This isolates the effect of service effort.
| Measure | Original case | One-input variation | Calculation |
|---|---|---|---|
| B service hours | 100 | 160 | Supplied changed input |
| B service cost (USD) | 5,000 | 8,000 | 160 × 50 |
| B contribution (USD) | 25,000 | 22,000 | 30,000 − 8,000 |
| B contribution margin | 25.0% | 22.0% | 22,000 / 100,000 |
| Total service hours | 160 | 220 | 40 + 160 + 20 |
| Total service cost (USD) | 8,000 | 11,000 | 220 × 50 |
| Total contribution (USD) | 82,000 | 79,000 | 90,000 − 11,000 |
| Total contribution margin | 27.3% | 26.3% | 79,000 / 300,000 |
The extra 60 hours cost $3,000, which explains the entire contribution decline. Gross margin and order frequency do not move. This is why a commercial account review needs the service cost boundary beside its revenue measures.
The account owner should investigate the work behind those hours: unusual onboarding, repeated corrections, or an agreed service obligation may require different responses. The cost-to-serve method covers a fuller allocation when hours alone do not represent the work.
Bring de-identified account, order, ledger, and service exports with compatible keys and periods, plus the supplied service-cost assumptions. Covirage maps the columns, and its tools compute and check the account measures and supporting totals; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See sales insights for the supporting use case.
Start with a defined account population, net revenue, cost of goods sold, distinct orders, and a service measure with a clear cost boundary. Add ratios only when their denominators are available. Every total should reconcile to the exports used for the stated reporting period.
A customer dashboard connects commercial account outcomes with service burden. A support dashboard usually focuses on operational measures such as case volume and response time. Service data can contribute to the account view, but operational speed alone does not measure account profitability.
No. Revenue must be compared with product costs and the service costs included in your definition. An account can generate substantial gross profit while requiring expensive support. Label any contribution measure precisely, because it may exclude sales expense, overhead, and other company costs.