Reviewed & updated by WordNExcel Team — Updated November 6, 2026
A sales report shows how much a business has sold over a period, how that compares with targets and past results, and where sales are coming from. Owners use it to see whether the business is on track, managers use it to coach their teams and investors use it to judge growth. On this page you can download five free sales report templates in Excel: a monthly sales report by product, a sales rep performance report and an annual sales report comparing this year with last year, plus a weekly channel sales report and a product and category sales breakdown.
Each file is a real, editable .xlsx spreadsheet. Type your sales figures and targets in the yellow cells, and the formulas work out totals, attainment, variances, growth and rankings. The monthly and annual reports include ready-made charts that update as you type.
Ad Campaign ROAS & Cost per Lead Calculator
Runs in your browser; nothing is sent or saved. Profit uses your gross margin on the sales value, before other costs.
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is a Sales Report?
A sales report summarises sales activity for a period, such as a week, month, quarter or year. A good sales report answers a few key questions:
- How much did we sell? Units and revenue.
- Did we hit target? Actual sales compared with the goal.
- What sold best? Products, regions or reps leading the results.
- Are we growing? Comparison with the same period last year.
- What should we do next? Notes and actions based on the figures.
Download Free Sales Report Templates
The templates open in Microsoft Excel, Google Sheets and LibreOffice Calc.
1. Monthly Sales Report

A one-page report of sales by product for a month. Enter the report month and, for up to 15 products, the units sold, average price and revenue target. The sheet works out revenue, attainment against target and the variance in dollars. The totals row adds up units, revenue and target, and the summary shows overall attainment, the best-selling product by revenue, how many products hit their target and the average selling price. A bar chart compares revenue with target for each product. The sample shows October 2026 for a small electronics accessories business: 3,035 units and $119,355 revenue against a $120,000 target, with the smartwatch as best seller.
2. Sales Rep Performance Report

A report for comparing salespeople over a month or quarter. For each rep, enter the region, calls made, meetings held, deals won, revenue and target. The sheet works out attainment and ranks each rep by revenue. The summary shows team revenue and target, team attainment, the top rep, the win rate (deals won compared with meetings), the average deal size and how many reps hit target. A small table adds up revenue by region with SUMIF. The sample shows Q3 2026 for seven reps with team revenue of $607,100 against a $630,000 target. Use it for sales meetings, one-to-ones and commission planning.
3. Annual Sales Report

A year-at-a-glance report comparing this year’s monthly sales with last year’s. Enter both years’ sales by month. The sheet works out the growth for each month and running year-to-date totals for both years. The summary shows year-to-date growth, the best month, the average month and a simple full-year forecast based on the average month so far. A line chart shows this year against last year. The sample shows 2026 with sales to October and year-to-date growth of 8.2% on 2025.
4. Weekly Channel Sales Report

A seven-day sales pulse for a store or channel. Enter orders, units, revenue and returns for each day; net sales calculates. Week totals sit at the bottom. Save a copy every Monday to build a simple week-on-week history without a BI tool. Pair it with the ad ROAS calculator at the top of this page when you are spending on ads and want to see whether the week’s sales covered the spend. The sample week peaks on Friday.
5. Product Category Sales Breakdown

Shows which products or categories make money, not just which ones sell. Enter units, revenue and cost for each line; gross profit and margin percent calculate. Sort by margin to decide what to promote or discontinue. Merchandisers and e-commerce managers use this monthly alongside the annual sales report. Rename the sample categories to your own catalogue and keep costs from your supplier list or inventory valuation.
How to Write a Sales Report
- Choose the period and the audience. A weekly report for the team needs more detail than a yearly report for the board.
- Collect the data from your sales system, invoices or point-of-sale reports.
- Enter the figures in the template and check the totals against your accounts.
- Compare with targets and with the same period last year.
- Look for the story. Which products or reps drove the result? What changed?
- Add a short summary at the top with the main points and actions.
- Share the report on a regular schedule, such as the first working day of each month.
Key Sales Metrics
- Revenue: total sales value for the period.
- Units sold: how many items were sold.
- Attainment: actual sales divided by target.
- Variance: the difference between actual and target.
- Average selling price: revenue divided by units.
- Win rate: deals won compared with opportunities or meetings.
- Average deal size: revenue divided by deals won.
- Growth: the change compared with the same period last year.
You don’t need to track every metric. Pick the few that matter most for your business and report them consistently.
Tips for Better Sales Reports
- Keep it short. Put the main numbers and a few sentences on the first page.
- Use the same format each time so people can compare periods easily.
- Show targets and last year alongside actual results; numbers mean more with context.
- Use charts to show trends quickly.
- Explain big changes. A note such as “large order from one customer” stops wrong conclusions.
- Focus on actions. End with what the team will do differently next period.
- Check the data. One typing error can change the whole picture.
Sales Report vs. Sales Forecast
A sales report looks back at what has happened. A sales forecast looks ahead at what is expected. The annual sales report includes a simple forecast based on the average month so far, which is a useful starting point. For a more accurate forecast, also consider seasonality, the sales pipeline and planned marketing.
Who Can Use These Templates?
- Small business owners tracking monthly sales.
- Sales managers reviewing team performance.
- Retail and e-commerce businesses reporting product sales.
- Account managers reporting to clients.
- Finance teams preparing management reports.
Reading the Monthly Report
Start with the summary at the top: total revenue, target and attainment tell you straight away whether the month was good. Then look at the product table. Products with a negative variance missed their target; ask why. Was stock short, did a competitor cut prices, or was the target too high? Products well above target may deserve more marketing or stock next month. The bar chart makes it easy to see which products are furthest from target.
The average selling price is also worth watching. If units rise but the average price falls, customers may be buying cheaper items or using more discounts. If both rise, the business is selling more of its higher-value products.
Reviewing Sales Rep Performance
Revenue is only part of the picture. The rep report also shows calls, meetings and deals, which helps explain the results. A rep with many meetings but few deals may need help with closing, while a rep with a high win rate but few meetings may need more leads. Use the ranking to recognise top performers, but focus coaching on the activity numbers, because those are what reps can change day to day. The region table shows whether one area is pulling the team result up or down.
Comparing Years
Monthly sales often follow a seasonal pattern, so comparing a month with the previous month can be misleading. December may always be higher than November, for example. The annual report compares each month with the same month last year, which removes most of the seasonal effect. Look at the year-to-date growth to see the overall trend, and at the monthly growth to spot months that broke the pattern.
Editing the Templates
Type in the yellow cells and leave the formula cells alone. Rename products, reps and regions to match your business. To add a product, type it in an empty row inside the table; the totals and chart include it. To use a different period, change the title cell, such as the month or quarter. Save a copy of each report with the period in the file name so you build a history over time.
Sharing the Report
Send the report as a PDF for people who only need to read it, and share the Excel file with anyone who needs to work with the figures. A short email with three or four key points, such as total sales, attainment, the best seller and the main action, helps busy readers.
Related Templates
You can also check these useful templates like the marketing budget plan templates, and the SWOT analysis templates for business planning.
You may also like the receipt templates and the customer contact list templates.
Frequently Asked Questions
What should a sales report include?
Sales for the period in units and revenue, a comparison with target and last year, the best products, reps or regions, and a short summary of actions.
How do I calculate sales attainment?
Divide actual sales by the target. For example, $119,355 in sales against a $120,000 target is 99% attainment.
How often should I make a sales report?
Most businesses report monthly, with weekly reports for sales teams and an annual report for the year.
Do the charts update automatically?
Yes. The charts in the monthly and annual reports update as you change the figures.
Can I use the templates in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets.
