Blog · Board and management reporting · Sales teams
Choose sales reports by the management decision each one supports. Work through pipeline coverage, closed outcomes and a bookings-to-revenue reconciliation using checked export figures.
The best Salesforce reports for sales managers connect open pipeline, closed outcomes and reported revenue to a specific decision. Start with the management question, agree on the population and dates, then select the report that answers it.
Salesforce's own introduction describes reports as a way to summarize, group and filter records; its opportunity example groups records by stage. That makes a useful starting point for a manager's review, as Salesforce's reporting guide explains. The selection below is a proposed management pack, rather than a list of official report names.
Covirage is not affiliated with Salesforce.
Give each view a question, a measure and a person responsible for acting. A chart that cannot change the conversation usually belongs outside the weekly review.
| Recommended view | Question it answers | Required export fields | Management action |
|---|---|---|---|
| Open pipeline by rep and close period | Where is the target least supported? | Opportunity ID, owner, stage, amount, expected close date | Inspect coverage gaps and deal readiness |
| Closed outcomes by rep | Where are opportunities being won or lost? | Opportunity ID, owner, closed status, close date, amount | Review losses and coaching needs |
| Stalled opportunities | Which open deals need a next step? | Opportunity ID, owner, stage, stage duration, next step | Confirm progress or revise the expected timing |
| Large-deal exposure | Which opportunities dominate the plan? | Opportunity ID, owner, amount, close period | Prepare alternatives for concentrated exposure |
| Bookings-to-revenue bridge | Why do sales and finance totals differ? | Opportunity ID or contract ID, booked value, recognition schedule, ledger period | Resolve missing mappings and timing differences |
The stalled-deal approach has direct vendor support: Salesforce's stuck-opportunity guidance describes using stage duration and recommends choosing thresholds with sales leadership. Set those thresholds from your selling process. A long procurement cycle and a routine renewal need different expectations.
Keep the detailed work queue beside the summary. The distinction between a dashboard, report and list matters here: the report explains the result, while the list identifies the opportunities someone must work.
Consider Cedar Industrial Supply, an illustrative US distributor reviewing September 2026. Sales operations supplies the opportunity export and rep targets. Finance supplies a contract-to-revenue bridge for the same period. All amounts are USD, with no currency conversion in this example.
The pipeline is a snapshot taken on September 1 for opportunities expected to close during September. Closed outcomes cover September 1 through September 30. The report preserves these separate dates so nobody mistakes a starting pipeline balance for an ending balance.
Use one opportunity row per opportunity in the pipeline and outcome summaries. If a second file has multiple product lines or invoices for that opportunity, total those rows separately before comparing amounts. Keep the unique opportunity identifier through the review so an unusual result can be traced back.
The rep summaries below are the input totals for the worked calculations. Targets are booking targets for the full month, rather than recognized-revenue targets.
| Rep | September target (USD) | Starting open pipeline (USD) | Closed wins | Closed losses | September bookings (USD) |
|---|---|---|---|---|---|
| Ana | 200,000 | 480,000 | 3 | 2 | 180,000 |
| Ben | 150,000 | 360,000 | 2 | 3 | 120,000 |
| Cy | 150,000 | 150,000 | 1 | 3 | 70,000 |
| Total | 500,000 | 990,000 | 6 | 8 | 370,000 |
Starting pipeline coverage = Starting open pipeline / Full-period booking target
Closed-opportunity win rate = Closed wins / (Closed wins + Closed losses)
| Rep | Coverage calculation | Coverage | Win-rate calculation | Win rate |
|---|---|---|---|---|
| Ana | 480,000 / 200,000 | 2.40x | 3 / (3 + 2) | 60.0% |
| Ben | 360,000 / 150,000 | 2.40x | 2 / (2 + 3) | 40.0% |
| Cy | 150,000 / 150,000 | 1.00x | 1 / (1 + 3) | 25.0% |
| Team | 990,000 / 500,000 | 1.98x | 6 / (6 + 8) | 42.9% |
Coverage is rounded to two decimals and percentages to one decimal. The team win rate divides total wins by total closed opportunities. It does not average rep percentages. Booking attainment is 370,000 / 500,000 = 74.0%.
Ana and Ben started with the same coverage ratio but finished with different closed win rates. That is a prompt to inspect deal mix and losses, rather than proof that either rep caused the difference. Cy's smaller starting coverage makes opportunity supply worth examining alongside execution. These are small closed populations, so inspect the underlying deals before drawing a broad conclusion.
Keep the pack consistent with the definitions in your monthly sales report. A different denominator in each meeting makes a trend impossible to interpret.
For this illustration, finance confirms that current bookings, the portion recognized later and revenue from earlier bookings explain the entire difference. Real schedules may need additional lines for credits, modifications or other approved adjustments.
| Rep | Current bookings (USD) | Current bookings recognized later (USD) | Revenue from earlier bookings (USD) | September ledger revenue (USD) |
|---|---|---|---|---|
| Ana | 180,000 | 40,000 | 10,000 | 150,000 |
| Ben | 120,000 | 20,000 | 5,000 | 105,000 |
| Cy | 70,000 | 10,000 | 15,000 | 75,000 |
| Total | 370,000 | 70,000 | 30,000 | 330,000 |
The bridge is 370,000 - 70,000 + 30,000 = $330,000. Each rep row follows the same identity. Sum the recognized-revenue rows and compare them with the ledger extract; the difference should be zero after all approved reconciling items are included.
Sales operations owns the opportunity population and target assignment. Finance owns the recognition classifications and ledger reconciliation. The manager owns the resulting account and coaching decisions. Preserve that division of responsibility when someone asks why bookings and revenue do not match.
For a recurring pack, sales-report automation covers the broader preparation workflow. Keep this selection exercise focused on which decisions deserve a place in the review.
Bring your opportunity export, target file and finance-approved revenue schedule to Covirage. Covirage maps the columns; its tools compute and check the comparisons, and 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 export. Creating an account takes about a minute; then you set up your business and bring your data.
See sales intelligence for the supporting sales-review context.
Start with the decision due next. For a forward review, inspect open pipeline against the matching target period. For a completed period, start with closed wins and losses, then reconcile booked amounts with the finance revenue schedule before interpreting rep results.
It can differ because a contract can be booked before its revenue is recognized, while earlier contracts can generate current revenue. Use a finance-approved bridge between the two measures. A difference is something to explain before treating it as an error.
Keep only reports that lead to an owner action, a coaching decision or a change in priorities. A compact pack can cover pipeline, outcomes, stalled deals and revenue reconciliation. Add a separate report when it answers a question the existing views cannot resolve.