Sales report template: the numbers worth reporting weekly

A sales report template is the standing structure for saying what was sold, by whom, against what expectation. Its value is comparability: the same rows and columns every period, so a reader sees the change rather than re-learning the layout. That single property is worth more than any amount of additional detail.

The common failure is reporting effort. Calls made, emails sent and meetings booked feel like information, and they answer a question nobody outside the sales team is asking. Report the outcome, and keep activity for the coaching conversation where it belongs.

What belongs in a sales report

• The period, stated unambiguously, and the date the report was produced.
• Revenue closed in the period, against target, with the variance calculated rather than left to the reader.
• The same figures cumulative for the quarter or year — a bad month inside a good quarter is a different conversation.
• A breakdown by whichever dimension you act on: rep, product, region or segment. One dimension, not four.
• Pipeline added in the period, because closed revenue is a lagging measure and new pipeline is the leading one.
• Deals lost, with the reason in a word — price, timing, competitor, no decision. This is the most actionable column and the one usually left blank.
• The three or four largest deals in progress, with their next step and date.
• A short commentary: what changed, what you are doing about it. Three sentences.

Report against a target or do not report the number at all. Revenue of 84,000 means nothing on its own — against a target of 70,000 it is a good month, against 120,000 it is a problem. Any figure without a comparison forces the reader to invent one, and they usually invent a flattering one.

Making it a ten-minute job

1. Fix the layout and never redesign it. The point is period-on-period comparison.
2. Pull the raw data the same way every time — one export, same filters — so producing the report is mechanical.
3. Let formulas do variance, percentages and totals. Any figure typed by hand is a figure that will eventually be wrong.
4. Keep one dimension of breakdown. Adding rep × product × region turns a report into a spreadsheet nobody reads.
5. Write the commentary last, and keep it to what changed and what you are doing.
6. Send it at the same time every week. A report that arrives unpredictably stops being read.
7. Once a quarter, ask the recipients which lines they actually use, and cut the rest. Reports accumulate rows and almost never lose them.

Weekly, monthly, quarterly

Different periods answer different questions and should not carry the same content. The weekly report is operational: what closed, what is at risk, what needs a decision this week. The monthly is managerial: performance against target, pipeline health, the trend. The quarterly is strategic: what is working, where the mix is shifting, what to change. Sending the weekly format monthly produces noise; sending the quarterly format weekly produces a report that takes half a day and lands too late to act on.

Ettex Sheets handles the mechanics: import an existing XLSX with formulas intact, formulas for variance and totals, conditional formatting to highlight anyone below target, charts from any range for the trend, pivots to switch the breakdown from rep to product without rebuilding, and export to CSV or XLS when someone wants the raw numbers. Version history means last month's report as sent is recoverable, and cell comments let a manager query a figure against the cell it sits in. The deals behind it live in Ettex CRM with a visual pipeline and activity logging, invoices raised on closed business sit in Ettex Invoices, and the written commentary belongs in Ettex Docs.

Said plainly: Ettex has no sales reporting or BI. There is no dashboard that refreshes itself, no scheduled report delivery, no automatic roll-up from CRM into a sheet, and no forecasting. You export the data and maintain the sheet. That suits a small team reporting weekly; anything larger wants reporting built into the sales tool.

What makes sales reports ignored

• Activity metrics reported to an audience that cannot act on them.
• Numbers with no target beside them, leaving the reader to guess whether it was a good week.
• A layout that changes every few months, destroying comparability.
• Four dimensions of breakdown, which buries the one number that mattered.
• Lost-reason left blank, discarding the most useful information the period produced.
• Produced manually, so it is late whenever the person is busy — which is exactly when it matters.
• Growing by accretion: rows added when someone asks, never removed when they stop looking.

A sales report template works when it is comparable, targeted and short: same layout every period, every number against an expectation, one breakdown, and the lost-reason column actually filled in.