Sales Report Templates: 6 Practical Formats

A useful sales report answers three questions: what happened, why it happened, and what the team will do next. It does not need 40 charts. Start with the audience and cadence, then use the smallest template that supports a decision.

The six formats below work in Google Sheets, Excel, Notion, or a document. Copy the fields as written, replace the example values, and keep the definitions consistent from one reporting period to the next.

The five numbers every sales report needs

• Revenue or bookings — Closed-won value for the period, shown against target and the comparable prior period.
• Qualified pipeline created — New opportunity value added during the period, not the total value sitting in the CRM.
• Win rate — Closed-won opportunities divided by all closed opportunities. Keep the opportunity definition stable.
• Sales cycle — Median days from qualified opportunity to close. Median is less distorted by one unusually slow deal.
• Forecast coverage — Open qualified pipeline expected this period divided by the remaining target.

1. Weekly sales report template

Use the weekly template for a team meeting. It should expose movement and blockers, not restate every CRM row.

WEEK: [date range]

HEADLINE
Revenue: [$] / Target: [$] ([%])
Qualified pipeline created: [$]
Deals won / lost: [#] / [#]

MOVEMENT
Largest win: [account, value, why it closed]
Largest loss: [account, value, loss reason]
Deals advanced: [account → new stage]
Deals slipped: [account → new close date]

RISKS
1. [risk, owner, next action, due date]
2. [risk, owner, next action, due date]

NEXT WEEK
1. [specific action]
2. [specific action]

2. Monthly sales report template

Use the monthly report to compare performance with both target and the prior month. Add commentary only where a number changed enough to affect the plan.

METRIC                    ACTUAL    TARGET    PRIOR MONTH    CHANGE
Revenue / bookings        [$]       [$]       [$]            [%]
Qualified pipeline        [$]       [$]       [$]            [%]
Win rate                  [%]       [%]       [%]            [pp]
Median sales cycle        [days]    [days]    [days]         [days]
Average deal size         [$]       [$]       [$]            [%]
Forecast accuracy         [%]       [%]       [%]            [pp]

WHAT CHANGED
- [driver supported by the data]

WHAT WE WILL CHANGE
- [action, owner, deadline, expected effect]

3. Executive sales report template

Executives need the forecast, the gap, and the decision required. Keep this version to one page and link to the detailed sheet.

PERIOD: [month or quarter]
Forecast: [$] ([%] of target)
Committed: [$]
Best case: [$]
Gap to target: [$]
Pipeline coverage: [x]

THREE DRIVERS
1. [positive or negative driver + value]
2. [positive or negative driver + value]
3. [positive or negative driver + value]

DECISIONS NEEDED
- [decision] by [date] because [measured consequence]

4. Sales forecast template

• Opportunity — Account and opportunity name.
• Owner — One accountable rep.
• Value — Expected contract value using one currency convention.
• Stage — Current verified stage, not the rep's desired stage.
• Probability — Historical close rate for that stage, unless a documented override applies.
• Expected close date — Date backed by a customer event or next step.
• Weighted value — Opportunity value multiplied by probability.
• Next step — Concrete customer action, owner, and date.

5. Pipeline health template

Pipeline health is about distribution and aging. Group open opportunities by stage, then show count, value, median age, conversion rate to the next stage, and the number with no scheduled next step.

6. Sales rep performance template

Use outcomes and controllable inputs together. Revenue alone favors inherited territories; activity alone rewards motion without progress.

• Outcomes — Revenue, attainment, win rate, average deal size, and sales cycle.
• Pipeline creation — Qualified opportunities and value created during the period.
• Progression — Stage conversion rates and opportunities advanced.
• Execution — Follow-up time, overdue next steps, and forecast accuracy.
• Context — Territory, tenure, lead source mix, and any material coverage changes.

Google Sheets column layout

Period | Rep | Segment | Revenue | Target | Qualified pipeline created | Opportunities won | Opportunities lost | Win rate | Median sales cycle | Forecast | Forecast accuracy | Notes

Keep raw opportunity rows on one tab and the report on another. Build the report with pivot tables or formulas so changing a filter does not overwrite the source data. Lock calculated columns and document each metric definition in a separate tab.

Connect paid acquisition to the sales report

If paid media creates pipeline, include spend, qualified leads, pipeline value, and closed-won revenue by campaign beside the sales metrics. Do not stop at form fills. The useful question is whether a campaign created qualified pipeline at an acceptable cost.

NotFair lets an AI client read live Google Ads data, compare periods, diagnose changes, and draft the paid-acquisition section from chat. Keep CRM-sourced pipeline and revenue in your sales system; use a stable campaign or click identifier when joining the two data sets.

FAQ