Quarterly Sales Report Template: What to Include and Track

A quarterly sales report template is a reusable structure for summarizing sales results, comparing them with targets or earlier periods, and explaining what affected performance. Use the blank table below to organize the figures, then add a short written summary that gives readers context and identifies practical follow-up actions.

What a Quarterly Sales Report Is For

A quarterly sales report gives a team a defined view of sales activity and outcomes over a three-month period. It can help managers, sales representatives, and other stakeholders see whether results are moving as expected, which products or territories contributed, and where further investigation may be useful. The report is most useful when its scope and definitions stay consistent from one quarter to the next.

It is not simply a list of transactions or a verdict on individual performance. A useful report connects the numbers to the conditions behind them: for example, a change in product mix, a delayed order, a new territory, a pricing change, or a shift in the number of active sales representatives. Those explanations help readers distinguish a meaningful trend from a one-time event.

Before preparing the report, state the period covered and the organizational scope. Specify whether the figures represent a whole business, a team, a region, a channel, or a product group. Also note the date the report was prepared and, if relevant, whether figures are preliminary. These details make a document easier to interpret when it is forwarded or reviewed later.

What to Include in the Report

Keep the core report focused on information readers can compare and act on. A compact report commonly includes:

• Reporting details: quarter dates, business unit or territory, report owner, and preparation date.
• Headline results: sales total for the period and a comparison with a stated target, if one exists.
• Breakdowns: results by product, region, channel, or representative when those categories matter to the audience.
• Comparisons: the prior quarter or the same quarter in an earlier year, with the comparison period named clearly.
• Supporting measures: units sold, number of orders, average order value, or other measures used consistently by the organization.
• Context and actions: important drivers, limitations in the data, open questions, and next steps with an owner or due date where possible.

Do not add every available measure just because it can be exported. A report crowded with disconnected metrics can obscure the main result. Select measures that answer the reader’s likely questions, and provide a brief definition for any term that could be interpreted in more than one way.

Quarterly Sales Report Template

How to Define and Calculate Common Measures

Metric names can vary between organizations, so put the chosen definition in the report or its notes. For example, one team may use sales to mean the value of orders booked, while another reports sales recognized or invoiced during the period. Those are not automatically interchangeable. Use the definition that matches the intended report and apply it consistently.

Common calculations include:

• Net sales: gross sales less the discounts, returns, or other deductions included in the organization’s definition.
• Target attainment: reported sales divided by the sales target, multiplied by 100. If sales are $11,000 against a $10,000 target, attainment is 110%.
• Period-over-period change: current-period sales minus comparison-period sales. To express the change as a percentage, divide that difference by the comparison-period amount and multiply by 100.
• Average order value: sales for the defined period divided by the number of qualifying orders, if both figures use the same scope and rules.

Always show the comparison period and units. A percentage change without its baseline can mislead, especially when the earlier period was unusually small or had no sales. If a measure is not meaningful for a particular comparison, explain why rather than implying that the figures are directly comparable.

How to Prepare the Report

A repeatable process reduces avoidable discrepancies and saves time in later quarters. One practical sequence is:

1. Set the scope. Confirm the quarter dates, business area, categories, and sales definition before collecting figures.
2. Gather the source data. Use the organization’s approved records and retain enough detail to trace a reported total back to its source.
3. Check and reconcile. Look for missing entries, duplicate records, inconsistent currency or units, and totals that do not agree with the underlying detail.
4. Calculate comparisons. Apply the same definitions to current and comparison periods, and label targets separately from actual results.
5. Write the narrative. Explain the largest changes, what is known about their causes, and what remains uncertain.
6. Review and share. Ask an appropriate reviewer to check figures, labels, and conclusions; then distribute the report to its intended audience.

Keep calculation logic visible where practical. A reader should be able to tell whether a total was copied from a source, calculated from rows, or adjusted for a stated reason. If an adjustment is necessary, document what changed and why instead of silently modifying the displayed result.

How to Interpret the Results

