Free Excel Sales Dashboard Template
Track your pipeline, quota attainment, rep performance, and deal velocity in one place. Pipeline funnel by stage, rep leaderboard with quota progress bars, sales-velocity math, and 12-month historical trends. Built for B2B SaaS teams, agencies, and enterprise sales. Free forever, no signup, no watermark.
Sales Dashboard 2026 — full workbook
Six sheets: dashboard with pipeline funnel and rep leaderboard, deal pipeline tracker, per-rep performance breakdown, quota configuration, historical trends, and a setup guide. Everything cross-linked.
Download sales-dashboard-2026.xlsxPreview: what you'll see when you open it
The Dashboard sheet gives you the four numbers a sales leader wants first — team pipeline, quota attainment, win rate, and average deal size — followed by the pipeline funnel and rep leaderboard:
The Deal Pipeline sheet is where you log every open opportunity — customer, rep, stage, value, expected close. Every dashboard number rolls up from here:
| Deal Name | Rep | Stage | Value | Prob | Weighted | Close Est. |
|---|---|---|---|---|---|---|
| Acme Corp — Enterprise plan | Sarah Chen | Negotiation | $124,000 | 72% | $89,280 | Feb 14 |
| Bloom Retail — Multi-store rollout | Marcus Rivera | Proposal | $86,500 | 45% | $38,925 | Feb 28 |
| Chapman Legal — Practice suite | Priya Kumar | Qualification | $42,000 | 28% | $11,760 | Mar 15 |
| Delta Studios — Team of 24 | Jake Morris | Prospecting | $28,800 | 15% | $4,320 | Mar 30 |
| Everest Media — Content package | Diana Lee | Closed Won | $67,200 | 100% | $67,200 | Jan 22 |
| Fairfield Bank — Compliance module | Tom Baxter | Closed Lost | $95,000 | 0% | — | Jan 18 |
What's inside the workbook
Six sheets, pre-configured and cross-linked. Log deals once — every visual updates automatically:
- Setup Guide — Quick start on the first sheet.
- Dashboard — Top KPI cards, pipeline funnel by stage, rep leaderboard. What you'll show in Monday's team meeting.
- Deal Pipeline — Every open opportunity as a row. Deal name, rep, stage (dropdown), value, probability, expected close date. Weighted forecast auto-computed.
- Rep Performance — Per-rep breakdown: deals worked, deals won, revenue, quota attainment, activity metrics. Feeds the leaderboard.
- Quotas — Set each rep's quarterly quota once. Attainment percentages calculate automatically as deals close.
- Historical Trends — 12-month rolling view of team revenue, deal count, and win rate. For quarterly board reports.
Features that make this different from generic CRM exports
Weighted pipeline forecast
Each deal's stage has a default win probability (customizable). Weighted forecast = deal value × probability, so your pipeline number reflects reality, not wishful thinking.
Auto-updating funnel visualization
The pipeline funnel on the Dashboard sheet updates instantly when you change a deal's stage. No pivot tables to refresh, no charts to rebuild.
Rep leaderboard with quota bars
Reps ranked by quarter-to-date revenue with color-coded quota progress bars. Green when they're on track, red when they're behind. Instant accountability.
Sales velocity computed for you
The template implements the standard sales velocity formula (# opps × win rate × deal size ÷ cycle length). Track whether your team is accelerating or slowing down.
Fully customizable stages
Prospecting → Qualification → Proposal → Negotiation → Closed by default. Rename or add stages to match your process (MEDDIC, BANT, SPICED, or your own). Formulas adapt.
Board-report ready
Dashboard sheet configured for landscape print with fit-to-page. Save as PDF for weekly team meetings or quarterly board reviews.
Who this sales dashboard is for
Sales managers & VPs
Weekly pipeline review, monthly forecast, quarterly board report — all from one workbook. Cheaper than Salesforce for early teams.
Individual sales reps
Track your own deals, quota progress, and activity. Better than living in your CRM's clunky reporting.
Founder-led sales teams
Pre-CRM startups still need pipeline visibility. Log deals in Excel until you're ready for a real CRM.
Sales pipeline stages explained
The template uses a standard 5-stage pipeline that fits most B2B sales processes. Here's what each stage means and typical benchmark win rates:
Prospecting
You've identified a potential customer and made contact. They haven't confirmed interest, budget, or timeline yet.
Typical win rate: 10-20%
Qualification
Prospect has confirmed they have a problem worth solving and you're a plausible fit. Budget and decision timeline being discussed.
Typical win rate: 25-35%
Proposal / Discovery
You've presented your solution and pricing. Prospect is evaluating — often against competitors or an internal buy vs build.
Typical win rate: 40-55%
Negotiation
Prospect has said yes in principle. Now you're working through contract terms, pricing details, and legal/procurement review.
Typical win rate: 65-80%
Closed Won
Contract signed, revenue recognized. Deal counts toward quota attainment. Move customer to onboarding.
Terminal stage · 100%
Closed Lost
Prospect chose a competitor, chose to do nothing, or the deal stalled indefinitely. Keep the record for win/loss analysis.
Terminal stage · 0%
Win rates are cumulative — a deal in Negotiation has a 65-80% chance of closing won from that point. Multiply forward: a Prospecting deal that reaches Negotiation has ~15% × ~30% × ~50% × ~72% ≈ 1.6% raw close probability from cold start.
Sales Velocity — the one formula every sales team should know
Sales velocity measures how quickly your pipeline converts into revenue. It's the single best diagnostic for whether your team is accelerating or slowing down:
Result: dollars per day. If you have 100 open deals, 25% win rate, $50K average deal, and 60-day cycle → velocity = (100 × 0.25 × 50,000) ÷ 60 = $20,833/day = $625K/month.
Why sales velocity is more useful than looking at any one metric
The formula's four levers all interact. A team with a great win rate but few opportunities has low velocity. A team with tons of pipeline but a slow cycle has low velocity. Watching velocity forces you to think in trade-offs:
- Want to raise velocity? You can double any one lever, or push all four by 20%.
- Cycle length is often the underappreciated one — cutting cycle from 90 to 60 days is a 50% velocity boost with no other change.
- Compare velocity across quarters and reps to spot who's actually accelerating vs just "busy".
The template computes velocity automatically on the Dashboard sheet, updated live as you log deals and close them.
Pipeline Coverage Ratio — is your pipeline big enough?
Pipeline coverage = (total pipeline value) ÷ (sales target for the period). It tells you whether you have enough deals in play to hit your number:
Qualification frameworks: BANT vs MEDDIC
How you qualify deals shapes what stages mean and how you forecast. The two most common frameworks:
BANT
Budget · Authority · Need · Timeline. Old-school (coined by IBM in the 1960s), still widely used. All four must be confirmed to move a deal past Qualification.
Best for: high-volume transactional sales, SMB, inbound-heavy motions.
MEDDIC
Metrics · Economic buyer · Decision criteria · Decision process · Identify pain · Champion. More rigorous framework for complex enterprise deals with multiple stakeholders.
Best for: enterprise deals >$50K ACV, complex multi-stakeholder decisions.
The template's stage names work with either framework. Just interpret "Qualification" as "all BANT confirmed" or "MEDDIC criteria met" based on which one your team uses.
How to use it — 3-step setup
Set up your team on the Quotas sheet
List each rep and their quarterly quota. This drives the rep leaderboard progress bars and team-level attainment percentage.
- One row per rep — name, email, quarterly quota, territory (optional)
- Quota can be revenue-based ($) or deal-count based (rare but supported)
- Add or remove reps at any time; formulas expand automatically
Log deals on the Deal Pipeline sheet
Every open opportunity gets one row. Update deal stages as they progress; that's it.
- Required fields: deal name, rep, stage, value, expected close date
- Stage is a dropdown — pick from Prospecting / Qualification / Proposal / Negotiation / Closed Won / Closed Lost
- Weighted forecast = value × default probability for that stage (customizable on the Pipeline Stages sheet)
- Log closed-lost deals too — you need them for win-rate math and win/loss analysis
Review the Dashboard weekly
Monday morning ritual: open Dashboard, review the 4 KPI cards, scan the funnel, check who's ahead and behind on the leaderboard.
- Red cards = your priorities this week
- Anyone below 60% quota with 2 weeks left in the quarter = coaching or pipeline help needed
- Save as PDF for the CEO or board update: File → Save As → PDF, Active Sheet
Customizing the template
Rename stages to match your process
On the Pipeline Stages sheet, edit the stage names in column A. The Deal Pipeline sheet's dropdown and the dashboard funnel will update automatically. Common custom stages: "Demo Scheduled", "POC Started", "Legal Review", "Verbal Yes" — whatever matches your team's process.
Adjust default win probabilities
Each stage has a default probability (Prospecting 15%, Negotiation 72%, etc.) that's used to weight the pipeline. Real team win rates vary — check your historical data. If your Negotiation → Won rate is actually 85%, update that on the Pipeline Stages sheet. The weighted forecast becomes more accurate.
Switch from quarterly to monthly quotas
The template defaults to quarterly quota tracking. To switch to monthly: on the Quotas sheet, replace "Quarterly Quota" with "Monthly Quota" and divide the numbers by 3. Dashboard's attainment % will now show monthly progress.
Add territories or product lines
The Deal Pipeline sheet has a "Territory" column (or add "Product" column via Insert). Use conditional formatting to color-code deals by territory. For a territory rollup, duplicate the Dashboard sheet, then adjust its formulas to filter by SUMIFS including territory.
Import from HubSpot, Salesforce, or Pipedrive
Export your CRM's deals report as CSV, then paste columns matching the template's Deal Pipeline structure. Most CRMs export: deal name, owner, stage, amount, close date — a direct match. Keep the template's stage names consistent with your CRM's for accurate rollups.
Excel functions used inside this template
The functions that power the funnel calculations, quota bars, and rep rollups:
Frequently asked questions
Is this template really free?
Yes — free for personal and commercial use. Sales teams can use it internally, consultants can use it with paying clients, no signup or email required. We appreciate a link back to this page if you share it publicly.
How is this different from a real CRM like Salesforce or HubSpot?
It's not a replacement — it's a lightweight complement. Real CRMs handle contact management, email tracking, activity logging, and multi-user collaboration. This template gives you the visualization and forecasting layer at zero cost. Many teams use both: log activity in the CRM, do weekly review in Excel because it's faster to slice.
Can I import deals from my existing CRM?
Yes. Export your CRM's deals as CSV, then paste the relevant columns (deal name, rep, stage, value, close date, probability) into the Deal Pipeline sheet. HubSpot, Salesforce, Pipedrive, and Zoho all support CSV export. Match stage names or map them (e.g., HubSpot's "Contract Sent" → this template's "Negotiation").
How many sales reps does it support?
The template is optimized for teams of 1-20 reps. Technically it works up to 50 reps, but the rep leaderboard is best-viewed for 6-10 (which fits on a printed page). For very large teams, you'd typically split by territory or region and have one workbook per group.
What's a healthy pipeline coverage ratio?
3-4× your sales target is the standard B2B SaaS benchmark. Below 2.5× and you likely can't hit your number even with normal win rates. Above 5× usually means stale deals — either close them out honestly or work them to closure. The exact ratio depends on your win rate (rough rule: coverage ratio ≥ 1 ÷ win rate).
How do I calculate sales velocity?
Sales Velocity = (# of Opportunities × Win Rate × Average Deal Size) ÷ Sales Cycle Length. Result is dollars per day, or revenue rate. The template computes this automatically on the Dashboard sheet. Watch the trend over time — accelerating velocity means your team is getting more efficient; slowing velocity means something needs to change.
Should I include closed-lost deals in the workbook?
Yes — they're essential for win rate calculation. Win rate = closed-won ÷ (closed-won + closed-lost). If you delete lost deals, your win rate will be artificially 100%. The template's Deal Pipeline sheet keeps them separate from open pipeline (only open deals contribute to pipeline value).
What if a deal reopens after being marked lost?
Change its stage back from Closed Lost to whatever's appropriate (usually Qualification or Proposal). The historical trend charts will reflect the original close date so your prior-period metrics don't retroactively change. Some CRMs handle this as a "re-opened deal" event; in this template, just editing the stage is enough.
How does the template handle multi-year contracts?
Enter the full contract value in the "Value" column. For ACV (Annual Contract Value) reporting, add an ACV column: value ÷ contract years. Duplicate the Dashboard sheet if you need both TCV and ACV views. This is common for enterprise SaaS where board reports use ACV but sales credit uses TCV.
Can I track commissions with this template?
Not directly — commission structures vary wildly (accelerators, kickers, SPIFs, etc.). But the Rep Performance sheet has each rep's closed revenue, which is the primary input to any commission calc. Add a "Commission" column to that sheet with your formula (e.g., =E4*0.08 for flat 8%), and you have per-rep commission tracking.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open with Google Sheets. Formulas transfer intact. Some conditional formatting may need to be recreated in Google Sheets' native format. For heavy team collaboration, saving as native Google Sheets format is smoother than round-tripping .xlsx.
How often should I update the pipeline?
Daily for high-velocity SMB teams (5-15 day cycles), weekly for typical mid-market (30-60 day cycles), bi-weekly for enterprise (90+ day cycles). The template doesn't care about frequency — it computes current-state whenever you look at it. Consistency matters more than frequency.
Should quotas be quarterly or annual?
Quarterly is standard for most B2B SaaS teams — short enough to hold reps accountable, long enough to smooth over slow months. Annual quotas are common for enterprise where deal cycles exceed a quarter. The template defaults to quarterly; switch to annual by dividing your annual quota by 4, or dividing to monthly for high-velocity teams.
How do I run a proper weekly sales meeting with this?
Standard 30-minute agenda: (1) Team KPIs — 5 min on Dashboard's top 4 cards, (2) Pipeline review — 10 min on the funnel, focus on Negotiation stage deals, (3) Rep round-robin — 10 min, each rep updates on top 2-3 deals, (4) Blockers — 5 min. Print the Dashboard sheet as PDF for anyone joining remotely.
Related templates
Build custom sales views with the Sheets & Cells AI Add-in
Ask in plain English — "show me deals over $50K stuck in Negotiation for more than 30 days" — and the Add-in writes the formula, filters the sheet, and highlights what matters. Right inside Excel.
Learn about the Add-in →