Sales Report Template Excel

A useful Excel sales report shows what happened, what is likely to happen next, and where follow-up is slipping. It should not be a decorative dashboard first. It should be a working view that helps a founder, sales lead, or operator make decisions about revenue.

The simplest version starts with clean deal data: company, owner, stage, deal value, close date, probability, source, last touch, and next action. From there, the report can summarize booked revenue, open pipeline, weighted forecast, and overdue follow-ups.

What to include in an Excel sales report

Use one raw data table and one report view. The raw table keeps the source of truth clean. The report view turns that table into useful summaries.

Core fields:

• company or account
• owner
• stage
• deal value
• probability
• weighted value
• close date
• source
• last touch
• next action

If you already use a sales pipeline template, most of those columns are already in place.

Step-by-step sales report build

Step 1. Create the deal table

Put each opportunity on one row. Do not merge cells in the raw data. Use consistent stage names like Lead, Discovery, Proposal, Negotiation, Closed Won, and Closed Lost.

Step 2. Add weighted forecast

If deal value is in D and probability is in E, use:

Format the result as currency and fill the formula down.

Step 3. Summarize open pipeline

Use SUMIFS to total open deals by stage:

For weighted forecast by owner:

Step 4. Add follow-up checks

Create a flag for deals with no next action:

This is often more useful than another chart because it points directly to the work that needs attention.

Step 5. Build the summary view

Create a compact report with:

• total open pipeline
• weighted forecast
• deals closing this month
• revenue won this month
• overdue follow-ups
• pipeline by owner
• pipeline by stage

Sales report vs sales pipeline

A sales pipeline tracks live opportunities. A sales report summarizes those opportunities for review.

The pipeline is where reps update next actions, close dates, and stage movement. The report is where managers review forecast quality, owner performance, and stalled deals. Small teams can keep both in one workbook, especially if the source data is structured cleanly.

For earlier contacts that are not real opportunities yet, use a CRM lead tracker instead of forcing every name into the report.

The Griddy way

Building a sales report by hand usually means creating formulas, fixing stage names, formatting currency, and rebuilding pivots every time the export changes.

"Turn this pipeline table into a sales report with open pipeline, weighted forecast, deals closing this month, and overdue next actions."

Griddy can clean the source table, add the formulas, and create the report view directly in the workbook.