Start with the headline result, but do not stop at whether it rose or fell. Compare the total with the target and the chosen historical baseline, then inspect the breakdowns to see where the change came from. A business could exceed its overall target while one region falls behind, or show a lower total because a large order moved across a quarter boundary. The underlying detail changes what the summary means.

Consider the fictional sample in the template: net sales of $11,000 are above a $10,000 target and higher than the stated prior-period figure of $9,500. Those comparisons describe the arithmetic, not the cause. The note about a late shipment might be relevant context, but the report should not claim that it caused the increase unless the available records support that conclusion. Separate verified facts from hypotheses, and identify follow-up questions when causation is unclear.

Useful commentary is specific and proportionate. Instead of writing “sales were strong,” state which measure exceeded which benchmark and mention the clearest known driver. If a result is mixed, say so. For instance, total sales may be above target while order volume declines; that could indicate a change in order size, but it does not establish why that change occurred.

Choosing a Format and Level of Detail

A spreadsheet is useful when the report needs calculations, sortable rows, or multiple breakdowns. A document or slide-based summary can work better for an audience that needs a concise narrative and a few visual comparisons. A printable table, like the template above, is suitable for a small number of categories or for gathering figures before producing a polished report.

Whichever format you choose, make it readable in print and on screen. Use clear labels, consistent number formats, and a visible distinction between actuals and targets. Avoid relying on color alone to communicate status; include text, symbols, or labels as well. If the report has many rows, include a clear summary and organize the detail so readers can find the categories relevant to them.

The right amount of detail depends on the audience. An executive summary may need totals, comparisons, and major drivers, while a team review may need representative- or product-level data. Share only detail that is relevant and appropriate for the intended readers, and avoid exposing personal or commercially sensitive information unnecessarily.

Common Reporting Problems to Avoid

• Changing definitions between periods: A revised treatment of returns or order dates can create an apparent trend. State the change and, where possible, make the comparison on a consistent basis.
• Mixing booking and fulfillment dates: Orders booked in one quarter may ship or be invoiced in another. Choose the measure that fits the report’s purpose and label it accurately.
• Comparing unlike periods: A quarter with different territory coverage, product availability, or selling days may not be directly comparable. Note material differences rather than treating the comparison as self-explanatory.
• Confusing percentages and percentage points: A move from 20% to 25% is an increase of 5 percentage points, not a 5% increase. State which form of comparison is being used.
• Overstating causes: A correlation between a change and an event does not prove that the event caused it. Use cautious wording where evidence is incomplete.
• Hiding exceptions in a total: A large one-time order or unusual return can distort the overall picture. Mention material exceptions and show a useful breakdown when appropriate.

For accounting or tax treatment that depends on your organization’s circumstances, ask a qualified professional rather than treating a general sales-report template as professional advice.

Frequently Asked Questions

What should a quarterly sales report include?
A useful report identifies the period and scope, summarizes sales results, compares them with a target or prior period, and explains relevant drivers or limitations. Add breakdowns and measures only when they help the intended reader understand the result.

How do I calculate quarterly sales growth?
Subtract the comparison period’s sales from the current quarter’s sales, then divide the difference by the comparison-period sales and multiply by 100. Label the baseline and use the same sales definition for both periods.

Is a sales report the same as a sales forecast?
No. A report summarizes recorded results for a completed period. A forecast estimates future results and depends on assumptions about expected sales activity. Keep historical actuals distinct from projections.

Should I report gross sales or net sales?
Use the measure that matches the organization’s reporting convention and the audience’s question. Define whether discounts, returns, or other adjustments are included, and avoid comparing figures built on different definitions.

How long should a quarterly sales report be?
There is no single required length. Keep the summary brief enough to scan, then include the level of supporting detail readers need to verify and understand the results. A small team may need only a table and a few notes; a broader review may need several breakdowns.

Related

• Project Status Reporting Template and How to Use It
• Product Inventory List Template: Fields, Counts, and Use
• Procurement SOP Template: Steps, Controls & Sample