How to prepare a sales report: weekly and monthly report template

The day before the Monday meeting, the sales manager asks for a report. Three salespeople send three different Excel files: one has sorted opportunities by stage, one by customer, and the third has listed only closed deals. The totals don’t match; the answer to “how much did we sell this month?” depends on which file you open. The hours spent preparing the report go into making the numbers agree, not explaining them. The problem is usually not the report format but the fact that nobody knows which data and which definitions the report was built from.

A sales report is a short summary document that shows, using the same definitions every time, what the sales team did in a given period, which stage the opportunities are in and how much the closed sales came to. Below you will find the skeleton of the weekly and monthly report, how the metrics are calculated, a one-page report example and practical tips for Excel and dashboards.

Which metrics should go into a sales report?

Adding more metrics does not make a report better; every metric should be tied to a decision. For a weekly report, the six metrics below give most B2B sales teams a sufficient skeleton.

Leave open opportunities out of the denominator of the win rate; look only at closed deals. If you add open opportunities to the denominator, the rate looks lower than it really is because of deals that have not yet been decided.

What goes into a monthly sales report?

The monthly report builds on the weekly one with period-on-period comparisons, breakdowns and loss analysis. You can copy the list below straight into your own template.

• Previous month and the same month last year: If your business is seasonal, looking only at the previous month is misleading.
• Breakdown by salesperson: Value, number of opportunities and win rate are read together; value on its own is often misleading.
• Distribution by product or service group: Which group brings in revenue, and which is falling short of target?
• Distribution by opportunity source: Separates the channel that really brings in business from the one that only brings in lots of enquiries.
• Average time to close: The average gap between the opening and closing dates of won opportunities.
• Reasons for lost opportunities: A reason chosen from a short list such as price, competitor, timing or budget; open-ended comments cannot be counted.
• Outlook for the next period: The total of opportunities whose expected close date falls next month. It is not a firm forecast, but it gives management a sense of direction.

Sales report example: a one-page layout

If a report does not fit on one page, nobody reads it. The order below stays the same for both weekly and monthly reports; only the table of figures grows.

1. Title and period: Report name, date range, who prepared it and which source the data came from.
2. Summary sentences: Three sentences to read at a glance. For example: “New opportunity intake has slowed; work is piling up at the quote stage; two large opportunities have passed their expected date.”
3. Table of figures: The metrics above, side by side with the previous period.
4. Stage distribution: A short visual summary of the funnel, with the stage where work is piling up highlighted.
5. Overdue opportunities: Opportunity name, owner, expected date and next step. It should fit on one screen.
6. Risks and decisions: Decisions needed from management, for example approving a discount or requesting extra resources.
7. Next period: Deals expected to close and the target for the period.

Don’t read the report from start to finish in the meeting. State the three summary sentences first, then spend time only on overdue opportunities and pending decisions. The table of figures is an appendix you open if someone asks; decisions are made in sections two and six. This order lets you use the weekly meeting to solve problems rather than listen to numbers.

How do you prepare a monthly sales report in Excel?

For a reliable report in Excel, a three-tab layout works well. On the raw data tab, each opportunity is one row: opportunity name, customer, owner, stage, value, opening date, expected close date and closing status. On the calculation tab, formulas such as COUNTIFS and SUMIFS derive the metrics from these rows. The summary tab is the single page the manager will see. That way you derive each figure from the data instead of typing it in by hand.

Excel is perfectly adequate for a small team with a short list of opportunities. These are the points where it breaks down:

• The data is pasted in again by hand every week; if a row is missing, the total changes without anyone noticing.
• Stage names are written differently (“Quote sent”, “quote”, “In quote”) and the formula counts them separately.
• When several people copy and edit the file, the question “which one is current?” comes back.
• Metrics such as overdue opportunities require date comparisons; one wrong date format breaks the whole column.

Sales report dashboard: what should you see at a glance?

A dashboard is the live version of the report, but it does not have to show everything. Five things to read at a glance are enough: closed sales against target, open opportunities spread across the stages, overdue opportunities, win rate and the expected closing value for the next period. Anything more is a distraction.

A dashboard has two limits: the figures are only as accurate as the data entered, and it does not answer the question “why?”. You still find out why an opportunity is overdue by talking to the salesperson; the dashboard only shows you where that conversation needs to happen.

Common mistakes in sales reports

• Showing value on its own: A single large opportunity can make a month look good. Value that is not read together with the number of opportunities and the win rate hides the team’s real performance.
• Leaving outdated opportunities open: As long as deals the customer gave up on long ago stay in the funnel, the stage distribution looks better than it is. In every meeting, close overdue opportunities or give them a new date.
• Presenting estimates as certainties: The expected close date is a projection. The report should label “expected” and “closed” separately.
• Changing the report without asking anyone: When a metric’s definition changes, comparison with past periods breaks. If you change a definition, recalculate the past using the new definition as well.
• Not making decisions after the report: If the report does not turn into a “next steps” list in the meeting, the effort that went into it is wasted.

How do you read a sales report in KurumsalPortal and YazSis CRM AI?

The Sales / Quotation & Customer Management module keeps customer records, opportunities, meetings, multi-currency quote revisions, approvals and closed sales in one shared flow. The module’s opportunity, sales and conversion report lets the sales manager see how many opportunities are in each stage, and the closed sales, in the same report. Instead of compiling a separate spreadsheet for the report, you read it directly from the opportunity and quote records.

In YazSis CRM AI, the opportunity funnel consists of the New, Contact, Demo, Quote, Won and Lost stages. The deal board shows opportunities spread across the stages, with amounts and expected close dates; overdue opportunities are marked in red. A won opportunity can optionally open a collection record. YazSis CRM AI is used today in YazSis’s own support and sales hub; the scope of a set-up adapted to your company is determined after a needs analysis.

To see the flow from quote and opportunity records to the sales report, take a look at the Sales / Quotation & Customer Management module page.