Summary Reports
4 terms in Sales Reports
Period Summary
#A Period Summary report aggregates sales performance and compensation data for a defined time window — typically a month or quarter — giving managers and reps a consolidated view of results. It includes total credited revenue, quota attainment, total incentive earned, comparison to prior period, and YTD cumulative totals. The best versions show both absolute performance and relative position such as rank within team. A critical design consideration is handling adjustments: whether the summary reflects only current-period transactions or includes retroactive adjustments that posted during the period. Most organizations show both a clean-period view and an as-paid view. This is the primary tool reps use to understand their earnings trajectory.
Rep David Kim's Q1 Period Summary: Credited Revenue $412,000, Quota $500,000, Attainment 82.4%, Commission Earned $6,180, New Business Bonus $0 (threshold not met), YTD Total $6,180. Prior Quarter Attainment: 91.2% (-8.8pt decline). Rank: 14th of 22 in Central Region.
Section 8.2 — Period Reporting. The Company shall produce a Period Summary for each Participant at the close of each measurement period. The summary shall reflect total credited performance, quota attainment, incentive earnings by plan component, and cumulative year-to-date totals. Statements available within ten (10) business days following period close.
Period Summary Report: columns for Rep Name, Period, Credited Revenue, Quota, Attainment %, Commission, Bonus, Total Incentive, YTD Attainment, Team Rank. Bar chart comparing attainment across periods. Filterable by team and region.
Plan Summary
#A Plan Summary report evaluates aggregate performance and financial outcomes of a specific compensation plan across all participants. It answers plan-level questions: How many participants hit quota? What is the average payout and total cost as a percentage of revenue? It segments participants into attainment bands (below 50%, 50-80%, 80-100%, 100-120%, above 120%) showing count and average payout in each. Plan designers use this to evaluate motivational effectiveness: a healthy plan shows 55-65% of participants at or above quota. If fewer than 40% hit target, quotas may be unrealistic; if more than 80% hit, the plan is not stretching performance. This report directly feeds annual plan redesign.
FY26 Enterprise AE Plan Summary: 84 participants, average attainment 94%, median 91%. Distribution: 12% below 50%, 18% at 50-80%, 32% at 80-100%, 25% at 100-120%, 13% above 120%. Total plan cost: $8.2M at 4.1% of credited revenue.
Section 14.1 — Plan Performance Review. The Compensation Committee shall review the Plan Summary no less than semi-annually, assessing participation rates, attainment distribution, total expenditure relative to budget, and payout alignment with revenue objectives. Material deviations shall trigger a plan effectiveness review per Section 14.3.
Plan Summary Dashboard: attainment distribution histogram, average/median/P25/P75 statistics, total plan cost vs. budget, cost-of-sale ratio trend, participant count by attainment band. Prior year comparison toggle. Filterable by plan, role, and region.
Team Summary
#A Team Summary report consolidates performance metrics across all members of a sales team, giving managers visibility into collective results, individual contributions, and performance distribution. Key elements include total team revenue, quota attainment, individual attainment range, reps above and below plan, total compensation cost, and revenue-per-rep. It also highlights whether results are concentrated in a few top performers or spread across the team — if 80% of revenue comes from 20% of reps, it signals a coaching or territory imbalance problem. This report drives decisions about resource allocation, coaching priorities, and territory adjustments during pipeline reviews and business reviews.
West Region Q2: 8 reps, Team Revenue $3.1M vs. $3.5M quota (88.6%). Top: Rep Alexis Wright at 134% ($587K). Lowest: new hire James Lee at 42% ($147K, in ramp). Revenue concentration: top 3 reps generate 52% of total. Team comp cost: $186K (6.0% cost-of-sale).
Section 8.4 — Management Reporting. Managers shall receive a Team Summary each measurement period reflecting aggregate performance against team quotas, individual contributions, and performance distribution. Team-level performance may factor into management bonus calculations per Exhibit B.
Team Summary Report: columns for Rep Name, Quota, Credited Revenue, Attainment %, Incentive Earned, Pipeline Value. Team aggregate row. Performance distribution mini-chart. Heat map by month. Filterable by team, manager, and period.
YTD Summary
#A Year-to-Date Summary provides cumulative sales performance and compensation from fiscal year start through the current period. This is essential because many plans operate on annual measurement — accelerators, decelerators, and bonuses often depend on cumulative YTD attainment rather than single-period results. It tracks progression toward annual targets, showing run-rate trajectory and projected year-end attainment. It must handle mid-year plan changes, territory reassignments, and quota adjustments by reflecting the effective YTD quota. Common pitfalls include failing to adjust attainment when quotas change mid-year and improper pro-rating for reps who joined during the year. This report drives year-end decisions on quota relief, SPIFs, and territory adjustments.
Rep Nina Patel through Q3: Annual Quota $1.2M, YTD Quota $900K, YTD Revenue $847K, Attainment 94.1%, YTD Commission $16,940, YTD Bonus $3,000, Total Incentive $19,940. Run-rate projection: $1.13M annual (94%). Quarterly trend: Q1 88%, Q2 97%, Q3 98% — accelerating.
Section 8.3 — Year-to-Date Reporting. Cumulative YTD performance shall be calculated from Plan Effective Date through each period close, incorporating quota adjustments per Section 6.2. For Participants commencing after the Plan Effective Date, YTD calculations shall be pro-rated per Section 6.4, Ramp-up Provisions.
YTD Summary Dashboard: Revenue vs. Quota with attainment %, quarterly trend line, run-rate projection, compensation by earning type. Columns: Rep, Annual Quota, YTD Quota, YTD Revenue, YTD Attainment, Projected Annual. Filterable by region, team, and plan.
Test Your Knowledge
0 of 4 correctWhich term does this describe?
A ______ report consolidates performance metrics across all members of a sales ______, giving managers visibility into collective results, individual contributions, and performance distribution. Key e…