Sales Report Template

You are a senior sales operations analyst and revenue reporting specialist who has built performance reporting frameworks for organizations ranging from high-growth startups to publicly traded enterprises with multi-territory revenue streams. You understand that an effective sales report is not a raw data dump but a structured backward-looking analysis that translates what happened during a given period into clear takeaways leadership can act on. You know how to connect attainment numbers to the underlying deal dynamics, team behaviors, and market conditions that produced them, surfacing patterns in conversion rates, deal velocity, and pipeline movement that would otherwise go unnoticed.

I need you to generate a complete sales report for [COMPANY_NAME] covering the [REPORTING_PERIOD:select:Weekly,Monthly,Quarterly,Semi-Annual,Annual] period ending [PERIOD_END_DATE]. The report is for [REPORT_AUDIENCE:select:CEO and executive leadership,VP of Sales for internal review,Board of directors or investors,Sales managers for team-level coaching,Cross-functional revenue operations meeting] and the organization structure is [ORG_STRUCTURE:select:Single team with one manager,Multiple teams across one region,Multiple regions with regional managers,Global organization with business units,Channel and direct sales combined].

The revenue target was [REVENUE_TARGET] and actual closed-won revenue was [ACTUAL_REVENUE]. The total deals closed was [DEALS_CLOSED:number:0-9999] out of [TOTAL_OPPORTUNITIES:number:1-9999] active opportunities. The average deal size was [AVG_DEAL_SIZE] and the average sales cycle length was [AVG_CYCLE_LENGTH:select:Under 14 days,14-30 days,31-60 days,61-90 days,91-180 days,Over 180 days]. The overall win rate for the period was [WIN_RATE:select:Under 10%,10-15%,16-20%,21-25%,26-30%,31-40%,41-50%,Over 50%].

The number of new opportunities created during the period was [NEW_OPPORTUNITIES:number:0-9999] with a combined value of [NEW_PIPELINE_VALUE]. The breakdown of losses by primary reason includes [LOSS_REASONS] such as lost to competitor, no decision, budget constraints, or poor fit. The team members or segments to cover are [TEAM_MEMBERS_OR_SEGMENTS] and any notable deals or market events that shaped results are [ADDITIONAL_CONTEXT?].

Generate a complete sales report structured as a cohesive analytical narrative. Open with an executive summary that delivers the headline attainment percentage, characterizes the period as above, on, or below plan, and highlights the two or three most important findings so a reader who only sees this section understands what happened and what matters most.

Move into a revenue performance analysis comparing actual revenue against target, breaking it down by segment or region where applicable, and comparing to the prior equivalent period. Attribute any gap or surplus to specific factors such as deal volume changes, average deal size shifts, or conversion rate fluctuations.

Follow with a pipeline and deal flow analysis examining new opportunities created versus opportunities closed or lost, net pipeline change, and coverage entering the next period. Flag stage-specific bottlenecks where deals stalled or fell out at above-normal rates.

Provide a win/loss analysis identifying the most common loss reasons by count and revenue impact, noting shifts in competitive dynamics, and highlighting replicable wins worth studying as best practices.

Include a team performance breakdown ranking each rep or segment by quota attainment, revenue, deals closed, average deal size, and win rate. Call out top performers and what drove their results, identify underperformers and where their metrics diverge from averages, and flag trajectory shifts heading into the next period.

Present key metrics covering stage conversion rates, average deal size trend, sales cycle length trend, pipeline-to-close ratio, and new business versus expansion split, stating current values against prior period benchmarks.

Close with three to five actionable insights, each naming the pattern observed, explaining why it matters, and recommending a specific action such as adjusting territory assignments, modifying pipeline targets, or investing in enablement. End with a watch list of items to monitor next period. Maintain an analytically honest tone throughout, presenting shortfalls with the same clarity as wins.