Blog · Board and management reporting · Sales teams
A B2B dashboard connects account revenue, open opportunities, and service activity. Work through a US distributor's figures, see how one corrected input changes the result, and use the checks to keep the account review honest.
A B2B dashboard puts account revenue, open pipeline, and service activity beside each other so a team can decide where to act. The useful unit is the customer account, with consistent identifiers across the exports. Keep actual revenue, possible future orders, and service workload as separate measures.
The first question is usually practical: which customer needs attention before the next order or renewal? A growing account can have a delivery problem. A shrinking account can have a genuine new opportunity. The dashboard should reveal those combinations without treating one as proof of the other.
This is an account business overview. For a deeper ranking of purchase behavior, use RFM analysis for B2B customers; it answers a different question about recency, frequency, and value. Keep the review here centered on present account performance and the next commercial decision.
Define revenue consistently before comparing periods. The SEC's financial statement guide distinguishes gross revenue from net revenue after returns and allowances. In this example, the ledger supplies net revenue after credits, with the same treatment in both quarters.
Redwood Industrial Supply is an illustrative US distributor. Its sales director reviews the quarter ended September 30, 2026, against the preceding quarter. All amounts are USD. Revenue and cost cover the quarter; opportunities and service cases are snapshots at September 30.
Prepare separate source tables before combining their account summaries:
| Export | Row identifier | Required account fields | Measure fields |
|---|---|---|---|
| Revenue ledger | Transaction ID | Account ID and name | Posting date, net revenue, cost of goods sold |
| Open opportunities | Opportunity ID | Account ID | Stage, amount, expected close date, owner |
| Service cases | Case ID | Account ID | Status, due date, assigned owner |
The account list includes every customer in any source. A customer with no open opportunity still belongs in the revenue view. A prospect with pipeline and no posted revenue should have zero revenue only after confirming the ledger match is complete.
Aggregate each export to account level first. Connecting every invoice directly to every case would repeat revenue when an account has several cases. Preserve the transaction and case identifiers so an account total can be checked against its underlying records.
The revenue and cost portion of Redwood's account review is:
| Account | Prior-quarter revenue (USD) | Current-quarter revenue (USD) | Current COGS (USD) | Gross profit (USD) | Revenue growth |
|---|---|---|---|---|---|
| Atlas Fabrication | 120,000 | 150,000 | 105,000 | 45,000 | 25.0% |
| Beacon Packaging | 100,000 | 80,000 | 60,000 | 20,000 | -20.0% |
| Cedar Components | 80,000 | 90,000 | 54,000 | 36,000 | 12.5% |
| Delta Assembly | 0 | 30,000 | 21,000 | 9,000 | Not applicable |
| Total | 300,000 | 350,000 | 240,000 | 110,000 | 16.7% |
Gross profit is revenue minus cost. Company growth is (350,000 − 300,000) / 300,000 = 16.7%, rounded to one decimal place. The total gross margin is 110,000 / 350,000 = 31.4%, also rounded to one decimal. Delta is a new account, so a percentage growth rate has no valid prior-period denominator.
Now put the account-level opportunity and service summaries beside those actuals:
| Account | Open pipeline (USD) | Open service cases | Past-due service cases |
|---|---|---|---|
| Atlas Fabrication | 60,000 | 2 | 0 |
| Beacon Packaging | 40,000 | 6 | 4 |
| Cedar Components | 100,000 | 1 | 0 |
| Delta Assembly | 50,000 | 1 | 0 |
| Total | 250,000 | 10 | 4 |
Open pipeline is the sum of unclosed opportunity amounts, not revenue. The Salesforce explanation of a sales pipeline describes it as the seller's view of active deals and their sales stages. Redwood keeps that potential business separate from posted sales.
Covirage is not affiliated with Salesforce.
Beacon needs a joint sales and service conversation. Its revenue fell by $20,000, and it has all four past-due cases. It also holds 6 / 10 = 60.0% of open cases. Those facts identify a review priority; they do not establish that service problems caused the revenue decline.
Cedar has the largest open opportunity value. The account owner should confirm the scope, decision maker, and next customer commitment before interpreting that value as growth. Single-contact dependency in key accounts provides the separate relationship check.
The account revenue summaries must return to the ledger: 150,000 + 80,000 + 90,000 + 30,000 = $350,000. The cost total must return to the same reporting scope. Revenue minus cost gives 350,000 − 240,000 = $110,000, matching the gross profit column.
The opportunity total must equal $250,000 in the open-opportunity export after the same filters. The case total must equal ten distinct open case IDs, with four past due. An unmatched account ID belongs on an exception list instead of disappearing from the totals.
Read buying gaps against the account's usual cadence before calling a customer inactive. Setting an account dormancy threshold explains why an infrequent buyer can look quiet while remaining healthy. The dashboard supplies the exception; the account history supplies context.
Suppose finance corrects Beacon's current-quarter net revenue from $80,000 to $100,000 after reversing an erroneous price credit. All cost, pipeline, and case inputs stay unchanged. This is a revenue correction, with no change in units supplied.
| Measure | Original result | With corrected Beacon revenue |
|---|---|---|
| Beacon revenue (USD) | 80,000 | 100,000 |
| Total revenue (USD) | 350,000 | 370,000 |
| Revenue increase versus prior quarter (USD) | 50,000 | 70,000 |
| Company revenue growth | 16.7% | 23.3% |
| Total gross profit (USD) | 110,000 | 130,000 |
| Total gross margin | 31.4% | 35.1% |
The revised growth is 70,000 / 300,000 = 23.3%; revised margin is 130,000 / 370,000 = 35.1%. Percentages are rounded to one decimal. Beacon's revenue is now flat against the preceding quarter, but its service exceptions still need action. A corrected financial input changes the commercial story without closing a single case.
Upload a file or Google Sheet containing your account revenue, opportunity, and service summaries; Covirage maps the columns, and its tools compute and check the figures. 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 Covirage for sales teams for the account review context.
Start with account revenue for comparable periods, open opportunity value, and unresolved service cases. Add gross profit when the cost allocation is reliable. Each measure needs a period or snapshot date, a source, and an owner who can explain exceptions.
A B2B account dashboard follows the customer relationship across sales and service. A sales dashboard may focus on rep attainment, activity, and pipeline. The account view is useful when commercial decisions depend on customer spending and delivery experience together.
Keep them separate. Revenue records completed economic activity under the company's accounting policy; open pipeline represents potential future business. Adding them obscures timing and uncertainty, particularly when opportunities contain renewals or orders that already appear in revenue.
Choose a cadence that matches the decision. A weekly account review can use a fresh opportunity and service snapshot alongside the latest closed accounting period. Label each cutoff so a recent service change is not mistaken for a restatement of closed revenue.