Free Sales Report Template gives businesses a simple way to organize and review their sales performance. A sales report can help you track revenue, products sold, customers, sales activities, targets, and performance over a specific period.
Sales reports can be created for daily, weekly, monthly, quarterly, or annual reporting. Common templates include sales activity reports, daily sales reports, monthly sales dashboards, sales KPI reports, and annual sales performance reports. (smartsheet.com)
What Is a Sales Report?
A sales report is a document or spreadsheet that summarizes sales activity and performance during a particular period.
Depending on the business, a sales report may include:
- Total sales
- Revenue
- Number of orders
- Products sold
- Customers acquired
- Sales representatives
- Sales targets
- Actual sales
- Sales conversion rate
- Sales pipeline
- Sales activities
- Profit or margin
- Previous-period comparisons
The purpose is to turn sales data into information that managers and business owners can use to make decisions. Sales reports can reveal trends, strengths, weaknesses, and opportunities within the sales process. (hubspot.com)
Why Use a Sales Report Template?
Creating every sales report from scratch can take unnecessary time.
A template gives your team a consistent structure for recording and presenting sales information.
Benefits include:
- Saves time
- Standardizes sales reporting
- Makes performance easier to compare
- Helps identify sales trends
- Makes targets easier to monitor
- Improves sales team accountability
- Supports business decision-making
- Reduces manual report preparation
A well-designed template can also be reused for different reporting periods.
Free Sales Report Template
You can use the following structure in Excel or Google Sheets.
Basic Sales Report
| Date | Salesperson | Customer | Product/Service | Quantity | Unit Price | Total Sales | Status |
|---|---|---|---|---|---|---|---|
| 01/09/2026 | John | ABC Ltd | POS System | 1 | KSh 85,000 | KSh 85,000 | Won |
| 02/09/2026 | Mary | XYZ Traders | CRM | 2 | KSh 15,000 | KSh 30,000 | Won |
| 03/09/2026 | Peter | Jane Stores | Support | 1 | KSh 8,000 | KSh 8,000 | Won |
Total Sales: KSh 123,000
The columns can be changed depending on what your business sells and the information you need to monitor.
Key Sections of a Sales Report
1. Reporting Period
Start by identifying the period covered by the report.
For example:
Sales Report: September 1–7, 2026
You can create reports for:
- Daily
- Weekly
- Monthly
- Quarterly
- Annually
2. Sales Revenue
Revenue is one of the most important figures in a sales report.
Track:
- Total revenue
- Revenue by product
- Revenue by salesperson
- Revenue by branch
- Revenue by customer
- Revenue by sales channel
Comparing revenue against previous periods can help identify whether sales are growing or declining.
3. Number of Sales
Track how many sales or orders were completed during the reporting period.
For example:
Total Orders: 85
Previous Month: 72
Growth: 18.1%
4. Products or Services Sold
A product-level breakdown helps identify your best-performing products.
| Product | Units Sold | Revenue |
|---|---|---|
| Product A | 120 | KSh 240,000 |
| Product B | 85 | KSh 170,000 |
| Product C | 45 | KSh 135,000 |
This information can help businesses make better decisions about inventory, pricing, and promotions.
5. Sales by Representative
If your business has a sales team, include individual performance.
| Salesperson | Target | Actual Sales | Achievement |
|---|---|---|---|
| John | KSh 500K | KSh 450K | 90% |
| Mary | KSh 500K | KSh 575K | 115% |
| Peter | KSh 500K | KSh 400K | 80% |
This makes it easier to identify high-performing teams and areas that require additional support.
6. Sales Targets
Compare actual sales against your target.
Formula:
Target Achievement = Actual Sales ÷ Sales Target × 100
For example:
Actual Sales = KSh 800,000
Sales Target = KSh 1,000,000
Target Achievement = 80%
Including targets in the report makes it easier to determine whether the business is on track.
Sales Report KPIs to Track
Your sales report does not need to contain every available metric.
Start with the KPIs that are directly related to your sales objectives.
Total Revenue
Measures the total value of sales generated during the reporting period.
Number of Deals Won
Shows how many opportunities were successfully converted into customers.
Average Deal Size
Shows the average value of successful deals.
Average Deal Size = Total Won Revenue ÷ Number of Won Deals
Win Rate
Shows the percentage of closed opportunities that resulted in a sale.
Win Rate = Deals Won ÷ Total Closed Deals × 100
Lead Conversion Rate
Measures how effectively leads become customers.
Sales Cycle
Measures how long it takes to move an opportunity from the beginning of the sales process to a completed sale.
Sales Target Achievement
Shows actual sales compared with the assigned target.
Tracking metrics such as revenue, average deal size, win rate, customer acquisition cost, and customer lifetime value can provide additional insight into sales performance. (hubspot.com)
Daily Sales Report Template
A daily report is useful when managers need to monitor sales activity frequently.
| Date | Salesperson | Calls | Meetings | New Leads | Sales | Revenue |
|---|---|---|---|---|---|---|
| Monday | John | 20 | 4 | 8 | 3 | KSh 75,000 |
| Monday | Mary | 18 | 5 | 10 | 4 | KSh 95,000 |
| Monday | Peter | 15 | 3 | 6 | 2 | KSh 40,000 |
Daily sales reports can provide a same-day view of revenue, pipeline movement, and sales activity. (smartsheet.com)
Weekly Sales Report Template
A weekly report can provide a broader view of sales activity.
| KPI | This Week | Last Week | Change |
|---|---|---|---|
| Revenue | KSh 650K | KSh 580K | +12% |
| New Leads | 85 | 72 | +18% |
| Deals Won | 28 | 24 | +17% |
| Average Deal | KSh 23K | KSh 24K | -4% |
| Calls | 320 | 300 | +7% |
Weekly reporting can help managers identify problems early and make adjustments before the end of the month.
Monthly Sales Report Template
A monthly sales report can provide a more comprehensive view of business performance.
Sales Summary
| Metric | Actual | Target | Achievement |
|---|---|---|---|
| Revenue | KSh 2.4M | KSh 2.5M | 96% |
| New Customers | 85 | 100 | 85% |
| Deals Won | 72 | 80 | 90% |
| Leads | 420 | 400 | 105% |
Monthly sales templates can also compare sales activity, conversion rates, revenue, and performance by channel or representative. (smartsheet.com)
Sales Report by Product
A product sales report helps businesses understand which products generate the most revenue.
| Product | Units Sold | Revenue | % of Total |
|---|---|---|---|
| Product A | 250 | KSh 500K | 40% |
| Product B | 180 | KSh 360K | 29% |
| Product C | 120 | KSh 240K | 19% |
| Product D | 75 | KSh 150K | 12% |
This can help with:
- Inventory planning
- Product promotions
- Pricing decisions
- Sales forecasting
- Product development
Sales Report by Customer
Tracking sales by customer can help identify your most valuable accounts.
| Customer | Orders | Revenue | Last Purchase |
|---|---|---|---|
| Customer A | 12 | KSh 450K | 04/09/2026 |
| Customer B | 8 | KSh 320K | 02/09/2026 |
| Customer C | 5 | KSh 175K | 30/08/2026 |
This information can also support customer retention and account management strategies.
Sales Report by Channel
If you sell through multiple channels, track where your sales originate.
Possible channels include:
- Website
- Social media
- Phone
- Physical store
- Sales representatives
- Referrals
- Online marketplace
For example:
| Channel | Leads | Sales | Revenue |
|---|---|---|---|
| Website | 120 | 35 | KSh 420K |
| 150 | 48 | KSh 510K | |
| Referrals | 60 | 25 | KSh 300K |
| Sales Team | 180 | 65 | KSh 750K |
This helps businesses identify the channels producing the strongest results.
How to Create a Sales Report in Excel
Step 1: Create a Sales Data Sheet
Create columns for:
- Date
- Customer
- Salesperson
- Product
- Quantity
- Unit price
- Total amount
- Sales channel
- Status
Step 2: Enter Your Sales Data
Record transactions consistently.
Avoid changing the format of dates, product names, or salesperson names between entries.
Step 3: Calculate Total Sales
Use Excel formulas to calculate the total value of sales.
For example:
Quantity × Unit Price = Total Sales
Step 4: Create Summary Tables
Use pivot tables or formulas to summarize:
- Revenue
- Products sold
- Salespeople
- Customers
- Sales channels
Step 5: Add Charts
Useful charts include:
- Monthly revenue
- Sales by product
- Sales by salesperson
- Sales by channel
- Target vs actual sales
Step 6: Compare Performance
Compare current performance against:
- Previous period
- Sales target
- Previous year
- Forecast
This makes the report more useful than simply listing transactions.
Sales Report for Small Businesses
Small businesses do not need a complicated reporting system.
A basic report can contain:
- Total sales
- Number of orders
- Top products
- Top customers
- Sales by salesperson
- Sales target
- Actual vs target
- Outstanding opportunities
As the business grows, additional KPIs and automated reporting can be introduced.
Sales Report for Kenyan Businesses
Kenyan businesses can customize their sales reports to reflect local operations.
Useful information may include:
- Revenue in KSh
- Sales by branch
- M-Pesa sales
- Cash sales
- Card sales
- Invoice sales
- Customer payments
- Product sales
- Sales representatives
- Outstanding invoices
For businesses using digital invoicing or CRM software, connecting sales information to centralized records can reduce manual reporting and improve data accuracy.
Sales Report vs Sales Dashboard
A sales report and sales dashboard are closely related but serve different purposes.
Sales Report
A report generally provides detailed information for a particular period.
It can include:
- Transactions
- Products
- Customers
- Salespeople
- Revenue
- Targets
Sales Dashboard
A dashboard provides a visual summary of important KPIs.
It may display:
- Revenue
- Pipeline
- Win rate
- Target achievement
- Sales trends
- Team performance
A dashboard is useful for quickly understanding performance, while a detailed report is better for investigating individual sales records.
Common Sales Reporting Mistakes
1. Tracking Too Much Information
Too many metrics can make a report difficult to understand.
Focus on information that supports actual business decisions.
2. Using Inconsistent Data
If different employees record information differently, your report may contain inaccurate results.
3. Not Comparing Against Targets
Actual sales numbers have more meaning when compared with targets or previous periods.
4. Ignoring Sales Trends
Do not look only at the current month’s results. Review changes over time.
5. Reporting Without Taking Action
The purpose of a sales report is not just to display numbers.
Use the information to decide:
- What should we improve?
- Which products need attention?
- Which sales channels perform best?
- Which representatives need support?
- Which opportunities should be prioritized?
When Should You Move From Excel to a CRM?
Excel can be an effective starting point for small sales teams.
However, manual sales reporting can become difficult when:
- Sales data grows
- Multiple people update records
- Managers need real-time reports
- Customer information is spread across different files
- Sales activities need to be tracked
- Reports must be created frequently
- Follow-ups need automation
A CRM can centralize customer, lead, opportunity, activity, and sales information and make reporting easier.
Instead of manually collecting data from multiple spreadsheets, sales teams can work from a centralized system and generate reports from the information already recorded.
Free Sales Report Template Checklist
Use this checklist when creating your sales report:
☐ Reporting period
☐ Total revenue
☐ Sales target
☐ Actual vs target
☐ Number of orders
☐ Products sold
☐ Top products
☐ New customers
☐ Sales by salesperson
☐ Sales by channel
☐ Sales conversion rate
☐ Average deal size
☐ Deals won
☐ Deals lost
☐ Pipeline value
☐ Sales activities
☐ Previous-period comparison
☐ Key observations
☐ Recommended actions
Conclusions
A Free Sales Report Template gives businesses a simple structure for organizing sales information and evaluating performance.
Whether you create a daily, weekly, monthly, quarterly, or annual report, focus on the numbers that help you understand what is happening in your sales process. Common sales reporting formats can track revenue, sales activity, conversion, products, representatives, targets, and trends. (smartsheet.com)
A good sales report should ultimately answer three questions:
How much did we sell?
How did we perform against our target?
What should we do next?
As your sales operation grows, consider moving from manually maintained spreadsheets to a CRM that can centralize sales data and automate reporting. Start your free trial today.