AI reporting template

Weekly Sales Report Template

Give sales leaders a fast read on both closed results and future coverage. The template connects bookings, pipeline movement, and deal risk so a strong week is not confused with a healthy forward outlook.

Sales & revenueWeeklySales report

Best for Sales managers, revenue operations teams, founders, account executives, and finance partners reviewing weekly commercial progress.

Built around the review

A useful template should lead to decisions, not just charts.

This structure starts with the questions stakeholders need answered, then defines the evidence and finished deliverable required to support the discussion.

Decisions this template should support

  1. 1Did the team create enough progress against target?
  2. 2Which deals moved, slipped, or became more likely to close?
  3. 3Where should managers focus coaching and deal support next week?

What the finished deliverable includes

  • Weekly sales headline
  • Bookings and target pacing
  • Pipeline movement and deal-risk view
  • Rep priorities and manager actions

Recommended source fields

  • Week or activity date
  • Opportunity and account
  • Stage and probability
  • Amount and expected close date
  • Sales owner
  • Win or loss status
  • Target or quota

Key metrics

  • Bookings
  • Target pacing
  • Pipeline created
  • Stage conversion
  • Pipeline coverage
  • Deals won, lost, or slipped

Suggested report sections

  • Executive sales summary
  • Bookings versus target
  • Pipeline movement
  • Critical deal review
  • Rep and segment performance
  • Next-week priorities

Copy this prompt

Start with a complete reporting brief

Upload your source file, paste this prompt, and then refine the output for your audience and reporting definitions.

Create a weekly sales report. Compare bookings with the prior week and target pace, explain pipeline creation and stage movement, identify deals that slipped or need support, and end with rep-level priorities for next week.

How to use this template

From source data to a review-ready sales report

Use the same four-step workflow each weekly cycle so the analysis stays comparable while the narrative responds to what changed.

01

Add the source data

Upload the latest Excel or CSV exports and include the prior comparison period.

02

Confirm the review brief

Define the audience, reporting period, metric rules, and which 3 questions matter most.

03

Challenge the analysis

Check totals, definitions, outliers, and whether each conclusion is supported by visible evidence.

04

Refine and deliver

Revise charts or narrative with AI, then export the finished sales report in an editable format.

Data preparation

Make the result easier to validate

  1. 1Use snapshot dates when comparing pipeline movement.
  2. 2Keep stage definitions consistent across owners.
  3. 3Separate closed revenue from open pipeline to avoid double counting.

FAQ

Using this template

Can this report identify slipped deals?

Yes. Include opportunity IDs, expected close dates, stages, and at least two dated pipeline snapshots.

Can it show quota pacing?

Yes. Include weekly, monthly, or quarterly quota values and the reporting period elapsed.

Should sales activity be included?

Include activity only when it helps explain pipeline creation, deal progression, or a specific coaching decision.